我有一個 pd.DataFrame 有一個日期時間索引。當我選擇一個特定的日期時間并且有兩個匹配項時,它會正確地選擇日期作為索引。
a = df.loc[date] a Symbol Order Shares Date
2011-01-10 AAPL BUY 1500 2011-01-10 AAPL SELL 1500
但是,當該日期只有一個匹配項時,它會將列指定為索引。
訂單代碼 GOOG Order BUY Shares 1000 Name: 2011-01-26 00:00:00, dtype: object
如何強制它始終將 Date 作為索引?我沒有索引的名稱。
uj5u.com熱心網友回復:
您可以使用一個元素串列:
a = df.loc[[date]]
樣品:
print (df)
Symbol Order Shares
Date
2011-01-09 AAPL BUY 1500
2011-01-10 AAPL BUY 1500
2011-01-10 AAPL SELL 1500
date = '2011-01-09'
a = df.loc[[date]]
print (a)
Symbol Order Shares
Date
2011-01-09 AAPL BUY 1500
date = '2011-01-10'
a = df.loc[[date]]
print (a)
Symbol Order Shares
Date
2011-01-10 AAPL BUY 1500
2011-01-10 AAPL SELL 1500
轉載請註明出處,本文鏈接:https://www.uj5u.com/net/312986.html
