Python Pandas - 如何将 DateTimeIndex 转换为 Period
要将DateTimeIndex转换为Period,请使用Pandas中的方法。频率是使用freq参数设置的。datetimeindex.to_period()
首先,导入所需的库-
import pandas as pd
创建一个日期时间索引,周期为5,频率为Y,即年份-
datetimeindex = pd.date_range('2021-10-18 07:20:32.261811624', periods=5, freq='2Y')
显示日期时间索引-
print("DateTimeIndex...\n", datetimeindex)
将DateTimeIndex转换为Period。我们使用值为“M”的“freq”参数将频率设置为月份-
print("\nConvert DateTimeIndex to Period...\n", datetimeindex.to_period(freq='M'))
示例
以下是代码-
import pandas as pd #DatetimeIndexwithperiod5andfrequencyasYi.e.year #timezoneisAustralia/Adelaide datetimeindex = pd.date_range('2021-10-18 07:20:32.261811624', periods=5, freq='2Y') #displayDateTimeIndex print("DateTimeIndex...\n", datetimeindex) #displayDateTimeIndex frequency print("DateTimeIndex frequency...\n", datetimeindex.freq) #ConvertDateTimeIndextoPeriod # We have set the frequency as Month using the "freq" parameter with value 'M' print("\nConvert DateTimeIndex to Period...\n", datetimeindex.to_period(freq='M'))输出结果
这将产生以下代码-
DateTimeIndex... DatetimeIndex(['2021-12-31 07:20:32.261811624', '2023-12-31 07:20:32.261811624', '2025-12-31 07:20:32.261811624', '2027-12-31 07:20:32.261811624', '2029-12-31 07:20:32.261811624'], dtype='datetime64[ns]', freq='2A-DEC') DateTimeIndex frequency... <2 * YearEnds: month=12> Convert DateTimeIndex to Period... PeriodIndex(['2021-12', '2023-12', '2025-12', '2027-12', '2029-12'], dtype='period[M]')