Use Python create a new table in sqlite from the information of csv file

See more:

Python

to_table: This function takes a csv filename, an SQLite filename, and a table name with default value "new1". It adds a new table with the specified name to the db that has the information from the csv file in it. The first row of the csv file contains the column names. All columns are TEXT type. The first column is the primary key. I recommend using Python's csv module so you don't have to parse the rows of the csv file yourself.

What I have tried:

def to_table(csv_file,sq_file,table_name='new1'):
'''
'''
conn=sqlite3.connect(sq_file)
conn.row_factory=sqlite3.Row
c=conn.cursor()
with open(csv_file,'r') as csvfile:
reader =csv.reader(csvfile)
row1=next(reader)
c.execute("CREATE TABLE table_name(row1[0] TEXT PRIMARY KEY,"+"row1[1:] TEXT);")
return sq_file