-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
  • 904
  • 1
  • 11
  • 25

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
  • 822,522
  • 95
  • 1,334
  • 1,252