Section 6: Lab: Getting Started with pandas 3
- Series, DataFrame and Index
- The str data type, now the default in pandas 3
- Copy-on-Write and why chained assignment no longer works
- Select data with loc and iloc
- Lab: explore a customer table with head, info and describe
Section 7: Lab: Selecting, Filtering and Calculating
- Filter data by conditions and with query
- Sort and rank data
- Calculate between columns and align data by index
- apply, map and value_counts
- Lab: find best-selling products and frequent customers
Section 8: Lab: Reading and Writing Data Files
- Read and write CSV, including Thai text and other delimiters
- Read Excel files with several sheets using openpyxl
- JSON data and tables from web pages with read_html
- Read large files in chunks and save as Parquet
- Lab: combine sales from several files into one table
Section 9: Lab: Data Cleaning, Part 1
- Find and handle missing values with isna, dropna and fillna
- Remove duplicates and replace wrong values
- Convert data types and rename columns
- Detect and handle outliers
- Lab: clean survey data
Section 10: Lab: Data Cleaning, Part 2
- Work with text using .str and regular expressions
- Parse dates with to_datetime and extract year, month and day
- Categorical data and reducing memory use
- Bin data with cut and create dummy variables
- Lab: prepare customer data for analysis