python - mpl_finance 删除 Candlestick Python 上的空日期
问题描述
我正在使用 DataFrame。我的数据用于烛台。问题是我无法删除周末日期。我的意思是,我的代码显示了这一点: 在此处输入图像描述
我正在寻找这个: 在此处输入图像描述
这是我的代码:
import matplotlib.ticker as ticker
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from mpl_finance import candlestick_ohlc
df = pd.read_csv('AAPL.csv')
df['Date'] = pd.to_datetime(df['Date'])
df["Date"] = df["Date"].apply(mdates.date2num)
dates = df['Date'].tolist()
ohlc = df[['Date', 'Open', 'High', 'Low','Close']]
f1, ax = plt.subplots(figsize = (12,6))
candlestick_ohlc(ax, ohlc.values, width=.5, colorup='green', colordown='red')
ax.xaxis.set_major_locator(ticker.MultipleLocator(1.0))
ax.xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d'))
plt.setp(ax.get_xticklabels(), rotation=70, fontsize=7)
close = df['Close'].values
plt.plot(dates,close, marker='o')
plt.show()
数据框:
Date,Open,High,Low,Close,Adj Close,Volume
2019-02-04,167.410004,171.660004,167.279999,171.250000,170.518677,31495500
2019-02-05,172.860001,175.080002,172.350006,174.179993,173.436157,36101600
2019-02-06,174.649994,175.570007,172.850006,174.240005,173.495911,28239600
2019-02-07,172.399994,173.940002,170.339996,170.940002,170.210007,31741700
2019-02-08,168.990005,170.660004,168.419998,170.410004,170.410004,23820000
2019-02-11,171.050003,171.210007,169.250000,169.429993,169.429993,20993400
2019-02-12,170.100006,171.000000,169.699997,170.889999,170.889999,22283500
2019-02-13,171.389999,172.479996,169.919998,170.179993,170.179993,22490200
2019-02-14,169.710007,171.259995,169.380005,170.800003,170.800003,21835700
2019-02-15,171.250000,171.699997,169.750000,170.419998,170.419998,24626800
2019-02-19,169.710007,171.440002,169.490005,170.929993,170.929993,18972800
2019-02-20,171.190002,173.320007,170.990005,172.029999,172.029999,26114400
2019-02-21,171.800003,172.369995,170.300003,171.059998,171.059998,17249700
2019-02-22,171.580002,173.000000,171.380005,172.970001,172.970001,18913200
2019-02-25,174.160004,175.869995,173.949997,174.229996,174.229996,21873400
2019-02-26,173.710007,175.300003,173.169998,174.330002,174.330002,17070200
2019-02-27,173.210007,175.000000,172.729996,174.869995,174.869995,27835400
2019-02-28,174.320007,174.910004,172.919998,173.149994,173.149994,28215400
解决方案
这是“不够”的解决方案,但我可以为你提出一些建议。
只需使用
import mplfinance as mpf
mpf.plot(df, type='candle')
这会自动忽略情节中的非交易日,让我更快乐一点,尽管我不能完全满意。我希望这会帮助你。
看一下这个。
推荐阅读
- ios - FirstResponder 只能在 textView 的一小部分中被点燃
- corda - 不支持同时使用多个模拟网络
- bash - bash 脚本中多个函数的计时执行时间
- sql - 如何拆分多个字符串并插入 SQL Server FN_SplitStr
- java - 将数据从活动传递到底部导航栏的片段
- reactjs - 可以从一台服务器向另一台服务器发出请求 - “错误:请求失败,状态码 401”
- c# - 从.NetCore2.1更改TargetFramework时如何替换Database.ExecuteSqlQuery
- ios - == 运算符什么时候依赖于 Equatable,什么时候不依赖?
- javascript - 如何使用 php 向数据库表中插入多个值?
- python-3.x - 如何遍历文件的每一行并将该文件的每一行与第二个文件的所有行匹配?