我有一个来自雅虎财经的数据框架。该数据帧有两个索引列。
data = pdr.get_data_yahoo(['AAPL','AMAZ'],start = datetime.date(2018, 1, 1) ,end= datetime.date.today())
data
从数据帧开始,只有AAPL信息的子数据帧该怎么做?
这是我得到的:
Open High Low Close Adj Close Volume
AAPL AMAZ AAPL AMAZ AAPL AMAZ AAPL AMAZ AAPL AMAZ AAPL AMAZ
Date
2018-01-02 170.160004 0.55200 172.300003 0.56143 169.259995 0.53000 172.259995 0.54000 169.712067 0.54000 25555900 26229
2018-01-03 172.529999 0.53800 174.550003 0.58000 171.960007 0.50000 172.229996 0.55000 169.682510 0.55000 29517900 51364
2018-01-04 172.539993 0.55000 173.470001 0.63000 172.080002 0.51000 173.029999 0.60000 170.470703 0.60000 22434600 45018
2018-01-05 173.440002 0.60000 175.369995 0.75000 173.050003 0.60000 175.000000 0.65000 172.411560 0.65000 23660000 88304
2018-01-08 174.350006 0.65000 175.610001 0.70000 173.929993 0.60000 174.350006 0.65000 171.771179 0.65000 20567800 27933
2018-01-09 174.550003 0.69000 175.059998 0.69000 173.410004 0.64000 174.330002 0.65000 171.751465 0.65000 21584000 17100
2018-01-10 173.160004 0.62000 174.300003 0.63000 173.000000 0.60000 174.289993 0.60000 171.712051 0.60000 23959900 18038
2018-01-11 174.589996 0.60000 175.490005 0.69000 174.490005 0.55000 175.279999 0.63045 172.687408 0.63045 18667700 28100
2018-01-12 176.179993 0.55500 177.360001 0.62690 175.649994 0.55500 177.089996 0.60010 174.470642 0.60010 25226000 29550
这就是我想要的:
Open High Low Close Adj Close Volume
Date
2018-01-02 170.160004 172.300003 169.259995 172.259995 169.712067 25555900
2018-01-03 172.529999 174.550003 171.960007 172.229996 169.682510 29517900
2018-01-04 172.539993 173.470001 172.080002 173.029999 170.470703 22434600
2018-01-05 173.440002 175.369995 173.050003 175.000000 172.411560 23660000
2018-01-08 174.350006 175.610001 173.929993 174.350006 171.771179 20567800
2018-01-09 174.550003 175.059998 173.410004 174.330002 171.751465 21584000
2018-01-10 173.160004 174.300003 173.000000 174.289993 171.712051 23959900
2018-01-11 174.589996 175.490005 174.490005 175.279999 172.687408 18667700
谢谢
https://stackoverflow.com/questions/53854785
复制相似问题