<p>下面的代码假设每个国家都有几个文件,需要对它们进行排序以查找最近一周的情况</p>
<pre><code>import glob
import os
import re
def find_country_file(country_name):
all_country_files = glob.glob(os.path.join(inputs_path, '{0}_W*.*'))
week_numbers = [re.search('W([0-9]+)', x) for x in all_country_files]
week_numbers = [int(x.group(1)) for x in week_numbers if x is not None]
latest_week_number = sorted(week_numbers, reversed=True)[0]
latest_country_file = [x for x in all_country_files if 'W{0}.'.format(latest_week_number) in x]
return os.path.basename(latest_country_file)
df_italy = pd.read_excel(find_country_file('Italy') , sheet_name='Sheet1')
df_russia = pd.read_excel(find_country_file('Russia'), sheet_name='Sheet3')
df_france_1 = pd.read_excel(find_country_file('France'),sheet_name='Sheet1', usecols = 'M, Q', skiprows=4)
df_spain = pd.read_excel(find_country_file('Spain'),sheet_name='Sheet2',usecols = 'T:U', skiprows=30 )
df_ne = pd.read_excel(find_country_file('NE'),sheet_name='Sheet2',usecols = 'N,P', skiprows=4 )
df_ne_c = pd.read_excel(find_country_file('NE'),sheet_name='Sheet1',usecols = 'H:J', skiprows=141)
</code></pre>
<p>find_country方法搜索路径中具有国家名称的所有文件,使用regex提取周数,对它们进行排序以查找最大的编号,然后从与找到的最近一周匹配的所有国家/地区文件的全局返回文件路径</p>