Course Outline
Python Fundamentals for Data Tasks
- Installing Python and configuring the development environment
- Core language concepts: variables, data types, and control structures
- Creating and executing basic Python scripts
File Management: CSV and Excel
- Reading and writing CSV files using the csv module and Pandas
- Handling Excel files via openpyxl/xlrd and Pandas
- Practical exercises: automating file conversion processes
Introduction to Pandas
- DataFrame fundamentals: creation, indexing, selection, and filtering
- Aggregation and grouping operations
- Standard cleaning procedures: managing missing values, duplicates, and type conversions
Introduction to Polars
- Polars concepts and performance characteristics relative to Pandas
- Essential DataFrame operations within Polars
- Use-case example: 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 using Polars
- Chaining operations and optimising memory usage
Process Automation with Python
- Developing scripts to automate repetitive data tasks and ETL steps
- Scheduling scripts using OS schedulers or task schedulers
- Implementing logging, error handling, and notification systems
Script Packaging and Best Practices
- Generating executables using PyInstaller or comparable tools
- Project structuring, virtual environments, and dependency management
- Version control fundamentals and documenting workflows
Hands-on Mini-Project
- End-to-end task: ingesting raw files, cleaning and transforming data, and generating outputs
- Automating the workflow and packaging it as a runnable script or executable
- Review and refinement based on peer feedback
Summary and Future Steps
Requirements
- Basic understanding of programming concepts or a strong willingness to learn
- Confidence in using the command-line or terminal for package installation
- Experience handling spreadsheet data (CSV/Excel)
Target Audience
- Data analysts and operations personnel seeking to automate data tasks
- Analytical engineers looking for lightweight ETL scripting solutions
- Professionals interested in implementing practical Python-based data workflows
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
everything was perfect
Florin Vrincianu
Course - Python Programming Fundamentals
Hands-on exercises related to content really helps to understand more about each topic. Also, style of start class with lecture and continue with hands-on exercise is good and helpful to relate with the lecture that presented earlier.
