将 UTC 时间添加/减去 Datetime 'Time'柱子

发布于 2025-01-09 19:56:02 字数 653 浏览 1 评论 0原文

我有一个示例数据框，如下所示。

import pandas as pd
import numpy as np

data = {'InsertedDate':['2022-01-21 20:13:19.000000', '2022-01-21 20:20:24.000000', '2022-02- 
         02 16:01:49.000000', '2022-02-09 15:01:31.000000'],
        'UTCOffset': ['-05:00','+02:00','-04:00','+06:00']}

df = pd.DataFrame(data)
df['InsertedDate'] = pd.to_datetime(df['InsertedDate'])
df

“InsertedDate”是一个日期时间列，其中“UTCOffset”是一个字符串列。我想将偏移时间添加到“插入日期”列，并将最终结果显示在新列中作为“日期时间”列。它应该类似于下图所示。

非常感谢任何帮助。谢谢你！

原文

I have a sample dataframe as given below.

import pandas as pd
import numpy as np

data = {'InsertedDate':['2022-01-21 20:13:19.000000', '2022-01-21 20:20:24.000000', '2022-02- 
         02 16:01:49.000000', '2022-02-09 15:01:31.000000'],
        'UTCOffset': ['-05:00','+02:00','-04:00','+06:00']}

df = pd.DataFrame(data)
df['InsertedDate'] = pd.to_datetime(df['InsertedDate'])
df

The 'InsertedDate' is a datetime column wheres the 'UTCOffset' is a string column.
I want to add the Offset time to the 'Inserteddate' column and display the final result in a new column as a 'datetime' column.
It should look something like this image shown below.

Any help is greatly appreciated. Thank you!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

執念 2025-01-16 19:56:02

您可以使用 pd.to_timedelta 作为偏移量并与时间相加。

# to_timedelta needs to have [+-]HH:MM:SS format, so adding :00 to fill :SS part.
df['UTCOffset'] = pd.to_timedelta(df.UTCOffset + ':00')
df['CorrectTime'] = df.InsertedDate + df.UTCOffset

You can use pd.to_timedelta for the offset and add with time.

# to_timedelta needs to have [+-]HH:MM:SS format, so adding :00 to fill :SS part.
df['UTCOffset'] = pd.to_timedelta(df.UTCOffset + ':00')
df['CorrectTime'] = df.InsertedDate + df.UTCOffset

回复收藏 0 原文

~没有更多了~