Pandas column not in list

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

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] = ...

Similar codes

9 votes59 views1 answer
Pandas sort by multiple columns
Python
0 vote101 views1 answer
Binary to decimal python
Python
4 votes107 views1 answer
Flatten nested list
Python
8 votes93 views1 answer
Python discord bot join voice channel
Python
0 vote98 views1 answer
F2 polar or nonpolar
Python
3 votes67 views2 answers
Python replace values in a matrix
Python
0 vote103 views1 answer
Box Plot, Python
Python
1 vote103 views1 answer
ModuleNotFoundError: No module named 'transforms3d'
Python
0 vote112 views1 answer
Convert video to text python
Python
0 vote97 views1 answer
Print a commans in python
Python