Jan-03-2018, 12:01 PM
I would like to pull data from a csv, rather than manually enter date range and filename every time.
In my csv, example rows:
2018, 01, 2017-12-31, 2018-01-06, filename_201801W01.csv.gz
2018, 02, 2018-01-07, 2018-01-13, filename_201801W02.csv.gz
At present, I manually enter:
date_ranges = [('2017-12-03', '2017-12-09')]
filename = 'filename_201801W01.csv.gz'
However, I would prefer to have to enter something like:
Year: '2018'
Week: '01'
and have the dates and filename pulled from the csv
Can you help?
So far:
week = 01
date_range = [( datefrom, dateto)]
filename = nameoffile
Thanks
In my csv, example rows:
2018, 01, 2017-12-31, 2018-01-06, filename_201801W01.csv.gz
2018, 02, 2018-01-07, 2018-01-13, filename_201801W02.csv.gz
At present, I manually enter:
date_ranges = [('2017-12-03', '2017-12-09')]
filename = 'filename_201801W01.csv.gz'
However, I would prefer to have to enter something like:
Year: '2018'
Week: '01'
and have the dates and filename pulled from the csv
Can you help?
So far:
with open ('DP Python dates.csv') as csvfile: readCSV = csv.reader(csvfile) datetos = [] datefroms = [] filenames = [] for row in readCSV: year = [0] week = [1] datefrom = [2] dateto = [3] filename = [4] datefroms.append(datefrom) datetos.append(dateto) filenames.append(filename) whatWeek = '01' coldex = week.index(whatWeek) coldex2 =week.index(whatWeek) theDateFrom = datefroms[coldex] theDateTo = datetos[coldex2] date_range = [(theDateFrom, theDateTo)]Then, I want something like:
week = 01
date_range = [( datefrom, dateto)]
filename = nameoffile
Thanks