- An understanding of ___.
- Experience with ___.
- ___ programming experience.
Audience
- ___
- ___
- ___
Day 1 - 2
1. Introduction to Python
a. Running Python code
b. Using Python Development Tools (IDEs and command line tools)
c. Working with Jupyter Notebook
d. Python 2 vs Python 3
2. Data Types and Operations
a. Variables and assignments
b. Integers and floats
c. Strings and bytes
d. Tuples and lists
e. Dictionaries and ordered dictionaries
f. Sets and frozen sets
3. Loops and conditional execution
a. If statement
b. For loop
c. While loop
d. List comprehension
4. Object Oriented and Functional Programming
a. Creating and using functions and classes
b. Modifying functions and classes with decorators
c. Lambda expressions
d. Creating modules
5. Error Handling and Testing
a. Handling and raising exceptions
b. Writing and executing tests (doc tests and unit tests)
6. Accessing Databases
a. Connecting to database using SQLAlchemy
b. Executing queries - selecting, inserting, updating and deleting data
c. Importing data into Python
7. Working with files
a. Accessing files and folders with the os module
b. Reading and writing .csv, .txt, .xlsx, .html and .json files
Day 3 (optional)
1. NumPy – Numerical Python library
a. Arrays
b. Vectorized operations
2. Introduction to pandas – data wrangling library
a. Basic data types– Series, DataFrame, Index
b. Data operations– indexing, selecting, filtering, function mapping, sorting, ranking, NaN, reindexing
c. Exploratory analysis – descriptive statistics, correlations, covariance, unique values
d. Missing values – filtering, imputation, working with NULL values
3. Merging, joining and reshaping data
a. Merge, Join – Combining data from different sources
b. Reshaping data – hierarchical index
c. Creating Pivot tables
d. Aggregating and grouping data