pandas-时序数据的位移与调整

最新推荐文章于 2023-05-06 01:25:53 发布

妮酱也爱敲代码

最新推荐文章于 2023-05-06 01:25:53 发布

阅读量262

点赞数 1

分类专栏：小象学院文章标签：数据分析

本文链接：https://blog.csdn.net/lildn/article/details/115032662

版权

本文详细介绍了Pandas库中用于处理时序数据位移和调整的asfreq API，通过该方法可以将数据转换为特定频率的时间序列。链接：https://pandas.pydata.org/pandasdocs/stable/reference/api/pandas.DataFrame.asfreq.html。

摘要由CSDN通过智能技术生成

asfreq的API（地址：https://pandas.pydata.org/pandasdocs/stable/reference/api/pandas.DataFrame.asfreq.html）
在这里插入图片描述

第四课 Pandas时序型数据分析
第四节 时序数据的位移与频率调整
import pandas as pd
import matplotlib.pyplot as plt

%matplotlib inline
#parse_dates=True将时间序列解析为datetime类型
data_df = pd.read_csv('./datasets/day_stats.csv', index_col='date', parse_dates=True, dayfirst=True)
data_df.head()
city	PM_China	PM_US Post	Polluted State CH	Polluted State US
date					
2013-10-01	beijing	67.416667	71.458333	light	light
2013-10-10	beijing	74.041667	81.583333	light	medium
2013-10-11	beijing	59.694444	59.291667	light	light
2013-10-12	beijing	69.236111	70.458333	light	light
2013-10-13	beijing	54.513889	57.333333	light	light
beijing_data = data_df[data_df['city'] == 'beijing'].copy()
beijing_data['PM_China'].plot(figsize=(10, 5))
<matplotlib.axes._subplots.AxesSubplot at 0x1de1cc83ba8>

位移 shift
beijing_data['+1'] = beijing_data['PM_China'].shift(1)
beijing_data['-1'] = beijing_data['PM_China'].shift(-1)
beijing_data.head()
city	PM_China	PM_US Post	Polluted State CH	Polluted State US	+1	-1
date							
2013-10-01	beijing	67.416667	71.458333	light	light	NaN	74.041667
2013-10-10	beijing	74.041667	81.583333	light	medium	67.416667	59.694444
2013-10-11	beijing	59.694444	59.291667	light	light	74.041667	69.236111
2013-10-12	beijing	69.