import sqlite3

conn = sqlite3.connect('../input/database.sqlite')
c = conn.cursor()

ids = [i[0] for i in c.execute('SELECT id FROM League').fetchall()]
names = [i[0] for i in c.execute('SELECT name FROM League').fetchall()]
id_league = {i: n for (i, n) in zip(ids, names)}
id_league

ids = [i[0] for i in c.execute('SELECT id FROM Country').fetchall()]
names = [i[0] for i in c.execute('SELECT name FROM Country').fetchall()]
id_country = {i: n for (i, n) in zip(ids, names)}

c.execute('PRAGMA TABLE_INFO(Player_Stats)').fetchall()