我试图逐日遍历数据帧。你知道吗
我的数据如下:
open high low close volume
date
2019-12-18 09:15:00+05:30 182.10 182.30 180.55 181.30 4252638
2019-12-18 09:30:00+05:30 181.30 183.45 181.00 183.20 5869850
2019-12-18 09:45:00+05:30 183.35 184.50 183.05 183.25 5201947
2019-12-18 10:00:00+05:30 183.25 183.30 182.45 182.90 2029440
2019-12-18 10:15:00+05:30 182.95 183.25 181.50 182.00 2613453
... ... ... ... ... ...
2019-12-24 14:15:00+05:30 175.40 175.70 175.10 175.40 480322
2019-12-24 14:30:00+05:30 175.40 175.60 174.65 174.80 1193108
2019-12-24 14:45:00+05:30 174.80 176.10 174.75 175.55 1765370
2019-12-24 15:00:00+05:30 175.50 175.75 174.90 175.50 1369208
2019-12-24 15:15:00+05:30 175.45 175.75 175.20 175.40 2010583
我试过了
(df['date'] >= "18-12-2019 09:00:00") & (df['date'] <= "18-12-2019 16:00:00")
但是我不需要特定日期的数据,我希望根据日期将当前数据帧拆分为多个数据帧,并将其存储在一个数组中。我该怎么做?你知道吗
预期产量:
res = [] # list of dataframes length = number of days
res[0] =
open high low close volume
date
2019-12-18 09:15:00+05:30 182.10 182.30 180.55 181.30 4252638
2019-12-18 09:30:00+05:30 181.30 183.45 181.00 183.20 5869850
2019-12-18 09:45:00+05:30 183.35 184.50 183.05 183.25 5201947
2019-12-18 10:00:00+05:30 183.25 183.30 182.45 182.90 2029440
2019-12-18 10:15:00+05:30 182.95 183.25 181.50 182.00 2613453
res[1] =
open high low close volume
date
2019-12-19 09:15:00+05:30 182.10 182.30 180.55 181.30 4252638
2019-12-19 09:30:00+05:30 181.30 183.45 181.00 183.20 5869850
2019-12-19 09:45:00+05:30 183.35 184.50 183.05 183.25 5201947
2019-12-19 10:00:00+05:30 183.25 183.30 182.45 182.90 2029440
2019-12-19 10:15:00+05:30 182.95 183.25 181.50 182.00 2613453
...
...
res[n] =
2019-12-24 14:15:00+05:30 175.40 175.70 175.10 175.40 480322
2019-12-24 14:30:00+05:30 175.40 175.60 174.65 174.80 1193108
2019-12-24 14:45:00+05:30 174.80 176.10 174.75 175.55 1765370
2019-12-24 15:00:00+05:30 175.50 175.75 174.90 175.50 1369208
2019-12-24 15:15:00+05:30 175.45 175.75 175.20 175.40 2010583
将不同的日期数据吐出并放入数组中。你知道吗
您可以尝试
groupby
方法并以您喜欢的方式聚合所有其他列。例如:OHLC将成为:
相关问题 更多 >
编程相关推荐