我正在处理我的 Pandafile,但我仍然没有想出如何解决这个问题。
我有以下 Pandas 对象:
pandaFile = pd.DataFrame([{'var1': 'Restaurant A','var2':'4.5','var3':
['AA','BB','CC'],'var4':['User1','User2','User3'],'var5':['Review 1','Review
2','Review 3']},{'var1': 'Restaurant B','var2':'5.0','var3':
['AA','BB','CC'],'var4':['User1','User2','User3'], 'var5':['Review 1','Review
2','Review 3']}])
print(pandaFile)
看起来像这样:
var1 var2 var3 var4 var5
0 Restaurant A 4.5 [AA, BB, CC] [User1, User2, User3] [Review 1, Review 2, Review 3]
1 Restaurant B 5.0 [AA, BB, CC] [User1, User2, User3] [Review 1, Review 2, Review 3]
我想得到以下输出:
var1 var2 var3 var4 var5
0 Restaurant A 4.5 [AA, BB, CC] User1 Review 1
1 Restaurant A 4.5 [AA, BB, CC] User2 Review 2
2 Restaurant A 4.5 [AA, BB, CC] User3 Review 3
3 Restaurant B 5.0 [AA, BB, CC] User1 Review 1
4 Restaurant B 5.0 [AA, BB, CC] User2 Review 2
5 Restaurant B 5.0 [AA, BB, CC] User3 Review 3
但我得到以下输出:
var1 var2 var3 var4 var5
0 Restaurant A 4.5 [AA, BB, CC] User1 Review 1
1 Restaurant A 4.5 [AA, BB, CC] User1 Review 2
2 Restaurant A 4.5 [AA, BB, CC] User1 Review 3
3 Restaurant A 4.5 [AA, BB, CC] User2 Review 1
4 Restaurant A 4.5 [AA, BB, CC] User2 Review 2
5 Restaurant A 4.5 [AA, BB, CC] User2 Review 3
6 Restaurant A 4.5 [AA, BB, CC] User3 Review 1
7 Restaurant A 4.5 [AA, BB, CC] User3 Review 2
8 Restaurant A 4.5 [AA, BB, CC] User3 Review 3
9 Restaurant B 5.0 [AA, BB, CC] User1 Review 1
10 Restaurant B 5.0 [AA, BB, CC] User1 Review 2
11 Restaurant B 5.0 [AA, BB, CC] User1 Review 3
12 Restaurant B 5.0 [AA, BB, CC] User2 Review 1
13 Restaurant B 5.0 [AA, BB, CC] User2 Review 2
14 Restaurant B 5.0 [AA, BB, CC] User2 Review 3
15 Restaurant B 5.0 [AA, BB, CC] User3 Review 1
16 Restaurant B 5.0 [AA, BB, CC] User3 Review 2
17 Restaurant B 5.0 [AA, BB, CC] User3 Review 3
获取用户和评论的多行是错误的。
我试图用下面的代码解决这个问题:
mva_cols = ['var4', 'var5']
counter = 0
for x in zip(mva_cols):
pandaFile = pd.DataFrame({col:np.repeat(pandaFile[col].values,
pandaFile[mva_cols[counter]].str.len()) for col in
pandaFile.columns.difference([mva_cols[counter]])}).assign(**
{mva_cols[counter]:np.concatenate(pandaFile[mva_cols[counter]].values)})
[pandaFile.columns.tolist()]
counter = counter + 1
print(counter)
print(str(pandaFile).encode('utf-8'))
请您参考如下方法:
或者你可以试试
new_df=df.reindex(df.index.repeat(df.var5.str.len()))
new_df.assign(var4=df.var4.sum(),var5=df.var5.sum())
Out[1022]:
var1 var2 var3 var4 var5
0 Restaurant A 4.5 [AA, BB, CC] User1 Review 1
0 Restaurant A 4.5 [AA, BB, CC] User2 Review 2
0 Restaurant A 4.5 [AA, BB, CC] User3 Review 3
1 Restaurant B 5.0 [AA, BB, CC] User1 Review 1
1 Restaurant B 5.0 [AA, BB, CC] User2 Review 2
1 Restaurant B 5.0 [AA, BB, CC] User3 Review 3
