取消合并或填充pandas groupby datafram中的列

2024-05-23 16:23:14 发布

您现在位置：Python中文网/ 问答频道 /正文
9160 3

我有一个数据帧，当打印在终端或发送到excel文件如下所示。在

+-----------------------------------------------------------------------------------------------------------+
| 112      Martin Messenger Bag                  MRKT-15-0004  Accessories Watch by Featured Host       NaN |
| 262      Fauna Pouch Kitten                    AREA-15-0050  Accessories Watch by Featured Host       NaN |
| 263      Key Cable                             NATI-15-0005  Gadgets     Featured                     NaN |
|                                                                          Gadgets                      NaN |
|                                                                          Summer Staples               NaN |
| 110      Winter Remedy Pack                    ECOA-15-0002  Home Goods  Home Goods                   NaN |
| 109      Travel Set                            ECOA-15-0001  Beauty      Featured                     NaN |
| 274      Ideal Notebook for iPhone             MOLLA-15-0014 Gadgets     Watch by Featured Host       NaN |
+-----------------------------------------------------------------------------------------------------------+

当前项目263在发送到excel时合并了单元格。填充两个合并行的数据的最佳方法是什么？这是pandas.DataFrame.reset_index的情况吗？在

编辑：我正在用XlsxWriter库编写excel文件


Tags： 文件数据终端hosthomebynanexcel
1条回答
网友
1楼 · 发布于 2024-05-23 16:23:14

merge_cells是一个默认为True的选项。尝试将其设置为False。在

df.to_excel(merge_cells=False)

相关问题 更多 >

    编程相关推荐