What is the difference between size and count in pandas?

by

size includes NaN values, count does not:

In [46]:
df = pd.DataFrame({'a':[0,0,1,2,2,2], 'b':[1,2,3,4,np.NaN,4], 'c':np.random.randn(6)})
df

Out[46]:
   a   b         c
0  0   1  1.067627
1  0   2  0.554691
2  1   3  0.458084
3  2   4  0.426635
4  2 NaN -2.238091
5  2   4  1.256943

In [48]:
print(df.groupby(['a'])['b'].count())
print(df.groupby(['a'])['b'].size())

a
0    2
1    1
2    2
Name: b, dtype: int64

a
0    2
1    1
2    3
dtype: int64

More Related Contents:

  1. What is the difference between NaN and None?
  2. How do I make a function in python which takes a list of integers as an input and outputs smaller lists with only two values?
  3. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  4. Fast Haversine Approximation (Python/Pandas)
  5. Convert pandas.Series from dtype object to float, and errors to nans
  6. pandas GroupBy columns with NaN (missing) values
  7. How can I split a column of tuples in a Pandas dataframe?
  8. Why in numpy `nan == nan` is False while nan in [nan] is True?
  9. Efficiently return the index of the first value satisfying condition in array
  10. Group duplicate column IDs in pandas dataframe
  11. Suppressing scientific notation in pandas? [duplicate]
  12. How to one hot encode variant length features?
  13. NumPy: calculate averages with NaNs removed
  14. Shift NaNs to the end of their respective rows
  15. convert nan value to zero
  16. pandas equivalent of np.where
  17. how to read certain columns from Excel using Pandas – Python
  18. which is faster for load: pickle or hdf5 in python
  19. Saving Matplotlib graphs to image as full screen
  20. Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
  21. Pandas in AWS lambda gives numpy error
  22. Pandas groupby with categories with redundant nan
  23. Filling in date gaps in MultiIndex Pandas Dataframe
  24. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  25. How to resample a dataframe with different functions applied to each column?
  26. Resample time series in pandas to a weekly interval
  27. Python Pandas: remove entries based on the number of occurrences
  28. Convert a column of timestamps into periods in pandas
  29. What is the Big O Complexity of Reversing the Order of Columns in Pandas DataFrame?
  30. How to use numpy to get the cumulative count by unique values in linear time?

Leave a Comment