Right pad in pandas python can be accomplished by str.pad() function. let’s see how to
- Right padding of a string column in pandas python.
Syntax of right padding in pandas:
dataframe.column.str.pad(width, side=’right’, fillchar=’ ‘)
width: width of resulting string; additional characters will be filled with spaces.
side: {‘left’, ‘right’, ‘both’}, default ‘left’.
fillchar: additional character which is used for filling
First let’s create a dataframe
import pandas as pd
import numpy as np
#Create a DataFrame
df1 = {
'State':['Arizona AZ','Georgia GG','Newyork NY','Indiana IN','Florida FL'],
'Score':[62,47,55,74,31]}
df1 = pd.DataFrame(df1,columns=['State','Score'])
print(df1)
df1 will be
Right padding of a string column in pandas python:
df1['State']=df1.State.str.pad(15,side='right',fillchar='X') print(df1)
We will be right padding for total 15 characters where the extra right characters are replaced by “X”.
