Answers for "python dataframe check values in a row"

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

finding the rows in a dataframe where column contains any of these values python

import pandas as pd

data = {'Month': ['January','February','March','April','May','June','July','August','September','October','November','December'],
        'Days in Month': [31,28,31,30,31,30,31,31,30,31,30,31]
        }

df = pd.DataFrame(data, columns = ['Month', 'Days in Month'])

contain_values = df[df['Month'].str.contains('Ju')]
print (contain_values)
Posted by: Guest on October-27-2020

Code answers related to "python dataframe check values in a row"

Python Answers by Framework

Browse Popular Code Answers by Language