我正试图将'Output'列中的值拆分为单独的行:
类别 | 输出 | 汽车 | 医生,回写 | 汽车
---|---|
跟踪,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)