Search whole dataframe for empty cells except specific columns - how to write condensed code to do this?

user_19794510 0
Viewed 27

I'm writing code that data cleans my original dataframe and then spits out a dataframe of all the rows with errors. This line of code currently finds empty cells in the column 'RaceId'. I have 40 other columns and I would like to find empty cells in all of them apart from 'InRun' and 'Flucs'. How do I create a line of code that does this so I don't have to write out 40 lines of code?

My code:

df2[(df2['RaceId'] == '']
pandas data-cleaning python
1 Answers

If you want to remove rows that have empty string in all the specified columns, pass all to agg

df[your_col_list].apply(lambda x: x == '').agg(all, axis=1)

Otherwise, pass any to agg.

user_192557490
Related