i need the value it can be 10.42 but also 0.1042!
i need Verona - Napoli (with - also) so i can do an update query and put them directly in calcio table
but its good to have also home and away team in other to columns to do other joins on other tables...
so with pandas i can also build the query and send to my db?
something like:
UPDATE calcio (home,visitors,p1,pX,p2,p1x,px2,p12) VALUES (" Verona","Napoli" ,"10.42 ","27.08","62.50 " ,"37.50","89.58","72.92" ) where partita ="Verona - Napoli"
and so on...
i need Verona - Napoli (with - also) so i can do an update query and put them directly in calcio table
but its good to have also home and away team in other to columns to do other joins on other tables...
so with pandas i can also build the query and send to my db?
something like:
UPDATE calcio (home,visitors,p1,pX,p2,p1x,px2,p12) VALUES (" Verona","Napoli" ,"10.42 ","27.08","62.50 " ,"37.50","89.58","72.92" ) where partita ="Verona - Napoli"
and so on...
sql = "INSERT INTO sbostats (home, visitor, p1, pX, p2, p1x, px2, p12) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)" for game in load_file("test.txt"): mycursor.execute(sql, tuple(game.values()))
Error: for game in load_file("test.txt"):
NameError: name 'load_file' is not defined