CODEWITHSUNDEEP
pythonpython-3.xpandasdataframestring-formatting
splinter
splinter

Reputation: 3897

Converting numbers to particular string format in a pandas DataFrame

I need to run a task which can be done with a loop, but I imagine that there is a more efficient and pretty way to do this. I have a DataFrame which has an integer column, which I would like to transform to a 4-digit string representation. That is, 3 should be converted to '0003', 234 should be converted to '0234'. I am looking for a vector operation that will do this to all entries in the column at once, quickly with simple code.

Upvotes: 12

Views: 21122

Answers (2)

craigim
craigim

Reputation: 3914

You can also do this using the Series.apply() method and an f-string wrapped in a lambda function:

In [1]: import pandas as pd


In [2]: df = pd.DataFrame({'a':[1,2], 'b':[3,234]})

In [3]: df
Out[3]:
   a    b
0  1    3
1  2  234

In [4]: df['b'] = df['b'].apply(lambda x: f"{x:04d}")

In [5]: df
Out[5]:
   a     b
0  1  0003
1  2  0234

In the f-string, the part after the colon says "zero-pad the field with four characters and make it a signed base-10 integer".

Upvotes: 8

MaxU - stand with Ukraine
MaxU - stand with Ukraine

Reputation: 210832

you can use Series.str.zfill() method:

df['column_name'] = df['column_name'].astype(str).str.zfill(4)

Demo:

In [29]: df = pd.DataFrame({'a':[1,2], 'b':[3,234]})

In [30]: df
Out[30]:
   a    b
0  1    3
1  2  234

In [31]: df['b'] = df['b'].astype(str).str.zfill(4)

In [32]: df
Out[32]:
   a     b
0  1  0003
1  2  0234

Upvotes: 14

Related Questions