import pandas as pd import sqlite3 # Create database conn = sqlite3.connect('guests.db') c = conn.cursor() # Create table c.execute('''CREATE TABLE guests (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, phone TEXT, email TEXT, visits INTEGER)''') # Insert data df = pd.read_csv('guests.csv') df.to_sql('guests', conn, if_exists='append', index=False) # Close connection conn.close()
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter