How to get unique values from multiple columns in a pandas groupby

by

You can do it with apply:

import numpy as np
g = df.groupby('c')['l1','l2'].apply(lambda x: list(np.unique(x)))

More Related Contents:

  1. Convert DataFrame column type from string to datetime
  2. How to apply a function to two columns of Pandas dataframe
  3. How to convert an XML file to nice pandas dataframe?
  4. Dynamically evaluate an expression from a formula in Pandas
  5. df.append() is not appending to the DataFrame
  6. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  7. Pandas groupby mean – into a dataframe?
  8. Load data from txt with pandas
  9. Add Leading Zeros to Strings in Pandas Dataframe
  10. Progress indicator during pandas operations
  11. pandas groupby without turning grouped by column into index
  12. Coloring Cells in Pandas
  13. How to import data from mongodb to pandas?
  14. How to group a pandas dataframe by a defined time interval?
  15. How to convert a Scikit-learn dataset to a Pandas dataset
  16. How to sort a Pandas DataFrame by index?
  17. pandas applying regex to replace values
  18. pandas two dataframe cross join [duplicate]
  19. Redefining the Index in a Pandas DataFrame object
  20. pandas .plot() x-axis tick frequency — how can I show more ticks?
  21. module ‘pandas’ has no attribute ‘rolling_mean’
  22. Group dataframe and get sum AND count?
  23. Replace value for a selected cell in pandas DataFrame without using index
  24. Anti-Join Pandas
  25. Get first row of dataframe in Python Pandas based on criteria
  26. Get mapping of categorical variables in pandas
  27. Drop rows on multiple conditions in pandas dataframe
  28. Convert pandas DataFrame into list of lists [duplicate]
  29. Got continuous is not supported error in RandomForestRegressor
  30. Can I perform dynamic cumsum of rows in pandas?

Leave a Comment