Error in Code about predicting-football-match-outcome-using-machine-learning HOT 2 OPEN

Did you ever find a solution to this issue? I am having the same problem

from predicting-football-match-outcome-using-machine-learning.

Hi @10511829 & @ThomasLee7795 & @prathameshtari - Would appreciate your insight.

I've hit a roadblock right at the start, with line #2 below

      1 with sqlite3.connect('database.sqlite') as con:
----> 2     countries = pd.read_sql_query("SELECT * from Country", con)

I get this error: DatabaseError: Execution failed on sql 'SELECT * from Country': no such table: Country

The database.sqlite file is created but it's 0KB (presumably empty) and I don't seem to see any code in this repository which orchestrates the loading of the .csv files INTO the sqlite database.

Could you please advise? Thank you

from predicting-football-match-outcome-using-machine-learning.