JupyterLab est appelé à remplacer Jupyter Notebook

Créer un environnement virtuel :

mkdir jupyterlab
cd jupyterlab
 
python3 -m venv venv
. venv/bin/activate

Installer JupyterLab :

pip install jupyterlab

Lancement du serveur local :

$ jupyter lab

Créer un environnement virtuel :

mkdir jupyterlab
cd jupyterlab
 
python -m venv venv
venv\scripts\activate

Installer JupyterLab :

pip install jupyterlab

Lancement du serveur local :

$ jupyter lab

pip install pymysql
pip install sqlalchemy

Installation :

pip install fdb
pip install sqlalchemy
pip install sqlalchemy-firebird
pip install pandas

Configuration :

host     = 'localhost'
dbpath   = '/path/to/my/database.fdb'   # sous Windnows: 'c:/path/to/my/database.fdb'
user     = 'sysdba'
password = 'masterkey'
dsn      = 'firebird://' + user + ':' + password + '@' + host + '/' + dbpath

Connexion :

import pandas as pd
 
data = pd.read_sql_query("select id, name from employees order by name;", con=dsn)

(… à venir …)