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
--
Best Regards
Javad Bayat
M.Sc. Environment Engineering
Alternative Mail: bayat194 at yahoo.com
[[alternative HTML version deleted]]
Dear Javad, data <- "Date Cases Country 2020-12-14 746 Country1 2020-12-15 324 Country1 2020-12-15 1 Country3 2020-12-13 298 Country2" data <- read.table(text=data, header=T) x <- reshape( data=data, timevar = "Country", idvar = "Date", direction = "wide") data x yields Date Cases Country 1 2020-12-14 746 Country1 2 2020-12-15 324 Country1 3 2020-12-15 1 Country3 4 2020-12-13 298 Country2 Date Cases.Country1 1 2020-12-14 746 2 2020-12-15 324 4 2020-12-13 NA Cases.Country3 Cases.Country2 1 NA NA 2 1 NA 4 NA 298 Best, Rasmus -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 833 bytes Desc: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20210308/3b88debe/attachment.sig>