How to aggregate unique count with pandas pivot_table

by

Do you mean something like this?

>>> df2.pivot_table(values="X", index='Y', columns="Z", aggfunc=lambda x: len(x.unique()))

Z   Z1  Z2  Z3
Y             
Y1   1   1 NaN
Y2 NaN NaN   1

Note that using len assumes you don’t have NAs in your DataFrame. You can do x.value_counts().count() or len(x.dropna().unique()) otherwise.

More Related Contents:

  1. Pandas Pivot tables row subtotals
  2. Pivoting a Pandas Dataframe containing strings – ‘No numeric types to aggregate’ error
  3. Pivot table subtotals in Pandas
  4. Pivot Tables or Group By for Pandas?
  5. Pivot Tables of Counts in Pandas DataFrame
  6. Difference between pivot and pivot_table. Why is only pivot_table working?
  7. Pandas groupby with bin counts
  8. How do I find the closest values in a Pandas series to an input number?
  9. How to display custom values on a bar plot
  10. How do I count the NaN values in a column in pandas DataFrame?
  11. Dummy variables when not all categories are present
  12. getting the index of a row in a pandas apply function
  13. Recursive definitions in Pandas
  14. Tilde sign in pandas DataFrame
  15. Drop columns whose name contains a specific string from pandas DataFrame
  16. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  17. Panda’s Write CSV – Append vs. Write
  18. Convert Pandas Series to DateTime in a DataFrame
  19. Expanding pandas data frame with date range in columns
  20. Why is np.where faster than pd.apply
  21. Improve subplot size/spacing with many subplots
  22. Extract column value based on another column in Pandas
  23. Change the color of text within a pandas dataframe html table python using styles and css
  24. pandas – scatter plot with different color legend for each point
  25. Pandas: parse merged header columns from Excel
  26. Remove substring from column based on another column
  27. How to use sklearn fit_transform with pandas and return dataframe instead of numpy array?
  28. pandas convert from datetime to integer timestamp
  29. geopandas point in polygon
  30. Rename columns in Pandas based on a dictionary

Leave a Comment