Concatenating equal data from a column into rows in Python

Question

What I need is to find a function in Python that mounts my file this way. I already searched in pandas and did not find.

Answer 1

One way is to:

df.groupby('Categoria').agg({'Descricao':lambda col: ', '.join(col)}).reset_index()

This way you are grouping the same data from the column Categoria and using for the column Descricao the rule lambda col: ', '.join(col), that is, concatenating the data into a string separated by ', '.