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.
Duration 14 hours
Course Outline
Python Foundations for Data Tasks
- Python installation and development environment setup
- Core language elements: variables, data types, and control structures
- Writing and executing basic Python scripts
File Handling: CSV and Excel
- Reading and writing CSV files via the csv module and Pandas
- Processing Excel files using openpyxl/xlrd and Pandas
- Practical exercise: automating file format conversions
Getting Started with Pandas
- DataFrame fundamentals: creation, indexing, selection, and filtering
- Executing aggregation and grouping tasks
- Standard cleaning operations: handling missing values, duplicates, and type conversion
Getting Started with Polars
- Understanding Polars concepts and performance metrics relative to Pandas
- Basic DataFrame operations within Polars
- Application example: deciding when to prefer Polars over Pandas
Advanced Data Transformation (Intermediate)
- Complex joins, window functions, and pivot operations in Pandas
- Efficient data processing patterns using Polars
- Chaining operations and memory usage optimization
Workflow 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
- Building executables using PyInstaller or similar tools
- Project organization, virtual environments, and dependency management
- Basics of version control and workflow documentation
Practical Mini-Project
- End-to-end task: reading raw files, cleaning and transforming data, and generating outputs
- Automating the workflow and packaging it as an executable script
- Review and refinements based on peer feedback
Summary and Future Directions
Requirements
- Basic knowledge of programming concepts or a strong eagerness to learn
- Proficiency in using the command line or terminal for package installation
- Experience with spreadsheet formats such as CSV or Excel
Target Audience
- Data analysts and operations teams looking to automate data tasks
- Analytics engineers seeking lightweight ETL scripting solutions
- Professionals interested in practical, Python-based data workflows
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.
