Get in Touch

Course Outline

Python Fundamentals for Data Tasks

  • Installing Python and configuring the development environment
  • Core language concepts: variables, data types, and control structures
  • Writing and executing basic Python scripts

File Handling: CSV and Excel

  • Reading and writing CSV files using the csv module and Pandas
  • Managing Excel files using openpyxl/xlrd and Pandas
  • Practical exercises: Automating file conversions

Introduction to Pandas

  • DataFrame essentials: creation, indexing, selection, and filtering
  • Aggregation and grouping operations
  • Standard cleaning operations: handling missing values, duplicates, and type conversions

Introduction to Polars

  • Polars concepts and performance characteristics relative to Pandas
  • Basic DataFrame operations within Polars
  • Case study: Determining when to prefer Polars over Pandas

Advanced Data Transformation (Intermediate Level)

  • Complex joins, window functions, and pivot operations in Pandas
  • Efficient data processing patterns with Polars
  • Operation chaining and memory usage optimization

Process Automation with Python

  • Developing scripts to automate repetitive data tasks and ETL steps
  • Scheduling scripts using OS or task schedulers
  • Implementing logging, error handling, and notifications

Script Packaging and Best Practices

  • Creating executables using PyInstaller or comparable tools
  • Project structuring, virtual environments, and dependency management
  • Foundations of version control and workflow documentation

Hands-on Mini-Project

  • End-to-end task: Ingest raw files, clean and transform data, and generate outputs
  • Automate the workflow and package it as a runnable script or executable
  • Review and refine based on peer feedback

Summary and Future Steps

Requirements

  • Familiarity with basic programming concepts or a strong willingness to learn
  • Comfortable using command-line or terminal for package installation
  • Experience handling spreadsheets (CSV/Excel)

Target Audience

  • Data analysts and operations staff automating data tasks
  • Analytical engineers seeking lightweight ETL scripting solutions
  • Professionals interested in practical Python-based data workflows
 14 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories