How to Remove Empty Strings from a Pandas Column with Simple Code

Introduction

Hello, I’m PiPi. Recently a member of the Python Silver group asked how to delete empty values in a Pandas column (HOBBY). The attempted command df_new.dropna(subset='HOBBY', inplace=True) did not remove the rows because the cells contain empty strings, not NaN.

Solution

The fix is to filter out empty strings directly. For example: df = df[df['HOBBY'] != ''] This removes rows where the HOBBY column is an empty string.

Another illustration of the same solution:

Conclusion

The issue is resolved with a simple inequality filter, demonstrating that understanding the difference between NaN and empty strings is essential when cleaning data with Pandas.