def duplicate_handle(): # 该部分加入for循环进行了修改
for name in category_landing_purchase:
if name == category_landing_purchase:
continue
dcu.merge_rows(name + '.xlsx')
return
def drop_score_empty(): # 删去评分为空的公式，如果第一列名为空，第一列也会被删
"""
some corporates lack of scores, we need to drop them.
:return:
"""
empty_check_list = [u'企业总评分'.encode('utf-8')]
for file_n in category_finance_files:
print file_n
dcu.merge_rows(file_n + '_index', file_url=corporation_index_file_url,
dst_file_url=corporation_index_file_url)
dcu.drop_rows_too_many_empty(file_n + '_index', file_url=corporation_index_file_url,
dst_file_url=corporation_index_file_url, columns=empty_check_list, thresh=1)
def drop_score_empty():
"""
some corporates lack of scores, we need to drop them.
:return:
"""
empty_check_list = [u'企业总评分'.encode('utf-8')]
for file_n in category_landing_purchase:
print file_n
dcu.merge_rows(file_n + '_index',
file_url=corporation_index_file_url,
dst_file_url=corporation_index_file_url)
dcu.drop_rows_too_many_empty(file_n + '_index',
file_url=corporation_index_file_url,
dst_file_url=corporation_index_file_url,
columns=empty_check_list,
thresh=1)
def duplicate_handle():
for name in category_competing_products:
dcu.merge_rows(name + '.xlsx')
def duplicate_handle():
for name in category_soft_assets_files:
dcu.merge_rows(name + '.xlsx')
def duplicate_handle():
for name in category_basic_information:
dcu.merge_rows(name + '.xlsx')
return
def duplicate_handle(): # 删除重复行
for name in category_finance_files:
dcu.merge_rows(name + '.xlsx')
def duplicate_handle():
for name in category_annual_report_files:
if name == u'年报-对外投资信息':
continue
dcu.merge_rows(name + '.xlsx')
def duplicate_handle():
for name in category_paying_taxes:
dcu.merge_rows(name + '.xlsx')