CODEWITHSUNDEEP
pythonpandasdataframe
betanoox
betanoox

Reputation: 81

Change column values in a Pandas Dataframe to show numbers as Milions

i have a Pandas DataFrame

   Symbol  Name  ...  % Change      Volume
9     XXX  YYY   ...     -3.62  58792000.0
11    XXX  YYY   ...      0.18  58587000.0

I would like to change the values in 'Volume' to have this result

   Symbol  Name  ...  % Change      Volume
9     XXX  YYY   ...     -3.62  58.792M
11    XXX  YYY   ...      0.18  58.587M

Upvotes: 2

Views: 254

Answers (2)

sophocles
sophocles

Reputation: 13831

We can get to your desired result literally step by step, by adding a '$' sign, dividing the number by 1000000, and adding the MM suffix:

df['Volume'] = '$' + (df['Volume'].astype(float)/1000000).astype(str) + 'MM'

print(df)

  Symbol Name  % Change     Volume
0    XXX  YYY    -3.620  $58.792MM
1    XXX  YYY     0.180  $58.587MM

Note that the resulting 'Volume' dtype will be object:

df.dtypes

Symbol       object
Name         object
% Change    float64
Volume       object
dtype: object

Happy to see if there's a more pythonic way by others.

Upvotes: 1

Akshay Sehgal
Akshay Sehgal

Reputation: 19332

How about something simple like this -

(df.Volume/1000000).round(3).astype(str)+'M'

Just divide the column by a million, round it to 3 significant digits, convert to str, and then add an 'M' at the end.

Upvotes: 1

Related Questions