pandas documentation
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