我有下面的日期和日期作为索引。我想删除重复的日期
Stock Open High Low Close Adj Close Volume
Date
2016-05-13 AAD 5.230000 5.260000 5.200000 5.260000 5.260000 5000
2016-05-16 AAD 5.220000 5.260000 5.220000 5.260000 5.260000 6000
2016-05-17 AAD 5.210000 5.260000 5.210000 5.260000 5.260000 2000
2016-05-17 AAD 5.210000 5.260000 5.210000 5.260000 5.260000 2000
2016-05-18 AAD 5.200000 5.250000 5.200000 5.250000 5.250000 3000
我需要的输出
Stock Open High Low Close Adj Close Volume
Date
2016-05-13 AAD 5.230000 5.260000 5.200000 5.260000 5.260000 5000
2016-05-16 AAD 5.220000 5.260000 5.220000 5.260000 5.260000 6000
2016-05-17 AAD 5.210000 5.260000 5.210000 5.260000 5.260000 2000
2016-05-18 AAD 5.200000 5.250000 5.200000 5.250000 5.250000 3000
我尝试使用
df.drop_duplicates()
和输出删除重复日期后的额外行。 Stock Open High Low Close Adj Close Volume
Date
2016-05-13 AAD 5.230000 5.260000 5.200000 5.260000 5.260000 5000
2016-05-16 AAD 5.220000 5.260000 5.220000 5.260000 5.260000 6000
2016-05-17 AAD 5.210000 5.260000 5.210000 5.260000 5.260000 2000
最佳答案
让我们利用耶斯雷尔提供的信息。
输入数据帧:
print(df)
Stock Open High Low Close Adj Close Volume
2016-05-13 AAD 5.23 5.26 5.20 5.26 5.26 5000
2016-05-16 AAD 5.22 5.26 5.22 5.26 5.26 6000
2016-05-17 AAD 5.21 5.26 5.21 5.26 5.26 2000
2016-05-17 AAD 5.21 5.26 5.21 5.26 5.26 2000
2016-05-18 AAD 5.20 5.25 5.20 5.25 5.25 3000
df1 = df[~df.index.duplicated(keep='last')]
print(df1)
输出:
Stock Open High Low Close Adj Close Volume
2016-05-13 AAD 5.23 5.26 5.20 5.26 5.26 5000
2016-05-16 AAD 5.22 5.26 5.22 5.26 5.26 6000
2016-05-17 AAD 5.21 5.26 5.21 5.26 5.26 2000
2016-05-18 AAD 5.20 5.25 5.20 5.25 5.25 3000
关于python - Python:在Pandas数据框中删除重复的索引,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/44392466/