From the course: Advanced Python: Practical Database Examples
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Challenge: Ingest data and visualize it with Matplotlib - Python Tutorial
From the course: Advanced Python: Practical Database Examples
Challenge: Ingest data and visualize it with Matplotlib
(bright music) - [Instructor] It's time to practice ingesting and visualizing data. In this challenge, you'll be given a new database that you need to visualize the data of. Here's what the data looks like. There are columns for order ID, property ID, state, city, product ID, product category, product type, quantity, product price, and order total. It represents sales for the Landon company. We've already transferred this data into a sqlite database file called landon.sqlite. It lives in a table called sales. Your job is to import this data into a Jupyter notebook. Then you'll create a graph that visualizes a statistic or fact of the data. It could be a bar graph that shows what city most orders came from. It could be a pie chart that shows the least popular product categories. It's up to you. Good luck, and happy coding.
Contents
-
-
-
-
Introduction to pandas2m 12s
-
(Locked)
Set up pandas and Jupyter Notebook2m 10s
-
(Locked)
Analyze data with pandas3m 30s
-
(Locked)
Analyze data with Matplotlib1m 29s
-
(Locked)
Connect to a DB using SQLAlchemy within Juypter Notebook2m 33s
-
(Locked)
Visualize data using SQLAlchemy, pandas, and Matplotlib3m 30s
-
(Locked)
Challenge: Ingest data and visualize it with Matplotlib1m 7s
-
(Locked)
Solution: Ingest data and visualize it using Matplotlib4m 9s
-
-
-