Thread
SQL in Jupyter Notebooks πŸ”₯

Introducing Jupysql a python library that lets you run SQL commands right inside Jupyter Notebooks:

A Thread πŸ§΅πŸ‘‡
Jupyter Notebooks already has Ipython magic commands to run SQL queries.

You can run any SQL query with %sql(line magic) and %%sql(cell magic) commands

"Jupysql" is an extension to this Ipython SQL package

Check out below example on how to install and use Jupysql:πŸ‘‡
Jupysql has other great features compared to IPython SQL like the one below to Plot large-scale datasets:

With the help of the "sqlplot" line command, you can plot large datasets inside the jupyter notebooks itselfπŸ“Š

Check out the below example on how to use sqlplot:πŸ‘‡
Jupysql also has other really great features compared to Ipython SQL. Checkout the blog and the GitHub repository:

Blog: ploomber.io/blog/jupysql/

GitHub Repository: github.com/ploomber/jupysql
That's a wrap!

If you are interested in:

- Python 🐍
- Data Science πŸ“ˆ
- Machine Learning πŸ€–
- Data Analysis πŸ“Š
- MLOps πŸ› 
- NLP πŸ—£
- Computer Vision πŸŽ₯

I'm sharing daily content over here, follow me β†’ @Sumanth_077 if you haven't already βœ…
Mentions
See All