Python pandas Filtering out nan from a data selection of a column of strings

by

Simplest of all solutions:

filtered_df = df[df['name'].notnull()]

Thus, it filters out only rows that doesn’t have NaN values in ‘name’ column.

For multiple columns:

filtered_df = df[df[['name', 'country', 'region']].notnull().all(1)]

More Related Contents:

  1. Annotate bars with values on Pandas bar plots
  2. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  3. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  4. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  5. Conditionally fill column values based on another columns value in pandas
  6. pandas concat generates nan values
  7. Normalize columns of a dataframe
  8. Pandas Groupby and Sum Only One Column
  9. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  10. Pandas Dataframe: Replacing NaN with row average
  11. How to read a .xlsx file using the pandas Library in iPython?
  12. “unstack” a pandas column containing lists into multiple rows [duplicate]
  13. Pandas Replace NaN with blank/empty string
  14. How to check whether a pandas DataFrame is empty?
  15. Convert pandas data frame to series
  16. vectorize conditional assignment in pandas dataframe
  17. Pandas DataFrame merge summing column
  18. Mapping ranges of values in pandas dataframe [duplicate]
  19. Binning a column with pandas
  20. Convert month int to month name in Pandas
  21. How to get/set a pandas index column title or name?
  22. Python pandas integer YYYYMMDD to datetime
  23. Pandas: drop columns with all NaN’s
  24. Calculate summary statistics of columns in dataframe
  25. How to use str.contains() with multiple expressions in pandas dataframes
  26. Check if certain value is contained in a dataframe column in pandas [duplicate]
  27. UnicodeDecodeError when reading CSV file in Pandas
  28. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  29. How to get number of groups in a groupby object in pandas?
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment