【送书】手把手教你用Python直观查看贵州茅台股票交易数据

#  coding=utf-8# 代码文件：chapter6/ch6.2.6.py
import matplotlib.pyplot as pltimport pandas as pd
plt.rcParams['font.family'] = ['SimHei']    # 设置中文字体plt.rcParams['axes.unicode_minus'] = False   # 设置负号正常显示
plt.figure(figsize=(15, 5))
f = r'data\股票的历史交易数据.xlsx'

df = pd.read_excel(f)
df2 = df.query("Date >='2021-03-01' and Date < '2021-04-01'").sort_values(by='Date')  ①
# 绘制折线plt.plot(df2['Date'], df2['Volume'])            ②
plt.title('贵州茅台股票')plt.ylabel('成交量')                      # 添加y轴标题plt.xlabel('交易日期'


    
)                    # 添加x轴标题plt.xticks(rotation=40)plt.show()

#  coding=utf-8# 代码文件：chapter6/ch6.2.7.py
import matplotlib.pyplot as pltimport pandas as pd
plt.rcParams['font.family'] = ['SimHei']       # 设置中文字体plt.rcParams['axes.unicode_minus'] = False    # 设置负号正常显示
plt.figure(figsize=(15, 5))
f = r'data\股票的历史交易数据.xlsx'
df = pd.read_excel(f)
df2 = df.query("Date >='2021-03-01' and Date < '2021-04-01'").sort_values(by='Date')
plt.title('贵州茅台股票历史OHLC折线图')plt.plot(df2['Date'], df2['Open'], label='开盘价')     ①plt.plot(df2['Date'], df2['High'], label='最高价')plt.plot(df2['Date'], df2['Low'], label='最低价')plt.plot(df2['Date'], df2['Close'], label='收盘价')    ②
plt.ylabel('成交量')plt.xlabel('交易日期')plt.xticks(rotation=40)
plt.show()