Python for Data Analysts – Core Skills

Setting Up Python and Running Your First Script

Variables and Core Data Types

Working with Text: Strings and Formatting

Lists: Storing Ordered Data

Tuples and Sets: Fixed Records and Unique Values

Dictionaries: Key-Value Records

Making Decisions: if, elif and else

Repeating Work: for and while Loops

List and Dictionary Comprehensions

Functions: Packaging Reusable Analysis Steps

Handling Errors with try and except

Modules and the Python Standard Library

Reading and Writing Files, Including CSV

NumPy Arrays: Fast Numeric Computation

pandas Series and DataFrames: Loading Your Data

Selecting, Filtering and Sorting in pandas

Cleaning Data: Missing Values, Types and Duplicates

Grouping and Aggregating with groupby

Combining Datasets with merge and concat

Visualising Results with Matplotlib