Get in Touch
 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

Number of participants


Price per participant

Upcoming Courses

Related Categories