pandas的日期处理，按日期索引到某一行

最新推荐文章于 2023-04-24 20:33:36 发布

原创最新推荐文章于 2023-04-24 20:33:36 发布 · 3.2k 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

data analysis 专栏收录该内容

2 篇文章

订阅专栏

博客内容介绍了如何在pandas中对数据进行日期处理，特别是如何根据日期精确地索引到某一行数据，详细展示了操作过程和最终成功输出的结果。

import pandas_datareader as pdr

AAPL= pdr.get_data_yahoo('AAPL')
AAPL['2010-10']

output：

                 High        Low       Open      Close       Volume  Adj Close
Date                                                                          
2010-10-01  40.939999  40.192856  40.878571  40.360001  112035700.0  26.912174
2010-10-04  40.414288  39.681427  40.228573  39.805714  108825500.0  26.542568
2010-10-05  41.349998  40.259998  40.285713  41.277142  125491800.0  27.523726
2010-10-06  41.712856  40.751427  41.369999  41.312859  167717200.0  27.547533
2010-10-07  41.497143  40.987144  41.477142  41.317142  102099900.0  27.550398
2010-10-08  42.071430  41.428570  41.672855  42.009998  164600800.0  28.012390
2010-10-11  42.462856  42.085712  42.105713  42.194286  106938300.0  28.135275
2010-10-12  42.785713  41.784286  42.201427  42.648571  139636000.0  28.438200
2010-10-13  43.137142  42.828571  42.885715  42.877144  157523100.0  28.590605
2010-10-14  43.209999  42.914288  43.098572  43.187141  108824100.0  28.797312
2010-10-15  45.000000  43.558571  43.919998  44.962856  230548500.0  29.981359
2010-10-18  45.571430  44.898571  45.495716  45.428570  273252700.0  30.291903
2010-10-19  44.824287  42.860001  43.342857  44.212856  308196000.0  29.481264
2010-10-20  44.892857  43.838570  44.142857  44.361427  180406100.0  29.580330
2010-10-21  44.962856  43.828571  44.622856  44.217144  137865000.0  29.484123
2010-10-22  44.291428  43.757141  44.152859  43.924286   93194500.0  29.288843
2010-10-25  44.514286  44.062859  44.155716  44.119999   98115500.0  29.419352
2010-10-26  44.248573  43.664288  43.838570  44.007141   98232400.0  29.344099
2010-10-27  44.271427  43.657143  43.950001  43.975716   99750700.0  29.323145
2010-10-28  44.000000  42.985714  43.992859  43.605713  137762800.0  29.076427
2010-10-29  43.697144  42.981430  43.461430  42.997143  107627800.0  28.670630

但是：

AAPL['2010-10-01']

output

KeyError: '2010-10-01'

最后换成

AAPL.loc['2010-10-01']

成功
output:

High         4.094000e+01
Low          4.019286e+01
Open         4.087857e+01
Close        4.036000e+01
Volume       1.120357e+08
Adj Close    2.691217e+01
Name: 2010-10-01 00:00:00, dtype: float64