pandas documentation

View original course

38 study materials · 7 sections

This DeepWiki provides a comprehensive guide to the pandas library, version 3.0.2, based on its official documentation. It is designed to take learners from installation and foundational concepts, such as the DataFrame and Series data structures, through hands-on tutorials on data wrangling, manipulation, and visualization. The course also includes advanced topics like time series analysis, guides for users transitioning from other tools like SQL and R, and resources for developers looking to master the API or contribute to the project.

Course Sections

Introduction to pandas

Key concepts: Installation (conda/pip) · Virtual Environments · Primary Data Structures (Series & DataFrame) · Core Features for Data Manipulation · Data Representation

This section introduces the pandas library, covering its purpose, core data structures (DataFrame and Series), and installation. It provides the foundational knowledge needed to understand why and how pandas is used for data analysis in Python.

Core Data Wrangling: A Hands-On Guide

Key concepts: Data I/O (read_csv, to_excel) · Subsetting & Filtering (loc, iloc) · Column Creation & Renaming · Grouping & Aggregation (groupby) · Combining & Merging Data (concat, merge) · Reshaping Data (pivot, melt) · Data Visualization (plot)

A practical, hands-on guide covering the most essential data manipulation tasks. This section walks through reading/writing data, selecting subsets, creating new columns, calculating statistics, reshaping tables, and combining data from multiple sources.

Advanced Data Handling: Time Series and Text

Key concepts: Time Series Conversion (pd.to_datetime) · Datetime Properties (.dt accessor) · DatetimeIndex and Slicing · Time Frequency Resampling (.resample) · Vectorized String Operations (.str accessor) · String Splitting and Filtering

This section dives into specialized techniques for handling two common but complex data types: time series and text. You will learn how to leverage pandas' built-in functionalities to parse dates, perform time-based analysis, and manipulate string data efficiently.

Comparing pandas with Other Data Tools

Key concepts: Comparison with R (dplyr) · Comparison with SQL (SELECT, WHERE, GROUP BY) · Comparison with Spreadsheets · Comparison with SAS/Stata/SPSS · Terminology Mapping · Syntax Translation

A translation guide for users familiar with other data analysis tools like R, SQL, SAS, and spreadsheets. This section maps common operations and terminology from those environments to their pandas equivalents, accelerating the learning curve for experienced analysts.

Essential Guides and References

Key concepts: User Guide · API Reference · Cheat Sheet · Data Structures · Indexing and Selecting Data

A curated list of the most important guides and reference materials for both quick lookups and in-depth learning. This section points you to the comprehensive User Guide, a fast-paced '10 minutes' tutorial, and a handy cheat sheet.

API Reference and Contribution Guide

Key concepts: Public vs. Private API · Contribution Workflow · Development Environment Setup · Code and Documentation Standards · Software Versioning · Release Notes

For advanced users and developers, this section covers the complete public API, the project's development lifecycle, and how to contribute to the pandas library. It also includes information on release notes to track the library's evolution.

Community Tutorials and Next Steps

Key concepts: Beginner-friendly tutorials · Real-world data examples · Diverse learning formats (cookbooks, workshops, videos)

A collection of tutorials, workshops, and articles created by the pandas community. These resources are aimed at new users and often use real-world datasets to demonstrate fundamental and advanced concepts in diverse formats.

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