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

10 votes158 views1 answer
Python - convert a column in a dataframe into a list
Python
236 votes626 views6 answers
Import random in python
Python
1 vote162 views1 answer
Data Compression in python
Python
0 vote151 views2 answers
Days in month function python
Python
1 vote150 views1 answer
Python datetime round to nearest hour
Python
0 vote203 views1 answer
Narcissistic number python
Python
0 vote177 views1 answer
Read all the lines as a list in a file using the readlines() function
Python
0 vote232 views1 answer
Subprocess.popen no output
Python
1 vote233 views1 answer
Lru_cache
Python
2 votes181 views2 answers
Python version kali linux
Python