python - 如何解决显示 AttributeError: 'Pandas' object has no attribute 'Password' 的问题？

Question

我正在尝试将 csv 文件导入到我在 sql 中创建的表中。我不确定它有什么问题，我已经尝试将 Password-hashed 更改为密码，但它仍然不起作用这是代码：

import mysql.connector
import pandas as pd

data = pd.read_csv('OnePassTesters.csv',)
df = pd.DataFrame(data, columns=[
    'Login', 'Name', 'Email', 'Mobile', 'Residence', 'Password-hashed', 'CPF', 'HDB', 'TP', 'DBS', 'FairPrice'])
print(df)

db = mysql.connector.connect(
    host="localhost",
    user="root",
    password="1234",
    database="OnePass"
)
cursor = db.cursor()

for row in df.itertuples():
    cursor.execute('''INSERT INTO OnePass.user_info ('Login_ID','User_Name','User_Email','User_Mobile','User_Residence',
    'User_Password', 'CPF','HDB','TP','DBS','FairPrice' ) 
    VALUES (?,?,?) ,
    ''',
                   row.Login,
                   row.Name,
                   row.Email,
                   row.Mobile,
                   row.Residence,
                   row.Password-hashed,
                   row.CPF,
                   row.HDB,
                   row.TP,
                   row.DBS,
                   row.FairPrice
                   )
    db.commit()

标签： pythonmysqlpandasmysql-connector-python