skka3134

1. Data reading, specifying time as the index, and converting time to standard format

import pandas as pd
data=pd.read_csv('data.csv',index_col=0,parse_dates=True)

Analysis of sequence changes

1. View the interpolation of the previous day

data.diff()

2. Average difference

data.diff().mean()

3. Growth rate

data.pct_change().round(3)

4. Average growth rate

data.pct_change().mean()

Time series resampling

1. Weekly basis

data.resample('1w').last()

2. Weekly basis, specifying labels

data.resample('1w',label='left').last()

3. Time window

Short-term average calculation