Getting Started
Install GPandas and run your first data analysis program
Loading CSV Files
Learn how to load CSV files into a DataFrame using gpandas.Read_csv()
Creating DataFrames
Build DataFrames from in-memory data using the DataFrame constructor
SQL Integration
Connect to SQL databases and Google BigQuery to load data into DataFrames
JSON, Excel & Parquet I/O
Read and write DataFrames as JSON records, Excel (.xlsx) spreadsheets, and Parquet files
DataFrame Operations
Select columns, rename, display, and export DataFrames
Adding Columns
Add, replace, compute, and insert DataFrame columns in place with Assign, AssignFunc, and Insert
Transforming Columns
Transform DataFrame values element-wise, remap values, and derive new columns row-wise
Handling Missing Data
Detect, fill, and drop null values in DataFrames with FillNA, DropNA, IsNA, and NotNA
Unique Values & Deduplication
Find distinct values, count cardinality, and remove duplicate rows with Unique, NUnique, Duplicated, …
Merging Data
Join and combine DataFrames using inner, left, right, and full outer merges
Type Casting & Inspection
Convert column types with AsType and inspect a DataFrame's structure with DTypes and Info
Sorting Data
Sort DataFrames by column values or index labels with flexible ordering options
Filtering Data
Subset DataFrame rows by comparison or predicate using chainable, error-deferred filters
Correlation, Sampling & Pipe
Compute correlation and covariance matrices, draw random samples, and chain operations with Pipe
Summary Statistics
Describe numeric columns and compute aggregations, null counts, and value frequencies
Label-based Indexing (Loc)
Access DataFrame data using row labels and column names with Loc()
Pivot and Melt
Reshape DataFrames between wide and long formats using pivot tables and melt operations
Grouping & Aggregation
Group rows by column values and compute aggregations, including multiple functions per column with …
Window Functions
Compute rolling aggregations, shift values, and run cumulative operations for time-series analysis
Stacking & MultiIndex
Reshape between wide and long with Stack and Unstack, and build composite indexes with SetMultiIndex
String Methods
Vectorized string operations on columns with the Str accessor: case, trim, contains, replace, and …
Plotting Charts
Visualize DataFrame data with interactive bar, line, pie, scatter, histogram, and heatmap charts
Position-based Indexing (iLoc)
Access DataFrame data using integer positions with ILoc()
DateTime
Parse string columns into datetimes and extract components like year, month, and weekday
Categorical Data
Convert repetitive string columns to a memory-efficient categorical type backed by integer codes
Series
The fundamental column type in GPandas with dtype enforcement and thread-safety