Pandas ‘count(distinct)’ equivalent

I believe this is what you want:

table.groupby('YEARMONTH').CLIENTCODE.nunique()

Example:

In [2]: table
Out[2]: 
   CLIENTCODE  YEARMONTH
0           1     201301
1           1     201301
2           2     201301
3           1     201302
4           2     201302
5           2     201302
6           3     201302

In [3]: table.groupby('YEARMONTH').CLIENTCODE.nunique()
Out[3]: 
YEARMONTH
201301       2
201302       3

Related Posts:

  1. How to groupby based on two columns in pandas?
  2. Pandas group-by and sum
  3. Count unique values per groups with Pandas
  4. Pandas group-by and sum
  5. Count unique values using pandas groupby
  6. Count unique values per groups with Pandas [duplicate]
  7. pandas groupby sort within groups
  8. how to sort pandas dataframe from one column
  9. How to reset index in a pandas dataframe? [duplicate]
  10. How to deal with SettingWithCopyWarning in Pandas
  11. How to deal with SettingWithCopyWarning in Pandas
  12. How to iterate over rows in a DataFrame in Pandas
  13. pandas read_json: “If using all scalar values, you must pass an index”
  14. How to iterate over rows in a DataFrame in Pandas
  15. Writing a pandas DataFrame to CSV file
  16. ImportError: No module named pandas
  17. How to change the order of DataFrame columns?
  18. ImportError: No module named pandas. Pandas installed pip
  19. How can I use the apply() function for a single column?
  20. “Series objects are mutable and cannot be hashed” error
  21. TypeError: ‘Series’ objects are mutable, thus they cannot be hashed problemwith column
  22. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  23. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  24. How do I select rows from a DataFrame based on column values?
  25. DataFrame constructor not properly called! error
  26. Python pandas groupby aggregate on multiple columns, then pivot
  27. Error”Can only compare identically-labeled Series objects” and sort_index
  28. How to count the occurrence of certain item in an ndarray?
  29. Python Pandas – Missing required dependencies [‘numpy’] 1
  30. pandas DataFrame “no numeric data to plot” error
  31. ‘DataFrame’ object has no attribute ‘sort’
  32. How to read a .xlsx file using the pandas Library in iPython?
  33. Get total of Pandas column
  34. Plot pie chart and table of pandas dataframe
  35. Type error: cannot convert the series to
  36. TypeError: ‘DataFrame’ object is not callable
  37. How to check whether a pandas DataFrame is empty?
  38. Convert columns to string in Pandas
  39. Change column type in pandas
  40. Shuffle DataFrame rows
  41. AttributeError: Can only use .dt accessor with datetimelike values
  42. Python: pandas merge multiple dataframes
  43. How to load a tsv file into a Pandas DataFrame?
  44. How to count the NaN values in a column in pandas DataFrame
  45. xlrd.biffh.XLRDError: Excel xlsx file; not supported
  46. Converting between datetime and Pandas Timestamp objects
  47. Pandas – DataFrame object is not callable
  48. Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
  49. Convert pandas data frame to series
  50. How do I combine two dataframes?
  51. How to sort a list of objects based on an attribute of the objects?
  52. Normalize columns of pandas data frame
  53. Converting strings to floats in a DataFrame
  54. Get first row value of a given column
  55. Normalize columns of pandas data frame
  56. Selecting/excluding sets of columns in pandas
  57. How to add title to seaborn boxplot
  58. How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
  59. How to add an empty column to a dataframe?
  60. Pandas join issue: columns overlap but no suffix specified
  61. How to apply a function to two columns of Pandas dataframe
  62. Convert categorical data in pandas dataframe
  63. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  64. SettingWithCopyWarning even when using .loc[row_indexer,col_indexer] = value
  65. Loading a file with more than one line of JSON into Pandas
  66. OSError: Initializing from file failed on csv in Pandas
  67. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
  68. AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas
  69. Insert a row to pandas dataframe
  70. Python Pandas ValueError Arrays Must be All Same Length
  71. How to save a Seaborn plot into a file
  72. Subtract two columns in dataframe
  73. pandas DataFrame: replace nan values with average of columns
  74. Pandas error “Can only use .str accessor with string values”
  75. How to get row number in dataframe in Pandas?
  76. Plotting multiple lines, in different colors, with pandas dataframe
  77. TypeError: cannot concatenate a non-NDFrame object
  78. Rename specific column(s) in pandas
  79. How to convert column with dtype as object to string in Pandas Dataframe
  80. Coalesce values from 2 columns into a single column in a pandas dataframe
  81. Unknown format code ‘f’ for object of type ‘str’- Folium
  82. Pandas: sum up multiple columns into one column without last column
  83. python pandas remove duplicate columns
  84. Convert Pandas Column to DateTime
  85. matplotlib: plot multiple columns of pandas data frame on the bar chart
  86. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  87. Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
  88. Move column by name to front of table in pandas
  89. How to count the number of files in a directory using Python
  90. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  91. Python: Convert timedelta to int in a dataframe
  92. Must have equal len keys and value when setting with an iterable
  93. Pandas dataframe groupby plot
  94. Calculate weighted average using a pandas/dataframe
  95. Got continuous is not supported error in RandomForestRegressor
  96. ValueError: multiclass format is not supported
  97. How to convert .sav file into csv file
  98. Convert list of dictionaries to a pandas DataFrame
  99. Python Pandas : pivot table with aggfunc = count unique distinct
  100. AttributeError: ‘Series’ object has no attribute ‘split’ error in sending emails

Leave a Comment