dataframe = pd.read_excel('0.xlsx')
print(dataframe.head)
df1 = pd.DataFrame(columns=['sid','val'])
temp = dataframe['sid'][0]
temp1 = []
for i in range(len(dataframe)):
if dataframe['sid'][i] == temp:
temp1.append(dataframe['val'][i])
else:
df1 = df1.append({'sid': temp, 'val': temp1}, ignore_index=True)
temp1 = []
temp = dataframe['sid'][i]
temp1.append(dataframe['val'][i])
if i == len(dataframe)-1:
df1 = df1.append({'sid': temp, 'val': temp1}, ignore_index=True)
print(df1)
写了个很丑的代码，应该能运行（）
我觉得这种问题应该是个入门级的问题吧，自己稍微想想就可以了