Connect to a database
In order to get data from a database with pandas
, you first need to be able to connect to one. In this exercise, you'll practice creating a database engine to manage connections to a database, data.db
. To do this, you'll use sqlalchemy
's create_engine()
function.
create_engine()
needs a string URL to the database. For SQLite databases, that string consists of "sqlite:///"
, then the database file name.
This exercise is part of the course
Streamlined Data Ingestion with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import sqlalchemy's create_engine() function
____