?因?yàn)樾【幨且粋€(gè)比較懶的人，所以有時(shí)候就想能不能通過一些方式提高日常工作中那些定時(shí)定點(diǎn)需要做的工作蛛壳，于是在閑暇時(shí)間抱著聯(lián)系python的目的寫下了這段關(guān)于財(cái)務(wù)分析的代碼杏瞻，感謝去的朋友可以看看，或者可以復(fù)制代碼再去測(cè)試衙荐，其中文字部分或者財(cái)務(wù)分析數(shù)據(jù)方面有什么問題捞挥，歡迎指正。

? ? ? ?此段代碼主要包括三個(gè)部分忧吟，第一部分是數(shù)據(jù)獲取砌函，此部分通過python從網(wǎng)易財(cái)經(jīng)網(wǎng)站爬取了目標(biāo)公司的年報(bào)數(shù)據(jù)，第二部分就是數(shù)據(jù)清洗和整理溜族，第三部分就是財(cái)務(wù)分析文檔的形成讹俊。

以下是代碼部分：

from?docx?import?Document??

from?docx.enum.text?import?WD_ALIGN_PARAGRAPH??

from?docx.oxml.ns?import?qn?#?中文格式??

from?docx.shared?import?Pt?#?磅數(shù)??

from?docx.shared?import?Inches?#?圖片尺寸??

from?bs4?import?BeautifulSoup??

from?urllib.request?import?urlopen??

import?pandas?as?pd??

import?numpy?as?np??

import?matplotlib.pyplot?as?plt??

import?os??

c_name?=?input('請(qǐng)輸入公司名稱：')??

stock_code?=?input("請(qǐng)輸入股票代碼：")??

st?=?input('請(qǐng)輸入開始年份：')??

et?=?input('請(qǐng)輸入結(jié)束年份：')??

data_list?=['zcfzb','lrb','xjllb']??

adrees?='http://quotes.money.163.com'??

y_list?=['報(bào)告日期']+[str(m)+'年'?for?m?in?list(range(int(st)-1,int(et)+1))][::-1]??

for?i?in?data_list:??

url?='http://quotes.money.163.com/f10/'+i+'_'+stock_code+'.html?type=year'??

????html?=?urlopen(url)??

soup?=?BeautifulSoup(html,'lxml')??

div?=soup.findAll('div',{'class':'inner_box'})??

df?=?BeautifulSoup(str(div[0]),features='lxml')??

a?=?df.findAll('a')??

for?each?in?a:??

if?each.string=='下載數(shù)據(jù)':??

new_html?=?adrees?+?each.get("href")??

????????????html1?=?urlopen(new_html)??

soup1?=?BeautifulSoup(html1,features='lxml')??

txt?=?soup1.text.replace('(萬元)','').replace('--','0')??

