Skip to content

Split Dataframe into several

2 messages · javad bayat, Rasmus Liland

Original
javad bayat
# 
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
Rasmus Liland
# 
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>