索引更改在新数据帧上不起作用

2024-09-27 20:17:13 发布

您现在位置:Python中文网/ 问答频道 /正文

我将字典转换为数据帧并更改索引,但仍然得到熊猫分配的数字索引号。为什么索引没有更改为name列

import numpy as np
import pandas as pd

exam_scores = {'name': ['Anastasia', 'Dima', 'Katherine', 'James', 'Emily', 'Michael', 'Matthew', 'Laura', 'Kevin', 'Jonas'],
'score': [12.5, 9, 16.5, np.nan, 9, 20, 14.5, np.nan, 8, 19]}
scores = pd.DataFrame(exam_scores)
scores.set_index('name')
print(scores.describe)

<bound method NDFrame.describe of         name  score
0  Anastasia   12.5
1       Dima    9.0
2  Katherine   16.5
3      James    NaN
4      Emily    9.0
5    Michael   20.0
6    Matthew   14.5
7      Laura    NaN
8      Kevin    8.0
9      Jonas   19.0>

Tags: nameimportasnppdexammichaelscores
1条回答
网友
1楼 · 发布于 2024-09-27 20:17:13

将其设置到位,使重置索引永久化

import numpy as np
import pandas as pd

exam_scores = {'name': ['Anastasia', 'Dima', 'Katherine', 'James', 'Emily', 'Michael', 'Matthew', 'Laura', 'Kevin', 'Jonas'],
'score': [12.5, 9, 16.5, np.nan, 9, 20, 14.5, np.nan, 8, 19]}
scores = pd.DataFrame(exam_scores)
scores.set_index('name', inplace=True)
scores

相关问题 更多 >

    热门问题