python pandas教程，python pandas loc 條件_Python pandas.loc多個條件并修改d的一部分

您可以使用掩碼并添加DateOffset，例如：In [43]:

df=pd.DataFrame({'a':pd.date_range(dt.datetime(2011,1,1), dt.datetime(2012,1,1), freq='M'), 'b':pd.date_range(dt.datetime(2010,6,1), dt.datetime(2011,6,1), freq='M')})

python pandas教程，df

Out[43]:

a b

python中loc的用法。0 2011-01-31 2010-06-30

1 2011-02-28 2010-07-31

2 2011-03-31 2010-08-31

pandas根據條件修改數據？3 2011-04-30 2010-09-30

4 2011-05-31 2010-10-31

5 2011-06-30 2010-11-30

6 2011-07-31 2010-12-31

7 2011-08-31 2011-01-31

8 2011-09-30 2011-02-28

9 2011-10-31 2011-03-31

10 2011-11-30 2011-04-30

11 2011-12-31 2011-05-31

In [65]:

df.loc[(df['a'].dt.year == 2011) & (df['b'].dt.year == 2010), 'b'] = df['b'] + pd.DateOffset(years=1)

df

Out[65]:

a b

0 2011-01-31 2011-06-30

1