pandas_datareader的结果不正确

Question

下面有Python代码，运行良好。唯一的问题是结果没有得到正确的排序。

import pandas_datareader as web
import datetime as dt
import csv

start = dt.datetime(2021,9,1)
end = dt.datetime(2021,9,26)

sembol=['BTC-USD']

btc = web.get_data_yahoo(sembol, start, end)

for ticker in sembol:
    ticker_csv = "{}.csv".format(ticker)
    btc.to_csv(ticker_csv)

这就是我在csv中得到的结果。例如，9月1日的49327.72265625收盘价是CSV，但在雅虎历史数据页面( 48,847.03 )上，它的价值是不同的。你知道为什么数据的顺序不正确吗？

Attributes,Adj Close,Close,High,Low,Open,Volume
Symbols,BTC-USD,BTC-USD,BTC-USD,BTC-USD,BTC-USD,BTC-USD
Date,,,,,,
2021-09-01,49327.72265625,49327.72265625,50343.421875,48652.3203125,48807.84765625,39508070319
2021-09-02,50025.375,50025.375,50982.2734375,48386.0859375,49288.25,43206179619
2021-09-03,49944.625,49944.625,50545.58203125,49548.78125,50009.32421875,37471327794
2021-09-04,51753.41015625,51753.41015625,51868.6796875,49538.59765625,49937.859375,30322676319
2021-09-05,52633.53515625,52633.53515625,52700.94140625,51053.6796875,51769.00390625,38884105426
2021-09-06,46811.12890625,46811.12890625,52853.765625,43285.20703125,52660.48046875,65210059683
2021-09-07,46091.390625,46091.390625,47334.0546875,44561.39453125,46827.76171875,49007762488

​

​

Answer 1

好吧我发现问题了。雅虎似乎有一个错误。如对吉突布的建议；

df = df[~df.index.duplicated(keep='last')]解决了这个问题。