Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
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.