Reorder factor levels by day of the week in R

r dataframe r-factor
Mittenchops picture Mittenchops · Apr 25, 2012 · Viewed 21.1k times · Source

I have the following data.frame in R:

> daily
        DoW         Duration
1    Friday 14.0000000000000
2    Monday 21.0000000000000
3  Saturday 12.0000000000000
4  Thursday 28.0000000000000
5   Tuesday 12.0000000000000
6 Wednesday 91.0000000000000
7    Sunday 20.0000000000000

I'd like to change the order of the factor levels so that the weeks are in (US) day-of-week order.

It looks like I can do this in a slow, puzzling way with relevel(). But this only takes 1 numeric argument and moves it to the top. So, relevel(daily$DoW, 7), moves Sunday to the top, but the rest remain unordered (which means I need to relevel it in reverse order).

Doable, but there must be a better way, right?

(Time series solution also acceptable.)

Answer

Tyler Rinker picture Tyler Rinker · Apr 25, 2012

You need to specify the levels in factor and then use order with indexing:

daily$DoW <- factor(daily$DoW, levels= c("Sunday", "Monday", 
    "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"))

daily[order(daily$DoW), ]

Related questions

Drop unused factor levels in a subsetted data frame

I have a data frame containing a factor. When I create a subset of this dataframe using subset or another indexing function, a new data frame is created. However, the factor variable retains all of its original levels, even when/…

Read More
Coerce multiple columns to factors at once

I have a sample data frame like below: data <- data.frame(matrix(sample(1:40), 4, 10, dimnames = list(1:4, LETTERS[1:10]))) I want to know how can I select multiple columns and convert them together to factors. I usually do it in the …

Read More
Unseen factor levels when appending new records with unseen string values to a dataframe, cause Warning and result in NA

I have a dataframe (14.5K rows by 15 columns) containing billing data from 2001 to 2007. I append new 2008 data to it with: alltime <- rbind(alltime,all2008) Unfortunately that generates a warning: > Warning message: In `[<-.factor`(`*tmp*`, ri, …

Read More