Dataframe column in list

Filter dataframe with list

df[df['Your_Column'].isin([3, 6])]

Pandas dataframe select rows not in list

df[~df.isin(subset).iloc[:,0]]

Dataframe column in list

In [1]: df = pd.DataFrame({'A': [5,6,3,4], 'B': [1,2,3,5]})

In [2]: df
Out[2]:
   A  B
0  5  1
1  6  2
2  3  3
3  4  5

In [3]: df[df['A'].isin([3, 6])]
Out[3]:
   A  B
1  6  2
2  3  3

Source: stackoverflow.com

Get dataframe column into a list

df_gearME = pd.read_excel('Gear M&Es.xlsx')
df_gearME['ColA'].to_list()

Source: stackoverflow.com

Similar codes

0 vote221 views1 answer
Calculate time python
Python
0 vote252 views1 answer
Installing intel-numpy
Python
3 votes256 views2 answers
How many columns have null values present in them? in pandas
Python
0 vote326 views2 answers
How to get current page url in django template
Python Django
21 votes357 views6 answers
Python avg
Python
2 votes275 views1 answer
Add colour to text in python
Python
27 votes275 views4 answers
Flask tutorial
Python
0 vote283 views1 answer
Flask read form data
Python
0 vote278 views1 answer
Pandas copy data from a column to another
Python
0 vote265 views1 answer
How to use self.list.setCurrentRow() in pyqt5
Python