-1

The size of dataframe is not changed after I called dropna. But I want all rows that has one value missing being dropped.

import pandas as pd


if __name__ == '__main__':
    # Import data
    census_subdivision_profile = pd.read_csv('../data/augmented/census_subdivision_profile_merged.csv')
    print(census_subdivision_profile.shape)
    census_subdivision_profile.dropna()
    print(census_subdivision_profile.shape)
ZHU
  • 824
  • 1
  • 9
  • 24

1 Answers1

1

You forget assign output back:

census_subdivision_profile = census_subdivision_profile.dropna()

Or add parameter inplace=True to DataFrame.dropna:

census_subdivision_profile.dropna(inplace=True)
jezrael
  • 729,927
  • 78
  • 1,141
  • 1,090