Cursusaanbod

Python Fundamentals for Data Tasks

  • Installing Python and setting up the development environment
  • Language fundamentals: variables, data types, control structures
  • Writing and running simple Python scripts

File Handling: CSV and Excel

  • Reading and writing CSV files using the csv module and Pandas
  • Working with 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: missing values, duplicates, and type conversions

Introduction to Polars

  • Polars concepts and performance characteristics compared to Pandas
  • Basic DataFrame operations in Polars
  • Use-case example: 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 with OS schedulers or task schedulers
  • Logging, error handling, and notifications

Packaging Scripts and Best Practices

  • Creating executables with PyInstaller or similar tools
  • Project structuring, virtual environments, and dependency management
  • Version control basics and documenting workflows

Hands-on Mini-Project

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

Summary and Next Steps

Vereisten

  • Basic familiarity with programming concepts or willingness to learn
  • Comfort using command-line or terminal for package installation
  • Experience working with spreadsheets (CSV/Excel)

Audience

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

Leveringsopties

PRIVÉGROEPSTRAINING

Onze identiteit draait om het leveren van precies wat onze klanten nodig hebben.

  • Pre-cursusgesprek met uw trainer
  • Aanpassing van de leerervaring om uw doelen te bereiken -
    • Op maat gemaakte overzichten
    • Praktische, praktische oefeningen met gegevens / scenario's die herkenbaar zijn voor de cursisten
  • Training gepland op een datum naar keuze
  • Gegeven online, op locatie/klaslokaal of hybride door experts die ervaring uit de echte wereld delen

Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Neem contact met ons op voor een exacte offerte en om onze laatste promoties te horen


OPENBARE TRAINING

Kijk op onze public courses

Reviews (5)

Voorlopige Aankomende Cursussen

Gerelateerde categorieën