How do I join rows in pandas dataframe as new line in same row?-CodePudding

I have a pandas dataframe that looks like this:

time text
01.01.1970 abc
01.01.1970 cde
01.01.1970 fgh
01.01.1980 abc
01.01.1980 xyz

I would like to join the rows of column text based on the entry for time. A new row should start in a new line.

The new dataframe should look like this:

time text
01.01.1970 abc
           cde
           fgh
01.01.1980 abc
           xyz

I tried this code:

out = (df.groupby('time', as_index=False)
       ['text'].agg(lambda x: '\n'.join(x.dropna())))

But first: join by \n is not want I want. And secondly, the text column is just text\ntime. How can I modify my code or should I use another approach?

My question is related to this question: