如何使用python筛选timeseries或dataframe中的日期范围

Question

仍然是Python的新手，只是想学习这些东西。谢谢你的帮助

现在，当我连接到Alpha Vantage时，我得到了所有日期的全部数据，看起来是这样的

我找到了一些很好的指南来源，但我总是得到空的数据帧或错误

到目前为止，代码就是这样的

import pandas as pd
from pandas import DataFrame
import datetime
from datetime import datetime as dt
from alpha_vantage.timeseries import TimeSeries
import numpy as np

stock_ticker = 'SPY'
api_key = open('/content/drive/My Drive/Colab Notebooks/key').read()

ts = TimeSeries (key=api_key, output_format = "pandas")
data_daily, meta_data = ts.get_daily_adjusted(symbol=stock_ticker, outputsize ='full')
#data_date_changed = data[:'2019-11-29']

data = pd.DataFrame(data_daily)

df.loc[datetime.date(year=2014,month=1,day=1):datetime.date(year=2015,month=2,day=1)]

Answer 1

答案是

stock_ticker = 'SPY'
api_key = 'apikeyddddd'

ts = TimeSeries (key=api_key, output_format = "pandas")
data_daily, meta_data = ts.get_daily_adjusted(symbol=stock_ticker, outputsize ='full')

test = data_daily[(data_daily.index > '2014-01-01') & (data_daily.index <= '2017-08-15')]

print(data_daily)
print(test)

Answer 2

import datetime 
df.loc[datetime.date(year=2014,month=1,day=1):datetime.date(year=2014,month=2,day=1)]

根据我的经验，不能在loc中传递简单的字符串，它必须是datetime对象