I am trying to import a csv file to mysql using python. I am getting an error ' TypeError: not enough arguments for format string' – Phpmyadmin

The format string (query) contains more occurrences of %s than you have supplied arguments in "row" from the csv file. Are all the lines the same number of fields?

I’ve always had more luck with named parameters when doing sql. This bit of code grabs the headers from the first line of the csv, then creates a list of dictionaries that use those headers from the rest of the file. This allows us to call executemany(query_string, list) and use named place holders in the query.

Using named place holders, the order and quantity of parameters is not such a big deal. As long as you have a field in the dictionary for each place holder, everything will sort itself out as far as ordering goes. You can also have extra fields in the dictionary that you don’t use in the query without it blowing up. These properties make it easier to make changes to both the query and the code and also make your sql much more readable.

Using executemany can be more efficient if the driver supports prepared queries.

import csv
import pymysql

data = [] 
headers = True
with open('E:py_docsfile101.csv') as f:
    for row in csv.reader(f):
        if headers:
            fields = [field for field in row]
            headers = False
        else:
            data.append({field: val for field, val in zip(fields, row)})
with pymysql.connect(host="127.0.0.1", port=3308, user="root", passwd="", db="database_name").cursor() as cur:
    cur.executemany("insert into table_name (field_1, field_2, field_3, ...) "
        "values (%(csv_fld_1)s, %(csv_fld_2)s, %(csv_fld_3)s, ...) "
        ,data)
    cur.connection.commit()```