-
Notifications
You must be signed in to change notification settings - Fork 0
/
THS_ALL.py
36 lines (29 loc) · 1.15 KB
/
THS_ALL.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
import os
import glob
bigdata = open(r"E:\\上市公司数据\\年份—利润表数据.txt", "w+")
all_name = glob.glob(r"E:\\上市公司数据\\上市公司年度报表\\[0-9]*_benefit_year.txt")
gg = 1
for path in all_name:
file_path = path
print(file_path)
scode = os.path.basename(os.path.realpath(file_path)).split("_")[0]
# print(scode)
gg += 1
# print(gg)
print('已完成:%s' % str(gg/3652))
with open(file_path) as con:
info_list = con.read().split("\n")
# 日期纬度
period_list = info_list[0].split("[")[-1].replace("]", "").split(",")
for each in range(1, len(info_list)):
# print (info_list[each])
# 项目纬度
if len(info_list[each]) > 1:
each_01 = info_list[each].replace("]", "").split("[")
dw_name = each_01[-2].split(",")[0]
fact_data = each_01[-1].split(",")
for i in range(0, len(period_list)):
name_date = (scode + "-" + dw_name + "-" + period_list[i] + "-" + fact_data[i]).replace("'", "")
# print(name_date)
bigdata.write(name_date + "\n" )
bigdata.close()