有人知道如何将字符串输出转换为浮点数吗?我正在尝试创建单独的数据框"Month"
and "day of the week"
基于时间戳索引。这df.index.strftime
输出一个字符串,但我需要一个float
基于月份数值(一月至十二月为 0-11 或 1-12)和一周中的某一天数值(周日至周六为 0-6 或 1-7)
from numpy.random import randint
import pandas as pd
# Create a df with a date-time index with data every 6 hours
rng = pd.date_range('1/5/2018 00:00', periods=5, freq='6H')
df = pd.DataFrame({'Random_Number':randint(1, 10, 5)}, index=rng)
# Getting different time information in the columns
df['month'] = df.index.strftime('%b')
df['Day_of_week'] = df.index.strftime('%a')
df
你需要DatetimeIndex.month http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DatetimeIndex.month.html and DatetimeIndex.dayofweek http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DatetimeIndex.dayofweek.html:
df['month'] = df.index.month
df['Day_of_week'] = df.index.dayofweek
print (df)
Random_Number month Day_of_week
2018-01-05 00:00:00 1 1 4
2018-01-05 06:00:00 8 1 4
2018-01-05 12:00:00 4 1 4
2018-01-05 18:00:00 5 1 4
2018-01-06 00:00:00 1 1 5
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)