How can I write a dataframe to a local sqlite3 file?

Question

I've got a directory of csv files which I would rather have as a sqlite3 database. What is the best way to write each csv file as a table in a database?

Demetri Pananos · Accepted Answer · 2016-12-04 20:13:41Z

6

I found a solution

import pandas as pd #IO
import sqlite3 #To write database
import glob #loop through working directory

cxn = sqlite3.connect('mydb.sqlite3')

for file in glob.glob('*.csv'):

    table_name = file[:-4] #File name without .csv
    df = pd.read_csv(file)
    df.to_sql(table_name, cxn, index = False)

edited Dec 4, 2016 at 20:13

answered Dec 4, 2016 at 8:13

Demetri Pananos

7,55411 gold badges49 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bill Bell Over a year ago

In case others come here to find a solution, would you consider editing your answer to show your import of pandas?

Collectives™ on Stack Overflow

How can I write a dataframe to a local sqlite3 file?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related