{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "f2993e69-925c-46f5-89ca-2c31ffb8b8b7", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 6, "id": "9a1f5c70-fa09-44c6-b965-4f0879e937ad", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "截止日 数据报告期 公布日 \n", "20121231 20121231 20130425 8734383.36\n", " 20131231 20140426 6635855.05\n", " 20140617 6635855.05\n", "20130331 20130331 20130426 -9115517.76\n", " 20140331 20140426 -9115517.76\n", " ... \n", "20210331 20220331 20220430 -1289465.67\n", "20210630 20210630 20210827 -2284058.28\n", "20210930 20210930 20211029 -2311959.04\n", "20211231 20211231 20220430 39970569.46\n", "20220331 20220331 20220430 -4443902.93\n", "Name: 归属于母公司所有者净利润, Length: 90, dtype: float64" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_tinysoft = pd.read_csv('tinysoft-data/基础报表/46.合并利润分配表/SZ000007.csv').set_index(['截止日','数据报告期', '公布日'])\n", "df_tinysoft['归属于母公司所有者净利润']" ] }, { "cell_type": "code", "execution_count": 4, "id": "c30974d2-2448-4f1f-87df-f9d82147ff82", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
symbolStockNameperiod转增比股东大会日送股比决案公布日红利比date实得比实施公布日分红送股基数红股比除权除息日备注预案预披露公布日送股上市日分红发放日股权登记日
0NE430090同辉信息201212310.50201305100.50201305140.00201304220.02013053116385477.00.020130603NaN020130604020130603
1NE430090同辉信息201312310.33201405130.33201405140.00201404230.02014060630450000.00.020140613NaN020140613020140612
2NE430090同辉信息201506300.51201508140.51201508150.00201507300.02015082052991500.00.020150827NaN020150827020150826
3NE430090同辉信息201906300.00201909050.50201909060.00201908160.02019091185555665.00.520190919NaN020190919020190918
4NE430090同辉信息202112310.0000.3000.05202204190.000.00.30NaN0000
\n", "
" ], "text/plain": [ " symbol StockName period 转增比 股东大会日 送股比 决案公布日 红利比 \\\n", "0 NE430090 同辉信息 20121231 0.50 20130510 0.50 20130514 0.00 \n", "1 NE430090 同辉信息 20131231 0.33 20140513 0.33 20140514 0.00 \n", "2 NE430090 同辉信息 20150630 0.51 20150814 0.51 20150815 0.00 \n", "3 NE430090 同辉信息 20190630 0.00 20190905 0.50 20190906 0.00 \n", "4 NE430090 同辉信息 20211231 0.00 0 0.30 0 0.05 \n", "\n", " date 实得比 实施公布日 分红送股基数 红股比 除权除息日 备注 预案预披露公布日 送股上市日 \\\n", "0 20130422 0.0 20130531 16385477.0 0.0 20130603 NaN 0 20130604 \n", "1 20140423 0.0 20140606 30450000.0 0.0 20140613 NaN 0 20140613 \n", "2 20150730 0.0 20150820 52991500.0 0.0 20150827 NaN 0 20150827 \n", "3 20190816 0.0 20190911 85555665.0 0.5 20190919 NaN 0 20190919 \n", "4 20220419 0.0 0 0.0 0.3 0 NaN 0 0 \n", "\n", " 分红发放日 股权登记日 \n", "0 0 20130603 \n", "1 0 20140612 \n", "2 0 20150826 \n", "3 0 20190918 \n", "4 0 0 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "report_rename_dict = {\n", " 'StockID':'symbol', # \n", " '报告期':'reported_at', # 财报对应的报告期，但同一期财报中可能对历史财报进行修正\n", " '公布日':'date', # 公布日之后，公开信息才能看到当期报告中的所有数据\n", " '截止日':'period', # 公布的数据对应的报告期，如果`截止日 < 报告期`，则为修正财报\n", " '预案公布日':'date'\n", "}\n", "df_tinysoft.rename(columns=report_rename_dict)" ] }, { "cell_type": "code", "execution_count": 5, "id": "98d687ae-3f5c-4a18-8e54-495a6944d27d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
StockIDStockName截止日公布日每股收益(扣除,摊薄)每股净资产(调整)净资产收益率(扣除,加权)(%)每股资本公积金净资产收益率(加权)(%)净资产收益率(调整)(%)...每股经营活动现金流量净额扣除非经常性损益后的净利润每股净资产每股未分配利润净资产收益率(扣除,摊薄)(%)每股收益(摊薄)每股收益(扣除,加权)备注每股现金净流量每股收益(加权)
0NE430090同辉信息20121231201304220.00.00.00.00.000.0...-0.73941834.501.940.00.00.0700.0NaN0.00.00
1NE430090同辉信息20130630201308230.00.00.00.00.930.0...0.000.001.960.00.00.0200.0NaN0.00.00
2NE430090同辉信息20131231201404230.00.00.00.07.110.0...0.132879509.041.650.00.00.1200.0NaN0.00.12
3NE430090同辉信息20140630201408220.00.00.00.0-0.010.0...0.000.001.230.00.0-0.0100.0NaN0.00.00
4NE430090同辉信息20141231201504240.00.00.00.04.940.0...0.001384507.461.300.00.00.0630.0NaN0.00.00
\n", "

5 rows × 21 columns

\n", "
" ], "text/plain": [ " StockID StockName 截止日 公布日 每股收益(扣除,摊薄) 每股净资产(调整) \\\n", "0 NE430090 同辉信息 20121231 20130422 0.0 0.0 \n", "1 NE430090 同辉信息 20130630 20130823 0.0 0.0 \n", "2 NE430090 同辉信息 20131231 20140423 0.0 0.0 \n", "3 NE430090 同辉信息 20140630 20140822 0.0 0.0 \n", "4 NE430090 同辉信息 20141231 20150424 0.0 0.0 \n", "\n", " 净资产收益率(扣除,加权)(%) 每股资本公积金 净资产收益率(加权)(%) 净资产收益率(调整)(%) ... 每股经营活动现金流量净额 \\\n", "0 0.0 0.0 0.00 0.0 ... -0.73 \n", "1 0.0 0.0 0.93 0.0 ... 0.00 \n", "2 0.0 0.0 7.11 0.0 ... 0.13 \n", "3 0.0 0.0 -0.01 0.0 ... 0.00 \n", "4 0.0 0.0 4.94 0.0 ... 0.00 \n", "\n", " 扣除非经常性损益后的净利润 每股净资产 每股未分配利润 净资产收益率(扣除,摊薄)(%) 每股收益(摊薄) 每股收益(扣除,加权) 备注 \\\n", "0 941834.50 1.94 0.0 0.0 0.070 0.0 NaN \n", "1 0.00 1.96 0.0 0.0 0.020 0.0 NaN \n", "2 2879509.04 1.65 0.0 0.0 0.120 0.0 NaN \n", "3 0.00 1.23 0.0 0.0 -0.010 0.0 NaN \n", "4 1384507.46 1.30 0.0 0.0 0.063 0.0 NaN \n", "\n", " 每股现金净流量 每股收益(加权) \n", "0 0.0 0.00 \n", "1 0.0 0.00 \n", "2 0.0 0.12 \n", "3 0.0 0.00 \n", "4 0.0 0.00 \n", "\n", "[5 rows x 21 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_tinysoft = pd.read_csv('tinysoft-data/基础报表/42.主要财务指标/NE430090.csv')\n", "df_tinysoft.head()" ] }, { "cell_type": "code", "execution_count": 6, "id": "ef41bb16-5991-4040-b62a-a86bd3f6e8e0", "metadata": {}, "outputs": [], "source": [ "report_rename_dict = {\n", " 'StockID':'symbol', # \n", " '报告期':'reported_at', # 财报对应的报告期，但同一期财报中可能对历史财报进行修正\n", " '公布日':'date', # 公布日之后，公开信息才能看到当期报告中的所有数据\n", " '截止日':'period', # 公布的数据对应的报告期，如果`截止日 < 报告期`，则为修正财报\n", " '预案公布日':'date'\n", "}\n", "df_tinysoft.rename(columns=report_rename_dict, inplace=True)" ] }, { "cell_type": "code", "execution_count": 7, "id": "34b467de-b252-4ce9-820f-044477206da5", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
symbolStockNameperioddate每股收益(扣除,摊薄)每股净资产(调整)净资产收益率(扣除,加权)(%)每股资本公积金净资产收益率(加权)(%)净资产收益率(调整)(%)...每股经营活动现金流量净额扣除非经常性损益后的净利润每股净资产每股未分配利润净资产收益率(扣除,摊薄)(%)每股收益(摊薄)每股收益(扣除,加权)备注每股现金净流量每股收益(加权)
0NE430090同辉信息20121231201304220.00.00.00.00.000.0...-0.73941834.501.940.00.00.0700.0NaN0.00.00
1NE430090同辉信息20130630201308230.00.00.00.00.930.0...0.000.001.960.00.00.0200.0NaN0.00.00
2NE430090同辉信息20131231201404230.00.00.00.07.110.0...0.132879509.041.650.00.00.1200.0NaN0.00.12
3NE430090同辉信息20140630201408220.00.00.00.0-0.010.0...0.000.001.230.00.0-0.0100.0NaN0.00.00
4NE430090同辉信息20141231201504240.00.00.00.04.940.0...0.001384507.461.300.00.00.0630.0NaN0.00.00
\n", "

5 rows × 21 columns

\n", "
" ], "text/plain": [ " symbol StockName period date 每股收益(扣除,摊薄) 每股净资产(调整) \\\n", "0 NE430090 同辉信息 20121231 20130422 0.0 0.0 \n", "1 NE430090 同辉信息 20130630 20130823 0.0 0.0 \n", "2 NE430090 同辉信息 20131231 20140423 0.0 0.0 \n", "3 NE430090 同辉信息 20140630 20140822 0.0 0.0 \n", "4 NE430090 同辉信息 20141231 20150424 0.0 0.0 \n", "\n", " 净资产收益率(扣除,加权)(%) 每股资本公积金 净资产收益率(加权)(%) 净资产收益率(调整)(%) ... 每股经营活动现金流量净额 \\\n", "0 0.0 0.0 0.00 0.0 ... -0.73 \n", "1 0.0 0.0 0.93 0.0 ... 0.00 \n", "2 0.0 0.0 7.11 0.0 ... 0.13 \n", "3 0.0 0.0 -0.01 0.0 ... 0.00 \n", "4 0.0 0.0 4.94 0.0 ... 0.00 \n", "\n", " 扣除非经常性损益后的净利润 每股净资产 每股未分配利润 净资产收益率(扣除,摊薄)(%) 每股收益(摊薄) 每股收益(扣除,加权) 备注 \\\n", "0 941834.50 1.94 0.0 0.0 0.070 0.0 NaN \n", "1 0.00 1.96 0.0 0.0 0.020 0.0 NaN \n", "2 2879509.04 1.65 0.0 0.0 0.120 0.0 NaN \n", "3 0.00 1.23 0.0 0.0 -0.010 0.0 NaN \n", "4 1384507.46 1.30 0.0 0.0 0.063 0.0 NaN \n", "\n", " 每股现金净流量 每股收益(加权) \n", "0 0.0 0.00 \n", "1 0.0 0.00 \n", "2 0.0 0.12 \n", "3 0.0 0.00 \n", "4 0.0 0.00 \n", "\n", "[5 rows x 21 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_tinysoft.head()" ] }, { "cell_type": "code", "execution_count": 14, "id": "2d61c6f5-abad-468c-bc3d-37e8e0591ef1", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
StockIDStockName截止日数据报告期公布日子公司所持股份非流动负债调整项目投资性房地产其他流动资产内部往来款...应收保费待处理固定资产净损失衍生金融资产流动资产合计其他债权投资长期待摊费用预付长期投资款固定资产合计存货净额存货
0NE430198微创光电2012123120121231201304150.00.00.00.00.0...0.00.00.074133645.210.00.00.0802953.352910629.542910629.54
1NE430198微创光电2012123120131231201403310.00.00.00.00.0...0.00.00.074133645.210.00.00.0802953.352910629.542910629.54
2NE430198微创光电2012123120131231201404170.00.00.00.00.0...0.00.00.074133645.210.00.00.0802953.352910629.542910629.54
3NE430198微创光电2013063020130630201308200.00.00.00.00.0...0.00.00.063623420.340.00.00.01181024.191763780.301763780.30
4NE430198微创光电2013123120131231201403310.00.00.00.00.0...0.00.00.066471426.490.00.00.023953808.251677872.891677872.89
\n", "

5 rows × 203 columns

\n", "
" ], "text/plain": [ " StockID StockName 截止日 数据报告期 公布日 子公司所持股份 非流动负债调整项目 \\\n", "0 NE430198 微创光电 20121231 20121231 20130415 0.0 0.0 \n", "1 NE430198 微创光电 20121231 20131231 20140331 0.0 0.0 \n", "2 NE430198 微创光电 20121231 20131231 20140417 0.0 0.0 \n", "3 NE430198 微创光电 20130630 20130630 20130820 0.0 0.0 \n", "4 NE430198 微创光电 20131231 20131231 20140331 0.0 0.0 \n", "\n", " 投资性房地产 其他流动资产 内部往来款 ... 应收保费 待处理固定资产净损失 衍生金融资产 流动资产合计 其他债权投资 \\\n", "0 0.0 0.0 0.0 ... 0.0 0.0 0.0 74133645.21 0.0 \n", "1 0.0 0.0 0.0 ... 0.0 0.0 0.0 74133645.21 0.0 \n", "2 0.0 0.0 0.0 ... 0.0 0.0 0.0 74133645.21 0.0 \n", "3 0.0 0.0 0.0 ... 0.0 0.0 0.0 63623420.34 0.0 \n", "4 0.0 0.0 0.0 ... 0.0 0.0 0.0 66471426.49 0.0 \n", "\n", " 长期待摊费用 预付长期投资款 固定资产合计 存货净额 存货 \n", "0 0.0 0.0 802953.35 2910629.54 2910629.54 \n", "1 0.0 0.0 802953.35 2910629.54 2910629.54 \n", "2 0.0 0.0 802953.35 2910629.54 2910629.54 \n", "3 0.0 0.0 1181024.19 1763780.30 1763780.30 \n", "4 0.0 0.0 23953808.25 1677872.89 1677872.89 \n", "\n", "[5 rows x 203 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_tinysoft = pd.read_csv('tinysoft-data/基础报表/44.合并资产负债表/NE430198.csv')\n", "df_tinysoft.head()" ] }, { "cell_type": "code", "execution_count": 15, "id": "d54c4b4e-50c5-432b-878a-ee3f6ff7ff3a", "metadata": {}, "outputs": [], "source": [ "report_rename_dict = {\n", " 'StockID':'symbol', # \n", " '数据报告期':'appear_in_period', # 财报对应的报告期，但同一期财报中可能对历史财报进行修正\n", " '公布日':'date', # 公布日之后，公开信息才能看到当期报告中的所有数据\n", " '截止日':'period', # 公布的数据对应的报告期，如果`截止日 < 报告期`，则为修正财报\n", " '预案公布日':'date'\n", "}\n", "df_tinysoft.rename(columns=report_rename_dict, inplace=True)" ] }, { "cell_type": "code", "execution_count": 16, "id": "66b0a836-afb5-4bbf-92e1-a248350a34e3", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "True" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "'appear_in_period' in df_tinysoft.columns" ] }, { "cell_type": "code", "execution_count": 17, "id": "757dbc55-76e0-4619-99e4-4fae6a6c9c33", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
symbolStockNameperiodappear_in_perioddate子公司所持股份非流动负债调整项目投资性房地产其他流动资产内部往来款...应收保费待处理固定资产净损失衍生金融资产流动资产合计其他债权投资长期待摊费用预付长期投资款固定资产合计存货净额存货
0NE430198微创光电2012123120121231201304150.00.00.00.000.0...0.00.00.07.413365e+070.00.00.0802953.352910629.542910629.54
3NE430198微创光电2013063020130630201308200.00.00.00.000.0...0.00.00.06.362342e+070.00.00.01181024.191763780.301763780.30
4NE430198微创光电2013123120131231201403310.00.00.00.000.0...0.00.00.06.647143e+070.00.00.023953808.251677872.891677872.89
5NE430198微创光电2013123120131231201404170.00.00.00.000.0...0.00.00.06.647143e+070.00.00.023953808.251677872.891677872.89
10NE430198微创光电2014063020140630201408180.00.00.00.000.0...0.00.00.05.443811e+070.00.00.025473333.411592398.421592398.42
11NE430198微创光电2014123120141231201503230.00.00.010000000.000.0...0.00.00.08.875022e+070.00.00.025371751.363160743.113160743.11
14NE430198微创光电2014123120141231201704200.00.00.010000000.000.0...0.00.00.08.875022e+070.00.00.025371751.363160743.113160743.11
16NE430198微创光电2014123120141231201706060.00.00.010000000.000.0...0.00.00.08.875022e+070.00.00.025371751.363160743.113160743.11
18NE430198微创光电2014123120141231201712220.00.00.010000000.000.0...0.00.00.08.875022e+070.00.00.025371751.363160743.113160743.11
19NE430198微创光电2015063020150630201507310.00.00.00.000.0...0.00.00.01.069109e+080.00.00.024549495.903880048.993880048.99
20NE430198微创光电2015123120151231201603250.00.00.041983460.250.0...0.00.00.01.498791e+080.00.00.023647498.405531527.035531527.03
22NE430198微创光电2015123120151231201704200.00.00.041983460.250.0...0.00.00.01.498791e+080.00.00.023647498.405531527.035531527.03
24NE430198微创光电2015123120151231201706060.00.00.041983460.250.0...0.00.00.01.498791e+080.00.00.023647498.405531527.035531527.03
25NE430198微创光电2015123120151231201712210.00.00.041983460.250.0...0.00.00.01.498356e+080.00.00.023647498.405531527.035531527.03
27NE430198微创光电2016063020160630201608150.00.00.010000000.000.0...0.00.00.01.190637e+080.00.00.023089092.884681295.444681295.44
28NE430198微创光电2016123120161231201704200.00.00.030000000.000.0...0.00.00.02.258819e+080.00.00.022760528.2217324158.0517324158.05
29NE430198微创光电2016123120161231201706060.00.00.030000000.000.0...0.00.00.02.258819e+080.00.00.022760528.2217324158.0517324158.05
30NE430198微创光电2016123120161231201712220.00.00.030000000.000.0...0.00.00.02.258819e+080.00.00.022760528.2217324158.0517324158.05
33NE430198微创光电2017063020170630201708300.00.00.010000000.000.0...0.00.00.01.876171e+080.00.00.022022804.8016361478.0816361478.08
34NE430198微创光电2017123120171231201801230.00.00.00.000.0...0.00.00.02.194605e+080.00.00.021200280.7615912996.6015912996.60
37NE430198微创光电2017123120171231202004140.00.00.00.000.0...0.00.00.02.194605e+080.00.00.021200280.7615912996.6015912996.60
38NE430198微创光电2017123120171231202007030.00.00.00.000.0...0.00.00.02.194605e+080.00.00.021200280.7615912996.6015912996.60
39NE430198微创光电2018033120180331201804260.00.00.00.000.0...0.00.00.01.695150e+080.00.00.021452500.9919653445.1619653445.16
40NE430198微创光电2018063020180630201808300.00.00.00.000.0...0.00.00.01.841927e+080.00.00.020700551.4417801363.2617801363.26
41NE430198微创光电2018093020180930201810310.00.00.00.000.0...0.00.00.01.820165e+080.00.00.020263093.3523861785.8623861785.86
42NE430198微创光电2018123120181231201904260.00.00.00.000.0...0.00.00.02.394558e+080.00.00.019854105.7017691042.3417691042.34
44NE430198微创光电2018123120181231202004140.00.00.00.000.0...0.00.00.02.394558e+080.00.00.019854105.7017691042.3417691042.34
46NE430198微创光电2018123120181231202007030.00.00.00.000.0...0.00.00.02.394558e+080.00.00.019854105.7017691042.3417691042.34
47NE430198微创光电2019033120190331201904260.00.00.00.000.0...0.00.00.02.248673e+080.00.00.019700587.2818289862.7518289862.75
48NE430198微创光电2019063020190630201908290.00.00.00.000.0...0.00.00.02.060442e+080.00.00.019751742.6034408679.5134408679.51
49NE430198微创光电2019093020190930201910300.00.00.00.000.0...0.00.00.02.196574e+080.00.00.019463063.0041886590.3541886590.35
50NE430198微创光电2019123120191231202004140.00.00.00.000.0...0.00.00.02.887782e+080.00.00.023744200.7929128387.4429128387.44
51NE430198微创光电2019123120191231202005280.00.00.00.000.0...0.00.00.02.887782e+080.00.00.023744200.7929128387.4429128387.44
52NE430198微创光电2019123120191231202007030.00.00.00.000.0...0.00.00.02.887782e+080.00.00.023744200.7929128387.4429128387.44
54NE430198微创光电2020063020200630202008240.00.00.00.000.0...0.00.00.02.638447e+080.00.00.034974714.3439213777.4339213777.43
55NE430198微创光电2020093020200930202010220.00.00.00.000.0...0.00.00.04.592226e+080.00.00.053333163.6336698873.3636698873.36
56NE430198微创光电2020123120201231202104260.00.00.00.000.0...0.00.00.04.897301e+080.00.00.067110892.2417742938.5017742938.50
58NE430198微创光电2021033120210331202104260.00.00.00.000.0...0.00.00.04.187303e+080.00.00.076872333.8929249304.6829249304.68
59NE430198微创光电2021063020210630202108270.00.00.00.000.0...0.00.00.03.975848e+080.00.00.079390134.9531631292.1231631292.12
60NE430198微创光电2021093020210930202110280.00.00.00.000.0...0.00.00.04.404329e+080.00.00.083281434.7629130959.8529130959.85
61NE430198微创光电2021123120211231202204270.00.00.00.000.0...0.00.00.04.841222e+080.00.00.093160821.4522227865.4322227865.43
62NE430198微创光电2022033120220331202204270.00.00.00.000.0...0.00.00.04.705716e+080.00.00.096153919.0434234735.6834234735.68
\n", "

42 rows × 203 columns

\n", "
" ], "text/plain": [ " symbol StockName period appear_in_period date 子公司所持股份 \\\n", "0 NE430198 微创光电 20121231 20121231 20130415 0.0 \n", "3 NE430198 微创光电 20130630 20130630 20130820 0.0 \n", "4 NE430198 微创光电 20131231 20131231 20140331 0.0 \n", "5 NE430198 微创光电 20131231 20131231 20140417 0.0 \n", "10 NE430198 微创光电 20140630 20140630 20140818 0.0 \n", "11 NE430198 微创光电 20141231 20141231 20150323 0.0 \n", "14 NE430198 微创光电 20141231 20141231 20170420 0.0 \n", "16 NE430198 微创光电 20141231 20141231 20170606 0.0 \n", "18 NE430198 微创光电 20141231 20141231 20171222 0.0 \n", "19 NE430198 微创光电 20150630 20150630 20150731 0.0 \n", "20 NE430198 微创光电 20151231 20151231 20160325 0.0 \n", "22 NE430198 微创光电 20151231 20151231 20170420 0.0 \n", "24 NE430198 微创光电 20151231 20151231 20170606 0.0 \n", "25 NE430198 微创光电 20151231 20151231 20171221 0.0 \n", "27 NE430198 微创光电 20160630 20160630 20160815 0.0 \n", "28 NE430198 微创光电 20161231 20161231 20170420 0.0 \n", "29 NE430198 微创光电 20161231 20161231 20170606 0.0 \n", "30 NE430198 微创光电 20161231 20161231 20171222 0.0 \n", "33 NE430198 微创光电 20170630 20170630 20170830 0.0 \n", "34 NE430198 微创光电 20171231 20171231 20180123 0.0 \n", "37 NE430198 微创光电 20171231 20171231 20200414 0.0 \n", "38 NE430198 微创光电 20171231 20171231 20200703 0.0 \n", "39 NE430198 微创光电 20180331 20180331 20180426 0.0 \n", "40 NE430198 微创光电 20180630 20180630 20180830 0.0 \n", "41 NE430198 微创光电 20180930 20180930 20181031 0.0 \n", "42 NE430198 微创光电 20181231 20181231 20190426 0.0 \n", "44 NE430198 微创光电 20181231 20181231 20200414 0.0 \n", "46 NE430198 微创光电 20181231 20181231 20200703 0.0 \n", "47 NE430198 微创光电 20190331 20190331 20190426 0.0 \n", "48 NE430198 微创光电 20190630 20190630 20190829 0.0 \n", "49 NE430198 微创光电 20190930 20190930 20191030 0.0 \n", "50 NE430198 微创光电 20191231 20191231 20200414 0.0 \n", "51 NE430198 微创光电 20191231 20191231 20200528 0.0 \n", "52 NE430198 微创光电 20191231 20191231 20200703 0.0 \n", "54 NE430198 微创光电 20200630 20200630 20200824 0.0 \n", "55 NE430198 微创光电 20200930 20200930 20201022 0.0 \n", "56 NE430198 微创光电 20201231 20201231 20210426 0.0 \n", "58 NE430198 微创光电 20210331 20210331 20210426 0.0 \n", "59 NE430198 微创光电 20210630 20210630 20210827 0.0 \n", "60 NE430198 微创光电 20210930 20210930 20211028 0.0 \n", "61 NE430198 微创光电 20211231 20211231 20220427 0.0 \n", "62 NE430198 微创光电 20220331 20220331 20220427 0.0 \n", "\n", " 非流动负债调整项目 投资性房地产 其他流动资产 内部往来款 ... 应收保费 待处理固定资产净损失 衍生金融资产 \\\n", "0 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "3 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "4 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "5 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "10 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "11 0.0 0.0 10000000.00 0.0 ... 0.0 0.0 0.0 \n", "14 0.0 0.0 10000000.00 0.0 ... 0.0 0.0 0.0 \n", "16 0.0 0.0 10000000.00 0.0 ... 0.0 0.0 0.0 \n", "18 0.0 0.0 10000000.00 0.0 ... 0.0 0.0 0.0 \n", "19 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "20 0.0 0.0 41983460.25 0.0 ... 0.0 0.0 0.0 \n", "22 0.0 0.0 41983460.25 0.0 ... 0.0 0.0 0.0 \n", "24 0.0 0.0 41983460.25 0.0 ... 0.0 0.0 0.0 \n", "25 0.0 0.0 41983460.25 0.0 ... 0.0 0.0 0.0 \n", "27 0.0 0.0 10000000.00 0.0 ... 0.0 0.0 0.0 \n", "28 0.0 0.0 30000000.00 0.0 ... 0.0 0.0 0.0 \n", "29 0.0 0.0 30000000.00 0.0 ... 0.0 0.0 0.0 \n", "30 0.0 0.0 30000000.00 0.0 ... 0.0 0.0 0.0 \n", "33 0.0 0.0 10000000.00 0.0 ... 0.0 0.0 0.0 \n", "34 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "37 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "38 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "39 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "40 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "41 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "42 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "44 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "46 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "47 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "48 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "49 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "50 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "51 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "52 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "54 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "55 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "56 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "58 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "59 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "60 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "61 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "62 0.0 0.0 0.00 0.0 ... 0.0 0.0 0.0 \n", "\n", " 流动资产合计 其他债权投资 长期待摊费用 预付长期投资款 固定资产合计 存货净额 \\\n", "0 7.413365e+07 0.0 0.0 0.0 802953.35 2910629.54 \n", "3 6.362342e+07 0.0 0.0 0.0 1181024.19 1763780.30 \n", "4 6.647143e+07 0.0 0.0 0.0 23953808.25 1677872.89 \n", "5 6.647143e+07 0.0 0.0 0.0 23953808.25 1677872.89 \n", "10 5.443811e+07 0.0 0.0 0.0 25473333.41 1592398.42 \n", "11 8.875022e+07 0.0 0.0 0.0 25371751.36 3160743.11 \n", "14 8.875022e+07 0.0 0.0 0.0 25371751.36 3160743.11 \n", "16 8.875022e+07 0.0 0.0 0.0 25371751.36 3160743.11 \n", "18 8.875022e+07 0.0 0.0 0.0 25371751.36 3160743.11 \n", "19 1.069109e+08 0.0 0.0 0.0 24549495.90 3880048.99 \n", "20 1.498791e+08 0.0 0.0 0.0 23647498.40 5531527.03 \n", "22 1.498791e+08 0.0 0.0 0.0 23647498.40 5531527.03 \n", "24 1.498791e+08 0.0 0.0 0.0 23647498.40 5531527.03 \n", "25 1.498356e+08 0.0 0.0 0.0 23647498.40 5531527.03 \n", "27 1.190637e+08 0.0 0.0 0.0 23089092.88 4681295.44 \n", "28 2.258819e+08 0.0 0.0 0.0 22760528.22 17324158.05 \n", "29 2.258819e+08 0.0 0.0 0.0 22760528.22 17324158.05 \n", "30 2.258819e+08 0.0 0.0 0.0 22760528.22 17324158.05 \n", "33 1.876171e+08 0.0 0.0 0.0 22022804.80 16361478.08 \n", "34 2.194605e+08 0.0 0.0 0.0 21200280.76 15912996.60 \n", "37 2.194605e+08 0.0 0.0 0.0 21200280.76 15912996.60 \n", "38 2.194605e+08 0.0 0.0 0.0 21200280.76 15912996.60 \n", "39 1.695150e+08 0.0 0.0 0.0 21452500.99 19653445.16 \n", "40 1.841927e+08 0.0 0.0 0.0 20700551.44 17801363.26 \n", "41 1.820165e+08 0.0 0.0 0.0 20263093.35 23861785.86 \n", "42 2.394558e+08 0.0 0.0 0.0 19854105.70 17691042.34 \n", "44 2.394558e+08 0.0 0.0 0.0 19854105.70 17691042.34 \n", "46 2.394558e+08 0.0 0.0 0.0 19854105.70 17691042.34 \n", "47 2.248673e+08 0.0 0.0 0.0 19700587.28 18289862.75 \n", "48 2.060442e+08 0.0 0.0 0.0 19751742.60 34408679.51 \n", "49 2.196574e+08 0.0 0.0 0.0 19463063.00 41886590.35 \n", "50 2.887782e+08 0.0 0.0 0.0 23744200.79 29128387.44 \n", "51 2.887782e+08 0.0 0.0 0.0 23744200.79 29128387.44 \n", "52 2.887782e+08 0.0 0.0 0.0 23744200.79 29128387.44 \n", "54 2.638447e+08 0.0 0.0 0.0 34974714.34 39213777.43 \n", "55 4.592226e+08 0.0 0.0 0.0 53333163.63 36698873.36 \n", "56 4.897301e+08 0.0 0.0 0.0 67110892.24 17742938.50 \n", "58 4.187303e+08 0.0 0.0 0.0 76872333.89 29249304.68 \n", "59 3.975848e+08 0.0 0.0 0.0 79390134.95 31631292.12 \n", "60 4.404329e+08 0.0 0.0 0.0 83281434.76 29130959.85 \n", "61 4.841222e+08 0.0 0.0 0.0 93160821.45 22227865.43 \n", "62 4.705716e+08 0.0 0.0 0.0 96153919.04 34234735.68 \n", "\n", " 存货 \n", "0 2910629.54 \n", "3 1763780.30 \n", "4 1677872.89 \n", "5 1677872.89 \n", "10 1592398.42 \n", "11 3160743.11 \n", "14 3160743.11 \n", "16 3160743.11 \n", "18 3160743.11 \n", "19 3880048.99 \n", "20 5531527.03 \n", "22 5531527.03 \n", "24 5531527.03 \n", "25 5531527.03 \n", "27 4681295.44 \n", "28 17324158.05 \n", "29 17324158.05 \n", "30 17324158.05 \n", "33 16361478.08 \n", "34 15912996.60 \n", "37 15912996.60 \n", "38 15912996.60 \n", "39 19653445.16 \n", "40 17801363.26 \n", "41 23861785.86 \n", "42 17691042.34 \n", "44 17691042.34 \n", "46 17691042.34 \n", "47 18289862.75 \n", "48 34408679.51 \n", "49 41886590.35 \n", "50 29128387.44 \n", "51 29128387.44 \n", "52 29128387.44 \n", "54 39213777.43 \n", "55 36698873.36 \n", "56 17742938.50 \n", "58 29249304.68 \n", "59 31631292.12 \n", "60 29130959.85 \n", "61 22227865.43 \n", "62 34234735.68 \n", "\n", "[42 rows x 203 columns]" ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_tinysoft[df_tinysoft['appear_in_period'] == df_tinysoft['period']]" ] }, { "cell_type": "code", "execution_count": 10, "id": "1419e2c2-0c94-4c8b-ad64-bcc38d5c5051", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
symbolStockNameperiodappear_indate子公司所持股份非流动负债调整项目投资性房地产其他流动资产内部往来款...应收保费待处理固定资产净损失衍生金融资产流动资产合计其他债权投资长期待摊费用预付长期投资款固定资产合计存货净额存货
0NE430198微创光电2012123120121231201304150.00.00.00.00.0...0.00.00.074133645.210.00.00.0802953.352910629.542910629.54
1NE430198微创光电2012123120131231201403310.00.00.00.00.0...0.00.00.074133645.210.00.00.0802953.352910629.542910629.54
2NE430198微创光电2012123120131231201404170.00.00.00.00.0...0.00.00.074133645.210.00.00.0802953.352910629.542910629.54
3NE430198微创光电2013063020130630201308200.00.00.00.00.0...0.00.00.063623420.340.00.00.01181024.191763780.301763780.30
4NE430198微创光电2013123120131231201403310.00.00.00.00.0...0.00.00.066471426.490.00.00.023953808.251677872.891677872.89
\n", "

5 rows × 203 columns

\n", "
" ], "text/plain": [ " symbol StockName period appear_in date 子公司所持股份 非流动负债调整项目 \\\n", "0 NE430198 微创光电 20121231 20121231 20130415 0.0 0.0 \n", "1 NE430198 微创光电 20121231 20131231 20140331 0.0 0.0 \n", "2 NE430198 微创光电 20121231 20131231 20140417 0.0 0.0 \n", "3 NE430198 微创光电 20130630 20130630 20130820 0.0 0.0 \n", "4 NE430198 微创光电 20131231 20131231 20140331 0.0 0.0 \n", "\n", " 投资性房地产 其他流动资产 内部往来款 ... 应收保费 待处理固定资产净损失 衍生金融资产 流动资产合计 其他债权投资 \\\n", "0 0.0 0.0 0.0 ... 0.0 0.0 0.0 74133645.21 0.0 \n", "1 0.0 0.0 0.0 ... 0.0 0.0 0.0 74133645.21 0.0 \n", "2 0.0 0.0 0.0 ... 0.0 0.0 0.0 74133645.21 0.0 \n", "3 0.0 0.0 0.0 ... 0.0 0.0 0.0 63623420.34 0.0 \n", "4 0.0 0.0 0.0 ... 0.0 0.0 0.0 66471426.49 0.0 \n", "\n", " 长期待摊费用 预付长期投资款 固定资产合计 存货净额 存货 \n", "0 0.0 0.0 802953.35 2910629.54 2910629.54 \n", "1 0.0 0.0 802953.35 2910629.54 2910629.54 \n", "2 0.0 0.0 802953.35 2910629.54 2910629.54 \n", "3 0.0 0.0 1181024.19 1763780.30 1763780.30 \n", "4 0.0 0.0 23953808.25 1677872.89 1677872.89 \n", "\n", "[5 rows x 203 columns]" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_tinysoft.head()" ] }, { "cell_type": "code", "execution_count": 11, "id": "a6ff3047-bf26-4521-9808-d3f91a9450b0", "metadata": {}, "outputs": [], "source": [ "export_cols = list(set(df_tinysoft.columns.tolist()) - set(['symbol', 'appear_in', 'date', 'period', 'StockName', '会计准则', '备注']))\n", "index_cols = list(set(df_tinysoft.columns.tolist()).intersection(set(['symbol', 'symbol', 'date', 'period'])))" ] }, { "cell_type": "code", "execution_count": 12, "id": "82a7e20f-a8ff-4851-8973-5beb474939bd", "metadata": {}, "outputs": [], "source": [ "df_tinysoft.set_index(index_cols, inplace=True)" ] }, { "cell_type": "code", "execution_count": 13, "id": "9ed86b68-e084-4ed9-ba4c-a9581a67b218", "metadata": {}, "outputs": [], "source": [ "df_tinysoft.drop(['StockName', '会计准则', '备注'], axis=1, inplace=True)" ] }, { "cell_type": "code", "execution_count": 14, "id": "1649106d-fa3b-49c1-b558-ba2f9f7cfb2c", "metadata": {}, "outputs": [], "source": [ "import warnings\n", "#from pandas.core.common import SettingWithCopyWarning\n", "\n", "#warnings.simplefilter(action='ignore', category=SettingWithCopyWarning)\n", "\n", "df_list = []\n", "for col in df_tinysoft.columns.tolist():\n", " if col in ['symbol', 'appear_in', 'date', 'period', 'StockName', '会计准则', '备注']:\n", " continue\n", " df_tmp = df_tinysoft[[col]].copy(deep=True)\n", " df_tmp['field'] = col\n", " df_tmp.rename(columns={col:'value'}, inplace=True)\n", " df_list.append(df_tmp)" ] }, { "cell_type": "code", "execution_count": 15, "id": "3aee4d6f-3a4e-4574-b8dd-d36a8c428fcb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
valuefield
datesymbolperiod
20130415NE430198201212316.922074e+06资本公积
20140331NE430198201212316.922074e+06资本公积
20140417NE430198201212316.922074e+06资本公积
20130820NE430198201306307.750074e+06资本公积
20140331NE430198201312311.027942e+05资本公积
...............
20210426NE430198202103312.389650e+08资本公积
20210827NE430198202106301.837979e+08资本公积
20211028NE430198202109301.837979e+08资本公积
20220427NE430198202112311.837979e+08资本公积
202203311.837979e+08资本公积
\n", "

63 rows × 2 columns

\n", "
" ], "text/plain": [ " value field\n", "date symbol period \n", "20130415 NE430198 20121231 6.922074e+06 资本公积\n", "20140331 NE430198 20121231 6.922074e+06 资本公积\n", "20140417 NE430198 20121231 6.922074e+06 资本公积\n", "20130820 NE430198 20130630 7.750074e+06 资本公积\n", "20140331 NE430198 20131231 1.027942e+05 资本公积\n", "... ... ...\n", "20210426 NE430198 20210331 2.389650e+08 资本公积\n", "20210827 NE430198 20210630 1.837979e+08 资本公积\n", "20211028 NE430198 20210930 1.837979e+08 资本公积\n", "20220427 NE430198 20211231 1.837979e+08 资本公积\n", " 20220331 1.837979e+08 资本公积\n", "\n", "[63 rows x 2 columns]" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_list[100]" ] }, { "cell_type": "code", "execution_count": 16, "id": "dfe8757b-c610-4d04-a642-5888f66b46d6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
valuefield
datesymbolperiod
20130415NE430198201212310.00子公司所持股份
20140331NE430198201212310.00子公司所持股份
20140417NE430198201212310.00子公司所持股份
20130820NE430198201306300.00子公司所持股份
20140331NE430198201312310.00子公司所持股份
...............
20210426NE4301982021033129249304.68存货
20210827NE4301982021063031631292.12存货
20211028NE4301982021093029130959.85存货
20220427NE4301982021123122227865.43存货
2022033134234735.68存货
\n", "

12348 rows × 2 columns

\n", "
" ], "text/plain": [ " value field\n", "date symbol period \n", "20130415 NE430198 20121231 0.00 子公司所持股份\n", "20140331 NE430198 20121231 0.00 子公司所持股份\n", "20140417 NE430198 20121231 0.00 子公司所持股份\n", "20130820 NE430198 20130630 0.00 子公司所持股份\n", "20140331 NE430198 20131231 0.00 子公司所持股份\n", "... ... ...\n", "20210426 NE430198 20210331 29249304.68 存货\n", "20210827 NE430198 20210630 31631292.12 存货\n", "20211028 NE430198 20210930 29130959.85 存货\n", "20220427 NE430198 20211231 22227865.43 存货\n", " 20220331 34234735.68 存货\n", "\n", "[12348 rows x 2 columns]" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.concat(df_list, axis=0)" ] }, { "cell_type": "code", "execution_count": 1, "id": "598b2430-5668-4c64-a0f0-a8bf76955258", "metadata": {}, "outputs": [], "source": [ "import os" ] }, { "cell_type": "code", "execution_count": 5, "id": "9e25db7e-ea9f-433a-b62d-0c33fc3f6a87", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['.ipynb_checkpoints',\n", " 'qlib-data',\n", " 'tinysoft-data',\n", " '__pycache__',\n", " 'src',\n", " 'wind-data']" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "[ name for name in os.listdir() if os.path.isdir(name) and ]" ] }, { "cell_type": "code", "execution_count": 8, "id": "444b1ff2-5293-406d-ab8b-7734057ab1ee", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "df_config = pd.read_excel('./tinysoft-data/基础报表/天软中英文字段对照表.xlsx', '合并资产负债表')" ] }, { "cell_type": "code", "execution_count": 11, "id": "6f3fcea6-c189-42d0-ac1c-5265dcd10bca", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "['子公司所持股份',\n", " '非流动负债调整项目',\n", " '投资性房地产',\n", " '其他流动资产',\n", " '内部往来款',\n", " '公益性生物资产',\n", " '其他权益工具投资',\n", " '存出保证金',\n", " '在建工程',\n", " '负债特殊项目',\n", " '待摊费用',\n", " '一年内到期的应收融资租赁款',\n", " '股权分置流通权',\n", " '股东权益合计',\n", " '被套期项目',\n", " '代理承销证券款',\n", " '向中央银行借款',\n", " '长期借款',\n", " '待转资产价值',\n", " '流动资产特殊项目',\n", " '无形资产及其它资产合计',\n", " '固定资产净额',\n", " '无形资产',\n", " '经营租入固定资产改良',\n", " '预付帐款',\n", " '长期债权投资',\n", " '股本',\n", " '流动资产调整项目',\n", " '非流动资产特殊项目',\n", " '拆出资金',\n", " '应付债券-其中：永续债',\n", " '应付票据及应付账款',\n", " '流动负债递延收益',\n", " '长期激励基金',\n", " '应付关联公司款',\n", " '所有者权益调整项目',\n", " '其他长期负债',\n", " '其他储备(公允价值变动储备)',\n", " '代理买卖证券款',\n", " '其他应付款',\n", " '应付工资',\n", " '衍生金融负债',\n", " '长期投资减值准备',\n", " '应收票据',\n", " '应收关联公司款',\n", " '应收款项融资',\n", " '所有者权益特殊项目',\n", " '股权投资差额',\n", " '交易性金融资产',\n", " '固定资产原值',\n", " '应收款项净额',\n", " '负债与股东权益总计',\n", " '资产调整项目',\n", " '累计折旧',\n", " '负债和权益调整项目',\n", " '其他权益工具-其中：优先股',\n", " '其他权益工具-其中：永续债',\n", " '结算备付金',\n", " '货币资金',\n", " '负债和权益特殊项目',\n", " '待转商品差价',\n", " '一般风险准备',\n", " '影响所有者权益的其他科目',\n", " '买入返售金融资产',\n", " '坏帐准备',\n", " '应付保证金',\n", " '油气资产',\n", " '归属母公司股东权益合计',\n", " '资产特殊项目',\n", " '一年内到期的非流动资产',\n", " '在建工程减值准备',\n", " '拟分配现金股利',\n", " '其他应收款',\n", " '累计未弥补子公司亏损',\n", " '应收票据及应收账款',\n", " '外币报表折算差额',\n", " '持有待售资产',\n", " '生产性生物资产',\n", " '合同资产',\n", " '未确认的投资损失',\n", " '其中：公益金',\n", " '盈余公积',\n", " '应交税金',\n", " '专项储备',\n", " '交易性金融负债',\n", " '流动负债调整项目',\n", " '其他综合收益',\n", " '非流动负债特殊项目',\n", " '套期工具',\n", " '减：库存股',\n", " '债权投资',\n", " '其他非流动资产',\n", " '应收帐款保理',\n", " '存货跌价准备',\n", " '发放贷款及垫款',\n", " '卖出回购金融资产款',\n", " '预计负债',\n", " '长期投资净额',\n", " '应付手续费及佣金',\n", " '负债合计',\n", " '资本公积',\n", " '其他权益工具',\n", " '资产总计',\n", " '交易性金融资产净额',\n", " '无形资产减值准备',\n", " '已归还投资',\n", " '少数股东权益',\n", " '应付债券-其中：优先股',\n", " '其他流动负债',\n", " '开办费',\n", " '委托贷款',\n", " '负债调整项目',\n", " '一年以上应付职工薪酬',\n", " '持有至到期投资',\n", " '非流动资产调整项目',\n", " '代理业务负债',\n", " '其他负债递延收益',\n", " '长期负债合计',\n", " '长期负债递延收益',\n", " '其他长期投资',\n", " '应收利息',\n", " '其他非流动金融资产',\n", " '工程物资',\n", " '应付福利费',\n", " '应付股利',\n", " '长期应付控股公司款',\n", " '其他应交款',\n", " '应收分保帐款',\n", " '住房周转金',\n", " '一年内到期的可转换债券',\n", " '专项应付款',\n", " '长期应付款',\n", " '国内票证结算',\n", " '租赁负债',\n", " '递延税款贷项',\n", " '应付债券',\n", " '其中:消耗性生物资产',\n", " '流动负债合计',\n", " '流动负债特殊项目',\n", " '一年内到期的预计负债',\n", " '风险准备金',\n", " '短期借款',\n", " '保险合同准备金',\n", " '应付分保帐款',\n", " '应收帐款',\n", " '应付短期债券',\n", " '长期投资合计',\n", " '应收补贴款',\n", " '应收分保合同准备金',\n", " '拆入资金',\n", " '吸收存款及同业存放',\n", " '交易性金融资产跌价准备',\n", " '固定资产净值',\n", " '期货保证金',\n", " '合并价差',\n", " '其中:质押借款',\n", " '应付控股公司款',\n", " '持有待售负债',\n", " '一年内到期的长期负债',\n", " '应收出口退税',\n", " '开发支出',\n", " '固定资产清理',\n", " '合同负债',\n", " '代销商品款',\n", " '其他长期资产',\n", " '已结算尚未完工款',\n", " '应付帐款',\n", " '预提费用',\n", " '预收帐款',\n", " '应付利息',\n", " '固定资产减值准备',\n", " '应付票据',\n", " '国际票证结算',\n", " '应收股利',\n", " '股本净额',\n", " '待处理流动资产净损失',\n", " '商誉',\n", " '非流动资产合计',\n", " '使用权资产',\n", " '已完工尚未结算款',\n", " '未分配利润',\n", " '长期股权投资',\n", " '可供出售金融资产',\n", " '递延税款借项',\n", " '长期应收帐款',\n", " '应收融资租赁款',\n", " '应收保费',\n", " '待处理固定资产净损失',\n", " '衍生金融资产',\n", " '流动资产合计',\n", " '其他债权投资',\n", " '长期待摊费用',\n", " '预付长期投资款',\n", " '固定资产合计',\n", " '存货净额',\n", " '存货']" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_config[df_config['数据类型'] == 'FLOAT']['天软字段'].tolist()" ] }, { "cell_type": "code", "execution_count": null, "id": "e33b814d-1a7e-4ea6-90f0-de899c430a1e", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.13" } }, "nbformat": 4, "nbformat_minor": 5 }