csv
import pandas as pd
读取
df1 = pd.read_csv(
r'shares\中原证券(601375)\lrb_601375.csv',
encoding='gbk'
)
df1.head()
报告日期 | 营业总收入(万元) | 营业收入(万元) | 利息收入(万元) | 已赚保费(万元) | 手续费及佣金收入(万元) | 房地产销售收入(万元) | 其他业务收入(万元) | 营业总成本(万元) | 营业成本(万元) | ... | 非流动资产处置损失(万元) | 利润总额(万元) | 所得税费用(万元) | 未确认投资损失(万元) | 净利润(万元) | 归属于母公司所有者的净利润(万元) | 被合并方在合并前实现净利润(万元) | 少数股东损益(万元) | 基本每股收益 | 稀释每股收益 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2021-03-31 | 107619.0 | -- | 27000.0 | -- | -- | -- | 44651.0 | 92131.0 | -- | ... | -- | 15646.0 | 2999.0 | -- | 12647.0 | 12096.0 | -- | 551.0 | 0.03 | 0.03 |
1 | 2020-12-31 | 310330.0 | -- | 95987.0 | -- | -- | -- | 126450.0 | 295449.0 | -- | ... | -- | 14403.0 | 4191.0 | -- | 10212.0 | 10430.0 | -- | -218.0 | 0.02 | 0.02 |
2 | 2020-09-30 | 220842.0 | -- | 70293.0 | -- | -- | -- | 84798.0 | 205689.0 | -- | ... | -- | 14760.0 | 4997.0 | -- | 9763.0 | 8675.0 | -- | 1088.0 | 0.02 | 0.02 |
3 | 2020-06-30 | 124998.0 | -- | 43928.0 | -- | -- | -- | 41443.0 | 118559.0 | -- | ... | -- | 5842.0 | 2474.0 | -- | 3368.0 | 3085.0 | -- | 283.0 | 0.01 | 0.01 |
4 | 2020-03-31 | 43667.0 | -- | 21818.0 | -- | -- | -- | 9225.0 | 50074.0 | -- | ... | -- | -6803.0 | -849.0 | -- | -5954.0 | -6712.0 | -- | 759.0 | -0.02 | -0.02 |
5 rows × 46 columns
写入
df1.to_csv(
r'shares\中原证券(601375)\lrb_601375.csv',
encoding='gbk',
index=False # 不要输出索引列
)
excel
读取数据
df2 = pd.read_excel(
r'shares1\历史20年沪深a股总市值.xlsx',
sheet_name='Sheet1', # 指定工作表名称
header=0 # 指定第几行做表头,0为第一行
)
df2
报告日期 | 000001.SZ | 000002.SZ | 000004.SZ | 000005.SZ | 000006.SZ | 000007.SZ | 000008.SZ | 000009.SZ | 000010.SZ | ... | 688687.SH | 688689.SH | 688696.SH | 688698.SH | 688699.SH | 688777.SH | 688788.SH | 688819.SH | 688981.SH | 689009.SH | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaT | 平安银行 | 万科A | 国华网安 | ST星源 | 深振业A | *ST全新 | 神州高铁 | 中国宝安 | 美丽生态 | ... | 凯因科技 | 银河微电 | 极米科技 | 伟创电气 | 明微电子 | 中控技术 | 科思科技 | 天能股份 | 中芯国际 | 九号公司 |
1 | NaT | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | ... | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 | 总市值 |
2 | 2011-06-30 | 5.94892e+10 | 9.29095e+10 | 1.03039e+09 | 3.52933e+09 | 5.74613e+09 | 1.84079e+09 | 9.11827e+08 | 1.87827e+10 | 2.15087e+09 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
3 | 2011-07-29 | 6.04301e+10 | 8.9611e+10 | 1.13117e+09 | 3.52933e+09 | 5.71646e+09 | 1.89854e+09 | 9.3024e+08 | 2.09206e+10 | 2.15087e+09 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
4 | 2011-08-31 | 8.63285e+10 | 8.9611e+10 | 1.01444e+09 | 3.52933e+09 | 5390090112 | 1.88699e+09 | 8.94886e+08 | 2.0637e+10 | 2.15087e+09 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
118 | 2021-02-26 | 4.14899e+11 | 3.84547e+11 | 3.11124e+09 | 2.26527e+09 | 6.96597e+09 | 1.40658e+09 | 6.53487e+09 | 2.49668e+10 | 2.94328e+09 | ... | 5.12882e+09 | 3251088000 | NaN | 2734200000 | 4357964800 | 41409180040 | 9.35718e+09 | 42344676000 | 4.35563e+11 | 49356826067 |
119 | 2021-03-31 | 4.27124e+11 | 348531966030 | 2.82075e+09 | 2.56166e+09 | 7.26297e+09 | 1.34075e+09 | 6.36802e+09 | 2.23876e+10 | 3.3614e+09 | ... | 4.29836e+09 | 3089304000 | 23145500000 | 3090600000 | 5800704000 | 37955532880 | 7477888968 | 45406791000 | 4.29084e+11 | 4.68643e+10 |
120 | 2021-04-30 | 4.51964e+11 | 3.27272e+11 | 2.62929e+09 | 2.34995e+09 | 7.27647e+09 | 1.29572e+09 | 6.22898e+09 | 2.71333e+10 | 3.44339e+09 | ... | 5.92362e+09 | 3370500000 | 34900000000 | 3144600000 | 9871608320 | 42886491200 | 7591190316 | 40925410000 | 4.31973e+11 | 52384420248 |
121 | 2021-05-31 | 4.69623e+11 | 3.10193e+11 | 2647444105 | 1.85244e+09 | 7.10097e+09 | 1.28186e+09 | 6.2846e+09 | 2.63854e+10 | 3.32041e+09 | ... | 6.24969e+09 | 3688932000 | 36638500000 | 3164400000 | 14622236160 | 46404369280 | 1.07689e+10 | 41479507000 | 4.44566e+11 | 51609919411 |
122 | 2021-06-09 | 4.78356e+11 | 3.01015e+11 | 3.27134e+09 | 2.06415e+09 | 7.04697e+09 | 1.268e+09 | 6.2846e+09 | 3.31171e+10 | 3.25482e+09 | ... | 5.51263e+09 | 3857136000 | 37374000000 | 3153600000 | 13044147200 | 44808477960 | 1.01563e+10 | 41421181000 | 444328520780 | 57172243604 |
123 rows × 4340 columns
写入数据
df2.to_excel(
r'123.xlsx',
index=False # 不要输出索引列
)