In [22]:

    

import csv
url_pattern = 'http://apps.who.int/gho/athena/xmart/xmart.csv?target=EBOLA_MEASURE/CASES,DEATHS&profile=crosstable&filter=COUNTRY:GIN;COUNTRY:UNSPECIFIED;COUNTRY:LBR;COUNTRY:UNSPECIFIED;COUNTRY:SLE;COUNTRY:UNSPECIFIED;LOCATION:-;DATAPACKAGEID:2016-01-06;INDICATOR_TYPE:SITREP_CUMULATIVE;INDICATOR_TYPE:SITREP_CUMULATIVE_21_DAYS;SEX:-&x-sideaxis=COUNTRY;EPI_DATE;CASE_DEFINITION&x-topaxis=EBOLA_MEASURE;INDICATOR_TYPE'
rpl_date = '2016-01-06'


    

In [18]:

    

r = csv.reader(open('files.csv'))


    

In [19]:

    

rows = [ro for ro in r]


    

In [20]:

    

len(rows)


    

    
Out[20]:





283

In [21]:

    

rows[0]


    

    
Out[21]:





['2016-01-20',
 'http://apps.who.int/gho/data/view.ebola-sitrep.ebola-summary-20160120?lang=en']

In [23]:

    

import requests
r = requests.get(url_pattern)
r.text


    

    
Out[23]:





'"","","","Number of cases","Number of cases","Number of deaths"\n"Country","Data as of","Case definition"," Cumulative"," In past 21 days"," Cumulative"\n"Guinea"," 28 December 2015"," Confirmed","3351","0","2083"\n"Guinea"," 28 December 2015"," Probable","453","Not reported.","453"\n"Guinea"," 28 December 2015"," Suspected","0","Not reported.","Data not available."\n"Guinea"," 28 December 2015"," Total","3804","0","2536"\n"Liberia"," 3 January 2016"," Confirmed","9","0","3"\n"Liberia"," 3 January 2016"," Probable","Not reported.","Not reported.","Data not available."\n"Liberia"," 3 January 2016"," Suspected","Data not available.","Not reported.","Data not available."\n"Liberia"," 3 January 2016"," Total","9","0","3"\n"Liberia"," 9 May 2015"," Confirmed","3151","-","Data not available."\n"Liberia"," 9 May 2015"," Probable","1879","-","Data not available."\n"Liberia"," 9 May 2015"," Suspected","5636","-","Data not available."\n"Liberia"," 9 May 2015"," Total","10 666","-","4806"\n"Sierra Leone"," 7 November 2015"," Confirmed","8704","0","3589"\n"Sierra Leone"," 7 November 2015"," Probable","287","Not reported.","208"\n"Sierra Leone"," 7 November 2015"," Suspected","5131","Not reported.","158"\n"Sierra Leone"," 7 November 2015"," Total","14 122","0","3955"\n"All countries","  "," Confirmed","15 215","0","Data not available."\n"All countries","  "," Probable","2619","Not reported.","Data not available."\n"All countries","  "," Suspected","10 767","Not reported.","Data not available."\n"All countries","  "," Total","28 601","0","11 300"\n'

In [24]:

    

with open('data.csv', 'w') as f:
    f.writelines(r.text)


    

In [26]:

    

for row in rows:
    date = row[0]
    url = url_pattern.replace(rpl_date, date)
    r = requests.get(url)
    with open('{}.csv'.format(date), 'w') as f:
        f.writelines(r.text)


    

In [ ]: