使用下面的 df，我正在嘗試使用 dateutil.relativedelta.relativedelta 確定一個新日期，但想遍歷 df['freq'] 和 df['time_int'] 作為 **kwargs 和 *args
In [1]: df
Out[1]:
date time_int freq
0 2021-11-16 -5 days
1 2021-11-16 -1 weeks
2 2021-11-16 -2 weeks
3 2021-11-16 -3 weeks
4 2021-11-16 -3 weeks
5 2021-11-16 -1 months
6 2021-11-16 -1 months
下面，我嘗試創建一個 dict 來通過 **kwargs，但該 dict 僅包含每個鍵的最后一個值。我需要它來遍歷所有的鍵值組合。
time_dict = dict(zip(df.freq,df.time_int))
df['new_date'] = df['date'].dt.date relativedelta(**time_dict)
所需的輸出：
test
Out[170]:
date time_int freq new_date
0 2021-11-16 -5 days 2021-11-11
1 2021-11-16 -1 weeks 2021-11-09
2 2021-11-16 -2 weeks 2021-11-02
3 2021-11-16 -3 weeks 2021-10-26
4 2021-11-16 -3 weeks 2021-10-26
5 2021-11-16 -1 months 2021-10-16
6 2021-11-16 -1 months 2021-10-16
uj5u.com熱心網友回復：
pandas已經包含relativedelta類似物件，pandas.DateOffset
您可以使用 Series.apply
def compute_new_date(row):
return row['date'] pd.DateOffset(**{row['freq']: row['time_int']})
# apply compute_new_date row-wise
df['new_date'] = df.apply(compute_new_date, axis=1)
輸出：
>>> df
date time_int freq new_date
0 2021-11-16 -5 days 2021-11-11
1 2021-11-16 -1 weeks 2021-11-09
2 2021-11-16 -2 weeks 2021-11-02
3 2021-11-16 -3 weeks 2021-10-26
4 2021-11-16 -3 weeks 2021-10-26
5 2021-11-16 -1 months 2021-10-16
6 2021-11-16 -1 months 2021-10-16
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/360955.html