/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

97 votes196 views6 answers
Python time.sleep
Python
22 votes205 views5 answers
How to check if a word is a palindrome in python
Python
0 vote198 views1 answer
Django-mathfilters
Python
0 vote189 views2 answers
Generator expression
Python
4 votes252 views2 answers
Python read array line by line
Python
3 votes236 views1 answer
Django admin prefetch_related
Python Django
2 votes180 views2 answers
Pandas unique values to list
Python
0 vote189 views1 answer
Striding in python
Python
0 vote190 views1 answer
Expand pandas dataframe into separate rows
Python
2 votes181 views2 answers
Iterate through attributes of class python
Python