How to import CSV file in SQLite database using Python ?
In this article, we’ll learn how to import data from a CSV file and store it in a table in the SQLite database using Python. You can download the CSV file from here which contains sample data on the name and age of a few students.
Contents of the CSV file
- Importing necessary modules
- Read data from CSV file DictReader()
- Establish a connection with the database.
sqliteConnection = sqlite3.connect('sql.db')
cursor = sqliteConnection.cursor()
- Create the student table and execute the query using execute() method.
- Inserting data into the table
cursor.executemany("insert into student (name, age) VALUES (?, ?);", student_info)
- Read data from the table
- And close the database.
Below is the implementation:
) as fin:
'create table student(name varchar2(10), age int);'
"insert into student (name, age) VALUES (?, ?);"
'select * from student;'
sqlite3.Error as error:
'Error occurred - '
'SQLite Connection closed'
Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses
are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!