将单元格与 pandas 合并 [英] Merge cells with pandas

问题描述

我想删除重复的单元格并合并它们，因为它们指出了子元素.例如我有一个这样的 df:

I want to remove duplicated cells with merge them all because they point out subelements. For example I have a df like this:

|   | Customer ID | Category      | VALUE   |
| -:|:----------- |:------------- | -------:|
| 0 | HETO90      | Baby Sets     |  1000.0 |
| 1 | HETO90      | Girls Dresses |  5356.0 |
| 2 | HETO90      | Girls Jumpers |  2822.0 |
| 3 | HETO90      | Girls Top     | 13398.0 |
| 4 | HETO90      | Shorts        |  7590.0 |

我只想将 HET090 合并到一个.像这样:

I just want to merge HET090 to the one. Like this:

|   | Customer ID | Category      | VALUE   |
| -:|:----------- |:------------- | -------:|
| 0 |             | Baby Sets     |  1000.0 |
| 1 |             | Girls Dresses |  5356.0 |
| 2 | HETO90      | Girls Jumpers |  2822.0 |
| 3 |             | Girls Top     | 13398.0 |
| 4 |             | Shorts        |  7590.0 |

推荐答案

在 Pandas 中，最里面的索引必须标记每一行.

In pandas the inner most index must label each row.

df = df.set_index('Customer ID', append=True).swaplevel(0,1)

输出:

                    Category    VALUE
Customer ID                          
HETO90      0      Baby Sets   1000.0
            1  Girls Dresses   5356.0
            2  Girls Jumpers   2822.0
            3      Girls Top  13398.0
            4         Shorts   7590.0

这篇关于将单元格与 pandas 合并的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！