Answers for "find rows if some particular values in column pandas"

1

select rows which entries equals one of the values pandas

In[10]: df
Name     Amount
---------------
Alice       100
Bob          50
Charlie     200
Alice        30
Charlie      10

In [11]: df['Name'].isin(['Alice', 'Bob'])
Out[11]: 
0     True
1     True
2    False
3     True
4    False
Name: Name, dtype: bool

In [12]: df[df.Name.isin(['Alice', 'Bob'])]
Out[12]: 
    Name  Amount
0  Alice     100
1    Bob      50
3  Alice      30
Posted by: Guest on February-14-2021
0

pandas check if any of the values in one column exist in another

df["exists"] = df.drop("target", 1).isin(df["target"]).any(1)
print(df)

    target  A       B       C       exists
0   cat     bridge  cat     brush   True
1   brush   dog     cat     shoe    False
2   bridge  cat     shoe    bridge  True
Posted by: Guest on March-19-2020

Code answers related to "find rows if some particular values in column pandas"

Python Answers by Framework

Browse Popular Code Answers by Language