How to rename data within a dataframe

Question

I have a dataframe but the numbering of the months is all jumbled. I need to change the following rows to the following, but i'm struggling to see an easy way through. I'm aware that this code changes the data, but it's just a case of working out the puzzle without adding columns together.

data$column[data$column == "0"] <- "7"

0 <- 7
1 <- 8
2 <- 9
3 <- 10
4 <- 1
5 <- 2
6 <- 3
7 <- 4
8 <- 5
9 <- 6

Thank you

It seems that you could use simple indexing like c(7, 8, 9, 10, 1, 2, 3, 4, 5, 6)[as.numeric(data$column) + 1] — alexis_laz
– alexis_laz, Commented Dec 2, 2016 at 19:17

Nate · Accepted Answer · 2016-12-02 19:13:16Z

2

maybe plyr::mapvalues() can help you here:

library(plyr)
df$column <- mapvalues(df$column, from = c(0,1:9), to = c(7:10, 1:6))

answered Dec 2, 2016 at 19:13

Nate

10.7k3 gold badges35 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

code_is_entropy · Accepted Answer · 2016-12-02 19:39:16Z

0

Use

data$column <- (data$column + 7) %% 10

answered Dec 2, 2016 at 19:39

code_is_entropy

6113 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to rename data within a dataframe

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related