删除python pandas.DataFrame 的多重index实例
如下dataframe想要删除多层index
top1000[:10]
| name | sex | births | year | prop | |||
|---|---|---|---|---|---|---|---|
| year | sex | ||||||
| 1880 | F | 0 | Mary | F | 7065 | 1880 | 0.077643 |
| 1 | Anna | F | 2604 | 1880 | 0.028618 | ||
| 2 | Emma | F | 2003 | 1880 | 0.022013 | ||
| 3 | Elizabeth | F | 1939 | 1880 | 0.021309 | ||
| 4 | Minnie | F | 1746 | 1880 | 0.019188 | ||
| 5 | Margaret | F | 1578 | 1880 | 0.017342 | ||
| 6 | Ida | F | 1472 | 1880 | 0.016177 | ||
| 7 | Alice | F | 1414 | 1880 | 0.015540 | ||
| 8 | Bertha | F | 1320 | 1880 | 0.014507 | ||
| 9 | Sarah | F | 1288 | 1880 | 0.014155 |
top1000.index = top1000.index.droplevel() top1000.index = top1000.index.droplevel() top1000[:10]
| name | sex | births | year | prop | |
|---|---|---|---|---|---|
| 0 | Mary | F | 7065 | 1880 | 0.077643 |
| 1 | Anna | F | 2604 | 1880 | 0.028618 |
| 2 | Emma | F | 2003 | 1880 | 0.022013 |
| 3 | Elizabeth | F | 1939 | 1880 | 0.021309 |
| 4 | Minnie | F | 1746 | 1880 | 0.019188 |
| 5 | Margaret | F | 1578 | 1880 | 0.017342 |
| 6 | Ida | F | 1472 | 1880 | 0.016177 |
| 7 | Alice | F | 1414 | 1880 | 0.015540 |
| 8 | Bertha | F | 1320 | 1880 | 0.014507 |
| 9 | Sarah | F | 1288 | 1880 | 0.014155 |
Out[484]:
| name | sex | births | year | prop | |
|---|---|---|---|---|---|
| 0 | Mary | F | 7065 | 1880 | 0.077643 |
| 1 | Anna | F | 2604 | 1880 | 0.028618 |
| 2 | Emma | F | 2003 | 1880 | 0.022013 |
| 3 | Elizabeth | F | 1939 | 1880 | 0.021309 |
| 4 | Minnie | F | 1746 | 1880 | 0.019188 |
| 5 | Margaret | F | 1578 | 1880 | 0.017342 |
| 6 | Ida | F | 1472 | 1880 | 0.016177 |
| 7 | Alice | F | 1414 | 1880 | 0.015540 |
| 8 | Bertha | F | 1320 | 1880 | 0.014507 |
| 9 | Sarah | F | 1288 | 1880 | 0.014155 |
以上这篇删除python pandas.DataFrame 的多重index实例就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持【听图阁-专注于Python设计】。