I am working with a csv data set with around 1 million records. I need to perform two operations on the data set:
- Prepare a dataset that do not have those rows that have some missing (blank) values in them.
- Prepare another data set that replaces empty values with unknown.
I have tried to use excel for it but that is taking too much time. Please someone help with the way it can be done in R?