Scribd
Upload
13 views1 page

Python Pandas Guide for Beginners

The document outlines a comprehensive guide to getting started with Python Pandas, covering setup in both Google Colab and local environments. It includes topics such as creating and manipulating DataFrames, data access methods, filtering, aggregating, and handling null values. Additionally, it highlights new functionalities in Pandas 2.0 and suggests next steps for further learning.

Uploaded by

boddeti2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views1 page

Python Pandas Guide for Beginners

The document outlines a comprehensive guide to getting started with Python Pandas, covering setup in both Google Colab and local environments. It includes topics such as creating and manipulating DataFrames, data access methods, filtering, aggregating, and handling null values. Additionally, it highlights new functionalities in Pandas 2.0 and suggests next steps for further learning.

Uploaded by

boddeti2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

 Getting Started with Python Pandas | Google Colab

 Getting Started with Python Pandas | Local Environment Setup (Cloning code, using virtual
environment, VS Code)
 Intro to Dataframes | Creating DataFrames, Index/Columns, Basic Functionality
 Loading in DataFrames from Files (CSV, Excel, Parquet, etc.)
 Accessing Data | .head() .tail() .sample()
 Accessing Data | .loc() .iloc()
 Setting DataFrame Values w/ loc() & iloc()
 Accessing Single Values | .at() .iat()
 Accessing Data | Grab Columns, Sort Values, Ascending/Descending
 Iterating over a DataFrame (df) with a For Loop | [Link]()
 Filtering Data | Syntax Options, Numeric Values, Multiple Conditions
 Filtering Data | String Operations, Regular Expressions (Regex)
 Filtering Data | Query Functions
 Adding / Removing Columns | Basics, Conditional Values, Math Operations, Renaming
Columns
 Adding / Removing Columns | String Operations, Datetime (pd.to_datetime) Operations
 Saving our Updated DataFrame (df.to_csv, df.to_excel, df.to_parquet, etc)
 Adding / Removing Columns | Using Lambda & Custom Functions w/ .apply()
 Merging & Concatenating Data | [Link](), [Link](), types of joins
 Handling Null Values (NaNs) | .fillna() .interpolate() .dropna() .isna() .notna()
 Aggregating Data | value_counts()
 Aggregating Data | Using Groupby - groupby() .sum() .mean() .agg()
 Aggregating Data | Pivot Tables
 Groupby combined with Datetime Operations
 Advanced Functionality | .shift() .rank() .cumsum() .rolling()
 New Functionality | Pandas 1.0 vs Pandas 2.0 – pyarrow
 New Functionality | GitHub Copilot & OpenAI ChatGPT
 What Next?? | Continuing your Python Pandas Learning…

You might also like