python将Excel表导入数据库中，数据库表中没有数据

Question

问题遇到的现象和发生背景 python将Excel表导入数据库

问题相关代码，请勿粘贴截图 # -- coding = utf-8 --

import sqlite3
import csv
conn = sqlite3.connect('Data.db')
cs = conn.cursor()


cs.execute('''create table data1(
            id int primary key not null,
            Nuclide varchar not null ,
            Z int not null,
            N int not null,
            Decaymode varchar,
            Halflife varchar,
            Kev varchar,
            Abundance varchar
)''')




with open('data1.csv','w+',encoding='utf-8') as b:
    data = csv.reader(b)
    for row in data:
        # print(row)
        cs.execute(b'insert into data1 values ("{row[0]}","{row[1]}","{row[2]}","{row[3]}","{row[4]}","{row[5]}","{row[6]}")')
    print("successful")
    conn.commit()
conn.close()

运行结果及报错内容 数据库表中，没有数据

我的解答思路和尝试过的方法

我想要达到的结果求数据

Answer 1

import sqlite3
import csv
conn = sqlite3.connect('Data.db')
cs = conn.cursor()


cs.execute('''create table data1(
            id int primary key not null,
            Nuclide varchar not null ,
            Z int not null,
            N int not null,
            Decaymode varchar,
            Halflife varchar,
            Kev varchar,
            Abundance varchar
)''')


with open('data1.csv', 'r', encoding='utf-8') as b:
    data = csv.reader(b)
    for row in data:
        # print(row)
        cs.execute(
            'insert into data1 values ("{}","{}","{}","{}","{}","{}","{}","{}")'.format(row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7]))
    print("successful")
    conn.commit()
conn.close()