In [1]:
import sqlite3
import pandas as pd
In [2]:
db = "/Users/flavio.clesio/Documents/Github/database.sqlite"
In [ ]:
with sqlite3.connect(db) as con:
player_attributes = pd.read_sql_query("SELECT * FROM Player_Attributes", con)
players = pd.read_sql_query("SELECT * FROM Player", con)
leagues = pd.read_sql_query("SELECT * FROM League", con)
match = pd.read_sql_query("SELECT * FROM Match", con)
team = pd.read_sql_query("SELECT * FROM Team", con)
team_attributes = pd.read_sql_query("SELECT * FROM Team_Attributes", con)
country = pd.read_sql_query("SELECT * FROM Country", con)
In [ ]: