Converting aggregated y-axis into millions/billions

plotly.js
1

Hi team, I have used df.groupby to group the value.
df1 = pd.DataFrame({'DEMAND': df.groupby(['STATE', 'YEAR'])['DEMAND'].sum()}).reset_index()

Now when I plot df1: DEMAND on y-axis and YEAR on x-axis using px.line.
Y- axis values appears way to big(7888999977898789.23). I want to show values in Millions/ Billions/ 100k etc.

Any help will be appreciated.

Thanks.

2

Transform the values first using Pandas and then plot the graph.

3

Thanks Eduardo. I figured it out, it was problem in sqlite database, I have used CAST to limit values to decimal upto 2 places. px automatically converted values to Millions.

4

Double-click the numbers in the axis labels. In the resulting settings area, find the Display Units dropdown and choose Millions. Change the axis Display Units.

www.tellthebell.com