这个代码了解一下
import pandas as pd
data = pd.read_excel(r"E:\01.xlsx")
data_res = pd.DataFrame()
def func(df):
for i in df.index:
list_1 = df.iloc[i,0].split()
for j in range(len(list_1)):
column_res = list_1[j].split(":")[0]
# try:
# column_res = int(list_1[j].split(":")[0])
# except ValueError:
# continue
data_res.loc[i,column_res] = list_1[j].split(":")[1]
func(data)
data_res.head(20)