pandas documentation

View original course

38 study materials · 8 sections

Pandas is the definitive open-source Python library for high-performance data analysis and manipulation, centered around its powerful DataFrame and Series structures. This documentation course covers the entire ecosystem, from initial installation and basic data ingestion to advanced time-series analysis and performance optimization. It serves as a comprehensive bridge for users transitioning from SQL, Excel, or R into the Python data science stack.

Course Sections

Getting Started and Installation

Key concepts: Conda/pip installation · Virtual environments · Package dependencies · 10 minutes to pandas · Cheat sheet

Covers the foundational setup of pandas, including installation methods and a high-level overview of the library's capabilities.

Core Data Structures: Series and DataFrames

Key concepts: Series · DataFrame · Data Alignment · Index Labels · NaN handling

An in-depth look at the primary objects in pandas: the 1D Series and the 2D DataFrame.

Data Ingestion and Selection

Key concepts: read_csv · read_excel · Boolean indexing · loc vs iloc · isin() · notna()

Techniques for reading data from external files and navigating through datasets using labels and positions.

Data Manipulation and Summary Statistics

Key concepts: Vectorization · Split-Apply-Combine · Groupby · Summary Statistics · Renaming

Transforming data through mathematical operations, grouping, and statistical aggregation.

Reshaping and Combining Datasets

Key concepts: Pivot · Melt · Concat · Merge · Long vs Wide format

Advanced layout changes and merging multiple data sources into a single analysis-ready table.

Specialized Data: Time Series and Text

Key concepts: DatetimeIndex · Resampling · str accessor · dt accessor · Timedelta

Handling temporal data and performing string manipulations at scale.

Comparison with Other Tools

Key concepts: SQL-to-pandas mapping · dplyr equivalents · Spreadsheet translation · In-place vs Copy

A guide for users coming from SQL, R, Excel, SAS, Stata, or SPSS.

User Guide, API Reference, and Development

Key concepts: API Reference · Performance Optimization · Pull Request Workflow · Release Notes

Deep-dive resources for advanced performance tuning and contributing to the pandas codebase.

Source Materials

Study pandas documentation on Lykke

This course page is free to open: signed out, you can read its first two sections, and signing in, on any plan, opens the rest. The free Lykke Chrome extension syncs your own Canvas courses, so ChatGPT, Claude and Muse can answer from your classes and deadlines. It only reads Canvas.

Add the free extensionSign in to open every section

Browse more course pages