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

1 vote235 views1 answer
Delete and start fresh with db django
Python
1 vote255 views1 answer
Values outside range pandas
Python
4 votes268 views1 answer
Read value from entry tkinter
Python
1 vote289 views1 answer
No module named base45 windows
Python
0 vote304 views1 answer
Problem with console writeline python
Python
0 vote284 views1 answer
Adding extra fields to user model django
Python Django
2 votes251 views2 answers
Read mat file header python numpy
Python
2 votes245 views3 answers
Python count of values in array
Python
0 vote263 views1 answer
Xtick for axvline
Python
0 vote262 views1 answer
B'string' python
Python