This tutorial explains how to split a data frame with R programming.
Create Sample Data
 |
| Sample Data |
data <- read.table(text="X Y ZSplit a data frame
ID12 2012-06 566
ID1 2012-06 10239
ID6 2012-06 524
ID12 2012-07 2360
ID1 2012-07 13853
ID6 2012-07 2352
ID12 2012-08 3950
ID1 2012-08 14738
ID6 2012-08 4104",header=TRUE)
mydt2 = split(data, data$Y)Get first list element
mydt2[[1]]Calculate mean on each list element
sapply(mydt2 , function(x) mean(x$Z))Split a list into multiple data frames
for(i in 1:length(mydt2)) {
assign(paste0("t.", i), mydt2[[i]])
}
Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.
dplyr is great for subsetting and calculating means, sd, min max etc. on subsetted data.
ReplyDelete