Data Science Mastery
A Python Step-By-Step Guide

Installing Python

Install Python libraries

Installing Jupyter Lab

Installing Visual Studio Code (VSCODE)

How to install Pandas

What is a DataFrame

How to use Pandas DataFrames

How to read any CSV file

How to read any JSON (Web + Offline)

How to read any EXCEL sheet

How to read any SQL database (example with SQlite)

How to scrape web pages and extract HTML tables

Select specific rows

Select specific columns

Select the first rows

Select the last rows

What can you filter for?

How to filter a DataFrame with one condition

How to filter a DataFrame with n conditions

Iterate over rows

Iterate over columns

How to replace values

How to replace null values

How to drop duplicates

How to rename columns

How to transpose a DataFrame

Lambda functions

How to stack DataFrames

Join a DataFrame to another on index

How to sum/subtract columns or rows

How to multiply/divide columns or rows

How to do a power/square root operation on columns or rows

How to round up values using ceil/floor on columns or rows

How to do an exponential or log operation on columns or rows

How to get the satistics of any DataFrame

How to count the number of occurrences in a column

How to get the type of a column

How to get the length of a column/row

How to check if a DataFrame is empty

How to compute the correlation in a DataFrame

How to compute the mean of a column/row

How to compute the variance of a column/row

How to compute the median of a column/row

How to compute the quantile of a column/row

How to compute the standard error fo the mean

How to plot with Pandas

How to make a line plot

How to make a bar plot

How to make a density plot

How to make a histogram

How to make a scatter plot

How to make a boxplot

How to make a pie plot

How to store data efficiently

How to save in CSV

How to save it in JSON

How to save it as an EXCEL file

How to save it in SQL Database

How to save it as an HTML table