阿里巴巴股票分析

1import pandas as pd 
2import matplotlib.pyplot as plt

1gupiao={'谷歌':'GOOG','亚马逊':'AMZN','Facebook':'FB',
2            '苹果':'AAPL','阿里巴巴':'BABA','腾讯':'0700.hk'}

1from pandas_datareader import data

1start_date = '2017-01-01'
2end_date = '2018-01-01'
3ali=data.get_data_yahoo(gupiao["阿里巴巴"],start_date,end_date)

1ali.head()

1def  change(column):
2    prichange=(column[column.size-1]-column[0])/column[0]
3    if (prichange > 0):
4        print("股票累计上涨：",prichange*100,"%")
5    elif (prichange == 0):
6        print("股票基本不变：",prichange*100,"%")
7    else :
8        print("股票累计下跌：",prichange*100,"%")
9    return prichange

1alichange=change(ali["Low"])

1yamaxun=data.get_data_yahoo(gupiao["亚马逊"],start_date,end_date)
2facebook=data.get_data_yahoo(gupiao["Facebook"],start_date,end_date)
3apple=data.get_data_yahoo(gupiao["苹果"],start_date,end_date)
4guge=data.get_data_yahoo(gupiao["谷歌"],start_date,end_date)
5tengxun=data.get_data_yahoo(gupiao["腾讯"],start_date,end_date)

1yamaxunchange=change(yamaxun["Low"])

1facechange=change(facebook["Low"])

1applechange=change(apple["Low"])

1gugechange=change(guge["Low"])

1tengxunchange=change(tengxun["Low"])

1ali.info()

1ali.dtypes

1ali.describe()

1ali.plot(y="Close")
2plt.xlabel("时间")
3plt.ylabel("股价（美元）")
4plt.title("2017年阿里巴巴股价走势")
5plt.grid(True)
6plt.show()

1ali2=ali.reset_index(drop=False)

1ali2.plot(x="Volume",y="Close",kind="scatter")
2plt.grid(True)
3plt.show()

1ali.corr()

1type(ali.index)

1a=ali.index

1type(a)

1tengxun["Close_dollar"]=tengxun["Close"]*0.1278

1tengxun.head()

 1ax1=ali.plot(y="Close",label="阿里巴巴")
 2yamaxun.plot(ax=ax1,y="Close",label="亚马逊")
 3apple.plot(ax=ax1,y="Close",label="苹果")
 4guge.plot(ax=ax1,y="Close",label="谷歌")
 5tengxun.plot(ax=ax1,y="Close_dollar",label="腾讯")
 6facebook.plot(ax=ax1,y="Close",label="Facebook")
 7plt.xlabel("时间")
 8plt.ylabel("股价（美元）")
 9plt.grid(True)
10plt.show()

1ax1=yamaxun.plot(y="Close",label="亚马逊")
2guge.plot(ax=ax1,y="Close",label="谷歌")
3plt.xlabel("时间")
4plt.ylabel("股价（美元）")
5plt.grid(True)
6plt.show()

1ax2=ali.plot(y="Close",label="阿里巴巴")
2apple.plot(ax=ax2,y="Close",label="苹果")
3tengxun.plot(ax=ax2,y="Close_dollar",label="腾讯")
4facebook.plot(ax=ax2,y="Close",label="Facebook")
5plt.xlabel("时间")
6plt.ylabel("股价（美元）")
7plt.grid(True)
8plt.show()

1gpmean=[ali["Close"].mean(),apple["Close"].mean(),guge["Close"].mean(),facebook["Close"].mean(),yamaxun["Close"].mean(),tengxun["Close_dollar"].mean()]

1gpmean

1gps=pd.Series(gpmean,index=["阿里巴巴","苹果","谷歌","Facebook","亚马逊","腾讯"])

1gps

1gps.plot(kind="bar",label="GAFATA")
2plt.xlabel("公司名称")
3plt.ylabel("股价（美元）")
4plt.grid(True)
5plt.show()

1closedf=pd.DataFrame()
2closedf=pd.concat([closedf,ali["Close"],apple["Close"],guge["Close"],facebook["Close"],yamaxun["Close"],tengxun["Close_dollar"]],axis=1)

1closedf.head()

1closedf.columns=["阿里巴巴","苹果","谷歌","Facebook","亚马逊","腾讯"]#直接命名

1closedf.plot(kind="box")
2plt.xlabel("公司名称")
3plt.ylabel("股价（美元）")
4plt.grid(True)
5plt.show()