在Python中的数据框列中添加百分号 [英] Add a percent sign to a dataframe column in Python

问题描述

我一直在尝试向数据框中的列添加百分号，但无济于事.有人有什么主意吗?

I've been attempting to add a percent sign to a column in my dataframe but to no avail. Would anyone have any idea?

import pandas as pd

names = ('jimmy', 'red', 'julie', 'brad', 'oranges')
score = (82, 38 , 55, 19, 33)

df = pd.DataFrame({'Name': names, 'Grade': score})

df
Out[20]: 
   Grade     Name
0     82    jimmy
1     38      red
2     55    julie
3     19     brad
4     33  oranges

我进行了无数次尝试，但似乎没有任何效果.这是一次失败的尝试:

I've made numerous attempts but nothing seems to work out. Here is one failed attempt:

df['Percent'] = str(df['Grade']) + '%'
df['Percent']
Out[22]: 
0    0    82\n1    38\n2    55\n3    19\n4    33\nN...
1    0    82\n1    38\n2    55\n3    19\n4    33\nN...
2    0    82\n1    38\n2    55\n3    19\n4    33\nN...
3    0    82\n1    38\n2    55\n3    19\n4    33\nN...
4    0    82\n1    38\n2    55\n3    19\n4    33\nN...
Name: Percent, dtype: object

推荐答案

使用您尝试将列转换为Series的字符串化版本:

What you tried just converted the column to a stringified version of a Series:

In [12]:
str(df['Grade'])

Out[12]:
'0    82\n1    38\n2    55\n3    19\n4    33\nName: Grade, dtype: int32'

这篇关于在Python中的数据框列中添加百分号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！