Data visualisation with SQL and Python - Learn SQL with IMDB database

Published: 01 September 2021
on channel: Hello Leo

956

To download the .db file:
http://leourushi.com/downloads.html

You will learn how to create a basic scatterplot chart using SQL and Python (Seaborn library).

Use this snippet for the SQL query:
select startYear, avg(runtimeMinutes) as avg_mins from basics
where titleType = 'movie'
and startYear between 1960 and 2020
group by startYear

Content:
00:00 Introduction
01:09 Set up - Download IMDB dataset
01:21 Set up - Install Anaconda
02:02 How to open Jupyter Notebook from Terminal
04:01 Make a new file in Jupyter Notebook
04:20 How to save progress in Jupyter Notebook
04:35 How to close Jupyter Notebook
05:04 Import Seaborn and SQLite3
06:15 Connect with a databse using sqlite3.connect()
07:28 Read a SQL query using Pandas
09:11 Seaborn chart samples
09:35 How to draw a scatter plot using Seaborn
11:45 How to change colour of scatter plot in Seaborn
12:05 How to close a connection with a database in Jupyter Notebook

On this page of the site you can watch the video online Data visualisation with SQL and Python - Learn SQL with IMDB database with a duration of hours minute second in good quality, which was uploaded by the user Hello Leo 01 September 2021, share the link with friends and acquaintances, this video has already been watched 956 times on youtube and it was liked by 17 viewers. Enjoy your viewing!

19,948

158