10.17 Remove Completely Empty Rows


To remove all rows from a dataset that are completely empty (NA for all values) we can count the number of NA’s in a row and if that is different to the number of columns in the dataset then keep that row

data <- data[rowSums(is.na(data)) != ncol(data), ] # Remove empty rows

Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0