Skip to content
Prev 387366 / 398502 Next

Split Dataframe into several

Dear R users;
Hi.
I have a problem with splitting dataframe into several.
I have a large dataframe (Length of 61000). It has 4 Columns as below:
"
               Date             Cases          Country
1            2020-12-14     746            Country1
2            2020-12-15      324           Country1
..
6000      2020-12-13      298            Country2
.
.
"
Each country has a different number of rows and their related dates are
different. What I want to do is: Extract rows for each country and make a
new column for that case of the country.
"
             Date             Cases_Country1      Cases_Country2
 Cases_Country3 ......
1           2020-12-14     746                      25
                65
2           2020-12-15      324
..
6000      2020-12-13      298                      352
              75
"
I used split function, but it create a list and I cannot use the data.
Please help me to fix this problem.
Sincerely