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 16 hours
Course Outline
Module 1: Pandas functions for working with DataFrames
-
Introduction to Pandas
- Basic data structures: Series and DataFrame
-
DataFrame operations
- Reading and writing data (CSV, Excel, etc.)
- Fundamental operations (selection, filtering, indexing)
-
Data modification
- Adding, removing columns and rows
- Modifying values within a DataFrame
-
Data aggregation and grouping
- GroupBy
- Aggregation, summing, averaging, etc.
-
Joining and concatenating DataFrames
- merge, join, concat
-
Handling missing data
- Identifying missing data
- Methods for filling in missing data
Module 2: Optimising program execution time
-
Introduction to optimisation
- The importance of optimisation in programming
-
Code optimisation
- Efficient data structures
- Avoiding repetitive calculations
- Loop optimisation
-
Pandas optimisation
- Vectorised operations
- Avoiding apply and lambda
- Working with large datasets
-
Simplifying code through function creation
- Creating and using functions
- Refactoring code
Module 3: Working with the NumPy library
-
Introduction to NumPy
- Importing the library
- Basic data structures: ndarray
-
Array operations
- Creating and modifying arrays
- Indexing and slicing arrays
-
Mathematical and statistical functions
- Basic mathematical operations
- Statistical and aggregate functions
-
Linear algebra
- Matrix multiplication
- Determinant, inverse matrix
-
Working with multidimensional data
- 2D, 3D, and higher-dimensional arrays
- Reshaping arrays
- 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)
- Using matplotlib to generate charts
- Saving charts as PNG files
- Advanced charts in Excel
-
Automating reports
- Creating automated reports with charts
- Combining Pandas with openpyxl/xlsxwriter
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 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
