Offered by CodeStep Academy

Python for Data Science & Automation

34 lessons · Free · Certificate on completion

Start Course for Free

What you'll learn

Module 1: Foundational Programming & Environment Setup

  • 1.1 Setting Up the Python Data Science Lab
  • 1.2 Python Core Syntax & Variables
  • 1.3 Decision Making & Loops
  • 1.4 Advanced Data Collections
  • 1.5 Modular Code & Errors

Module 2: Numerical Computing with NumPy

  • 2.1 Introduction to NumPy ndarray
  • 2.2 Array Creation & Manipulation
  • 2.3 NumPy Array Indexing & Slicing
  • 2.4 Vectorized Operations in NumPy
  • 2.5 Statistical Operations & Linear Algebra with NumPy

Module 3: Data Manipulation & Engineering with Pandas

  • 3.1 Data Structures — Pandas Series & DataFrames
  • 3.2 Ingesting Data — Read CSV, Excel, JSON & SQL into Pandas
  • 3.3 Data Inspection — Understand a Dataset with Pandas
  • 3.4 Data Cleaning Pipelines — Handle Missing Values, Duplicates & Text Data
  • 3.5 Transformation & Aggregation — GroupBy, Pivot Tables, Merge, Join & Concatenation

Module 4: Exploratory Data Analysis (EDA) & Visualization

  • 4.1 Core Visualization with Matplotlib
  • 4.2 Statistical Data Visualization with Seaborn
  • 4.3 Interactive Data Visuals with Plotly
  • 4.4 Structured EDA Framework: Step-by-Step Workflow to Explore Any Dataset

Module 5: Core Automation & Scripting

  • 5.1 File System & OS Automation
  • 5.2 Office Document Automation
  • 5.3 Web Scraping Pipelines
  • 5.4 Browser Automation with Selenium
  • 5.5 API & Web Service Interaction with Python

Module 6: Capstone Projects & Task Scheduling

  • 6.1 Desktop Script Deployment: Schedule Python Scripts Automatically
  • 6.2 Project 1 — Data Analytics Pipeline
  • 6.3 Project 2 — End-to-End Python Automation Pipeline

Module 7: Python SQL & Database Integration

  • 7.1 Python with SQLite — Complete Database Tutorial
  • 7.2 Connecting Python to MySQL
  • 7.3 Python Database CRUD Operations - Complete Tutorial
  • 7.4 Python Database Transactions & Error Handling
  • 7.5 Python Database Design, Relationships & Joins
  • 7.6 Python Database Views, Stored Procedures & Advanced SQL
  • 7.7 Python Database Performance, Indexing & Query Optimization

Lessons unlock one at a time as you progress through the course.