Question

How to replace NA with 0 in data frame with R

Answer 1

df = data.frame(a = c(1, 3, NA, 7),
                b = c(12, 98, 87, 20),
                c = c(2, 4, NA, 9),
                d = c(13, 77, NA, NA),
                row.names = c('o', 'p', 's', 't'))
 
print(df)
 
df[is.na(df)] = 0
 
print(df)
 
 
 
       
       
# run:
#
#    a  b  c  d
# o  1 12  2 13
# p  3 98  4 77
# s NA 87 NA NA
# t  7 20  9 NA
#   a  b c  d
# o 1 12 2 13
# p 3 98 4 77
# s 0 87 0  0
# t 7 20 9  0
#

 

70+ SQL courses for beginners and professionals