.. currentmodule:: pandas .. _api: ************* API Reference ************* .. _api.functions: General functions ----------------- Data manipulations ~~~~~~~~~~~~~~~~~~ .. currentmodule:: pandas.tools.pivot .. autosummary:: :toctree: generated/ pivot_table .. currentmodule:: pandas.tools.merge .. autosummary:: :toctree: generated/ merge concat Pickling ~~~~~~~~ .. currentmodule:: pandas.core.common .. autosummary:: :toctree: generated/ load save File IO ~~~~~~~ .. currentmodule:: pandas.io.parsers .. autosummary:: :toctree: generated/ read_table read_csv ExcelFile.parse HDFStore: PyTables (HDF5) ~~~~~~~~~~~~~~~~~~~~~~~~~ .. currentmodule:: pandas.io.pytables .. autosummary:: :toctree: generated/ HDFStore.put HDFStore.get Standard moving window functions ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. currentmodule:: pandas.stats.moments .. autosummary:: :toctree: generated/ rolling_count rolling_sum rolling_mean rolling_median rolling_var rolling_std rolling_corr rolling_cov rolling_skew rolling_kurt rolling_apply rolling_quantile Standard expanding window functions ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. currentmodule:: pandas.stats.moments .. autosummary:: :toctree: generated/ expanding_count expanding_sum expanding_mean expanding_median expanding_var expanding_std expanding_corr expanding_cov expanding_skew expanding_kurt expanding_apply expanding_quantile Exponentially-weighted moving window functions ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ ewma ewmstd ewmvar ewmcorr ewmcov .. currentmodule:: pandas .. _api.series: Series ------ Attributes and underlying data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ **Axes** * **index**: axis labels .. autosummary:: :toctree: generated/ Series.values Series.dtype Series.isnull Series.notnull Conversion / Constructors ~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.__init__ Series.astype Series.copy Indexing, iteration ~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.get Series.ix Series.__iter__ Series.iteritems Binary operator functions ~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.add Series.div Series.mul Series.sub Series.combine Series.combine_first Series.round Function application, GroupBy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.apply Series.map Series.groupby .. _api.series.stats: Computations / Descriptive Stats ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.abs Series.any Series.autocorr Series.between Series.clip Series.clip_lower Series.clip_upper Series.corr Series.count Series.cov Series.cummax Series.cummin Series.cumprod Series.cumsum Series.describe Series.diff Series.kurt Series.mad Series.max Series.mean Series.median Series.min Series.nunique Series.pct_change Series.prod Series.quantile Series.rank Series.skew Series.std Series.sum Series.unique Series.var Series.value_counts Reindexing / Selection / Label manipulation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.align Series.drop Series.first Series.head Series.idxmax Series.idxmin Series.isin Series.last Series.reindex Series.reindex_like Series.rename Series.reset_index Series.select Series.take Series.tail Series.truncate Missing data handling ~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.dropna Series.fillna Series.interpolate Reshaping, sorting ~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.argsort Series.order Series.reorder_levels Series.sort Series.sort_index Series.sortlevel Series.swaplevel Series.unstack Combining / joining / merging ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.append Series.replace Series.update Time series-related ~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.asfreq Series.asof Series.shift Series.first_valid_index Series.last_valid_index Series.weekday Series.resample Series.tz_convert Series.tz_localize Plotting ~~~~~~~~ .. autosummary:: :toctree: generated/ Series.hist Series.plot Serialization / IO / Conversion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ Series.from_csv Series.load Series.save Series.to_csv Series.to_dict Series.to_sparse Series.to_string .. _api.dataframe: DataFrame --------- Attributes and underlying data ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ **Axes** * **index**: row labels * **columns**: column labels .. autosummary:: :toctree: generated/ DataFrame.as_matrix DataFrame.dtypes DataFrame.get_dtype_counts DataFrame.values DataFrame.axes DataFrame.ndim DataFrame.shape Conversion / Constructors ~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.__init__ DataFrame.astype DataFrame.convert_objects DataFrame.copy Indexing, iteration ~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.head DataFrame.ix DataFrame.insert DataFrame.__iter__ DataFrame.iteritems DataFrame.iterrows DataFrame.itertuples DataFrame.lookup DataFrame.pop DataFrame.tail DataFrame.xs Binary operator functions ~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.add DataFrame.div DataFrame.mul DataFrame.sub DataFrame.radd DataFrame.rdiv DataFrame.rmul DataFrame.rsub DataFrame.combine DataFrame.combineAdd DataFrame.combine_first DataFrame.combineMult Function application, GroupBy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.apply DataFrame.applymap DataFrame.groupby .. _api.dataframe.stats: Computations / Descriptive Stats ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.abs DataFrame.any DataFrame.clip DataFrame.clip_lower DataFrame.clip_upper DataFrame.corr DataFrame.corrwith DataFrame.count DataFrame.cov DataFrame.cummax DataFrame.cummin DataFrame.cumprod DataFrame.cumsum DataFrame.describe DataFrame.diff DataFrame.kurt DataFrame.mad DataFrame.max DataFrame.mean DataFrame.median DataFrame.min DataFrame.pct_change DataFrame.prod DataFrame.quantile DataFrame.rank DataFrame.skew DataFrame.sum DataFrame.std DataFrame.var Reindexing / Selection / Label manipulation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.add_prefix DataFrame.add_suffix DataFrame.align DataFrame.drop DataFrame.drop_duplicates DataFrame.duplicated DataFrame.filter DataFrame.first DataFrame.head DataFrame.idxmax DataFrame.idxmin DataFrame.last DataFrame.reindex DataFrame.reindex_axis DataFrame.reindex_like DataFrame.rename DataFrame.reset_index DataFrame.select DataFrame.set_index DataFrame.tail DataFrame.take DataFrame.truncate .. _api.dataframe.missing: Missing data handling ~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.dropna DataFrame.fillna Reshaping, sorting, transposing ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.delevel DataFrame.pivot DataFrame.reorder_levels DataFrame.sort DataFrame.sort_index DataFrame.sortlevel DataFrame.swaplevel DataFrame.stack DataFrame.unstack DataFrame.T DataFrame.to_panel DataFrame.transpose Combining / joining / merging ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.append DataFrame.join DataFrame.merge DataFrame.replace DataFrame.update Time series-related ~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.asfreq DataFrame.shift DataFrame.first_valid_index DataFrame.last_valid_index DataFrame.resample DataFrame.to_period DataFrame.to_timestamp DataFrame.tz_convert DataFrame.tz_localize Plotting ~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.boxplot DataFrame.hist DataFrame.plot Serialization / IO / Conversion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .. autosummary:: :toctree: generated/ DataFrame.from_csv DataFrame.from_dict DataFrame.from_items DataFrame.from_records DataFrame.info DataFrame.load DataFrame.save DataFrame.to_csv DataFrame.to_dict DataFrame.to_excel DataFrame.to_html DataFrame.to_records DataFrame.to_sparse DataFrame.to_string .. _api.panel: Panel ----- .. _api.panel.stats: Computations / Descriptive Stats ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~