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
Module 1: Pandas Functions in Data Frame Work
-
Introduction to Pandas
- Core data structures: Series and DataFrame
-
DataFrame Operations
- Loading and saving data (CSV, Excel, etc.)
- Basic operations (selection, filtering, indexing)
-
Data Modification
- Adding and removing columns and rows
- Modifying values within a DataFrame
-
Data Aggregation and Grouping
- GroupBy functionality
- Aggregation, summing, averaging, etc.
-
Combining and Merging DataFrames
- merge, join, concat
-
Handling Missing Data
- Identifying missing data
- Methods for filling missing data
Module 2: Program Execution Time Optimization
-
Introduction to Optimization
- The importance of optimization in programming
-
Code Optimization
- Efficient data structures
- Avoiding redundant computations
- Loop optimization
-
Pandas Optimization
- Vectorization of operations
- Avoiding apply and lambda
- Working with large datasets
-
Simplifying Code Through Function Creation
- Creating and using functions
- Code refactoring
Module 3: Working with the NumPy Library
-
Introduction to NumPy
- Importing the library
- Core data structures: ndarray
-
Array Operations
- Creating and modifying arrays
- Array indexing and slicing
-
Mathematical and Statistical Functions
- Basic mathematical operations
- Statistical and aggregating functions
-
Linear Algebra
- Matrix multiplication
- Determinant, inverse matrix
-
Working with Multi-dimensional Data
- 2D, 3D, and higher-dimensional arrays
- Array shape transformations
- Integration with Other Libraries
Module 4: Creating Charts in Excel Using Python
- Introduction to openpyxl and xlsxwriter
-
Creating Charts in Excel
- Creating simple charts (line, bar, etc.)
- Formatting charts
-
Generating Charts as Images (PNG)
- Utilizing matplotlib for chart generation
- Saving charts as PNG files
- Advanced Charts in Excel
-
Report Automation
- Creating automated reports with charts
- Integrating Pandas with openpyxl/xlsxwriter
16 Hours
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 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
