Skip to main content
 首页 » 编程设计

python之使用多个变量转换 Panda 文档

2025年01月19日9落叶无声

我正在处理我的 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