import pandas as pd
filepath='C:\\Users\hasee\Desktop\wenjuan.xlsx'
list=(i for i in range(1049))
file=pd.read_excel(filepath,index=list)
index1=file['UserId'].unique()
df=pd.DataFrame(index=index1)
for id2 in df.index:
for i in range(1,17,1):
for id in file.index:
if file.loc[id,'UserId']==id2:
if file.loc[id,'QuesNo']==i:
df.loc[id2,i]=file.loc[id,'Answer']
df.to_excel('C:\\Users\hasee\Desktop\\01.xlsx')
一个将问卷数列排序数据转换成易分析的横列数据的代码
最新推荐文章于 2024-09-26 19:43:55 发布