Pessoal, estou começando em Python, e achei nas minhas buscas um código pra fazer um insert no banco de dados. Porém já tive alguns erros que consegui solucionar e agora travei. Poderiam me ajudar?
df = pd.read_csv('DADOS/Pasta1.csv', sep = ';')
##Conexao BD
host=''
port='5432'
dbname='postgres'
user='postgres'
password='#'
tbname = ''
cnxn = pg.connect("host='{}' port='{}' dbname='{}' user='{}' password='{}'"
.format(host, port, dbname, user, password))
cursor = cnxn.cursor()
for index, row in df.iterrows():
cursor.execute("INSERT INTO humanresources.departmenttest (departmentid,name,groupname) values(?,?,?)", row.departmentid, row.name, row.groupname)
o erro é o seguinte.. AttributeError: 'Series' object has no attribute 'departmentid'
csv utulizado
DepartmentID,Name,GroupName, 1,Engineering,Research and Development, 2,Tool Design,Research and Development, 3,Sales,Sales and Marketing, 4,Marketing,Sales and Marketing, 5,Purchasing,Inventory Management, 6,Research and Development,Research and Development, 7,Production,Manufacturing, 8,Production Control,Manufacturing, 9,Human Resources,Executive General and Administration, 10,Finance,Executive General and Administration, 11,Information Services,Executive General and Administration, 12,Document Control,Quality Assurance, 13,Quality Assurance,Quality Assurance, 14,Facilities and Maintenance,Executive General and Administration, 15,Shipping and Receiving,Inventory Management, 16,Executive,Executive General and Administration
obs: usando pandas
