How to transform numbers in data-frame column to comma separated

Question

i am working with python , so in my dataframe i have a column named Company Profit and values of this column are 33536310, 842925200,.. etc.

I want to convert all values to be comma separated every three digits, like: 231,535,366 etc in whole column

will it work if i try like slicing last 3 digit as string and concatenate comma? — wm 50, Apr 13 '20 at 14:19
Country China 1367643161.29 United States 317615384.615 Japan 127403595.973 United Kingdom 63870967.7419 Russian Federation 143500000.0 Canada 35233864.8649 Germany 80379996.9697 India 1276730769.23 France 63837349.3976 South Korea 49805429.8643 Italy 59908256.8807 Spain 46443396.2264 Iran 77075630.2521 Australia 23316017.316 Brazil 205915254.237 — wm 50, Apr 13 '20 at 14:22
Does this answer your question? [How to insert a comma as a thousands separator in a pandas dataframe column?](https://stackoverflow.com/questions/47404472/how-to-insert-a-comma-as-a-thousands-separator-in-a-pandas-dataframe-column) — rpanai, Apr 13 '20 at 14:34

score 0 · Accepted Answer · answered Apr 13 '20 at 14:27

0

Something like this will work:

In [601]: def thousand_separator(val): 
     ...:     return f"{val:,}"  
     ...: 

In [602]: df['Company Profit'] = df['Company Profit'].apply(thousand_separator) 
In [603]: df['Company Profit']                                                                                                                                                              
Out[602]: 
0     33,536,310
1    842,925,200
Name: Profit, dtype: object

answered Apr 13 '20 at 14:27

Mayank Porwal

33,470
8
37
58

i have tried but it is saying that thousand_separator is not defined. I have imported pandas as well as numpy – wm 50 Apr 13 '20 at 14:32
@wm50 I have already created `thousand_separator` function above. You also copy paste it first. Then run the commands below it. – Mayank Porwal Apr 13 '20 at 14:33
where is the option to accept? actually i m new here – wm 50 Apr 14 '20 at 14:37

score 0 · Answer 2 · answered Apr 13 '20 at 14:54

Alternatively you can do this with f-string in newer version of Python. Use comma as a separator:

df = pd.DataFrame({'Company Profit':[33536310,842925200,231535366]})
df['Company Profit'] = df['Company Profit'].apply(lambda x: f"{x:,}")
print(df)

  Company Profit
0     33,536,310
1    842,925,200
2    231,535,366

How to transform numbers in data-frame column to comma separated

2 Answers2