API reference

This page gives an overview of all public pandas objects, functions and methods. All classes and functions exposed in pandas.* namespace are public.

Some subpackages are public which include pandas.errors, pandas.plotting, and pandas.testing. Public functions in pandas.io and pandas.tseries submodules are mentioned in the documentation. pandas.api.types subpackage holds some public functions related to data types in pandas.

Warning

The pandas.core, pandas.compat, and pandas.util top-level modules are PRIVATE. Stable functionality in such modules is not guaranteed.

• Input/output
  • Pickling
  • Flat file
  • Clipboard
  • Excel
  • JSON
  • HTML
  • HDFStore: PyTables (HDF5)
  • Feather
  • Parquet
  • ORC
  • SAS
  • SPSS
  • SQL
  • Google BigQuery
  • STATA
• General functions
  • Data manipulations
  • Top-level missing data
  • Top-level conversions
  • Top-level dealing with datetimelike
  • Top-level dealing with intervals
  • Top-level evaluation
  • Hashing
  • Testing
• Series
  • Constructor
  • Attributes
  • Conversion
  • Indexing, iteration
  • Binary operator functions
  • Function application, GroupBy & window
  • Computations / descriptive stats
  • Reindexing / selection / label manipulation
  • Missing data handling
  • Reshaping, sorting
  • Combining / comparing / joining / merging
  • Time Series-related
  • Accessors
  • Plotting
  • Serialization / IO / conversion
• DataFrame
  • Constructor
  • Attributes and underlying data
  • Conversion
  • Indexing, iteration
  • Binary operator functions
  • Function application, GroupBy & window
  • Computations / descriptive stats
  • Reindexing / selection / label manipulation
  • Missing data handling
  • Reshaping, sorting, transposing
  • Combining / comparing / joining / merging
  • Time Series-related
  • Flags
  • Metadata
  • Plotting
  • Sparse accessor
  • Serialization / IO / conversion
• pandas arrays
  • pandas.array
  • Datetime data
  • Timedelta data
  • Timespan data
  • Period
  • Interval data
  • Nullable integer
  • Categorical data
  • Sparse data
  • Text data
  • Boolean data with missing values
• Index objects
  • Index
  • Numeric Index
  • CategoricalIndex
  • IntervalIndex
  • MultiIndex
  • DatetimeIndex
  • TimedeltaIndex
  • PeriodIndex
• Date offsets
  • DateOffset
  • BusinessDay
  • BusinessHour
  • CustomBusinessDay
  • CustomBusinessHour
  • MonthEnd
  • MonthBegin
  • BusinessMonthEnd
  • BusinessMonthBegin
  • CustomBusinessMonthEnd
  • CustomBusinessMonthBegin
  • SemiMonthEnd
  • SemiMonthBegin
  • Week
  • WeekOfMonth
  • LastWeekOfMonth
  • BQuarterEnd
  • BQuarterBegin
  • QuarterEnd
  • QuarterBegin
  • BYearEnd
  • BYearBegin
  • YearEnd
  • YearBegin
  • FY5253
  • FY5253Quarter
  • Easter
  • Tick
  • Day
  • Hour
  • Minute
  • Second
  • Milli
  • Micro
  • Nano
• Frequencies
  • pandas.tseries.frequencies.to_offset
• Window
  • Rolling window functions
  • Weighted window functions
  • Expanding window functions
  • Exponentially-weighted window functions
  • Window indexer
• GroupBy
  • Indexing, iteration
  • Function application
  • Computations / descriptive stats
• Resampling
  • Indexing, iteration
  • Function application
  • Upsampling
  • Computations / descriptive stats
• Style
  • Styler constructor
  • Styler properties
  • Style application
  • Builtin styles
  • Style export and import
• Plotting
  • pandas.plotting.andrews_curves
  • pandas.plotting.autocorrelation_plot
  • pandas.plotting.bootstrap_plot
  • pandas.plotting.boxplot
  • pandas.plotting.deregister_matplotlib_converters
  • pandas.plotting.lag_plot
  • pandas.plotting.parallel_coordinates
  • pandas.plotting.plot_params
  • pandas.plotting.radviz
  • pandas.plotting.register_matplotlib_converters
  • pandas.plotting.scatter_matrix
  • pandas.plotting.table
• General utility functions
  • Working with options
  • Testing functions
  • Exceptions and warnings
  • Data types related functionality
  • Bug report function
• Extensions
  • pandas.api.extensions.register_extension_dtype
  • pandas.api.extensions.register_dataframe_accessor
  • pandas.api.extensions.register_series_accessor
  • pandas.api.extensions.register_index_accessor
  • pandas.api.extensions.ExtensionDtype
  • pandas.api.extensions.ExtensionArray
  • pandas.arrays.PandasArray
  • pandas.api.indexers.check_array_indexer

Cookbook Input/output