python pandas将索引转换为日期时间 [英] python pandas convert index to datetime

问题描述

如何将字符串的熊猫索引转换为日期时间格式

How do i convert a pandas index of strings to datetime format

我的数据框"df"就是这样

my dataframe 'df' is like this

                     value          
2015-09-25 00:46    71.925000
2015-09-25 00:47    71.625000
2015-09-25 00:48    71.333333
2015-09-25 00:49    64.571429
2015-09-25 00:50    72.285714

但是索引的类型是字符串，但是我需要它的日期时间格式，因为出现错误

but the index is of type string, but i need it a datetime format because i get the error

'Index' object has no attribute 'hour'

使用

 df['A'] = df.index.hour

推荐答案

它应能按预期工作.尝试运行以下示例.

It should work as expected. Try to run the following example.

import pandas as pd
import io

data = """value          
"2015-09-25 00:46"    71.925000
"2015-09-25 00:47"    71.625000
"2015-09-25 00:48"    71.333333
"2015-09-25 00:49"    64.571429
"2015-09-25 00:50"    72.285714"""

df = pd.read_table(io.StringIO(data), delim_whitespace=True)

# Converting the index as date
df.index = pd.to_datetime(df.index)

# Extracting hour & minute
df['A'] = df.index.hour
df['B'] = df.index.minute
df

#                          value  A   B
# 2015-09-25 00:46:00  71.925000  0  46
# 2015-09-25 00:47:00  71.625000  0  47
# 2015-09-25 00:48:00  71.333333  0  48
# 2015-09-25 00:49:00  64.571429  0  49
# 2015-09-25 00:50:00  72.285714  0  50

这篇关于python pandas将索引转换为日期时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！