Data wrangling

Diving in

• Introduction
• Loading and exploring the dataset
• Dropping Missing Values with dropna
• The unique function
• Setting and Resetting the Index
• The GroupBy Method
• Concatenating
• Merging
• Joining
• Random sampling
• Sorting by column values
• User-defined functions

Data sources

• Introduction
• CSV file headers
• CSV delimiters
• Skiprows and nrows
• Reading CSV data from a compressed file
• Reading sheets from an Excel file
• Reading a Text file
• Reading HTML tables
• Reading from a JSON file
• Reading a PDF file
• Using Beautiful Soup
• Exporting a DataFrame as an Excel file

Some secrets

• Introduction
• Generator expressions
• Zip function and messy data
• Data representation using {}
• Outliers in numerical data
• Rinse and repeat
• Ames housing

Data gathering

• Introduction
• Using requests and beautiful soup
• Reading data from XML
• Reading data from API
• Gutenberg
• Full moon dataset

RDBMS and SQL

• Introduction
• SQL refresher
• Quotes table
• Joining and creating dataframe

---

More cuisine

• Milliway's Main Menu