在Pandas中将一行数据拆分为多行

import pandas as pd

# 创建包含列表的DataFrame
data = {'Name': ['John', 'Alice', 'Bob'],
        'Hobbies': [['Reading', 'Cooking'], ['Gardening'], ['Painting', 'Photography']]}
df = pd.DataFrame(data)

# 使用explode()函数拆分'Hobbies'列
df_exploded = df.explode('Hobbies')

print(df_exploded)

    Name       Hobbies
0   John       Reading
0   John       Cooking
1  Alice     Gardening
2    Bob      Painting
2    Bob  Photography