Pandas not in list

>>> df
  countries
0        US
1        UK
2   Germany
3     China
>>> countries
['UK', 'China']
>>> df.countries.isin(countries)
0    False
1     True
2    False
3     True
Name: countries, dtype: bool
>>> df[df.countries.isin(countries)]
  countries
1        UK
3     China
>>> df[~df.countries.isin(countries)]
  countries
0        US
2   Germany

Source: stackoverflow.com

Python not in list

>>> 3 not in [2, 3, 4]
False
>>> 3 not in [4, 5, 6]
True

Source: stackoverflow.com

Pandas column not in list

col_list = ['Fx', 'Fy','Fz']
col_mask = ~(df.columns.isin(col_list)) # boolean list of whether each col in df is in col_list
other_cols = data.columns[col_mask] 
df[other_cols] = ...

Isnotin python

import pandas as pd

>>> df
  country
0        US
1        UK
2   Germany
3     China
>>> countries_to_keep
['UK', 'China']
>>> df.country.isin(countries_to_keep)
0    False
1     True
2    False
3     True
Name: country, dtype: bool
>>> df[df.country.isin(countries_to_keep)]
  country
1        UK
3     China
>>> df[~df.country.isin(countries_to_keep)]
  country
0        US
2   Germany

Source: stackoverflow.com

Similar codes

0 vote312 views1 answer
Python find matching string regardless of case
Python
13 votes397 views2 answers
Delete database entry using name django
Python Django
-1 vote317 views1 answer
How to call a class in python
Python
0 vote335 views1 answer
How to fit the whole text beside checkbox in ipywidgets
Python
1 vote319 views1 answer
How to make a kivy label multiline text
Python
-1 vote312 views1 answer
How do you split a list into evenly sized chunks?
Python
0 vote323 views1 answer
Extract x y coordinates from image in pdf python
Python
0 vote326 views1 answer
Python -c crypt command in python3.3 and above
Python
0 vote335 views1 answer
Flask mongoengine configuration
Python Flask
0 vote321 views2 answers
Groupby fillna ffill
Python