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.
Diese Übung ist Teil des Kurses
Streamlined Data Ingestion with pandas
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
# Import sqlalchemy's create_engine() function
____