import akshare as ak
import pandas as pd
import streamlit as st
import matplotlib.pyplot as plt
from matplotlib.dates import DateFormatter

# 獲取貴州茅臺(tái)近十年財(cái)務(wù)報(bào)表
balance_sheet = ak.stock_financial_report_sina(stock="sh600519", symbol="資產(chǎn)負(fù)債表").head(40)
income_statement = ak.stock_financial_report_sina(stock="sh600519", symbol="利潤(rùn)表").head(40)
cash_flow = ak.stock_financial_report_sina(stock="sh600519", symbol="現(xiàn)金流量表").head(40)

# 保存為CSV文件
balance_sheet.to_csv('C:/Users/Hp/Desktop/Test1/balance_sheet.csv', index=False)#要填你要保存的地址
income_statement.to_csv('C:/Users/Hp/Desktop/Test1/income_statement.csv', index=False)
cash_flow.to_csv('C:/Users/Hp/Desktop/Test1/cash_flow.csv', index=False)

# 讀取數(shù)據(jù)并設(shè)置日期索引
bs_data = pd.read_csv('C:/Users/Hp/Desktop/Test1/balance_sheet.csv', parse_dates=['報(bào)告日'], index_col='報(bào)告日').head(20)
is_data = pd.read_csv('C:/Users/Hp/Desktop/Test1/income_statement.csv', parse_dates=['報(bào)告日'], index_col='報(bào)告日').head(20)
cf_data = pd.read_csv('C:/Users/Hp/Desktop/Test1/cash_flow.csv', parse_dates=['報(bào)告日'], index_col='報(bào)告日').head(20)

# 按日期排序
bs_data = bs_data.sort_values(by='報(bào)告日')
is_data = is_data.sort_values(by='報(bào)告日')
cf_data = cf_data.sort_values(by='報(bào)告日')

# 計(jì)算凈利潤(rùn)
is_data['總凈利潤(rùn)'] = is_data['營(yíng)業(yè)總收入'] - is_data['營(yíng)業(yè)總成本']

# 計(jì)算同比增長(zhǎng)率
is_data['營(yíng)收同比增長(zhǎng)'] = (is_data['營(yíng)業(yè)收入'] - is_data['營(yíng)業(yè)收入'].shift(4)) / is_data['營(yíng)業(yè)收入'].shift(4) * 100
is_data['總凈利潤(rùn)同比增長(zhǎng)'] = (is_data['總凈利潤(rùn)'] - is_data['總凈利潤(rùn)'].shift(4)) / is_data['總凈利潤(rùn)'].shift(4) * 100

# 單位轉(zhuǎn)換為億元
is_data['營(yíng)業(yè)收入_億元'] = is_data['營(yíng)業(yè)收入'] / 1e8
is_data['總凈利潤(rùn)_億元'] = is_data['總凈利潤(rùn)'] / 1e8

# 創(chuàng)建Web界面
st.title('貴州茅臺(tái)(600519)財(cái)務(wù)分析儀表板')

# 設(shè)置中文字體
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False

# 分標(biāo)簽頁(yè)展示
tab1, tab2 = st.tabs(["財(cái)務(wù)指標(biāo)趨勢(shì)", "同比增長(zhǎng)分析"])

with tab1:
    # 營(yíng)業(yè)收入與凈利潤(rùn)趨勢(shì)圖
    fig1, (ax1, ax2) = plt.subplots(2, 1, figsize=(12, 10))
    ax1.plot(is_data.index, is_data['營(yíng)業(yè)收入_億元'], label='營(yíng)業(yè)收入', color='#1f77b4', marker='o')
    ax2.plot(is_data.index, is_data['總凈利潤(rùn)_億元'], label='總凈利潤(rùn)', color='#2ca02c', marker='s')
    # 設(shè)置圖表格式（略）
    st.pyplot(fig1)

with tab2:
    # 同比增長(zhǎng)率分析
    growth_data = is_data[['營(yíng)收同比增長(zhǎng)', '總凈利潤(rùn)同比增長(zhǎng)']].dropna()
    fig2, ax = plt.subplots(figsize=(12, 6))
    ax.plot(growth_data.index, growth_data['營(yíng)收同比增長(zhǎng)'], label='營(yíng)收同比增長(zhǎng)率', color='#d62728', marker='^')
    ax.plot(growth_data.index, growth_data['總凈利潤(rùn)同比增長(zhǎng)'], label='凈利潤(rùn)同比增長(zhǎng)率', color='#ff7f0e', marker='d')
    # 設(shè)置圖表格式（略）
    st.pyplot(fig2)

# 展示核心數(shù)據(jù)表格
st.subheader("核心財(cái)務(wù)數(shù)據(jù)")
col1, col2 = st.columns(2)
with col1:
    st.dataframe(is_data[['營(yíng)業(yè)收入_億元', '總凈利潤(rùn)_億元']].tail(1).style.format("{:.2f}"))
with col2:
    st.dataframe(growth_data[['營(yíng)收同比增長(zhǎng)', '總凈利潤(rùn)同比增長(zhǎng)']].tail(1).style.format("{:.1f}%"))

pip install akshare pandas streamlit matplotlib

streamlit run C:\Users\Hp\Desktop\py\Test1.py