Course Outline
Python Fundamentals for Data Tasks
- Installing Python and configuring the development environment
- Core language elements: variables, data types, and control structures
- Composing 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 format conversions
Getting Started with Pandas
- DataFrame essentials: creation, indexing, selection, and filtering
- Aggregation and grouping workflows
- Standard cleaning tasks: handling missing values, duplicates, and type conversions
Getting Started with Polars
- Polars concepts and performance benchmarks compared to Pandas
- Fundamental 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
- Optimized data processing patterns using 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-level or task schedulers
- Implementing logging, error handling, and notification systems
Script Packaging and Best Practices
- Creating executables using PyInstaller or comparable tools
- Project structure, virtual environments, and dependency management
- Version control fundamentals and workflow documentation
Hands-on Mini-Project
- End-to-end scenario: ingesting raw files, cleaning and transforming data, and generating outputs
- Automating the workflow and packaging it as a runnable script or executable
- Peer review and iterative improvements
Conclusion and Next Steps
Requirements
- Basic familiarity with programming concepts or a strong willingness to learn
- Proficiency in using the command line or terminal for package installation
- Experience working with spreadsheet formats (CSV/Excel)
Target Audience
- Data analysts and operations staff looking to automate data tasks
- Analytical engineers seeking lightweight ETL scripting solutions
- Professionals interested in practical, Python-based data workflows
Testimonials (3)
everything was perfect
Florin Vrincianu
Course - Python Programming Fundamentals
The adaptation of exos to our context and the consideration of our request
Amel Guetat - EURO-INFORMATION DEVELOPPEMENTS
Course - Fraud Detection with Python and TensorFlow
Machine Translated
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.
