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 for Data Frame Work
-
Introduction to Pandas
- Fundamental 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
- Aggregation, summation, averages, etc.
-
Combining and Merging DataFrames
- merge, join, concat
-
Handling Missing Data
- Identifying missing data
- Techniques for imputing missing data
Module 2: Program Runtime Optimization
-
Introduction to Optimization
- The importance of optimization in programming
-
Code Optimization
- Efficient data structures
- Avoiding redundant calculations
- Loop optimization
-
Pandas Optimization
- Vectorizing operations
- Avoiding apply and lambda functions
- 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
- Fundamental data structures: ndarray
-
Array Operations
- Creating and modifying arrays
- Indexing and slicing arrays
-
Mathematical and Statistical Functions
- Basic mathematical operations
- Statistical and aggregation functions
-
Linear Algebra
- Matrix multiplication
- Determinant, inverse matrix
-
Multidimensional Data Handling
- 2D, 3D, and higher-dimensional arrays
- Array shape transformations
- Integration with Other Libraries
Module 4: Creating Excel Charts with Python
- Introduction to openpyxl and xlsxwriter
-
Creating Excel Charts
- Creating simple charts (line, bar, etc.)
- Chart formatting
-
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
16 Hours
