トレンド、周期、ノイズ（１）

!wget -O "/content/sample_data/whard_new.xlsx" "http://www.mi.u-tokyo.ac.jp/consortium2/data/whard_new.xlsx"

!wget -O "/content/sample_data/maxtemp.xlsx" "http://www.mi.u-tokyo.ac.jp/consortium2/data/maxtemp.xlsx"

!wget -O "/content/sample_data/nikkei225_new2.xlsx" "http://www.mi.u-tokyo.ac.jp/consortium2/data/nikkei225_new2.xlsx"

import pandas as pd

f_n="whard_new"#@param{type:"string"}

df = pd.read_excel('/content/sample_data/'+f_n+'.xlsx')

df

import numpy as np

import matplotlib.pyplot as plt

df_n='whard'#@param{type:"string"}

x = np.array(range(len(df)))

y = np.array(df[df_n])

plt.plot(x, y)

plt.show()

num=30#@param{type:"integer"}

b=np.ones(num)/num

y2=np.convolve(y, b, mode='same')

y3=y-y2

plt.plot(x,y)

plt.show()

plt.plot(x,y2)

plt.xlim([min(x)+num,max(x)-num])

plt.show()

plt.plot(x,y3)

plt.xlim([min(x)+num,max(x)-num])

plt.show()