Google Automation with Python

cars.py

#!/usr/bin/env python3


import csv
import datetime
import requests


FILE_URL = "https://storage.googleapis.com/gwg-hol-assets/gic215/employees-with-date.csv"

def get_start_date():
    """Interactively get the start date to query for."""

    print()
    print('Getting the first start date to query for.')
    print()
    print('The date must be greater than Jan 1st, 2018')
    year  =int( input('Enter a value for the year: '))
    month = int( input('Enter a value for the month: '))
    day = int( input('Enter a value for the day: '))
    print()

    return datetime.datetime(year, month, day)

def get_file_lines(url):
    """Returns the lines contained in the file at the given URL"""

    # Download the file over the internet
    response = requests.get(url, stream=True)
    lines = []

    for line in response.iter_lines():
        lines.append(line.decode("UTF-8"))
    return lines

def get_same_or_newer(start_date, data):
    """Returns the employees that started on the given date, or the closest one."""
    reader = csv.DictReader(data)
#   with open(data, mode = 'r') as infile:
#       reader = csv.reader(infile)
#       with open('data_new.csv', mode = 'w') as outfile:
#               writer csv.writer(outfile)
#               mydict = {rows[0]:rows[1] for rows in reader}
#               print(mydict)
#     reader = csv.DictReader(data)
   # We want all employees that started at the same date or the closest newer
    # date. To calculate that, we go through all the data and find the
    # employees that started on the smallest date that's equal or bigger than
    # the given start date.

    min_date = datetime.datetime.today()
    min_date_employees = []

    for row in reader:
        row_date = datetime.datetime.strptime(row['Start Date'], '%Y-%m-%d')
#        row_date = int(row['Start Date'])
        # If this date is smaller than the one we're looking for,

        # we skip this row
        if row_date < start_date:
            continue

        # If this date is smaller than the current minimum,
        # we pick it as the new minimum, resetting the list of
        # employees at the minimal date.
        if row_date < min_date:
            min_date = row_date
            min_date_employees = []

        if row_date == start_date:
        # If this date is the same as the current minimum,
        # we add the employee in this row to the list of
        # employees at the minimal date.
#        if row_date == start_date:
          min_date_employees.append("{} {}".format(row['Name'], row['Surname']))

    return min_date, min_date_employees

def list_newer(start_date, data):
    while start_date < datetime.datetime.today():
        start_date, employees = get_same_or_newer(start_date,data)
        print("Started on {}: {}".format(start_date.strftime("%b %d, %Y"), employees))

        # Now move the date to the next one
        start_date = start_date + datetime.timedelta(days=1)

def main():
    data = get_file_lines(FILE_URL)
    start_date = get_start_date()
    list_newer(start_date,data)

if __name__ == "__main__":
    main()