-1

the question I have pertains to formatting in pandas / python. The question below is stated.

The trading volume numbers are large. Scale the trading volume to be in millions of shares. Ex: 117,147,500 shares will become 117.1475 million after scaling.

This is what the dataframe looks like. I need it to be fixed for all 125 rows.

enter image description here

Patrick Cod
  • 19
  • 3

3 Answers3

1

Probably the simplest way is to divide the whole column by a million

apple['volume'] = apple['volume'].div(1000000)
DavidCox88
  • 813
  • 1
  • 10
  • hmm. That is still giving the volume in a weird format. Now I have 8.56e-05 7.64e-05 5.84e-05 etc – Patrick Cod Apr 28 '22 at 13:03
  • @PatrickCod it's a scientific notation. You can convert those numbers to float. https://stackoverflow.com/questions/25099626/convert-scientific-notation-to-float – Hellmick Apr 28 '22 at 13:09
1

You can substitute numbers like 117147500 in the following two ways: either with floating point numbers:

import pandas as pd
dictionary = {'Column':[4,5,6,7], 'Volume':[117147500,12000,14000,18000]}
df = pd.DataFrame(dictionary)
df

df_scaled_column=df['Volume']/1000000

# Replace old column with scaled values
df['Volume'] = df_scaled_column
df

Out: 
   Column    Volume
0       4  117.1475
1       5    0.0120
2       6    0.0140
3       7    0.0180

or with strings. In particular I use a function that I found from an answer to this SE post formatting long numbers as strings in python:

import pandas as pd
dictionary = {'Column':[4,5,6,7], 'Volume':[117147500,12000,14000,18000]}
df = pd.DataFrame(dictionary)
df

# Function defined in a old StackExchange post
def human_format(num):
    num = float('{:.3g}'.format(num))
    magnitude = 0
    while abs(num) >= 1000:
        magnitude += 1
        num /= 1000.0
    return '{}{}'.format('{:f}'.format(num).rstrip('0').rstrip('.'), ['', 'K', 'M', 'B', 'T'][magnitude])

# Example of what the function does
human_format(117147500) #'117M'

# Create empty list
numbers_as_strings = []

# Fill the empty list with the formatted values
for number in df['Volume']:
    numbers_as_strings.append(human_format(number))

# Create a dataframe with only one column containing formatted values
dictionary = {'Volume': numbers_as_strings}
df_numbers_as_strings = pd.DataFrame(dictionary)

# Replace old column with formatted values
df['Volume'] = df_numbers_as_strings
df

Out: 
   Column Volume
0       4   117M
1       5    12K
2       6    14K
3       7    18K
Student.py
  • 225
  • 3
  • 14
  • is there a way to take away the scientific notation. This does divide the billions but now the trading volume ends with scientific notation as opposed to "M" – Patrick Cod Apr 28 '22 at 13:10
  • Sorry but I do not understand what you mean... in the post you said *Ex: 117,147,500 shares will become 117.1475 million after scaling.* So 117147500 becomes 117.1475. How do you want it ? – Student.py Apr 28 '22 at 13:15
  • @PatrickCod I added an other solution ! I hope it is the one you were looking for. – Student.py Apr 28 '22 at 14:58
1

You can use transform() method (https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.transform.html) and divide those volume numbers by 1000,000.

Hellmick
  • 99
  • 2
  • 11