如何从 ColA 获取 ColB
ColA (Localized datetime) ColB (New datetime)
2016-09-19 00:29:13-05:00 2016-09-19 00:29:13
2016-09-19 04:16:04-02:00 2016-09-19 04:16:04
2016-09-19 06:57:54+01:00 2016-09-19 06:57:54
str
在列上使用 Pandas 字符串切片(因为数据类型是object
根据 OP):
df['ColB (New datetime)'] = df['ColA (Localized datetime)'].str[:-6]
或者:
df['ColB (New datetime)'] = df['ColA (Localized datetime)'].str.slice(start=0,stop=19)
print(df)
ColA (Localized datetime) ColB (New datetime)
0 2016-09-19 00:29:13-05:00 2016-09-19 00:29:13
1 2016-09-19 04:16:04-02:00 2016-09-19 04:16:04
2 2016-09-19 06:57:54+01:00 2016-09-19 06:57:54
编辑:由于之前的SO 解决方案输出Timestamp
在整个列中的格式不一致,虽然数据类型是object
但每个值是Timestamp
:
df['ColB (New datetime)'] = df['ColA (Localized datetime)'].apply(lambda x: x.replace(tzinfo=None))
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句