How do I count the NaN values in a column in pandas DataFrame?

by

Use the isna() method (or it’s alias isnull() which is also compatible with older pandas versions < 0.21.0) and then sum to count the NaN values. For one column:

>>> s = pd.Series([1,2,3, np.nan, np.nan])

>>> s.isna().sum()   # or s.isnull().sum() for older pandas versions
2

For several columns, this also works:

>>> df = pd.DataFrame({'a':[1,2,np.nan], 'b':[np.nan,1,np.nan]})

>>> df.isna().sum()
a    1
b    2
dtype: int64

More Related Contents:

  1. how to calculation cost time [closed]
  2. Filter dataframe rows if value in column is in a set list of values [duplicate]
  3. Converting a Pandas GroupBy output from Series to DataFrame
  4. String concatenation of two pandas columns
  5. pandas: filter rows of DataFrame with operator chaining
  6. Reshape wide to long in pandas
  7. How do I create test and train samples from one dataframe with pandas?
  8. Pandas – Slice large dataframe into chunks
  9. Find column name in pandas that matches an array
  10. How do convert a pandas dataframe to XML?
  11. Python Pandas max value in a group as a new column
  12. Group duplicate column IDs in pandas dataframe
  13. How to convert column with list of values into rows in Pandas DataFrame
  14. Remove or replace spaces in column names
  15. pandas dataframe columns scaling with sklearn
  16. Shift NaNs to the end of their respective rows
  17. how to read certain columns from Excel using Pandas – Python
  18. which is faster for load: pickle or hdf5 in python
  19. Return multiple columns from pandas apply()
  20. How to slice a pandas DataFrame by position?
  21. Python Pandas – Merge based on substring in string
  22. Filling in date gaps in MultiIndex Pandas Dataframe
  23. Writing a Python Pandas DataFrame to Word document
  24. Find unique values in a Pandas dataframe, irrespective of row or column location
  25. Remove ends of string entries in pandas DataFrame column
  26. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  27. start index at 1 for Pandas DataFrame
  28. Multi Index Sorting in Pandas
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment