Code With Python for  Data Analysis and Visualization

Course Introduction and Curriculum Overview
Connect with the Community
Prerequisites for Taking This Course
Accessing Course Materials

Windows Installation Walkthrough for Jupyter
Getting Started with Jupyter
Installing Pandas and Matplotlib

Creating Notebooks and Running Cells
Shutting Down the Notebook Server
Understanding Cell Outputs
Using Command Mode Shortcuts
Exploring Cell Types: Markdown in Action!
Restarting the Kernel
Accessing Documentation Within a Notebook
EXERCISE: Jupyter Notebook
SOLUTION: Jupyter Notebook

Working with Datasets and CSV Files
Using pd.read_csv and Creating DataFrames
Inspecting DataFrames: head(), tail(), and More
Exploring Data Types with info()
House Sales Dataset: A Detailed Walkthrough
Titanic Passenger Dataset: A Comprehensive Guide
Handling Non-Comma Separators: Netflix Dataset Example
Customizing Headers: Country Population Dataset
EXERCISE: DataFrames and Datasets
SOLUTION: DataFrames and Datasets

Module Introduction
Setting Up the Starting Project
Planning the Project
Adding URLs & Views
Adding First Templates
Template Content & Static Files
Adding Images as Static Files
Adding the "All Posts" Page & Style
Linking the Pages
Adding the "Single Post" Page
Adding Dummy Data to the "Views" File
Special Template Features & Syntax
Adding a Single Post Page
Adding a 404 Page
Useful Resources & Links

Module Introduction
Different Kinds of Data
Understanding Database Options
Understanding SQL
Django Models
Creating a Django Model with Fields
Migrations
Inserting Data
Getting all Entries
Updating Models & Migrations
Blank vs Null
Updating Data
Deleting Data
Create Instead of Save
Querying & Filtering Data
"or" Conditions
Query Performance
Bulk Operations
Preparing Templates
Rendering Queried Data in the Template
Rendering the Details Page
Model URLs
Adding a Slugfield & Overwriting Save
Using the Slug & Updating Field Options
Aggregation & Ordering
Summary
Useful Resources & Links

Basics of set_index
Using set_index with the World Happiness Index Dataset
Setting Index Directly with read_csv
Introduction to sort_values
Sorting by Multiple Columns
Sorting Text Columns
Working with sort_index
Combining Sorting and Plotting
Understanding loc
Exploring iloc
Using loc and iloc with Series
EXERCISE: Indexing and Sorting
SOLUTION: Indexing and Sorting

Filtering DataFrame with Boolean
Filtering With Comparison Operators
The Between Method
The isin() Method
Combining Conditions Using AND (&)
Combining Conditions Using OR (|)
Bitwise Negation
isna() and notna() Methods
Filtering + Plotting Examples
Exercise Filtering
SOLUTION: Filtering Exercise

Dropping Columns
Dropping Rows
Adding Static Columns
Creating Dynamic Columns
Identifying Homes with the Highest Price per Square Foot
Analyzing Largest Bitcoin Price Changes
EXERCISE: Adding and Removing Columns and Rows
SOLUTION: Adding and Removing Columns and Rows

Renaming Columns and Index Labels
Using the replace() Method
Updating Values with loc[]
Updating Multiple Values with loc[]
Making Updates with loc[] and Boolean Masks
EXERCISE: Updating Values
SOLUTION: Updating Values Exercise