Pandas Brain Teasers

Puzzle 25

Hit and Run

hits.py

import sqlite3
import pandas as pd

conn = sqlite3.connect(':memory:')
conn.executescript('''
CREATE TABLE visits (day DATE, hits INTEGER);
INSERT INTO visits VALUES
    ('2020-07-01', 300),
    ('2020-07-02', 500),
    ('2020-07-03', 900);
''')

df = pd.read_sql('SELECT * FROM visits', conn)
print('time span:', df['day'].max() - df['day'].min())

Guess the Output
	Try to guess what the output is before moving to the next page.

This code will raise a TypeError.

I love SQLite3. ...