<jupyter_start><jupyter_text>Create dataframe<jupyter_code>from pandas import DataFrame

Cars = {'Brand': ['Honda Civic','Toyota Corolla','Ford Focus','Audi A4'],
        'Price': [22000,25000,27000,35000]
        }

df = DataFrame(Cars, columns= ['Brand', 'Price'])
df<jupyter_output><empty_output><jupyter_text>Create sqllite server<jupyter_code>import sqlite3
conn = sqlite3.connect('TestDB1.db')
c = conn.cursor()<jupyter_output><empty_output><jupyter_text>Create cars table in server<jupyter_code>c.execute('CREATE TABLE CARS (Brand text, Price number)')
conn.commit()<jupyter_output><empty_output><jupyter_text>Add dataframe to cars table<jupyter_code>df.to_sql('CARS', conn, if_exists='replace', index = False)
c.execute('''  
SELECT * FROM CARS
          ''')
for row in c.fetchall():
    print (row)<jupyter_output>('Honda Civic', 22000)
('Toyota Corolla', 25000)
('Ford Focus', 27000)
('Audi A4', 35000)
{'fraction_non_alphanumeric': 0.15553121577217963, 'fraction_numerical': 0.04928806133625411, 'mean_word_length': 6.811965811965812, 'pattern_counts': {'":': 0, '<': 16, '<?xml version=': 0, '>': 16, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '4', 'dir': 'jupyter-structured-clean-dedup', 'id': '66920', 'license': 'MIT', 'n_tokens_mistral': 385, 'n_tokens_neox': 342, 'n_words': 67, 'path': 'SQL/SQLlite3_Basic.ipynb', 'repo_name': 'corybaird/Web_development', 'size': '913'}