USE PYTHON ONLY:

def ex1():

"""

Reproduce ex1.tsv from 'AdmissionsCorePopulatedTable.txt'

https://mkzia.github.io/eas503-notes/sql/sql_6_conditionals.html#conditionals

Separate the columns by a tab

"""

# BEGIN SOLUTION

pass

# END SOLUTION

def ex2():

"""

Repeat ex1 but add the Quarter column

This is the last SQL query on https://mkzia.github.io/eas503-notes/sql/sql_6_conditionals.html#conditionals

Hint: https://stackoverflow.com/questions/60624571/sort-list-of-month-name-strings-in-ascending-order

"""

# BEGIN SOLUTION

pass

# END SOLUTION

TEST CASE IT SHOULD PASS:

@weight(10)

@visibility('visible')

@number("ex1")

def test_ex1(self):

self.assignment8.ex1()

result_from_file = pd.read_csv('ex1.tsv')

expected_from_file = pd.read_csv('ex1_solution.tsv')

assert result_from_file.equals(expected_from_file) == True

@weight(10)

@visibility('visible')

@number("ex2")

def test_ex2(self):

self.assignment8.ex2()

result_from_file = pd.read_csv('ex2.tsv')

expected_from_file = pd.read_csv('ex2_solution.tsv')

assert result_from_file.equals(expected_from_file) == True