在Pandas中将单元格分解为多行

import pandas as pd

# 创建DataFrame
data = {'Name': ['John Doe', 'Jane Smith', 'Alice Johnson'],
        'Age': [25, 30, 35],
        'City': ['New York', 'London', 'Paris'],
        'Skills': ['Python, Java', 'C++, JavaScript', 'HTML, CSS, Python']}
df = pd.DataFrame(data)

# 分解单元格
df['Skills'] = df['Skills'].apply(lambda x: x.split(', ')).explode('Skills')

# 打印结果
print(df)

            Name  Age      City       Skills
0      John Doe   25  New York       Python
0      John Doe   25  New York         Java
1    Jane Smith   30    London          C++
1    Jane Smith   30    London   JavaScript
2  Alice Johnson   35     Paris         HTML
2  Alice Johnson   35     Paris          CSS
2  Alice Johnson   35     Paris       Python