如何使用Pandas将以下数据分割成单独的行?



我正试图将'Output'列中的值拆分为单独的行:

tbody> <<tr>汽车
类别 输出
汽车医生,回写
跟踪,dataview
import pandas as pd
d = {'Category': ["Car", "Car"], 'Output': ["Doc, writeback", "Trace, dataview"]}
df = pd.DataFrame(data=d)
df_splitted = pd.DataFrame(columns = df.columns)
for i in range(len(df)):
outputs = df['Output'][i].split(',')
for j in outputs:
df_splitted.loc[len(df_splitted)] = [df['Category'][i], j]
print(df_splitted)

最新更新