Answers for "find values in data frame not present in another data frame"

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
0

pandas look for values in column with condition

# The common syntax is df.loc[], the condition is put in the bracket

#Eg, look for rows with column1 > 5 and column2 = 3
df.loc[(df['column_1'] > 5) & (df['column_2'] = 3)]
Posted by: Guest on May-30-2021

Python Answers by Framework

Browse Popular Code Answers by Language