import excel csv into mysql with python

1# Insert DataFrame to Table
2for row in df.itertuples():
3    cursor.execute('''
4                INSERT INTO TestDB.dbo.people_info (Name, Country, Age)
5                VALUES (?,?,?)
6                ''',
7                row.Name, 
8                row.Country,
9                row.Age
10                )
11conn.commit()

1import pandas as pd
2import pyodbc
3
4# Import CSV
5data = pd.read_csv (r'C:\Users\Ron\Desktop\Test\People.csv')   
6df = pd.DataFrame(data, columns= ['Name','Country','Age'])
7
8# Connect to SQL Server
9conn = pyodbc.connect('Driver={SQL Server};'
10                      'Server=RON\SQLEXPRESS;'
11                      'Database=TestDB;'
12                      'Trusted_Connection=yes;')
13cursor = conn.cursor()
14
15# Create Table
16cursor.execute('CREATE TABLE people_info (Name nvarchar(50), Country nvarchar(50), Age int)')
17
18# Insert DataFrame to Table
19for row in df.itertuples():
20    cursor.execute('''
21                INSERT INTO TestDB.dbo.people_info (Name, Country, Age)
22                VALUES (?,?,?)
23                ''',
24                row.Name, 
25                row.Country,
26                row.Age
27                )
28conn.commit()
29