我有一個看起來像這樣的數據幀:>>> my_df.loc[600:614,'Week-Year']600 39-2018601 39-2018602 40-2018603 40-2018604 41-2018605 41-2018606 42-2018607 42-2018608 43-2018609 43-2018610 44-2018611 44-2018612 45-2018613 45-2018614 46-2018該列基本上是“年周數 - 年”。我現在想將此數據幀從某一周切成某一周。這是我嘗試過的:>>> end_date = datetime(2013, 4, 30)>>> my_df.loc[(my_df['Week-Year'] <= end_date.strftime('%M-%Y'))]但是,這不會返回任何內容。那么,我該怎么做呢?
1 回答

拉莫斯之舞
TA貢獻1820條經驗 獲得超10個贊
我認為這里有必要轉換為日期時間:Week-Year
d = pd.to_datetime(my_df['Week-Year'].add('_1'), format='%W-%Y_%w')
#https://stackoverflow.com/a/54033252/2901002
#ISO week numbers (ISO 8601 week definitions)
d = pd.to_datetime(my_df['Week-Year'].add('_1'), format='%V-%G_%u')
然后在布爾索引中進行篩選:
df = my_df[d <= end_date]
添加回答
舉報
0/150
提交
取消