Check if value of dataframe is existing in list

Question

I am trying to split a pandas Dataframe into two, based on the value in the column "country".

If the value exists in the following list (EU-COUNTRY-CODES), the row should be added to a dataframe called "EU", if it does not exist in the list I want to add the row to another dataframe.

eu-country-codes = ["BE","BG","DK","EE","FI","FR","GR","IE","IT","HR","LV","LT","LU","MT","NL","AT","PL","PT","RO","SM","SE","SK","SI","ES","CZ","HU","VA","FO","CY"]

I tried to do it this way but got following Error:

data = pd.read_csv("datei.csv", sep=",", header=0)
eu= data[data["country"] not in eu-country-codes]

ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

eu = data[~data["country"].isin(eu-country-codes)] I believe — smichael_44
– smichael_44, Commented Aug 25, 2022 at 16:37

Mouad Slimane · Accepted Answer · 2022-08-25 16:37:07Z

1

try this:

data[data["country"].isin( eu-country-codes)==False]

answered Aug 25, 2022 at 16:37

Mouad Slimane

1,0635 silver badges18 bronze badges

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

1 Comment

lasse3434 Over a year ago

Thank you so much! I love those problems where is waste my lifetime thanks to less than 10 letters.

Collectives™ on Stack Overflow

Check if value of dataframe is existing in list

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related