Splitting data frame in R

Question

I'm new to R. I have a dataset with names in the first row, the category the names belong to in the second row, and then price observations for two year from the third row onwards. I want to split the data frame using the categories in the second row. How do I do this?

This is what my dataset looks like (on R):

This is what I want it look like (on Excel) :

Note: I cannot do this on Excel and then import because there are way too many categories.

I do not think so, I did read that post before asking this question. The problem is the structure of the dataset. I have added a capture of what my dataset looks like. — phil_t, Mar 27 '17 at 15:27
Post a capture of what ur expecting too. Not able to understand your end requirement. — Jil Jung Juk, Mar 27 '17 at 15:28
@phil_t, your question is just not in the right format. Can you please check [this post](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example). — InspectorSands, Mar 27 '17 at 16:43

score 0 · Accepted Answer · answered Mar 27 '17 at 15:13

0

Multiple possiblities

df <- data.frame(data = c(1:12), category = rep(letters[1:3], 4))

subset function.
```
df_a <- subset(df, category == "a")
```
basic data.frame subset
```
df_a <- df[df$category == "a",]
```

into a list

ls <- list
for(category in unique(df$category)){
   ls[[category]] <- df[df$category == "a", ]
}

answered Mar 27 '17 at 15:13

Lukáš Hejtmánek

290
1
9

I am not able to use subset or your other suggestions because the category does not have a row name. I have added a capture of what my dataset looks like as of now. I am not sure I can add a row name for the second row. – phil_t Mar 27 '17 at 15:24

score 0 · Answer 2 · answered Mar 27 '17 at 15:15

0

You have the answer in your question. The split or split.data.frame functions would do it. The second argument must be of factor type for this to work.

Example

newdf <- split.data.frame(iris, iris$Species)
newdf

answered Mar 27 '17 at 15:15

Jil Jung Juk

690
2
9
21

I am not able to use split because the category does not have a row name. I have added a capture of what my dataset looks like as of now. I am not sure I can add a row name for the second row. – phil_t Mar 27 '17 at 15:23

Splitting data frame in R

2 Answers2