Get in Touch

Course Outline

Python Fundamentals for Data Operations

  • 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.
  • Manipulating Excel files using openpyxl/xlrd and Pandas.
  • Practical exercises: automating file conversions.

Introduction to Pandas

  • DataFrame basics: creation, indexing, selection, and filtering.
  • Aggregation and grouping operations.
  • Common cleaning operations: handling missing values, duplicates, and type conversions.

Introduction to Polars

  • Understanding Polars concepts and its performance characteristics compared to Pandas.
  • Basic DataFrame operations in Polars.
  • Use-case example: determining when to choose Polars over Pandas.

Advanced Data Transformation (Intermediate)

  • Complex joins, window functions, and pivot operations in Pandas.
  • Efficient data processing patterns with Polars.
  • Chaining operations and optimizing memory usage.

Process Automation with Python

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

Packaging Scripts and Best Practices

  • Creating executables with PyInstaller or similar tools.
  • Project structuring, virtual environments, and dependency management.
  • Basics of version control and documenting workflows.

Hands-on Mini-Project

  • End-to-end task: reading raw files, cleaning and transforming data, and generating outputs.
  • Automating the workflow and packaging it as a runnable script or executable.
  • Review and improvements based on peer feedback.

Summary and Next Steps

Requirements

  • Basic understanding of programming concepts or eagerness to learn.
  • Comfort with using the command line or terminal for package installation.
  • Experience working with spreadsheets (CSV/Excel).

Audience

  • Data analysts and operations staff automating data tasks.
  • Analytical engineers looking for 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