Essential Numpy and Pandas
章节 1: Introduction to Data Handling in Python
What are Numpy and Pandas?
Importance for AI and Data Science
Setting Up Your Environment
Running Your First Code Snippets
Introduction to Jupyter Notebooks
Hands-on practical: Setup and Verification
章节 2: Getting Started with NumPy Arrays
Understanding NumPy N-dimensional Arrays
Creating Arrays from Python Lists
Built-in Array Creation Functions
Understanding Array Data Types
Hands-on practical: Creating and Inspecting Arrays
章节 3: NumPy Array Indexing and Slicing
Accessing Single Elements
Hands-on practical: Selecting Data from Arrays
章节 4: Fundamental NumPy Operations
Basic Arithmetic Operations
Introduction to Universal Functions (ufuncs)
Mathematical and Statistical Functions
Logical Operations on Arrays
Introduction to Broadcasting
Hands-on practical: Performing Calculations on Arrays
章节 5: Introduction to Pandas
Pandas Data Structure: Series
Pandas Data Structure: DataFrame
Hands-on practical: Creating and Examining Series/DataFrames
章节 6: Loading and Saving Data with Pandas
Reading Data from CSV Files
Reading Data from Excel Files
Reading Data from Other Formats
Writing Data to CSV Files
Writing Data to Excel Files
Hands-on practical: Importing and Exporting Datasets
章节 7: Data Selection and Indexing in Pandas
Selecting Rows Using Labels (.loc)
Selecting Rows Using Integer Position (.iloc)
Mixing Label and Position Based Indexing
Conditional Selection (Boolean Indexing)
Resetting DataFrame Index
Hands-on practical: Accessing Specific Data Subsets
章节 8: Basic Data Manipulation with Pandas
Handling Missing Data: Dropping
Handling Missing Data: Filling
Dropping Columns and Rows
Modifying Existing Columns
Hands-on practical: Cleaning and Modifying DataFrames
章节 9: Grouping and Aggregating Data
The Split-Apply-Combine Concept
Grouping Data with groupby()
Applying Aggregation Functions
Applying Multiple Aggregations
Grouping by Multiple Columns
Hands-on practical: Summarizing Data with GroupBy
章节 10: Combining DataFrames
Introduction to Combining Data
Concatenating DataFrames (pd.concat)
Database-Style Merging (pd.merge)
Understanding Merge Types (Joins)
Index-Based Joining (.join)
Hands-on practical: Combining Datasets