I'm trying to build a data-frame from csv file by selecting only the rows where one column is = to a string and a 2nd column has no value. The code below is supposed to only show the rows that match the conditions but it returns all the rows.
def match_db_groups(Users, Path, Dir, Processed_File): Missing_Group = path.join('/', Users, Path, Dir, Processed_File) df = pd.read_csv(Missing_Group) filter_1 = df['DATABASE_TYPE'] == 'ORACLE' filter_2 = df['LOB'].isnull( == True) df.where(filter_1 & filter_2, inplace = True) print(df)