import pandas as pd #加载数据分析包pandas
pd.set_option('display.precision',4) #设置pandas输出精度
YQdata=pd.read_excel('./data/DaPy_data.xlsx','YQdata',index_col=0)
YQdata

QTdata=pd.read_excel('./data/DaPy_data.xlsx','QTdata',index_col=0)
QTdata
QTdata.plot(grid=True)

#形成年度时序数据
YGDP=QTdata.groupby(['Year'])['GDP'].sum()
YGDP
(1)一次模型:y = a + bx
import numpy as np
n=20
x=np.arange(n)+1 #生成1:n的等差数列
y=1+2*x
import matplotlib.pyplot as plt
plt.plot(x,y,'o-'); #点线图

y=1+0.2*np.log(x)
plt.plot(x,y,'o-')

y=0.2*np.exp(0.1*x)
plt.plot(x,y,'o-')
