python - 重命名 pandas 数据框的第一行

Question

更新:

View of the Dataframe

@jezrael，请找到我所指的数据框的图像。希望这有帮助。

我有一个使用 (value_counts) 函数构建的 pandas 数据框。输出有两列标题，带有标签 Unnamed:0,Unnamed:1

下面给出的是数据框的 View :

Unnamed:0,Unnammed:1
Drop less than 1%,3
Drop less than 2%,5
Drop less than 3%,2

下面给出的是我用来构建此数据框的代码:

Output1.groupby(['Status']).agg(lambda x: x.mad())
Output1 = Output1.replace(np.nan, '', regex=True)
SumMail = pd.DataFrame(pd.value_counts(Output1['Status']).sort_index())
SumMail.rename(columns=lambda x: x[10:], inplace=True)

任何人都可以建议我如何让这个标题有一个标签。谢谢。

谢谢..

Answer 1

我相信需要:

Output1 = pd.DataFrame({'Status': ['Drop less than 1%',
                                   'Drop less than 1%',
                                    np.nan, 
                                   'Drop less than 2%', 
                                   'Drop less than 2%', 
                                   'Drop less than 3%']})

print (Output1)
              Status
0  Drop less than 1%
1  Drop less than 1%
2                NaN
3  Drop less than 2%
4  Drop less than 2%
5  Drop less than 3%

Output1 = Output1.replace(np.nan, '', regex=True)
SumMail = (Output1['Status'].value_counts()
                            .sort_index()
                            .head(10)
                            .rename_axis('a')
                            .reset_index(name='b'))
print (SumMail)
                   a  b
0                     1
1  Drop less than 1%  2
2  Drop less than 2%  2
3  Drop less than 3%  1