'Convert data.frame to time series R zero-width problem

I have the following table

    head(subsetc)
# A tibble: 6 x 20
  `Deal Type` value `Announced Equity Value~` Date  `Completion/Te~` `Target Name` `Acquirer Name` `Payment Type` `Acquirer Indu~` `Target Indust~`
  <chr>       <dbl> <dttm>                    <chr>            <dbl> <chr>         <chr>           <chr>          <chr>            <chr>           
1 M&A         2985  NA                        2021~            44377 Alight Solut~ Foley Trasimen~ Cash and Stock Diversified      Consumer, Non-c~
2 M&A         2445. 1904-10-02 22:33:36       2021~            44377 Cardtronics ~ NCR Corp        Cash           Technology       Consumer, Non-c~
3 M&A          875  1902-05-24 00:00:00       2021~            44377 Hillman Grou~ Landcadia Hold~ Stock          Diversified      Industrial      
4 M&A          800  NA                        2021~            44377 UPS Freight ~ TFI Internatio~ Cash           Industrial       Industrial      
5 M&A          700  NA                        2021~            44286 Pet Supplies~ Franchise Grou~ Cash           Consumer, Non-c~ Consumer, Cycli~
6 M&A          681  1901-11-11 00:00:00       2021~            44377 Sunlight Fin~ Spartan Acquis~ Stock          Diversified      Financial

The column date contains date of this type 2021-01-31 and more than one observation can have the same day. I would like to group values by date and if possible in a time series table

r


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source