Pandas groupby with delimiter join

by

Alternatively you can do it this way:

In [48]: df.groupby('col')['val'].agg('-'.join)
Out[48]:
col
A    Cat-Tiger
B     Ball-Bat
Name: val, dtype: object

UPDATE: answering question from the comment:

In [2]: df
Out[2]:
  col    val
0   A    Cat
1   A  Tiger
2   A  Panda
3   B   Ball
4   B    Bat
5   B  Mouse
6   B    Egg

In [3]: df.groupby('col')['val'].agg('-'.join)
Out[3]:
col
A       Cat-Tiger-Panda
B    Ball-Bat-Mouse-Egg
Name: val, dtype: object

Last for convert index or MultiIndex to columns:

df1 = df.groupby('col')['val'].agg('-'.join).reset_index(name="new")

More Related Contents:

  1. Concatenate strings from several rows using Pandas groupby
  2. Pandas number rows within group in increasing order
  3. How can I pivot a dataframe?
  4. Pandas: filling missing values by mean in each group
  5. Keep other columns when doing groupby
  6. pandas GroupBy columns with NaN (missing) values
  7. Count unique values per groups with Pandas [duplicate]
  8. Multiple aggregations of the same column using pandas GroupBy.agg()
  9. Conditionally fill column values based on another columns value in pandas
  10. Pandas GroupBy and select rows with the minimum value in a specific column
  11. what are all the dtypes that pandas recognizes?
  12. Pandas Groupby and Sum Only One Column
  13. matplotlib: plot multiple columns of pandas data frame on the bar chart
  14. How can I see the formulas of an excel spreadsheet in pandas / python?
  15. Unpack dictionary from Pandas Column
  16. Pandas Groupby / List to Multiple Rows
  17. How to change the plot order of the categorical x-axis
  18. Pandas groupby with categories with redundant nan
  19. Bar graph from dataframe groupby
  20. append dictionary to data frame
  21. pandas group by and assign a group id then ungroup
  22. What is the equivalent of SQL “GROUP BY HAVING” on Pandas?
  23. Format a number with commas to separate thousands
  24. Create a pandas DataFrame from generator?
  25. reading multiple files contained in a zip file with pandas
  26. How to compute jaccard similarity from a pandas dataframe
  27. Search and replace dots and commas in pandas dataframe
  28. Why do I get a KeyError when using pandas apply?
  29. pandas scatter plotting datetime
  30. Pandas(Python) : Fill empty cells with with previous row value?

Leave a Comment