python - 如何从数据框创建列表列表
问题描述
我有一个数据框df,我想将数据框转换为列表列表
left_side right_side similarity
0114600043776001 loan payment receipt 0421209017073500 loan payment receipt 0.689008
0114600043776001 loan payment receipt 0421209017073500 loan payment receipt 0.689008
vat onverve*issuance fee*506108 vat onverve*issuance fee*5061087 0.743522
vat onverve*issuance fee*506108 verve*issuance fee*506108*********1112 0.684342
verve*issuance fee*506108 verve*issuance fee*506108*********8296 0.717817
verve*issuance fee*506108 vat onverve*issuance fee*506108** 0.684342
maint fee recovery jun 2018 vat maint fee recovery jun 2018 0.896607
maint fee recovery jun 2018 vat maint fee recovery jun 2018 0.896607
maint fee recovery jun 2018 vat maint fee recovery jun 2018 0.896607
预期输出应如下所示:
[[0114600043776001 loan payment receipt, 0421209017073500 loan payment receipt,
0421209017073500 loan payment receipt],
[vat onverve*issuance fee*506108, vat onverve*issuance fee*5061087,
verve*issuance fee*506108*********1112],
[verve*issuance fee*506108*********8296, verve*issuance fee*506108
vat onverve*issuance fee*506108** ],...]
我尝试将上述 df 分组left_side column
并将结果 df 转换为列表,但输出不是我所期望的。请在这方面需要你的帮助
grouup_df = df.groupby(['left_side']).right_side.sum().to_frame()
grouup_df.values.tolist()
输出如下所示:
['0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt']
['vat maint fee recovery jun 2018vat maint fee recovery jun 2018vat maint fee recovery jun 2018maint fee recovery jul 2018maint fee recovery oct 2018maint fee recovery jul 2018maint fee recovery jul 2018']
解决方案
import pandas as pd
dfold = {'left_side': ['string','string','string','string'],
'right_side': ['string','string','string','string']
}
df = pd.DataFrame(dfold, columns= ['left_side', 'right_side'])
print(df)
df_list = df.values.tolist()
print(df_list)
推荐阅读
- mysql - 在事务中插入多行,如果其中一个失败,则插入其余行
- java - 我可以检测到用户何时打开其他应用程序吗?
- java - 如何关闭 GUI 窗口并使用 Java 中的内部类打印出一些文本?
- xamarin - 有没有办法可以在我的 Xamarin.Forms 应用程序中访问项目的构建版本?
- sql - T-SQL按时间间隔计数并找到最高频率
- c - 我的二进制搜索树的预遍历代码正在工作,但是每个元素都是指向结构的指针的堆栈是如何工作的?
- sql-server - 将多行转换为多列sql server
- wpf - 如何在更高级别设置datatrigger的绑定数据
- angular - 如何使用 API 获取数据初始化图表?
- javascript - 创建带有背景图像的 Javascript 图库