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)
-
Modifying data
- Adding, removing columns and rows
- Modifying values in 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 imputing missing values
Module 2: Optimising program execution time
-
Introduction to optimisation
- The significance of optimisation in programming
-
Code optimisation
- Efficient data structures
- Avoiding redundant calculations
- Loop optimisation
-
Pandas optimisation
- Vectorising 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
- Basic data structures: ndarray
-
Array operations
- Creating and modifying arrays
- Indexing and slicing arrays
-
Mathematical and statistical functions
- Basic mathematical operations
- Statistical and aggregating functions
-
Linear algebra
- Matrix multiplication
- Determinant and 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 Excel charts
-
Report automation
- Creating automated reports with charts
- Integrating Pandas with openpyxl/xlsxwriter
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised 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