Running SQL Queries in Jupyter Notebook using JupySQL, DuckDB, and MySQL | by Wei-Meng Lee | Feb, 2023
Learn how to run SQL in your Jupyter NotebooksPhoto by Wafer WAN on UnsplashTraditionally, data scientists use Jupyter Notebook to pull data from database servers, or from external datasets (such as CSV, JSON files, etc) and store them into Pandas dataframes:All images by author unless otherwise statedThey then use the dataframes for visualization purposes. This approach has a couple of drawbacks:Querying a database server may degrade the performance of the database server, which may not be optimized for analytical…