r_datacleaning_snippets.md

Data cleaning

Remove NA values

cleaned_df <- na.omit(df)

Replace NA values

df$Column[is.na(df$Column)] <- replacement_value

Remove duplicates

cleaned_df <- unique(df)

Rename columns

colnames(df)[colnames(df) == "Old_Name"] <- "New_Name"

Rename rows

rownames(df)[rownames(df) == "Old_Name"] <- "New_Name"

Remove columns

cleaned_df <- df[, -c(1, 2, 3)]

Remove rows

cleaned_df <- df[-c(1, 2, 3), ]