How can I connect Jupyter Notebook to a database?

How can I connect Jupyter Notebook to a database?

You can connect Jupyter Notebook to a database using libraries like SQLAlchemy or pandas. Which database are you using?

I'm using PostgreSQL. Can you show me an example?

Sure! First, install the necessary libraries with !pip install sqlalchemy psycopg2. Then, use the following code:

from sqlalchemy import create_engine

# Replace 'username', 'password', 'host', 'port', and 'dbname' with your details
engine = create_engine('postgresql://username:password@host:port/dbname')

# Now you can connect and run queries
with engine.connect() as connection:
    result = connection.execute('SELECT * FROM your_table')
    for row in result:
        print(row)

What if I want to use SQLite instead?

For SQLite, you can use the same SQLAlchemy library. Just change the connection string to:

engine = create_engine('sqlite:///your_database.db')