Removing All rows with improper data [duplicate]

Question

I need to remove the rows of data in data frame that have been entered incorrectly for example I have a column of countries. I need to delete all the values that are not counties. I know the list of countries that should be there. For example I would want to delete the row containing a numeric value as a country. Here is my attempt:

currency_list <- c("GBP","HKD","AUD","NZD","USD")
KS_2016.update$currency[KS_2016.update$currency =currency_list]

Please also show the input and output, and explain how the output differs from the expected output. — Jeff Learman
– Jeff Learman, Commented Apr 13, 2018 at 19:14

akrun · Accepted Answer · 2018-04-13 19:07:15Z

2

We can use subset it with %in% and !

subset(KS_2016.update, !currency %in% currency_list)

Or use filter from dplyr

library(dplyr)
KS_2016.update %>%
        filter(!currency %in% currency_list)

answered Apr 13, 2018 at 19:07

akrun

891k38 gold badges590 silver badges700 bronze badges

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

1 Comment

Hunter Knighton Over a year ago

You're awesome!

Collectives™ on Stack Overflow

Removing All rows with improper data [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related