/Python/Pandas dataframe select rows not in list

Pandas dataframe select rows not in list

Dataframe slice by list of values

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

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 slice by list of values

In [4]: df[~df['A'].isin([3, 6])]
Out[4]:
   A  B
0  5  1
3  4  5

Source: stackoverflow.com

Similar codes

0 vote361 views1 answer
Set .difference() Operation in python3
Python
0 vote334 views1 answer
Pandas drop unnamed columns grebber
Python
0 vote368 views1 answer
Get timestamp with pyrhon
Python
6 votes355 views3 answers
Infinty in python
Python
1 vote328 views1 answer
Convert pandas dataframe to numpy dataframe
Python
1 vote411 views1 answer
How to play sound after pressing a button in tkinter
Python
5 votes476 views3 answers
Flask port
Python Flask
0 vote336 views1 answer
Unable to get local issuer certificate python
Python
0 vote361 views2 answers
How to split string with comma in python
Python
1 vote364 views2 answers
Tensor vs numpy array
Python