This does work thanks.
Is there a solution 'non column' specific?
So I really only want to remove rows where the whole row is empty (or with empty strings). This solution is based on if the rows of 'Column name' are empty as opposed to the complete row i.e across all columns.
I have used this before but is there a more elegant way?
Is there a solution 'non column' specific?
So I really only want to remove rows where the whole row is empty (or with empty strings). This solution is based on if the rows of 'Column name' are empty as opposed to the complete row i.e across all columns.
I have used this before but is there a more elegant way?
for index, row in df.iterrows(): #loop through rows of df for further df cleaning if row.any() == '': df.drop(index,inplace=True)