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', '

Solution 1:

Cast the dtype to str using astype:

In [11]:
df['Percent'] = df['Grade'].astype(str) + '%'df

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

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'

Solution 2:

I find that the easiest way to do it:

df['Percent'] = df['Grade'].map("{:,.2f}%".format)

Solution 3:

You can do it like that too :

df['Percent'] = df['Grade'].apply( lambda x : str(x) + '%')