Pandas Python中的拆分列表

import pandas as pd

my_list = ['apple,banana,orange', 'cat,dog', 'sun,moon,star']
split_list = [item.split(',') for item in my_list]
print(split_list)

[['apple', 'banana', 'orange'], ['cat', 'dog'], ['sun', 'moon', 'star']]

import pandas as pd

data = {'fruits': ['apple,banana,orange', 'cat,dog', 'sun,moon,star']}
df = pd.DataFrame(data)

df[['fruit1', 'fruit2', 'fruit3']] = df['fruits'].apply(lambda x: pd.Series(x.split(',')))
print(df)

                fruits fruit1 fruit2  fruit3
0  apple,banana,orange  apple banana  orange
1             cat,dog    cat    dog    None
2        sun,moon,star    sun   moon    star