電大財務(wù)大數(shù)據(jù)分析編程作業(yè)5

編程作業(yè)5任務(wù)說明本次編程作業(yè)主要檢驗同學(xué)們對項目十內(nèi)容的學(xué)習(xí)情況，請大家按照任務(wù)要求完成。任務(wù)要求根據(jù)中國軟件盈利能力分析數(shù)據(jù)(中國軟件盈利能力分析.xlsx),計算并分析該公司的銷售毛利率和凈資產(chǎn)收益率。具體編程任務(wù)：1.使用read_excel()函數(shù)讀取Excel數(shù)據(jù)'中國軟件盈利能力分析.xlsx',命名為2.對數(shù)據(jù)進(jìn)行行列轉(zhuǎn)置(使用value.T命令)3.根據(jù)下面的公式計算凈資產(chǎn)收益率，并增加為數(shù)據(jù)的一列。凈資產(chǎn)收益率=凈利潤/((期初凈資產(chǎn)+期末凈資產(chǎn))/2)4.繪制凈資產(chǎn)收益率折線圖。提交作業(yè)方式●按照模板要求填寫內(nèi)容，●上傳word文件,命名格式：“學(xué)號-姓名-編程作業(yè)5”。溫馨提示1.考核知識點：項目十中的學(xué)習(xí)目標(biāo)1、學(xué)習(xí)目標(biāo)2、學(xué)習(xí)目標(biāo)32.認(rèn)真觀看這部分學(xué)習(xí)視頻、閱讀教材，能夠很好的幫助你完成本次作業(yè)。編程實操作業(yè)提交模板姓名：學(xué)號：班級：作業(yè)主題：使用pandas讀取excel,并計算凈資產(chǎn)收益率繪圖任務(wù)簡介(簡要填寫本次編程任務(wù)要實現(xiàn)的具體內(nèi)容)根據(jù)中國軟件盈利能力分析數(shù)據(jù)(中國軟件盈利能力分析.xlsx),計算并分析該公司的銷售毛利率和凈資產(chǎn)收益率。具體編程任務(wù)：1.使用read_excel()函數(shù)讀取Excel數(shù)據(jù)‘中國軟件盈利能力分析.xlsx’,命名為2.對數(shù)據(jù)進(jìn)行行列轉(zhuǎn)置(使用value.T命令)3.根據(jù)下面的公式計算凈資產(chǎn)收益率，并增加為數(shù)據(jù)的一列。凈資產(chǎn)收益率=凈利潤/((期初凈資產(chǎn)+期末凈資產(chǎn))/2)4.繪制凈資產(chǎn)收益率折線圖。實現(xiàn)代碼導(dǎo)入庫#1.使用read_excel()函數(shù)讀取Excel數(shù)據(jù)‘中國軟件盈利能力分析.xlsx',命名為ProfitDataProfitData=pd.read_excel('/編程5,中國軟件盈利能力分析.xlsx')#2.對數(shù)據(jù)進(jìn)行行列轉(zhuǎn)置(使用value.T命令)ProfitData=ProfitData.T#將列名變?yōu)榈谝恍袛?shù)據(jù)ProfitData.columns=ProfitData.iloc[0,:]#刪除第一行數(shù)據(jù)ProfitData=ProfitData.drop('Unnamed:0')#3.根據(jù)下面的公式計算凈資產(chǎn)收益率，并增加為數(shù)據(jù)的一列。凈資產(chǎn)收益率=凈利潤/((期初凈資產(chǎn)+期末凈資產(chǎn))/2)末凈資產(chǎn)])/2#4.繪制凈資產(chǎn)收益率折線圖importmatplotlib.pyplotaplt.rcParams['font.sans-serif]=['SimHei]#為了讓圖表中顯示中文plt.rcParams['axes.unicode_minus']=False#顯示負(fù)號ProfitData['凈資產(chǎn)收益率'].plot()plt.title('凈資產(chǎn)收益率折線圖')plt.show()代碼運行結(jié)果(粘貼運行結(jié)果截圖)ProfitData=pd.read_excel('./編程5,中國軟件盈利能力分析.xlsx')#2.”對數(shù)據(jù)進(jìn)行行列轉(zhuǎn)置(使用value.T命令)ProfitData=ProfitData.T#將列名變?yōu)榈谝恍袛?shù)據(jù)ProfitData.columns=ProfitData.iloc[0,:]#剛除第一行數(shù)據(jù)ProfitData=ProfitData.drop('Unnamed:0')ProfitDataOut[1]:銷售凈收入產(chǎn)品成本凈利潤期初凈資產(chǎn)期末凈資產(chǎn)2020-06-3000:00:001393576690.84930788569.71-491167324.312493401672.012210777431.612020-03-3100:00:00602116408.1398547546.94-199063979.532761772535.392493401672.012019-12-3100:00:005819592183.33815338052.95141738761.382280931307.322761772535.392019-09-3000:00:003145931203.342099017454.76-278982876.32324051287.512280931307.322019-06-3000:00:002065023059.661398090493.75-236763807.762459515585.242324051287.512019-03-3100:00:001007082826.38724578422.44-126953000.732605401549.652459515585.242018-12-3100:00:004613161359.62808504276.82128629620.062168312102.592605401549.652018-09-3000:00:002541016117.891618151378.44-328284024.442200560933.492168312102.592018-06-3000:00:001530668735.98962149296.74-296202713.412372753952.462200560933.492018-03-3100:00:00565220865.05334520863.11-152370606.942523529533.832372753952.462017-12-3100:00:004942995517.063055233876.3361470394.482516710494.592523529533.832017-09-3000:00:002966820665.021911489195.92-336435954.412623038436.12516710494.59#3,相據(jù)下面的公式計算凈資產(chǎn)收益率，并增加為數(shù)據(jù)的一列。凈資產(chǎn)收益率=凈利潤/((期初凈資產(chǎn)+期末凈資產(chǎn))/2)#3,相據(jù)下面的公式計算凈資產(chǎn)收益率，并增加為數(shù)據(jù)的一列。凈資產(chǎn)收益率=凈利潤/((期初凈資產(chǎn)+期末凈資產(chǎn))/2)[2]:ProfitData[’凈資產(chǎn)收益率’]=ProfitData[’凈利潤’]/((ProfitData[’期初凈資產(chǎn)’]+ProfitData[’期末凈資產(chǎn)’])/2)ProfitDataUnnamedUnnamed:0銷售凈收入產(chǎn)品成本凈利潤期初凈資產(chǎn)期未凈資產(chǎn)凈資產(chǎn)收益率1393576690.84930788569.71-491167324.312493401672.012210777431.61-0.208822602116408.1398547546.94-199063979.532761772535.392493401672.01-0.0757595819592183.33815338052.95141738761.382280931307.322761772535.390.0562153145931203.342099017454.76-278982876.32324051287.512280931307.322065023059.661398090493.75-236763807.762459515585.242324051287.51-0.098991007082826.38724578422.44-126953000.732605401549.652459515585.24-0.050134613161359.62808504276.82128629620.062168312102.592605401549.650.0538912541016117.891618151378.44-328284024.442200560933.492168312102.59-0.1502831530668735.98962149296.74-296202713.412372753952.462200560933.49-0.129535565220865.05334520863.11-152370606.942523529533.832372753952.46-0.0622394942995517.063055233876.3361470394.48251671