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

6 votes102 views1 answer
Django model form
Python
19 votes112 views2 answers
Learn python 3
Python
2 votes64 views1 answer
How to separate a string or int with comma in python
Python
157 votes140 views3 answers
Command to update pip
Python
0 vote136 views1 answer
Django queryset group by sum
Python Django
0 vote109 views1 answer
Python aus liste tuple machen
Python
0 vote141 views1 answer
Django request.data example
Python Django
9 votes114 views1 answer
How to convert a set to a list in python
Python
0 vote110 views1 answer
Matplotlib clear plot
Python
0 vote114 views1 answer
Python String with Alphanumeric characters
Python