'How to save a data frame with with the split (explode) method in a separte row?

I want to save a CSV-File but it doesn't really save the changes. That's my code:

 import pandas as pd
 data=pd.read_csv("Olympic.csv", parse_dates=["Birthday"])
 data['Birthday'] = data['Birthday'].dt.strftime('%d.%m.%Y')

 data['Medaille'].str.split(', ')
 data.assign(Medaille=data['Medaille'].str.split(', ')).explode('Medaille')

The output of the data.head() is:

      Medaille
0     Gold   800m
1     Silver 600m
2     Bronze 300m
3     Gold   500m
4     Silver 500m
5     Silver 600m
6     Gold   400m

I wanted to save the CSV with the Method data.to_csv("Save.csv", index=False)

But after i saved it and looked at the changes again with the method data.head() it goes to the default changes (also inside of the saved CSV-File):

data.head()

     Medaille
0    Gold   800m, Silver 600m
1    Bronze 300m, Gold   500m
2    Silver 500m
3    Silver 600m
4    Gold   400m


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source