guofu
/
TslDataFeed
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
TslDataFeed/wind-api.ipynb

3056 lines
108 KiB
Raw Permalink Normal View History Unescape

init
2 years ago
{
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>symbol</th>\n",
" <th>StockName</th>\n",
" <th>period</th>\n",
" <th>转增比</th>\n",
" <th>股东大会日</th>\n",
" <th>送股比</th>\n",
" <th>决案公布日</th>\n",
" <th>红利比</th>\n",
" <th>date</th>\n",
" <th>实得比</th>\n",
" <th>实施公布日</th>\n",
" <th>分红送股基数</th>\n",
" <th>红股比</th>\n",
" <th>除权除息日</th>\n",
" <th>备注</th>\n",
" <th>预案预披露公布日</th>\n",
" <th>送股上市日</th>\n",
" <th>分红发放日</th>\n",
" <th>股权登记日</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20121231</td>\n",
" <td>0.50</td>\n",
" <td>20130510</td>\n",
" <td>0.50</td>\n",
" <td>20130514</td>\n",
" <td>0.00</td>\n",
" <td>20130422</td>\n",
" <td>0.0</td>\n",
" <td>20130531</td>\n",
" <td>16385477.0</td>\n",
" <td>0.0</td>\n",
" <td>20130603</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>20130604</td>\n",
" <td>0</td>\n",
" <td>20130603</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20131231</td>\n",
" <td>0.33</td>\n",
" <td>20140513</td>\n",
" <td>0.33</td>\n",
" <td>20140514</td>\n",
" <td>0.00</td>\n",
" <td>20140423</td>\n",
" <td>0.0</td>\n",
" <td>20140606</td>\n",
" <td>30450000.0</td>\n",
" <td>0.0</td>\n",
" <td>20140613</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>20140613</td>\n",
" <td>0</td>\n",
" <td>20140612</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20150630</td>\n",
" <td>0.51</td>\n",
" <td>20150814</td>\n",
" <td>0.51</td>\n",
" <td>20150815</td>\n",
" <td>0.00</td>\n",
" <td>20150730</td>\n",
" <td>0.0</td>\n",
" <td>20150820</td>\n",
" <td>52991500.0</td>\n",
" <td>0.0</td>\n",
" <td>20150827</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>20150827</td>\n",
" <td>0</td>\n",
" <td>20150826</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20190630</td>\n",
" <td>0.00</td>\n",
" <td>20190905</td>\n",
" <td>0.50</td>\n",
" <td>20190906</td>\n",
" <td>0.00</td>\n",
" <td>20190816</td>\n",
" <td>0.0</td>\n",
" <td>20190911</td>\n",
" <td>85555665.0</td>\n",
" <td>0.5</td>\n",
" <td>20190919</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>20190919</td>\n",
" <td>0</td>\n",
" <td>20190918</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20211231</td>\n",
" <td>0.00</td>\n",
" <td>0</td>\n",
" <td>0.30</td>\n",
" <td>0</td>\n",
" <td>0.05</td>\n",
" <td>20220419</td>\n",
" <td>0.0</td>\n",
" <td>0</td>\n",
" <td>0.0</td>\n",
" <td>0.3</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>StockID</th>\n",
" <th>StockName</th>\n",
" <th>截止日</th>\n",
" <th>公布日</th>\n",
" <th>每股收益(扣除,摊薄)</th>\n",
" <th>每股净资产(调整)</th>\n",
" <th>净资产收益率(扣除,加权)(%)</th>\n",
" <th>每股资本公积金</th>\n",
" <th>净资产收益率(加权)(%)</th>\n",
" <th>净资产收益率(调整)(%)</th>\n",
" <th>...</th>\n",
" <th>每股经营活动现金流量净额</th>\n",
" <th>扣除非经常性损益后的净利润</th>\n",
" <th>每股净资产</th>\n",
" <th>每股未分配利润</th>\n",
" <th>净资产收益率(扣除,摊薄)(%)</th>\n",
" <th>每股收益(摊薄)</th>\n",
" <th>每股收益(扣除,加权)</th>\n",
" <th>备注</th>\n",
" <th>每股现金净流量</th>\n",
" <th>每股收益(加权)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20121231</td>\n",
" <td>20130422</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>-0.73</td>\n",
" <td>941834.50</td>\n",
" <td>1.94</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.070</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20130630</td>\n",
" <td>20130823</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.93</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>1.96</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.020</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20131231</td>\n",
" <td>20140423</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>7.11</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.13</td>\n",
" <td>2879509.04</td>\n",
" <td>1.65</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.120</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20140630</td>\n",
" <td>20140822</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>-0.01</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>1.23</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>-0.010</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20141231</td>\n",
" <td>20150424</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.94</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.00</td>\n",
" <td>1384507.46</td>\n",
" <td>1.30</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.063</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 21 columns</p>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>symbol</th>\n",
" <th>StockName</th>\n",
" <th>period</th>\n",
" <th>date</th>\n",
" <th>每股收益(扣除,摊薄)</th>\n",
" <th>每股净资产(调整)</th>\n",
" <th>净资产收益率(扣除,加权)(%)</th>\n",
" <th>每股资本公积金</th>\n",
" <th>净资产收益率(加权)(%)</th>\n",
" <th>净资产收益率(调整)(%)</th>\n",
" <th>...</th>\n",
" <th>每股经营活动现金流量净额</th>\n",
" <th>扣除非经常性损益后的净利润</th>\n",
" <th>每股净资产</th>\n",
" <th>每股未分配利润</th>\n",
" <th>净资产收益率(扣除,摊薄)(%)</th>\n",
" <th>每股收益(摊薄)</th>\n",
" <th>每股收益(扣除,加权)</th>\n",
" <th>备注</th>\n",
" <th>每股现金净流量</th>\n",
" <th>每股收益(加权)</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20121231</td>\n",
" <td>20130422</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>-0.73</td>\n",
" <td>941834.50</td>\n",
" <td>1.94</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.070</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20130630</td>\n",
" <td>20130823</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.93</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>1.96</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.020</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20131231</td>\n",
" <td>20140423</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>7.11</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.13</td>\n",
" <td>2879509.04</td>\n",
" <td>1.65</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.120</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20140630</td>\n",
" <td>20140822</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>-0.01</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" <td>1.23</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>-0.010</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NE430090</td>\n",
" <td>同辉信息</td>\n",
" <td>20141231</td>\n",
" <td>20150424</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.94</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.00</td>\n",
" <td>1384507.46</td>\n",
" <td>1.30</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.063</td>\n",
" <td>0.0</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 21 columns</p>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>StockID</th>\n",
" <th>StockName</th>\n",
" <th>截止日</th>\n",
" <th>数据报告期</th>\n",
" <th>公布日</th>\n",
" <th>子公司所持股份</th>\n",
" <th>非流动负债调整项目</th>\n",
" <th>投资性房地产</th>\n",
" <th>其他流动资产</th>\n",
" <th>内部往来款</th>\n",
" <th>...</th>\n",
" <th>应收保费</th>\n",
" <th>待处理固定资产净损失</th>\n",
" <th>衍生金融资产</th>\n",
" <th>流动资产合计</th>\n",
" <th>其他债权投资</th>\n",
" <th>长期待摊费用</th>\n",
" <th>预付长期投资款</th>\n",
" <th>固定资产合计</th>\n",
" <th>存货净额</th>\n",
" <th>存货</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20121231</td>\n",
" <td>20130415</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>74133645.21</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20131231</td>\n",
" <td>20140331</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>74133645.21</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20131231</td>\n",
" <td>20140417</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>74133645.21</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20130630</td>\n",
" <td>20130630</td>\n",
" <td>20130820</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>63623420.34</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1181024.19</td>\n",
" <td>1763780.30</td>\n",
" <td>1763780.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20131231</td>\n",
" <td>20131231</td>\n",
" <td>20140331</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>66471426.49</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23953808.25</td>\n",
" <td>1677872.89</td>\n",
" <td>1677872.89</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 203 columns</p>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>symbol</th>\n",
" <th>StockName</th>\n",
" <th>period</th>\n",
" <th>appear_in_period</th>\n",
" <th>date</th>\n",
" <th>子公司所持股份</th>\n",
" <th>非流动负债调整项目</th>\n",
" <th>投资性房地产</th>\n",
" <th>其他流动资产</th>\n",
" <th>内部往来款</th>\n",
" <th>...</th>\n",
" <th>应收保费</th>\n",
" <th>待处理固定资产净损失</th>\n",
" <th>衍生金融资产</th>\n",
" <th>流动资产合计</th>\n",
" <th>其他债权投资</th>\n",
" <th>长期待摊费用</th>\n",
" <th>预付长期投资款</th>\n",
" <th>固定资产合计</th>\n",
" <th>存货净额</th>\n",
" <th>存货</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20121231</td>\n",
" <td>20130415</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>7.413365e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20130630</td>\n",
" <td>20130630</td>\n",
" <td>20130820</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6.362342e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1181024.19</td>\n",
" <td>1763780.30</td>\n",
" <td>1763780.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20131231</td>\n",
" <td>20131231</td>\n",
" <td>20140331</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6.647143e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23953808.25</td>\n",
" <td>1677872.89</td>\n",
" <td>1677872.89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20131231</td>\n",
" <td>20131231</td>\n",
" <td>20140417</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6.647143e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23953808.25</td>\n",
" <td>1677872.89</td>\n",
" <td>1677872.89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20140630</td>\n",
" <td>20140630</td>\n",
" <td>20140818</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5.443811e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25473333.41</td>\n",
" <td>1592398.42</td>\n",
" <td>1592398.42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20141231</td>\n",
" <td>20141231</td>\n",
" <td>20150323</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>8.875022e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25371751.36</td>\n",
" <td>3160743.11</td>\n",
" <td>3160743.11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20141231</td>\n",
" <td>20141231</td>\n",
" <td>20170420</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>8.875022e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25371751.36</td>\n",
" <td>3160743.11</td>\n",
" <td>3160743.11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20141231</td>\n",
" <td>20141231</td>\n",
" <td>20170606</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>8.875022e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25371751.36</td>\n",
" <td>3160743.11</td>\n",
" <td>3160743.11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20141231</td>\n",
" <td>20141231</td>\n",
" <td>20171222</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>8.875022e+07</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25371751.36</td>\n",
" <td>3160743.11</td>\n",
" <td>3160743.11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20150630</td>\n",
" <td>20150630</td>\n",
" <td>20150731</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.069109e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>24549495.90</td>\n",
" <td>3880048.99</td>\n",
" <td>3880048.99</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20151231</td>\n",
" <td>20151231</td>\n",
" <td>20160325</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>41983460.25</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.498791e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23647498.40</td>\n",
" <td>5531527.03</td>\n",
" <td>5531527.03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20151231</td>\n",
" <td>20151231</td>\n",
" <td>20170420</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>41983460.25</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.498791e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23647498.40</td>\n",
" <td>5531527.03</td>\n",
" <td>5531527.03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20151231</td>\n",
" <td>20151231</td>\n",
" <td>20170606</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>41983460.25</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.498791e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23647498.40</td>\n",
" <td>5531527.03</td>\n",
" <td>5531527.03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20151231</td>\n",
" <td>20151231</td>\n",
" <td>20171221</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>41983460.25</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.498356e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23647498.40</td>\n",
" <td>5531527.03</td>\n",
" <td>5531527.03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20160630</td>\n",
" <td>20160630</td>\n",
" <td>20160815</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.190637e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23089092.88</td>\n",
" <td>4681295.44</td>\n",
" <td>4681295.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20161231</td>\n",
" <td>20161231</td>\n",
" <td>20170420</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.258819e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>22760528.22</td>\n",
" <td>17324158.05</td>\n",
" <td>17324158.05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20161231</td>\n",
" <td>20161231</td>\n",
" <td>20170606</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.258819e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>22760528.22</td>\n",
" <td>17324158.05</td>\n",
" <td>17324158.05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20161231</td>\n",
" <td>20161231</td>\n",
" <td>20171222</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>30000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.258819e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>22760528.22</td>\n",
" <td>17324158.05</td>\n",
" <td>17324158.05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20170630</td>\n",
" <td>20170630</td>\n",
" <td>20170830</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10000000.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.876171e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>22022804.80</td>\n",
" <td>16361478.08</td>\n",
" <td>16361478.08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20171231</td>\n",
" <td>20171231</td>\n",
" <td>20180123</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.194605e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>21200280.76</td>\n",
" <td>15912996.60</td>\n",
" <td>15912996.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20171231</td>\n",
" <td>20171231</td>\n",
" <td>20200414</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.194605e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>21200280.76</td>\n",
" <td>15912996.60</td>\n",
" <td>15912996.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20171231</td>\n",
" <td>20171231</td>\n",
" <td>20200703</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.194605e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>21200280.76</td>\n",
" <td>15912996.60</td>\n",
" <td>15912996.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20180331</td>\n",
" <td>20180331</td>\n",
" <td>20180426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.695150e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>21452500.99</td>\n",
" <td>19653445.16</td>\n",
" <td>19653445.16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20180630</td>\n",
" <td>20180630</td>\n",
" <td>20180830</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.841927e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>20700551.44</td>\n",
" <td>17801363.26</td>\n",
" <td>17801363.26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20180930</td>\n",
" <td>20180930</td>\n",
" <td>20181031</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.820165e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>20263093.35</td>\n",
" <td>23861785.86</td>\n",
" <td>23861785.86</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20181231</td>\n",
" <td>20181231</td>\n",
" <td>20190426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.394558e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19854105.70</td>\n",
" <td>17691042.34</td>\n",
" <td>17691042.34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20181231</td>\n",
" <td>20181231</td>\n",
" <td>20200414</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.394558e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19854105.70</td>\n",
" <td>17691042.34</td>\n",
" <td>17691042.34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20181231</td>\n",
" <td>20181231</td>\n",
" <td>20200703</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.394558e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19854105.70</td>\n",
" <td>17691042.34</td>\n",
" <td>17691042.34</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20190331</td>\n",
" <td>20190331</td>\n",
" <td>20190426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.248673e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19700587.28</td>\n",
" <td>18289862.75</td>\n",
" <td>18289862.75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20190630</td>\n",
" <td>20190630</td>\n",
" <td>20190829</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.060442e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19751742.60</td>\n",
" <td>34408679.51</td>\n",
" <td>34408679.51</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20190930</td>\n",
" <td>20190930</td>\n",
" <td>20191030</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.196574e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19463063.00</td>\n",
" <td>41886590.35</td>\n",
" <td>41886590.35</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20191231</td>\n",
" <td>20191231</td>\n",
" <td>20200414</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.887782e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23744200.79</td>\n",
" <td>29128387.44</td>\n",
" <td>29128387.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20191231</td>\n",
" <td>20191231</td>\n",
" <td>20200528</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.887782e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23744200.79</td>\n",
" <td>29128387.44</td>\n",
" <td>29128387.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20191231</td>\n",
" <td>20191231</td>\n",
" <td>20200703</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.887782e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23744200.79</td>\n",
" <td>29128387.44</td>\n",
" <td>29128387.44</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20200630</td>\n",
" <td>20200630</td>\n",
" <td>20200824</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.638447e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>34974714.34</td>\n",
" <td>39213777.43</td>\n",
" <td>39213777.43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20200930</td>\n",
" <td>20200930</td>\n",
" <td>20201022</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.592226e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>53333163.63</td>\n",
" <td>36698873.36</td>\n",
" <td>36698873.36</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20201231</td>\n",
" <td>20201231</td>\n",
" <td>20210426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.897301e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>67110892.24</td>\n",
" <td>17742938.50</td>\n",
" <td>17742938.50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20210331</td>\n",
" <td>20210331</td>\n",
" <td>20210426</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.187303e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>76872333.89</td>\n",
" <td>29249304.68</td>\n",
" <td>29249304.68</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20210630</td>\n",
" <td>20210630</td>\n",
" <td>20210827</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3.975848e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>79390134.95</td>\n",
" <td>31631292.12</td>\n",
" <td>31631292.12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20210930</td>\n",
" <td>20210930</td>\n",
" <td>20211028</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.404329e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>83281434.76</td>\n",
" <td>29130959.85</td>\n",
" <td>29130959.85</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20211231</td>\n",
" <td>20211231</td>\n",
" <td>20220427</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.841222e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>93160821.45</td>\n",
" <td>22227865.43</td>\n",
" <td>22227865.43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20220331</td>\n",
" <td>20220331</td>\n",
" <td>20220427</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.00</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.705716e+08</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>96153919.04</td>\n",
" <td>34234735.68</td>\n",
" <td>34234735.68</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>42 rows × 203 columns</p>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>symbol</th>\n",
" <th>StockName</th>\n",
" <th>period</th>\n",
" <th>appear_in</th>\n",
" <th>date</th>\n",
" <th>子公司所持股份</th>\n",
" <th>非流动负债调整项目</th>\n",
" <th>投资性房地产</th>\n",
" <th>其他流动资产</th>\n",
" <th>内部往来款</th>\n",
" <th>...</th>\n",
" <th>应收保费</th>\n",
" <th>待处理固定资产净损失</th>\n",
" <th>衍生金融资产</th>\n",
" <th>流动资产合计</th>\n",
" <th>其他债权投资</th>\n",
" <th>长期待摊费用</th>\n",
" <th>预付长期投资款</th>\n",
" <th>固定资产合计</th>\n",
" <th>存货净额</th>\n",
" <th>存货</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20121231</td>\n",
" <td>20130415</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>74133645.21</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20131231</td>\n",
" <td>20140331</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>74133645.21</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20121231</td>\n",
" <td>20131231</td>\n",
" <td>20140417</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>74133645.21</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>802953.35</td>\n",
" <td>2910629.54</td>\n",
" <td>2910629.54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20130630</td>\n",
" <td>20130630</td>\n",
" <td>20130820</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>63623420.34</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1181024.19</td>\n",
" <td>1763780.30</td>\n",
" <td>1763780.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>NE430198</td>\n",
" <td>微创光电</td>\n",
" <td>20131231</td>\n",
" <td>20131231</td>\n",
" <td>20140331</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>66471426.49</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>23953808.25</td>\n",
" <td>1677872.89</td>\n",
" <td>1677872.89</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 203 columns</p>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>value</th>\n",
" <th>field</th>\n",
" </tr>\n",
" <tr>\n",
" <th>date</th>\n",
" <th>symbol</th>\n",
" <th>period</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>20130415</th>\n",
" <th>NE430198</th>\n",
" <th>20121231</th>\n",
" <td>6.922074e+06</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20140331</th>\n",
" <th>NE430198</th>\n",
" <th>20121231</th>\n",
" <td>6.922074e+06</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20140417</th>\n",
" <th>NE430198</th>\n",
" <th>20121231</th>\n",
" <td>6.922074e+06</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20130820</th>\n",
" <th>NE430198</th>\n",
" <th>20130630</th>\n",
" <td>7.750074e+06</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20140331</th>\n",
" <th>NE430198</th>\n",
" <th>20131231</th>\n",
" <td>1.027942e+05</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <th>...</th>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20210426</th>\n",
" <th>NE430198</th>\n",
" <th>20210331</th>\n",
" <td>2.389650e+08</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20210827</th>\n",
" <th>NE430198</th>\n",
" <th>20210630</th>\n",
" <td>1.837979e+08</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20211028</th>\n",
" <th>NE430198</th>\n",
" <th>20210930</th>\n",
" <td>1.837979e+08</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">20220427</th>\n",
" <th rowspan=\"2\" valign=\"top\">NE430198</th>\n",
" <th>20211231</th>\n",
" <td>1.837979e+08</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20220331</th>\n",
" <td>1.837979e+08</td>\n",
" <td>资本公积</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>63 rows × 2 columns</p>\n",
"</div>"
],
"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": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th>value</th>\n",
" <th>field</th>\n",
" </tr>\n",
" <tr>\n",
" <th>date</th>\n",
" <th>symbol</th>\n",
" <th>period</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>20130415</th>\n",
" <th>NE430198</th>\n",
" <th>20121231</th>\n",
" <td>0.00</td>\n",
" <td>子公司所持股份</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20140331</th>\n",
" <th>NE430198</th>\n",
" <th>20121231</th>\n",
" <td>0.00</td>\n",
" <td>子公司所持股份</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20140417</th>\n",
" <th>NE430198</th>\n",
" <th>20121231</th>\n",
" <td>0.00</td>\n",
" <td>子公司所持股份</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20130820</th>\n",
" <th>NE430198</th>\n",
" <th>20130630</th>\n",
" <td>0.00</td>\n",
" <td>子公司所持股份</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20140331</th>\n",
" <th>NE430198</th>\n",
" <th>20131231</th>\n",
" <td>0.00</td>\n",
" <td>子公司所持股份</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <th>...</th>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20210426</th>\n",
" <th>NE430198</th>\n",
" <th>20210331</th>\n",
" <td>29249304.68</td>\n",
" <td>存货</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20210827</th>\n",
" <th>NE430198</th>\n",
" <th>20210630</th>\n",
" <td>31631292.12</td>\n",
" <td>存货</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20211028</th>\n",
" <th>NE430198</th>\n",
" <th>20210930</th>\n",
" <td>29130959.85</td>\n",
" <td>存货</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">20220427</th>\n",
" <th rowspan=\"2\" valign=\"top\">NE430198</th>\n",
" <th>20211231</th>\n",
" <td>22227865.43</td>\n",
" <td>存货</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20220331</th>\n",
" <td>34234735.68</td>\n",
" <td>存货</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>12348 rows × 2 columns</p>\n",
"</div>"
],
"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
}