读取excel数据 画k线 成交量图

# -*- coding: utf-8 -*-
"""
Created on Tue Mar 23 18:32:15 2021

@author: 
"""
#读取excel数据  画k线 成交量图

import pandas as pd
import numpy as np
import datetime as dt
import matplotlib.pyplot as mp
import matplotlib.dates as md
from matplotlib import gridspec

# 1.读取csv文件数据
'''
#直接读取np.loadtxt得到的dates 是array类型
dates, open_price, max_price, min_price, close_price, volumes = np.loadtxt(
    r".\SPY.csv",
    delimiter=",",
    usecols=(1, 3, 4, 5, 6, 7),
    unpack=True,
    dtype="M8[D], f8, f8, f8, f8, f8",
    converters={1: dmy2ymd})


dates, open_price, max_price, min_price, close_price, volumes = np.loadtxt(
    r".\SPY.csv",
    delimiter=",",
	usecols=(0, 1, 2, 3, 4, 5),
	unpack=True,
	dtype="M8[D], f8, f8, f8, f8, f8"
    )
'''



df=pd.read_csv("short.csv")

dates = df['timestamp']
open_price=df['open']
max_price=df['high']
min