csv?=?open(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集\%s%s.csv'%(stock_code,i),'w',encoding='utf-8')?.write(txt)??

data?=?pd.read_csv(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集\%s%s.csv'%(stock_code,i))??

list1?=?list(range(int(data.columns[-2][:4]),?int(data.columns[1][:4])?+?1))[::-1]??

new_list?=?['報(bào)告日期']+[str(i)?+?'年'?for?i?in?list1]?+?[data.columns[-1][:4]]??

????????????data.columns?=?new_list??

writer?=?pd.ExcelWriter(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集\%s%s.xlsx'?%(stock_code,i))??

data.to_excel(writer,index=False)??

????????????writer.save()??

????????????writer.close()??

p_list?=?os.listdir(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集')??

for?name?in?p_list:??

if?name.endswith('.csv'):??

os.remove(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集\%s%s.csv'%(stock_code,i))??

#讀取已有數(shù)據(jù)并按照所需的列數(shù)進(jìn)行合并??

path_list?=?os.listdir(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集')??

data?=?pd.DataFrame()??

for?path?in?path_list:??

fp?=?r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\數(shù)據(jù)采集\%s'?%?(path)??

dfs?=?pd.read_excel(fp,None,usecols=y_list)??

????keys?=?dfs.keys()??

for?i?in?keys:??

????????df1?=?dfs[i]??

????????data?=?pd.concat([df1,data])??

data?=?data.fillna(0)??

data['報(bào)告日期']?=data['報(bào)告日期'].str.strip()??

data?=?data.drop_duplicates(subset=['報(bào)告日期'],keep='first')??

data?=?data.set_index('報(bào)告日期')??

hb?=?data.drop('%s年'%?(int(st)-1),axis=1)??

#定義所需函數(shù)??

#財(cái)務(wù)指標(biāo)函數(shù)定義??

def?hs1(cs1,cs2):??

return?round(cs1/cs2,2)??

def?hs2(cs1,cs2,cs3):??

return?round((cs1-cs2)/cs3,2)??

def?hs3(cs1,cs2,cs3):??

return?round((cs1+cs2)/cs3,2)??

def?hs4(cs1,cs2,cs3):??

return?round(cs1/(cs2-cs3),2)??

def?hs5(cs1,cs2,cs3):??

return?round(cs1/(cs2+cs3),2)??

def?hs6(cs1,cs2,cs3,cs4):??

return?round((cs1-cs2-cs3)/cs4,2)??

def?hs7(cs1,cs2):??

return?round((cs1-cs2)/cs1,2)??

def?change(x,y):??

if?x.loc[y,'%s年'?%?et]?<?x.loc[y,'%s年'?%?st]:??

return?('%s由%s年的%.2f萬元，變化為%s年的%.2f萬元煌抒，變化數(shù)為%.2f萬元,變化率為%.2f'?%??

(y,st,x.loc[y,'%s年'?%?st],et,x.loc[y,'%s年'?%?et],round(x.loc[y,'%s年'?%?et]-x.loc[y,'%s年'?%?st],2),??

round((x.loc[y,'%s年'?%?et]-x.loc[y,'%s年'?%?st])/x.loc[y,'%s年'?%?st],2)))??

else:??

return?('%s由%s年的%.2f萬元仍劈，變化為%s年的%.2f萬元，變化數(shù)為%.2f萬元,變化率為%.2f'?%??

(y,st,x.loc[y,'%s年'?%?st],et,x.loc[y,'%s年'?%?et],round(x.loc[y,'%s年'?%?et]?-?x.loc[y,'%s年'?%?st],2),??

round((x.loc[y,'%s年'?%?et]?-?x.loc[y,?'%s年'?%?st])/x.loc[y,?'%s年'?%?st],2)))??

def?up(x,y):??

if?x.loc[y,'%s年'?%?et]?<?x.loc[y,'%s年'?%?st]:??

return?('%s指標(biāo)由%s年的%.2f寡壮，變化為%s年的%.2f贩疙，變化數(shù)為%.2f，由此看出該公司的%s指標(biāo)變?nèi)??%??

(y,st,x.loc[y,'%s年'?%?st],et,x.loc[y,'%s年'?%?et],round(x.loc[y,'%s年'?%?et]-x.loc[y,'%s年'?%?st],2),y))??

else:??

return?('%s指標(biāo)由%s年的%.2f况既，變化為%s年的%.2f这溅，變化數(shù)為%.2f，由此看出該公司的%s指標(biāo)變強(qiáng)'?%??

(y,st,x.loc[y,'%s年'?%?st],et,x.loc[y,?'%s年'?%?et],round(x.loc[y,'%s年'?%?et]-x.loc[y,'%s年'%?st],2),y))??

def?down(x,y):??

if?x.loc[y,'%s年'?%?et]?<?x.loc[y,'%s年'?%?st]:??

return?('%s指標(biāo)由%s年的%.2f棒仍，變化為%s年的%.2f悲靴，變化數(shù)為%.2f，由此看出該公司的%s指標(biāo)變強(qiáng)'?%??

(y,st,x.loc[y,'%s年'?%?st],et,x.loc[y,'%s年'?%?et],round(x.loc[y,'%s年'?%?et]-x.loc[y,'%s年'?%?st],2),y))??

else:??

return?('%s指標(biāo)由%s年的%.2f莫其，變化為%s年的%.2f癞尚，變化數(shù)為%.2f，由此看出該公司的%s指標(biāo)變?nèi)??%??

(y,st,x.loc[y,'%s年'?%?st],et,x.loc[y,?'%s年'?%?et],round(x.loc[y,'%s年'?%?et]-x.loc[y,'%s年'%?st],2),y))??

#計(jì)算平均資產(chǎn)總額??

def?pj_data(xm):??

????pj_data?=?[]??

for?i?in?range(len(xm)-1):??

if?i?<?len(xm):??

pjz?=?round((xm[i]?+?xm[i+1])/2,2)??

????????????pj_data.append(pjz)??

return?pj_data??

#計(jì)算增長(zhǎng)率??

def?zzl_data(xm):??

????zzl_data?=?[]??

for?i?in?range(len(xm)-1):??

if?i?<?len(xm):??

zzl?=?round((xm[i]-xm[i+1])/xm[i+1],2)??

????????????zzl_data.append(zzl)??

return?zzl_data??

#畫圖函數(shù)??

def?fig(x,y):??

????fig?=?plt.figure()??

for?i?in?range(len(x.index)):??

????????plt.plot(x.columns.values,x.iloc[i],label?=x.index[i])??

????plt.title(y)??

plt.legend(loc?='upper?right')??

fig.savefig(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\%s.png'%?y)??

return?fig??

#生成表格函數(shù)??

def?data_table(x,y):??

t?=?d1.add_table(rows=y.shape[0]?+?1,?cols=y.shape[1]?+?1,?style='Table?Grid')??

for?n?in?range(len(x)):??

t.cell(0,?n).text?=?x[n]??

for?m?in?range(len(list(y.index))):??

t.cell(m?+1,?0).text?=?list(y.index)[m]??

for?j?in?range(y.shape[0]):??

for?i?in?range(y.shape[1]):??

t.cell(j?+1,?i?+?1).text?=?str(y.iloc[j,?i])??

return?t??

#計(jì)算所需財(cái)務(wù)數(shù)據(jù)??

#財(cái)報(bào)主要財(cái)務(wù)數(shù)據(jù)??

zy?=?hb.loc[['流動(dòng)資產(chǎn)合計(jì)','非流動(dòng)資產(chǎn)合計(jì)','資產(chǎn)總計(jì)','流動(dòng)負(fù)債合計(jì)','非流動(dòng)負(fù)債合計(jì)','負(fù)債合計(jì)','所有者權(quán)益(或股東權(quán)益)合計(jì)','營(yíng)業(yè)總收入',??

'營(yíng)業(yè)總成本','利潤(rùn)總額','凈利潤(rùn)']]??

#?#資產(chǎn)結(jié)構(gòu)主要數(shù)據(jù)??

zc?=?hb.loc[['貨幣資金','應(yīng)收賬款','預(yù)付款項(xiàng)','其他應(yīng)收款','存貨','流動(dòng)資產(chǎn)合計(jì)','長(zhǎng)期股權(quán)投資','固定資產(chǎn)','在建工程','無形資產(chǎn)',??

'長(zhǎng)期待攤費(fèi)用','非流動(dòng)資產(chǎn)合計(jì)']]??

zc2?=?hb.loc[['貨幣資金','應(yīng)收賬款','預(yù)付款項(xiàng)','其他應(yīng)收款','存貨','長(zhǎng)期股權(quán)投資','固定資產(chǎn)','在建工程','無形資產(chǎn)',??

'長(zhǎng)期待攤費(fèi)用']]??

zc_bh?=?round(abs(zc2['%s年'%et]-zc2['%s年'%st]),2)??

zc1?=?round(hb.loc[['貨幣資金','應(yīng)收賬款','預(yù)付款項(xiàng)','其他應(yīng)收款','存貨','長(zhǎng)期股權(quán)投資','固定資產(chǎn)','在建工程','無形資產(chǎn)',??

'長(zhǎng)期待攤費(fèi)用']]/hb.loc['資產(chǎn)總計(jì)'],2)??

#負(fù)債結(jié)構(gòu)主要數(shù)據(jù)??

fz?=?hb.loc[['短期借款','應(yīng)付賬款','預(yù)收賬款','應(yīng)付職工薪酬','應(yīng)交稅費(fèi)','其他應(yīng)付款','流動(dòng)負(fù)債合計(jì)','長(zhǎng)期借款','長(zhǎng)期應(yīng)付款',??

'非流動(dòng)負(fù)債合計(jì)']]??

fz2?=?hb.loc[['短期借款','應(yīng)付賬款','預(yù)收賬款','應(yīng)付職工薪酬','應(yīng)交稅費(fèi)','其他應(yīng)付款','長(zhǎng)期借款','長(zhǎng)期應(yīng)付款']]??

fz_bh?=?round(abs(fz2['%s年'%et]-fz2['%s年'%st]),2)??

fz1?=?round(hb.loc[['短期借款','應(yīng)付賬款','預(yù)收賬款','應(yīng)付職工薪酬','應(yīng)交稅費(fèi)','其他應(yīng)付款','長(zhǎng)期借款','長(zhǎng)期應(yīng)付款']]/hb.loc['負(fù)債合計(jì)'],2)??

#股本結(jié)構(gòu)主要數(shù)據(jù)??

qy?=?hb.loc[['實(shí)收資本(或股本)','資本公積','盈余公積','未分配利潤(rùn)','所有者權(quán)益(或股東權(quán)益)合計(jì)']]??

qy2?=?hb.loc[['實(shí)收資本(或股本)','資本公積','盈余公積','未分配利潤(rùn)']]??

qy_bh?=?round(abs(qy2['%s年'%et]-qy2['%s年'%st]),2)??

qy1?=?round(hb.loc[['實(shí)收資本(或股本)','資本公積','盈余公積','未分配利潤(rùn)']]/hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'],2)??

#利潤(rùn)表主要數(shù)據(jù)??

lr?=?hb.loc[['營(yíng)業(yè)總收入','營(yíng)業(yè)收入','其他業(yè)務(wù)收入','營(yíng)業(yè)總成本','營(yíng)業(yè)成本','其他業(yè)務(wù)成本','銷售費(fèi)用','管理費(fèi)用','財(cái)務(wù)費(fèi)用','其他業(yè)務(wù)利潤(rùn)',??

'營(yíng)業(yè)利潤(rùn)','利潤(rùn)總額','所得稅費(fèi)用','凈利潤(rùn)']]??

#現(xiàn)金流量表主要數(shù)據(jù)??

xj?=?hb.loc[['經(jīng)營(yíng)活動(dòng)現(xiàn)金流入小計(jì)','經(jīng)營(yíng)活動(dòng)現(xiàn)金流出小計(jì)','經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~','投資活動(dòng)現(xiàn)金流入小計(jì)','投資活動(dòng)現(xiàn)金流出小計(jì)',??

'投資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~','籌資活動(dòng)現(xiàn)金流入小計(jì)','籌資活動(dòng)現(xiàn)金流出小計(jì)','籌資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~','現(xiàn)金及現(xiàn)金等價(jià)物凈增加額']]??

#計(jì)算償債能力指標(biāo)??

ldbl=hs1(cs1=hb.loc['流動(dòng)資產(chǎn)合計(jì)'],cs2=hb.loc['流動(dòng)負(fù)債合計(jì)'])????????????????#流動(dòng)比率??

sdbl=hs2(cs1=hb.loc['流動(dòng)資產(chǎn)合計(jì)'],cs2=hb.loc['存貨'],cs3=hb.loc['流動(dòng)負(fù)債合計(jì)'])??????????#速動(dòng)比率??

zcfzl=hs1(cs1=hb.loc['負(fù)債合計(jì)'],cs2=hb.loc['資產(chǎn)總計(jì)'])???????????????????????????????????#資產(chǎn)負(fù)債率??

gdqybl=hs1(cs1=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'],cs2=hb.loc['資產(chǎn)總計(jì)'])????????????????????????????#股東權(quán)益比率??

cqfzbl=hs1(cs1=hb.loc['非流動(dòng)負(fù)債合計(jì)'],cs2=hb.loc['資產(chǎn)總計(jì)'])?????????????????????????????#長(zhǎng)期負(fù)債比率??

cqzwyu=hs4(cs1=hb.loc['非流動(dòng)負(fù)債合計(jì)'],cs2=hb.loc['流動(dòng)資產(chǎn)合計(jì)'],cs3=hb.loc['流動(dòng)負(fù)債合計(jì)'])???#長(zhǎng)期債務(wù)與營(yíng)運(yùn)資金比率??

fzsy=hs1(cs1=hb.loc['負(fù)債合計(jì)'],cs2=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'])???????????????????????????????????#負(fù)債與所有者權(quán)益比率??

czcz=hs5(cs1=hb.loc['非流動(dòng)負(fù)債合計(jì)'],cs2=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'],cs3=hb.loc['非流動(dòng)負(fù)債合計(jì)'])???#長(zhǎng)期資產(chǎn)與長(zhǎng)期資金比率??

zbhl=hs1(cs1=hb.loc['非流動(dòng)負(fù)債合計(jì)'],cs2=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'])???????????????????????????????#資本化比率??

zbgdh=hs2(cs1=hb.loc['資產(chǎn)總計(jì)'],cs2=hb.loc['非流動(dòng)負(fù)債合計(jì)'],cs3=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'])?????????#資本固定化比率??

cqbl=hs1(cs1=hb.loc['負(fù)債合計(jì)'],cs2=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'])?????????????????????????????????????#產(chǎn)權(quán)比率??

cz=pd.DataFrame({'流動(dòng)比率':ldbl,'速動(dòng)比率':sdbl,'資產(chǎn)負(fù)債率':zcfzl,'股東權(quán)益比率':gdqybl,'長(zhǎng)期負(fù)債比率':cqfzbl,??

'長(zhǎng)期債務(wù)與營(yíng)運(yùn)資金比率':cqzwyu,'負(fù)債與所有者權(quán)益比率':fzsy,??

'長(zhǎng)期資產(chǎn)與長(zhǎng)期資金比率':czcz,'資本化率':zbhl,'資本固定化比率':zbgdh,'產(chǎn)權(quán)比率':cqbl})??

cz?=?cz.T??

cz_bh?=?cz.std(axis?=1)??

#?計(jì)算盈利能力指標(biāo)??

zzclr?=?hs1(cs1?=?hb.loc['利潤(rùn)總額'],cs2?=?pj_data(xm=?data.loc['資產(chǎn)總計(jì)']))??

zzcjlr?=?hs1(cs1?=?hb.loc['凈利潤(rùn)'],cs2?=pj_data(xm=?data.loc['資產(chǎn)總計(jì)']))??

yylr?=hs1(cs1?=?hb.loc['營(yíng)業(yè)利潤(rùn)'],cs2?=hb.loc['營(yíng)業(yè)總收入']?)??

jzcsy?=?hs1(cs1?=?hb.loc['凈利潤(rùn)'],cs2?=hb.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)']?)??

gbbc?=?hs1(cs1?=?hb.loc['凈利潤(rùn)'],cs2?=hb.loc['實(shí)收資本(或股本)']?)??

xsml?=?hs7(cs1=hb.loc['營(yíng)業(yè)收入'],cs2=hb.loc['營(yíng)業(yè)成本'])??

yl?=?pd.DataFrame({'總資產(chǎn)利潤(rùn)率':zzclr,'總資產(chǎn)凈利潤(rùn)率':zzcjlr,'營(yíng)業(yè)利潤(rùn)率':yylr,'凈資產(chǎn)收益率':jzcsy,'股本報(bào)酬率':gbbc,'銷售毛利率':xsml})??

yl?=?yl.T??

yl_bh?=?yl.std(axis?=1)??

#計(jì)算運(yùn)營(yíng)能力指標(biāo)??

yszkzzl?=?hs1(cs1=hb.loc['營(yíng)業(yè)收入'],cs2=pj_data(xm=data.loc['應(yīng)收賬款']))???#?應(yīng)收賬款周轉(zhuǎn)率??

yszkzzt?=?round(360/yszkzzl,2)????#?應(yīng)收賬款周轉(zhuǎn)天數(shù)??

chzzl?=?hs1(cs1=hb.loc['營(yíng)業(yè)成本'],cs2=pj_data(xm=data.loc['存貨']))???#?存貨周轉(zhuǎn)率??

chzzt?=?round(360/chzzl,2)????#?存貨周轉(zhuǎn)天數(shù)??

zzzzzl?=?hs1(cs1=hb.loc['營(yíng)業(yè)總收入'],cs2=pj_data(xm=data.loc['資產(chǎn)總計(jì)']))????#?總資產(chǎn)周轉(zhuǎn)率??

zzzzzt?=?round(360/zzzzzl,2)????#?總資產(chǎn)周轉(zhuǎn)天數(shù)??

ldzczzl?=?hs1(cs1=hb.loc['營(yíng)業(yè)收入'],cs2=pj_data(xm=data.loc['流動(dòng)資產(chǎn)合計(jì)']))???#?流動(dòng)資產(chǎn)周轉(zhuǎn)率??

ldzczzt?=?round(360/ldzczzl,2)???????#?流動(dòng)資產(chǎn)周轉(zhuǎn)天數(shù)??

yy?=?pd.DataFrame({'應(yīng)收賬款周轉(zhuǎn)率':yszkzzl,'應(yīng)收賬款周轉(zhuǎn)天數(shù)':yszkzzt,'存貨周轉(zhuǎn)率':chzzl,'存貨周轉(zhuǎn)天數(shù)':chzzt,??

'總資產(chǎn)周轉(zhuǎn)率':zzzzzl,'總資產(chǎn)周轉(zhuǎn)天數(shù)':zzzzzt,'流動(dòng)資產(chǎn)周轉(zhuǎn)率':ldzczzl,'流動(dòng)資產(chǎn)周轉(zhuǎn)天數(shù)':ldzczzt})??

yy?=?yy.T??

yy_bh?=?yy.std(axis?=1)??

#?計(jì)算成長(zhǎng)能力指標(biāo)??

zyyw?=?zzl_data(xm=data.loc['營(yíng)業(yè)收入'])??#?主營(yíng)業(yè)務(wù)收入增長(zhǎng)率??

jlrzz?=?zzl_data(xm=data.loc['凈利潤(rùn)'])??#?凈利潤(rùn)增長(zhǎng)率??

jzzzz?=?zzl_data(xm=data.loc['所有者權(quán)益(或股東權(quán)益)合計(jì)'])?#?凈資產(chǎn)增長(zhǎng)率??

zzzzz?=?zzl_data(xm=data.loc['資產(chǎn)總計(jì)'])?#?總資產(chǎn)增長(zhǎng)率??

czn?=?pd.DataFrame({'主營(yíng)業(yè)務(wù)收入增長(zhǎng)率':zyyw,'凈利潤(rùn)增長(zhǎng)率':jlrzz,'凈資產(chǎn)增長(zhǎng)率':jzzzz,'總資產(chǎn)增長(zhǎng)率':zzzzz})??

czn?=?czn.T??

czn.columns?=?[str(m)+'年'?for?m?in?list(range(int(st),int(et)+1))][::-1]??

czn_bh?=?czn.std(axis?=1)??

writer?=?pd.ExcelWriter(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\%s%s年至%s年財(cái)務(wù)分析基數(shù)數(shù)據(jù)表.xlsx'?%(c_name,st,et))??

zy.to_excel(writer,sheet_name='財(cái)報(bào)主要數(shù)據(jù)表')??

zc.to_excel(writer,sheet_name='資產(chǎn)結(jié)構(gòu)表')??

fz.to_excel(writer,sheet_name='負(fù)債結(jié)構(gòu)表')??

qy.to_excel(writer,sheet_name='股本結(jié)構(gòu)表')??

lr.to_excel(writer,sheet_name='利潤(rùn)表主要數(shù)據(jù)表')??

xj.to_excel(writer,sheet_name='現(xiàn)金流量表主要數(shù)據(jù)表')??

cz.to_excel(writer,sheet_name='償債能力主要數(shù)據(jù)表')??

yl.to_excel(writer,sheet_name='盈利能力主要數(shù)據(jù)表')??

yy.to_excel(writer,sheet_name='運(yùn)營(yíng)能力主要數(shù)據(jù)表')??

czn.to_excel(writer,sheet_name='成長(zhǎng)能力主要數(shù)據(jù)表')??

writer.save()??

writer.close()??

#制作各種所需圖??

#財(cái)務(wù)主要數(shù)據(jù)變化趨勢(shì)圖??

fig(x=zy,y='財(cái)務(wù)主要數(shù)據(jù)變化趨勢(shì)圖')??

#資產(chǎn)結(jié)構(gòu)變化趨勢(shì)圖??

fig(x=zc,y='資產(chǎn)結(jié)構(gòu)變化趨勢(shì)圖')??

#負(fù)債結(jié)構(gòu)變化趨勢(shì)圖??

fig(x=fz,y='負(fù)債結(jié)構(gòu)變化趨勢(shì)圖')??

#股本結(jié)構(gòu)變化趨勢(shì)圖??

fig(x=qy,y='股本結(jié)構(gòu)變化趨勢(shì)圖')??

#利潤(rùn)表主要數(shù)據(jù)變化趨勢(shì)圖??

fig(x=lr,y='利潤(rùn)表主要數(shù)據(jù)變化趨勢(shì)圖')??

#現(xiàn)金流量表主要數(shù)據(jù)變化趨勢(shì)圖??

fig(x=xj,y='現(xiàn)金流量表主要數(shù)據(jù)變化趨勢(shì)圖')??

#償債能力主要指標(biāo)變化趨勢(shì)圖??

fig(x=cz,y='償債能力主要指標(biāo)變化趨勢(shì)圖')??

#盈利主要指標(biāo)變化趨勢(shì)圖??

fig(x=yl,y='盈利能力主要指標(biāo)變化趨勢(shì)圖')??

#運(yùn)營(yíng)能力主要指標(biāo)變化趨勢(shì)圖??

fig(x=yy,y='運(yùn)營(yíng)能力主要指標(biāo)變化趨勢(shì)圖')??

#成長(zhǎng)能力主要指標(biāo)變化趨勢(shì)圖??

fig(x=czn,y='成長(zhǎng)能力主要指標(biāo)變化趨勢(shì)圖')??

#文章正文部分??

#文章正文標(biāo)題部分??

d1?=?Document()??

p1?=d1.add_paragraph()??

p1.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

r1?=?p1.add_run('%s財(cái)務(wù)分析報(bào)告'?%?c_name?)??

r1.font.size?=?Pt(14)??

r1.font.bold?=True??

r1.font.name?='仿宋_GB2312'??

r1._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#文章正文第一部分——財(cái)報(bào)主要數(shù)據(jù)??

p2?=d1.add_paragraph()??

r2?=?p2.add_run('???一乱陡、公司基本財(cái)務(wù)數(shù)據(jù)?\n ??下表數(shù)據(jù)為%s%s年至%s年主要財(cái)務(wù)數(shù)據(jù)：'%(c_name,st,et))??

r2.font.size?=?Pt(10)??

#?r2.font.bold?=?True??

r2.font.name?='仿宋_GB2312'??

r2._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入財(cái)報(bào)主要數(shù)據(jù)表格??

data_table(x=y_list,y=zy)??

#財(cái)報(bào)主要數(shù)據(jù)的描述??

p22?=?d1.add_paragraph()??

run22?=?p22.add_run('????從上表數(shù)據(jù)中可以看出否纬，%s；%s蛋褥；%s临燃；%s；%s；%s膜廊；%s乏沸。\n ????下圖為各項(xiàng)數(shù)據(jù)的變化趨勢(shì)圖：'?%?(change(x=zy,y?=?'資產(chǎn)總計(jì)'),??

change(x=zy,y?='負(fù)債合計(jì)'),change(x=zy,y?=?'所有者權(quán)益(或股東權(quán)益)合計(jì)'),change(x=zy,y?=?'營(yíng)業(yè)總收入'),change(x=zy,y?=?'營(yíng)業(yè)總成本'),??

change(x=zy,y?='利潤(rùn)總額'),change(x=zy,y?=?'凈利潤(rùn)')))??

run22.font.name?="仿宋_GB2312"??

run22._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run22.font.size?=?Pt(10)??

#插入財(cái)報(bào)主要數(shù)據(jù)變化趨勢(shì)圖??

tu1?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\財(cái)務(wù)主要數(shù)據(jù)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu1.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

#??

#文章正文第二部分——資產(chǎn)結(jié)構(gòu)??

p3?=d1.add_paragraph()??

r3?=?p3.add_run('???二、資產(chǎn)負(fù)債表分析?\n ? 1爪瓜、資產(chǎn)結(jié)構(gòu)分析\n ???下表數(shù)據(jù)為%s%s年至%s年資產(chǎn)結(jié)構(gòu)分析主要數(shù)據(jù)蹬跃。'%(c_name,st,et))??

r3.font.size?=?Pt(10)??

#?r3.font.bold?=?True??

r3.font.name?='仿宋_GB2312'??

r3._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入資產(chǎn)結(jié)構(gòu)表格??

data_table(x=y_list,y=zc)??

p31?=?d1.add_paragraph()??

run31?=?p31.add_run('????'??

'從上表數(shù)據(jù)中可以看出，在%s年至%s年度中%s铆铆；%s蝶缀；其中變化最大的項(xiàng)目為%s；變化最小的項(xiàng)目為%s薄货。'??

'在%s年度的資產(chǎn)結(jié)構(gòu)中占比最大的項(xiàng)目%s翁都，占比比例為%.2f，此項(xiàng)目%s年度的占比為%.2f谅猾；'??

'占比最小的項(xiàng)目為%s其中占比為%.2f柄慰，此項(xiàng)目%s年度的占比為%.2f。'??

'以上是對(duì)資產(chǎn)結(jié)構(gòu)的整體介紹税娜，其他具體項(xiàng)目的變化趨勢(shì)見下圖：'?%(??

????st,et,??

change(x=zc,y?='流動(dòng)資產(chǎn)合計(jì)'),change(x=zc,y?=?'非流動(dòng)資產(chǎn)合計(jì)'),change(x=zc2,y?=?zc_bh.idxmax()),change(x=zc2,y?=?zc_bh.idxmin()),??

et,zc1['%s年'%et].idxmax(),zc1.loc[zc1['%s年'%et].idxmax(),'%s年'%et],st,zc1.loc[zc1['%s年'%st].idxmax(),'%s年'%st],??

zc1['%s年'%et].idxmin(),zc1.loc[zc1['%s年'%et].idxmin(),'%s年'%et],st,zc1.loc[zc1['%s年'%st].idxmin(),'%s年'%st]))??

run31.font.name?="仿宋_GB2312"??

run31._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run31.font.size?=?Pt(10)??

#??

tu2?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\資產(chǎn)結(jié)構(gòu)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu2.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

p4?=d1.add_paragraph()??

r4?=?p4.add_run('?? 2坐搔、負(fù)債結(jié)構(gòu)分析\n ???下表數(shù)據(jù)為%s%s年至%s年負(fù)債結(jié)構(gòu)分析主要數(shù)據(jù)。'%(c_name,st,et))??

r4.font.size?=?Pt(10)??

#?r4.font.bold?=?True??

r4.font.name?='仿宋_GB2312'??

r4._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#??

#插入負(fù)債結(jié)構(gòu)表??

data_table(x=y_list,y=fz)??

p41?=?d1.add_paragraph()??

run41?=?p41.add_run('????'??

'從上表數(shù)據(jù)中可以看出敬矩，在%s年至%s年度中%s概行；%s；其中變化最大的項(xiàng)目為%s弧岳；變化最小的項(xiàng)目為%s占锯。'??

'在%s年度的負(fù)債結(jié)構(gòu)中占比最大的項(xiàng)目%s，占比比例為%.2f缩筛，此項(xiàng)目%s年度的占比為%.2f；'??

'占比最小的項(xiàng)目為%s其中占比為%.2f堡称，此項(xiàng)目%s年度的占比為%.2f瞎抛。'??

'以上是對(duì)負(fù)債結(jié)構(gòu)的整體介紹，其他具體項(xiàng)目的變化趨勢(shì)見下圖：'?%(??

????st,et,??

change(x=fz,y='流動(dòng)負(fù)債合計(jì)'),change(x=fz,y='非流動(dòng)負(fù)債合計(jì)'),change(x=fz2,y=fz_bh.idxmax()),change(x=fz2,y=fz_bh.idxmin()),??

et,fz1['%s年'%et].idxmax(),fz1.loc[fz1['%s年'%et].idxmax(),'%s年'%et],st,fz1.loc[fz1['%s年'%st].idxmax(),'%s年'%st],??

fz1['%s年'%et].idxmax(),fz1.loc[fz1['%s年'%et].idxmax(),'%s年'%et],st,fz1.loc[fz1['%s年'%st].idxmax(),'%s年'%st]??

????))??

run41.font.name?="仿宋_GB2312"??

run41._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run41.font.size?=?Pt(10)??

tu3?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\負(fù)債結(jié)構(gòu)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu3.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

p5?=d1.add_paragraph()??

r5?=?p5.add_run('?? 3却紧、所有者權(quán)益結(jié)構(gòu)分析\n ???下表數(shù)據(jù)為%s%s年至%s年所有者權(quán)益結(jié)構(gòu)分析主要數(shù)據(jù)桐臊。'%(c_name,st,et))??

r5.font.size?=?Pt(10)??

#?r5.font.bold?=?True??

r5.font.name?='仿宋_GB2312'??

r5._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入權(quán)益結(jié)構(gòu)表??

data_table(x=y_list,y=qy)??

p51?=?d1.add_paragraph()??

run51?=?p51.add_run('????'??

'從上表數(shù)據(jù)中可以看出，在%s年至%s年度中%s晓殊；%s断凶；其中變化最大的項(xiàng)目為%s；變化最小的項(xiàng)目為%s巫俺。'??

'在%s年度的股本結(jié)構(gòu)中占比最大的項(xiàng)目%s认烁，占比比例為%.2f，此項(xiàng)目%s年度的占比為%.2f；'??

'占比最小的項(xiàng)目為%s其中占比為%.2f却嗡，此項(xiàng)目%s年度的占比為%.2f舶沛。'??

'以上是對(duì)股本結(jié)構(gòu)的整體介紹，其他具體項(xiàng)目的變化趨勢(shì)見下圖：'?%(??

????st,et,??

change(x=qy,?y='實(shí)收資本(或股本)'),?change(x=qy,?y='未分配利潤(rùn)'),?change(x=qy2,?y=qy_bh.idxmax()),change(x=qy2,?y=qy_bh.idxmin()),??

et,qy1['%s年'%et].idxmax(),qy1.loc[qy1['%s年'%et].idxmax(),'%s年'%et],st,qy1.loc[qy1['%s年'%st].idxmax(),'%s年'%st],??

qy1['%s年'%et].idxmax(),qy1.loc[qy1['%s年'%et].idxmax(),'%s年'%et],st,qy1.loc[qy1['%s年'%st].idxmax(),'%s年'%st]??

????))??

run51.font.name?="仿宋_GB2312"??

run51._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run51.font.size?=?Pt(10)??

tu4?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\股本結(jié)構(gòu)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu4.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

#??

p6?=d1.add_paragraph()??

r6?=?p6.add_run('???三窗价、利潤(rùn)表分析\n ???下表數(shù)據(jù)為%s%s年至%s年利潤(rùn)表主要數(shù)據(jù)如庭。'%(c_name,st,et))??

r6.font.size?=?Pt(10)??

#?r6.font.bold?=?True??

r6.font.name?='仿宋_GB2312'??

r6._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入利潤(rùn)表??

data_table(x=y_list,y=lr)??

p61?=?d1.add_paragraph()??

run61?=?p61.add_run('????從上表數(shù)據(jù)中可以看出，%s;%s;%s;%s;%s;%s;%s;%s;%s;%s;%s;%s;%s;%s撼港。\n ?下圖為各項(xiàng)數(shù)據(jù)的變化趨勢(shì)圖：'%??

(change(x=lr,y='營(yíng)業(yè)總收入'),change(x=lr,y='營(yíng)業(yè)收入'),change(x=lr,y='其他業(yè)務(wù)收入'),change(x=lr,y='營(yíng)業(yè)總成本'),??

change(x=lr,y='營(yíng)業(yè)成本'),change(x=lr,y='其他業(yè)務(wù)成本'),change(x=lr,y='銷售費(fèi)用'),change(x=lr,y='管理費(fèi)用'),??

change(x=lr,y='財(cái)務(wù)費(fèi)用'),change(x=lr,y='其他業(yè)務(wù)利潤(rùn)'),change(x=lr,y='營(yíng)業(yè)利潤(rùn)'),change(x=lr,y='利潤(rùn)總額'),??

change(x=lr,y='所得稅費(fèi)用'),change(x=lr,y='凈利潤(rùn)'),))??

run61.font.name?="仿宋_GB2312"??

run61._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run61.font.size?=?Pt(10)??

tu5?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\利潤(rùn)表主要數(shù)據(jù)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu5.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

#??

p7?=d1.add_paragraph()??

r7?=?p7.add_run('???四坪它、現(xiàn)金流量表分析\n ???下表數(shù)據(jù)為%s%s年至%s年現(xiàn)金流量表主要數(shù)據(jù)。'%(c_name,st,et))??

r7.font.size?=?Pt(10)??

#?7.font.bold?=?True??

r7.font.name?='仿宋_GB2312'??

r7._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入現(xiàn)金流量表??

data_table(x=y_list,y=xj)??

p71?=?d1.add_paragraph()??

run71?=?p71.add_run('????從上表數(shù)據(jù)中可以看出帝牡，%s;%s;%s;%s;%s;%s;%s;%s;%s;%s往毡。\n ?下圖為各項(xiàng)數(shù)據(jù)的變化趨勢(shì)圖：'?%?(??

change(x=xj,y='經(jīng)營(yíng)活動(dòng)現(xiàn)金流入小計(jì)'),change(x=xj,y='經(jīng)營(yíng)活動(dòng)現(xiàn)金流出小計(jì)'),change(x=xj,y='經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~'),??

change(x=xj,y='投資活動(dòng)現(xiàn)金流入小計(jì)'),change(x=xj,y='投資活動(dòng)現(xiàn)金流出小計(jì)'),change(x=xj,y='投資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~'),??

change(x=xj,y='籌資活動(dòng)現(xiàn)金流入小計(jì)'),change(x=xj,y='籌資活動(dòng)現(xiàn)金流出小計(jì)'),change(x=xj,y='籌資活動(dòng)產(chǎn)生的現(xiàn)金流量?jī)纛~'),??

change(x=xj,y='現(xiàn)金及現(xiàn)金等價(jià)物凈增加額')))??

run71.font.name?="仿宋_GB2312"??

run71._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run71.font.size?=?Pt(10)??

#??

tu6?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\現(xiàn)金流量表主要數(shù)據(jù)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu6.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

#??

#??

p8?=d1.add_paragraph()??

r8?=?p8.add_run('???五、綜合財(cái)務(wù)指標(biāo)分析?\n ? 1否灾、償債能力分析\n ???下表數(shù)據(jù)為%s%s年至%s年嘗債能力分析指標(biāo)主要數(shù)據(jù)卖擅。'%(c_name,st,et))??

r8.font.size?=?Pt(10)??

#?r8.font.bold?=?True??

r8.font.name?='仿宋_GB2312'??

r8._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入償債能力表??

data_table(x=y_list,y=cz)??

p81?=?d1.add_paragraph()??

run81?=?p81.add_run('????上表數(shù)據(jù)反映出，%s墨技；%s惩阶；%s；%s扣汪。其中變化最大的指標(biāo)為%s断楷。下圖為各項(xiàng)指標(biāo)數(shù)據(jù)的變化趨勢(shì)圖：'%(??

up(x=cz,y='流動(dòng)比率'),up(x=cz,y='速動(dòng)比率'),down(x=cz,y='資產(chǎn)負(fù)債率'),down(x=cz,y='產(chǎn)權(quán)比率'),change(x=cz,?y=cz_bh.idxmax())??

)?)??

run81.font.name?="仿宋_GB2312"??

run81._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run81.font.size?=?Pt(10)??

tu7?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\償債能力主要指標(biāo)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu7.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

p9?=d1.add_paragraph()??

r9?=?p9.add_run('?? 2、盈利能力分析\n ???下表數(shù)據(jù)為%s%s年至%s年盈利能力分析指標(biāo)主要數(shù)據(jù)崭别。'%(c_name,st,et))??

r9.font.size?=?Pt(10)??

#?r9.font.bold?=?True??

r9.font.name?='仿宋_GB2312'??

r9._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入盈利能力表??

data_table(x=y_list,y=yl)??

p91?=?d1.add_paragraph()??

run91?=?p91.add_run('?????上表數(shù)據(jù)反映出冬筒，%s；%s茅主；%s舞痰；%s；%s诀姚；%s响牛。其中變化最大的指標(biāo)為%s。下圖為各項(xiàng)指標(biāo)數(shù)據(jù)的變化趨勢(shì)圖：'%(??

up(x=yl,y='總資產(chǎn)利潤(rùn)率'),up(x=yl,y='總資產(chǎn)凈利潤(rùn)率'),up(x=yl,y='營(yíng)業(yè)利潤(rùn)率'),up(x=yl,y='凈資產(chǎn)收益率'),up(x=yl,y='股本報(bào)酬率'),??

up(x=yl,y='銷售毛利率'),change(x=yl,?y=yl_bh.idxmax())??

)?)??

run91.font.name?="仿宋_GB2312"??

run91._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run91.font.size?=?Pt(10)??

tu8?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\盈利能力主要指標(biāo)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu8.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

p10?=d1.add_paragraph()??

r10?=?p10.add_run('?? 3赫段、運(yùn)營(yíng)能力分析\n ???下表數(shù)據(jù)為%s%s年至%s年運(yùn)營(yíng)能力分析指標(biāo)主要數(shù)據(jù)呀打。'%(c_name,st,et))??

r10.font.size?=?Pt(10)??

#?r10.font.bold?=?True??

r10.font.name?='仿宋_GB2312'??

r10._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入運(yùn)營(yíng)能力表??

data_table(x=y_list,y=yy)??

p101?=?d1.add_paragraph()??

run101?=?p101.add_run('????上表數(shù)據(jù)反映出，%s糯笙；%s贬丛；%s；%s给涕；%s豺憔；%s额获；%s；%s焕阿。下圖為各項(xiàng)指標(biāo)數(shù)據(jù)的變化趨勢(shì)圖：'?%(??

up(x=yy,y='應(yīng)收賬款周轉(zhuǎn)率'),down(x=yy,y='應(yīng)收賬款周轉(zhuǎn)天數(shù)'),up(x=yy,y='存貨周轉(zhuǎn)率'),down(x=yy,y='存貨周轉(zhuǎn)天數(shù)'),??

up(x=yy,y='總資產(chǎn)周轉(zhuǎn)率'),down(x=yy,y='總資產(chǎn)周轉(zhuǎn)天數(shù)'),up(x=yy,y='流動(dòng)資產(chǎn)周轉(zhuǎn)率'),down(x=yy,y='流動(dòng)資產(chǎn)周轉(zhuǎn)天數(shù)')))??

run101.font.name?="仿宋_GB2312"??

run101._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run101.font.size?=?Pt(10)??

tu9?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\運(yùn)營(yíng)能力主要指標(biāo)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu9.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

p11?=d1.add_paragraph()??

r11?=?p11.add_run('?? 4咪啡、成長(zhǎng)能力分析\n ???下表數(shù)據(jù)為%s%s年至%s年成長(zhǎng)能力分析指標(biāo)主要數(shù)據(jù)。'%(c_name,st,et))??

r11.font.size?=?Pt(10)??

#?r11.font.bold?=?True??

r11.font.name?='仿宋_GB2312'??

r11._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

#插入成長(zhǎng)能力表??

data_table(x=y_list,y=czn)??

p111?=?d1.add_paragraph()??

run111?=?p111.add_run('????上表數(shù)據(jù)反映出暮屡，%s;%s;%s;%s撤摸。\n ???下圖為各項(xiàng)指標(biāo)數(shù)據(jù)的變化趨勢(shì)圖：'?%(??

up(x=czn,y='主營(yíng)業(yè)務(wù)收入增長(zhǎng)率'),up(x=czn,y='凈利潤(rùn)增長(zhǎng)率'),up(x=czn,y='凈資產(chǎn)增長(zhǎng)率'),up(x=czn,y='總資產(chǎn)增長(zhǎng)率')))??

run111.font.name?="仿宋_GB2312"??

run111._element.rPr.rFonts.set(qn('w:eastAsia'),?u'仿宋_GB2312')??

run111.font.size?=?Pt(10)??

tu10?=?d1.add_picture(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\成長(zhǎng)能力主要指標(biāo)變化趨勢(shì)圖.png',width=Inches(6),height=Inches(4))??

tu10.alignment?=?WD_ALIGN_PARAGRAPH.CENTER??

d1.save(r'C:\Users\admin\Desktop\python_data\財(cái)務(wù)分析\成果展示\%s%s年度至%s年度財(cái)務(wù)分析.docx'?%?(c_name,st,et))??

以下是最終的生成的文檔以及數(shù)據(jù)報(bào)表等。

感興趣的話可以在微信公眾號(hào)中搜索“數(shù)據(jù)處理和工作效率：Big_Data-"褒纲，查看其他文章准夷。