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 DataFrame Management
-
Overview of the Pandas Library
- Fundamental data structures: Series and DataFrames
-
DataFrame Manipulations
- Ingestion and export of data (CSV, Excel, and other formats)
- Essential operations (data selection, filtering, and indexing)
-
Data Alteration
- Insertion and deletion of rows and columns
- Modification of values within a DataFrame
-
Data Aggregation and Grouping
- Use of the GroupBy method
- Calculations for aggregation, totals, and mean values
-
Combining and Merging DataFrames
- Utilization of merge, join, and concat functions
-
Management of Missing Data
- Detection of null values
- Techniques for imputing absent data points
Module 2: Enhancing Program Execution Efficiency
-
Fundamentals of Optimization
- The significance of performance optimization in programming
-
Code-Level Optimization
- Selection of efficient data structures
- Elimination of redundant computations
- Optimization of loop structures
-
Pandas-Specific Optimization
- Vectorized execution of operations
- Avoidance of apply and lambda functions where possible
- Strategies for handling large-scale datasets
-
Code Simplification via Function Development
- Creation and implementation of modular functions
- Process of code refactoring
Module 3: Utilization of the NumPy Library
-
Introduction to NumPy
- Importing the library
- Core data structure: ndarray
-
Array Operations
- Initialization and modification of arrays
- Array indexing and slicing techniques
-
Mathematical and Statistical Functions
- Execution of basic mathematical operations
- Application of statistical and aggregate functions
-
Linear Algebra
- Matrix multiplication
- Calculation of determinants and inverse matrices
-
Handling of Multidimensional Data
- Management of 2D, 3D, and higher-order arrays
- Reshaping array dimensions
- Integration with Supplementary Libraries
Module 4: Chart Generation in Excel via Python
- Overview of openpyxl and xlsxwriter
-
Construction of Excel Charts
- Creation of standard charts (line, bar, etc.)
- Configuration of chart formatting
-
Export of Charts as Images (PNG)
- Utilization of matplotlib for visual generation
- Saving outputs as PNG files
- Development of Advanced Excel Charts
-
Report Automation
- Generation of automated reports featuring embedded charts
- Integration of Pandas with openpyxl or xlsxwriter