Reading specific rows (lookup)

[hshivaraj]

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

Im not sure if its just me or anybody else. I dont understand what your asking. Your question is too wage; hard to understand what your asking. Let me ask you a few questions.

Am i right in thinking that your CSV file looks as follow?

Output:
2018, 01, 2017-12-31, 2018-01-06, filename_201801W01.csv.gz
2018, 02, 2018-01-07, 2018-01-13, filename_201801W02.csv.gz

You want the data range and the file name retrieved when just entered the year and the week? For instance

Input
year: 2018
week: 01

Output:
date_range:  2017-12-31, 2018-01-06
filename: filename_201801W01.csv.gz

Correct?