python - 更改 pandas Dataframe 中日期时间的值

Question

我想用日期时间格式更改 pandas 数据框列的值。基本上我想连续添加 20 秒。我是 python/pandas 的新手，所以我不知道有什么方法可以解决这个问题。

到目前为止，这是我的代码:

df_date = dataframe['date'] # get date column
df_date = datedf.to_frame() #convert series to df


for index, row in df_date.iterrows():
    if (index % 3 == 0):
        #minute +1 f. e. from 12:00:40 to 12:01:0

    elif (index % 3 == 1) or (index % 3 == 2):     
        # seconds + 20 
        # from 12:01:00 to 12:01:20
        # or from 12:01:20 to 12:01:40

数据框 df_date:

原文:

0  2017-03-10 01:00:00
1  2017-03-10 01:00:00
2  2017-03-10 01:00:00
3  2017-03-10 01:00:00
4  2017-03-10 01:00:00

...

预期:

0  2017-03-10 01:00:20
1  2017-03-10 01:00:40
2  2017-03-10 01:01:00
3  2017-03-10 01:00:20
4  2017-03-10 01:00:40

...

如有任何帮助，我们将不胜感激!

Answer 1

添加 np.arange 创建的时间增量乘以 20 与 to_timedelta :

td = pd.to_timedelta(np.arange(1, len(dataframe) + 1) * 20, unit='s')

或由 timedelta_range 创建:

td = pd.timedelta_range(0, periods=len(dataframe), freq='20s') 

---

dataframe['date'] = pd.to_datetime(dataframe['date']) + td
print (dataframe)
                 date
0 2017-03-10 01:00:20
1 2017-03-10 01:00:40
2 2017-03-10 01:01:00
3 2017-03-10 01:01:20
4 2017-03-10 01:01:40