如何使用matplotlib更改单位以百万而不是1e7显示x轴

w8f9ii69 于 2023-06-06 发布在其他

关注(0)|答案(1)|浏览(460)

import pyodbc
import pandas as pd
import matplotlib.pyplot as plt

conn = pyodbc.connect('Driver={SQL Server};' # This is what server type we are connecting to
                      'Server=DESKTOP-3JKKF7H;' # This is the location and name of the server, same as what we use to connect using SSMS
                      'Database=AdventureWorks2019;' # This is which database we are connecting to within the selected server
                      'Trusted_Connection=yes;') # This allows us to forgo entering a trusted key or password because we are the admin of this computer and the...
                    # ... database has been configured to allow this user when we set it up. 

cursor = conn.cursor()

query = 'SELECT * FROM Regional'

regional = pd.read_sql(query, conn)

print(regional.head())

regional.plot.barh(x='Region', y='Sales')
plt.xlabel("Sales (10s of millions)")

plt.show()

matplotlib

来源：https://stackoverflow.com/questions/76365432/how-do-i-change-the-units-using-matplotlib-to-show-the-x-axis-in-millions-rather

1条答案

按热度按时间

ljo96ir51#

import numpy as np
import matplotlib.pyplot as plt

data = np.array([28E6, 17E6, 7E6, 6E6, 4E6])
labels = 'Southwest Northwest Central Southeast Northeast'.split()

fig, (ax0, ax1)  = plt.subplots(ncols=2, figsize=(10, 4))
fig.set_layout_engine('constrained')

ax0.barh(labels, data)
ax0.set_xlabel('Sales')

ax1.barh(labels, data/1E6)
ax1.set_xlabel('Sales, in Millions')

plt.show()

赞(0）回复(0）举报 2023-06-06

我来回答

如何使用matplotlib更改单位以百万而不是1e7显示x轴

1条答案

相关问题

热门标签

最新问答