How to replace NAs with characters within a df [duplicate]

Question

I want all NAs to be replaced with "Not Found" in a df .

i have this df

A    B
1    NA
2    NA
3    NA

How can i get that .

A    B
1    Not Found
2    Not Found
3    Not Found

It's better to leave it as NAs. Especially if that column is a factor. Other than that, a simple Google search gives all you need. Have you saw this stackoverflow.com/questions/8161836/… ? — David Arenburg
– David Arenburg, Commented Feb 2, 2016 at 7:59

pe-perry · Accepted Answer · 2016-02-02 08:16:13Z

3

You can Assign "Not Found" to df[is.na(df)]. However, it will cause errors if some columns are factors.

df <- data.frame(A = 1:3, B = rep(NA, 3), stringsAsFactors = FALSE)
df
#   A  B
# 1 1 NA
# 2 2 NA
# 3 3 NA
 df[is.na(df)] <- "Not Found"
df
#   A         B
# 1 1 Not Found
# 2 2 Not Found
# 3 3 Not Found

edited Feb 2, 2016 at 8:16

answered Feb 2, 2016 at 8:01

pe-perry

2,6312 gold badges25 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

How to replace NAs with characters within a df [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related