Adding comma separators to a string in a Dataframe Column with pandas

Question

I am trying to add comma separators to indicate thousands to my string to a column in a dataframe. Can someone help with format? I do not understand how to do this to an entire column in a dataframe

Top15['PopEst'] = re.sub("(\d)(?=(\d{3})+(?!\d))", r"\1,", "%d" % Top15['PopEst'])

I got the code from there originally. I do not understand how to do this for the entire row in the dataframe. — python_new_user, Nov 28 '16 at 07:33

score 4 · Answer 1 · edited Dec 28 '16 at 08:35

4

I think what you are looking for is this:

Top15["PopEst"] = Top15["PopEst"].map(lambda x: "{:,}".format(x))

The "{:,}".format() would work as a thousand separator for a single string/float/int, so you can use map() to apply it to each of the elements in column.

edited Dec 28 '16 at 08:35

GilZ

6,418
5
30
40

answered Dec 28 '16 at 06:40

Thomas Thoresen

41
1

score 0 · Answer 2 · edited Mar 01 '17 at 12:43

0

I think this will help you.

v= format(12345678, ',d')
print(v)
//12,345,678

edited Mar 01 '17 at 12:43

Mistalis

17,793
13
73
97

answered Mar 01 '17 at 12:20

Chandu_Muthyala

1
1

score 0 · Answer 3 · answered Mar 01 '17 at 12:33

Top15['PopEst']=(Top15['Energy Supply']/Top15['Energy Supply per Capita'])
df = Top15[['PopEst']]
df = df.reset_index()

i=0
while(len(df)>i):
    v =str(df.iloc[i]['PopEst']).split('.')

    strr = str(format(int(v[0]), ',d'))+"."+v[1]

    df.iloc[i] = df.iloc[i].replace(df.iloc[i]['PopEst'],strr)

    i = i+1

df.set_index(['Country Name'], inplace=True)

Adding comma separators to a string in a Dataframe Column with pandas

3 Answers3