Replacing value in multiple columns in data.table

Question

I have a large table with time series data (not in time series format) and I would like to replace certain values with a simple line of code. Below you will find a sample of the table. I would like to replace NA with nothing and 88888 with 0. Of course this can be done column by column with the help of a while-loop. However, I guess there is a simpler solution to this issue. Any suggestions?

Sample dataset:

sample <- structure(list(Period = c("01-12-08", "01-01-09", "01-02-09", "01-03-09",
 "01-04-09", "01-05-09", "01-06-09", "01-07-09", "01-08-09", "01-09-09", "01-10-09",
 "01-11-09", "01-12-09", "01-01-10", "01-02-10"), Serie1 = c(NA, NA, NA, NA, NA, NA,
 NA, NA, NA, NA, NA, 6L, 88888L, 88888L, 88888L), Serie2 = c(NA, NA, NA, NA, NA, NA,
 20L, 88888L, 88888L, 88888L, 88888L, 88888L, 88888L, NA, NA), Serie3 = c(NA, NA,
 NA, NA, NA, NA, NA, NA, NA, 10L, 10L, 88888L, 88888L, 88888L, 88888L)), .Names =
 c("Period", "Serie1", "Serie2", "Serie3"), row.names = c(NA, -15L), class =
 c("data.table", "data.frame"))

lukeA · Accepted Answer · 2014-02-20 11:17:47Z

5

sample[is.na(sample)] <- ""
sample[sample == 88888] <- 0

answered Feb 20, 2014 at 11:17

lukeA

54.4k5 gold badges102 silver badges101 bronze badges

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

2 Comments

nograpes Over a year ago

Note, however, that by converting the NA to "", you also convert your column from integer to character. NA is the best way to represent "nothing" for a column of integer.

Roland Over a year ago

This also doesn't modify the data.table in place.

Collectives™ on Stack Overflow

Replacing value in multiple columns in data.table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related