Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from pandas import read_csv
- FILENAME = 'UPF Riders.csv'
- tableName ='headquarters'
- fileData = read_csv(FILENAME, header=None).to_numpy()
- for data in fileData:
- code, latitude, longitude, postal_address = data[:4]
- sql_query = f"INSERT INTO {tableName}(code, latitude, longitude, postal_address) VALUES ({code},'{latitude}','{longitude}',"+ '"' + str(postal_address) + '"' + ");"
- print(sql_query)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement