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

3 votes174 views1 answer
Local testing server Python
Python
1 vote179 views1 answer
Python convert input into lowercase
Python
0 vote197 views1 answer
Cryptography 'openssl/opensslv.h' file not found
Python
0 vote153 views1 answer
Queryset.raw() in django rest framework joining tables
Python
0 vote154 views1 answer
Nlp spacy medium
Python
0 vote173 views1 answer
Get time format python2 hours minutes seconds milliseconds
Python
0 vote153 views1 answer
Seconds since epoc python
Python
9 votes160 views3 answers
How to get image in jupyter notebook
Python
1 vote177 views2 answers
Format date field in pandas
Python
3 votes199 views1 answer
Django import model from another app
Python Django