{{ header }} .. _api.dataframe: ========= DataFrame ========= .. currentmodule:: pandas Constructor ~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame Attributes and underlying data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ **Axes** .. autosummary:: :toctree: api/ DataFrame.index DataFrame.columns .. autosummary:: :toctree: api/ DataFrame.dtypes DataFrame.info DataFrame.select_dtypes DataFrame.values DataFrame.axes DataFrame.ndim DataFrame.size DataFrame.shape DataFrame.memory_usage DataFrame.empty DataFrame.set_flags Conversion ~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.astype DataFrame.convert_dtypes DataFrame.infer_objects DataFrame.copy DataFrame.to_numpy Indexing, iteration ~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.head DataFrame.at DataFrame.iat DataFrame.loc DataFrame.iloc DataFrame.insert DataFrame.__iter__ DataFrame.items DataFrame.keys DataFrame.iterrows DataFrame.itertuples DataFrame.pop DataFrame.tail DataFrame.xs DataFrame.get DataFrame.isin DataFrame.where DataFrame.mask DataFrame.query DataFrame.isetitem For more information on ``.at``, ``.iat``, ``.loc``, and ``.iloc``, see the :ref:`indexing documentation `. Binary operator functions ~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.__add__ DataFrame.add DataFrame.sub DataFrame.mul DataFrame.div DataFrame.truediv DataFrame.floordiv DataFrame.mod DataFrame.pow DataFrame.dot DataFrame.radd DataFrame.rsub DataFrame.rmul DataFrame.rdiv DataFrame.rtruediv DataFrame.rfloordiv DataFrame.rmod DataFrame.rpow DataFrame.lt DataFrame.gt DataFrame.le DataFrame.ge DataFrame.ne DataFrame.eq DataFrame.combine DataFrame.combine_first Function application, GroupBy & window ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.apply DataFrame.map DataFrame.pipe DataFrame.agg DataFrame.aggregate DataFrame.transform DataFrame.groupby DataFrame.rolling DataFrame.expanding DataFrame.ewm .. _api.dataframe.stats: Computations / descriptive stats ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.abs DataFrame.all DataFrame.any DataFrame.clip DataFrame.corr DataFrame.corrwith DataFrame.count DataFrame.cov DataFrame.cummax DataFrame.cummin DataFrame.cumprod DataFrame.cumsum DataFrame.describe DataFrame.diff DataFrame.eval DataFrame.kurt DataFrame.kurtosis DataFrame.max DataFrame.mean DataFrame.median DataFrame.min DataFrame.mode DataFrame.pct_change DataFrame.prod DataFrame.product DataFrame.quantile DataFrame.rank DataFrame.round DataFrame.sem DataFrame.skew DataFrame.sum DataFrame.std DataFrame.var DataFrame.nunique DataFrame.value_counts Reindexing / selection / label manipulation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.add_prefix DataFrame.add_suffix DataFrame.align DataFrame.at_time DataFrame.between_time DataFrame.drop DataFrame.drop_duplicates DataFrame.duplicated DataFrame.equals DataFrame.filter DataFrame.head DataFrame.idxmax DataFrame.idxmin DataFrame.reindex DataFrame.reindex_like DataFrame.rename DataFrame.rename_axis DataFrame.reset_index DataFrame.sample DataFrame.set_axis DataFrame.set_index DataFrame.tail DataFrame.take DataFrame.truncate .. _api.dataframe.missing: Missing data handling ~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.bfill DataFrame.dropna DataFrame.ffill DataFrame.fillna DataFrame.interpolate DataFrame.isna DataFrame.isnull DataFrame.notna DataFrame.notnull DataFrame.replace Reshaping, sorting, transposing ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.droplevel DataFrame.pivot DataFrame.pivot_table DataFrame.reorder_levels DataFrame.sort_values DataFrame.sort_index DataFrame.nlargest DataFrame.nsmallest DataFrame.swaplevel DataFrame.stack DataFrame.unstack DataFrame.melt DataFrame.explode DataFrame.squeeze DataFrame.to_xarray DataFrame.T DataFrame.transpose Combining / comparing / joining / merging ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.assign DataFrame.compare DataFrame.join DataFrame.merge DataFrame.update Time Series-related ~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.asfreq DataFrame.asof DataFrame.shift DataFrame.first_valid_index DataFrame.last_valid_index DataFrame.resample DataFrame.to_period DataFrame.to_timestamp DataFrame.tz_convert DataFrame.tz_localize .. _api.frame.flags: Flags ~~~~~ Flags refer to attributes of the pandas object. Properties of the dataset (like the date is was recorded, the URL it was accessed from, etc.) should be stored in :attr:`DataFrame.attrs`. .. autosummary:: :toctree: api/ Flags .. _api.frame.metadata: Metadata ~~~~~~~~ :attr:`DataFrame.attrs` is a dictionary for storing global metadata for this DataFrame. .. warning:: ``DataFrame.attrs`` is considered experimental and may change without warning. .. autosummary:: :toctree: api/ DataFrame.attrs .. _api.dataframe.plotting: Plotting ~~~~~~~~ ``DataFrame.plot`` is both a callable method and a namespace attribute for specific plotting methods of the form ``DataFrame.plot.``. .. autosummary:: :toctree: api/ :template: autosummary/accessor_callable.rst DataFrame.plot .. autosummary:: :toctree: api/ :template: autosummary/accessor_method.rst DataFrame.plot.area DataFrame.plot.bar DataFrame.plot.barh DataFrame.plot.box DataFrame.plot.density DataFrame.plot.hexbin DataFrame.plot.hist DataFrame.plot.kde DataFrame.plot.line DataFrame.plot.pie DataFrame.plot.scatter .. autosummary:: :toctree: api/ DataFrame.boxplot DataFrame.hist .. _api.frame.sparse: Sparse accessor ~~~~~~~~~~~~~~~ Sparse-dtype specific methods and attributes are provided under the ``DataFrame.sparse`` accessor. .. autosummary:: :toctree: api/ :template: autosummary/accessor_attribute.rst DataFrame.sparse.density .. autosummary:: :toctree: api/ :template: autosummary/accessor_method.rst DataFrame.sparse.from_spmatrix DataFrame.sparse.to_coo DataFrame.sparse.to_dense Serialization / IO / conversion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: api/ DataFrame.from_dict DataFrame.from_records DataFrame.to_orc DataFrame.to_parquet DataFrame.to_pickle DataFrame.to_csv DataFrame.to_hdf DataFrame.to_sql DataFrame.to_dict DataFrame.to_excel DataFrame.to_json DataFrame.to_html DataFrame.to_feather DataFrame.to_latex DataFrame.to_stata DataFrame.to_records DataFrame.to_string DataFrame.to_clipboard DataFrame.to_markdown DataFrame.style DataFrame.__dataframe__