Groupby Concatenation

Concatenate the values in a dataset grouped by a specified column. Concatenation is the process of combining or merging two or more sets or strings into a single set or string. Read more about concatenation on Wikipedia https://en.wikipedia.org/wiki/Concatenation

The concatenation of sets [1, 2, 3] and [4, 5, 6] results in the set [1, 2, 3, 4, 5, 6].

Useful for aggregating text data by category, helpful in creating lists or summaries by group.

• Microsoft Excel: CONCATENATE
• Google Sheets: JOIN
• Apple Numbers: JOIN
• Python Pandas: df.groupby('grouping_column').apply(lambda x: x['column1'] + x['column2'])
• Related Words: calculate groupby concatenation, merge strings based on a grouping column