Setting-up SQL on Google Colab
Zindua School
0:00 / 0:00
Setting-up SQL on Google Colab
18 166 просмотров · 3 года назад
Zindua School
629 подписчиков
18 166 просмотров · 3 года назад
In this tutorial, we cover why Data Scientists use Ipython Notebooks and how we can set-up SQL on the Google Colab Ipython Notebook.
You can download the database used in the video here: https://www.sqlitetutorial.net/sqlite...
Here are the code snippets from the video:
***
!pip install pymysql
***
***
%load_ext sql
***
***
%sql sqlite:///chinook.db
***
Now, every time you create a cell and add "%%sql", you can start running SQL:
%%sql
SELECT * FROM customers
LIMIT 5
***