---
title: "pandas"
description: "pandas is a powerful, open-source data manipulation and analysis library for Python."
canonical: "https://motherduck.com/glossary/pandas/"
related:
  - title: "DuckDB vs Pandas vs Polars for Python Developers"
    url: "https://motherduck.com/blog/duckdb-versus-pandas-versus-polars/"
  - title: "DuckLake | MotherDuck Docs"
    url: "https://motherduck.com/docs/concepts/ducklake/"
  - title: "Loading data to MotherDuck with Python | MotherDuck Docs"
    url: "https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-md-python/"
gated_asset:
  title: "DuckLake on MotherDuck"
  url: "https://motherduck.com/product/ducklake/"
---

# pandas

> pandas is a powerful, open-source data manipulation and analysis library for Python.

[pandas](https://pandas.pydata.org/) is a powerful, open-source data manipulation and analysis library for Python. It provides high-performance, easy-to-use data structures and tools designed to make working with structured data both intuitive and efficient. At its core, pandas offers two main data structures: Series (one-dimensional) and DataFrame (two-dimensional), which allow users to handle labeled and relational data with ease. 

Data analysts and engineers frequently use pandas for tasks such as reading and writing data in various formats (CSV, Excel, JSON, SQL databases), cleaning and transforming datasets, merging and joining data from different sources, and performing complex aggregations and time series analysis. The library's integration with other scientific computing tools in the Python ecosystem, such as NumPy and Matplotlib, makes it an essential component of many data science workflows.

<glossary-callout guide="duckdb-book-brief" />

Pandas excels at handling missing data, reshaping datasets, and implementing sophisticated indexing operations. Its powerful groupby functionality enables split-apply-combine operations, which are crucial for data aggregation and analysis. For aspiring data professionals, mastering pandas is often considered a fundamental skill, as it provides a solid foundation for more advanced data science and machine learning tasks.



**Watch:** [DuckDB vs Pandas vs Polars: Performance Comparison for Python](https://motherduck.com/videos/duckdb-vs-pandas-vs-polars-for-python-devs/)