pandasで一分足からOHCLを作成
import pandas as pd
filepass = "C:/Users/aaaa/Desktop/USDJPY_M1/USDJPY_M1.csv"
date = pd.read_csv(filepass, sep=',',header=None,names=('day', 'open', 'high','low', 'close', 'volume'))
date['day'] = pd.to_datetime(date['day'],format='%Y.%m.%d %H:%M')#str to datetime64
df = date.set_index('day')
d_ohlc = {'open': 'first',
'high': 'max',
'low': 'min',
'close': 'last',
'volume': 'sum'}
day_df = df.resample('D').agg(d_ohlc)
day_df = day_df[day_df.index.weekday < 5]#mon==0,...,sun==6
参考:
https://note.nkmk.me/python-pandas-time-series-multiindex/
https://python.civic-apps.com/date-format/
https://note.nkmk.me/python-pandas-time-series-resample-asfreq/
https://note.nkmk.me/python-pandas-resampling-ohlc/
Author And Source
この問題について(pandasで一分足からOHCLを作成), 我々は、より多くの情報をここで見つけました https://qiita.com/konkon375/items/96cb29df51587f8d40fc著者帰属:元の著者の情報は、元のURLに含まれています。著作権は原作者に属する。
Content is automatically searched and collected through network algorithms . If there is a violation . Please contact us . We will adjust (correct author information ,or delete content ) as soon as possible .