Table of Contents

CategoricalIndex
- CategoricalIndex.add_categories()
- CategoricalIndex.as_ordered()
- CategoricalIndex.as_unordered()
- CategoricalIndex.categories
- CategoricalIndex.codes
- CategoricalIndex.map()
- CategoricalIndex.ordered
- CategoricalIndex.remove_categories()
- CategoricalIndex.remove_unused_categories()
- CategoricalIndex.rename_categories()
- CategoricalIndex.reorder_categories()
- CategoricalIndex.set_categories()
- CategoricalIndex[source]
DataFrame
- DataFrame()
- DataFrame.abs()
- DataFrame.add()
- DataFrame.add_prefix()
- DataFrame.add_suffix()
- DataFrame.agg()
- DataFrame.aggregate()
- DataFrame.align()
- DataFrame.all()
- DataFrame.any()
- DataFrame.append()
- DataFrame.apply()
- DataFrame.applymap()
- DataFrame.asfreq()
- DataFrame.asof()
- DataFrame.assign()
- DataFrame.astype()
- DataFrame.as_blocks()
- DataFrame.as_matrix()
- DataFrame.at
- DataFrame.at_time()
- DataFrame.axes
- DataFrame.between_time()
- DataFrame.bfill()
- DataFrame.blocks
- DataFrame.bool()
- DataFrame.boxplot()
- DataFrame.clip()
- DataFrame.clip_lower()
- DataFrame.clip_upper()
- DataFrame.columns
- DataFrame.combine()
- DataFrame.combine_first()
- DataFrame.compound()
- DataFrame.consolidate()
- DataFrame.convert_objects()
- DataFrame.copy()
- DataFrame.corr()
- DataFrame.corrwith()
- DataFrame.count()
- DataFrame.cov()
- DataFrame.cummax()
- DataFrame.cummin()
- DataFrame.cumprod()
- DataFrame.cumsum()
- DataFrame.describe()
- DataFrame.diff()
- DataFrame.div()
- DataFrame.divide()
- DataFrame.dot()
- DataFrame.drop()
- DataFrame.dropna()
- DataFrame.drop_duplicates()
- DataFrame.dtypes
- DataFrame.duplicated()
- DataFrame.empty
- DataFrame.eq()
- DataFrame.equals()
- DataFrame.eval()
- DataFrame.ewm()
- DataFrame.expanding()
- DataFrame.ffill()
- DataFrame.fillna()
- DataFrame.filter()
- DataFrame.first()
- DataFrame.first_valid_index()
- DataFrame.floordiv()
- DataFrame.from_csv()
- DataFrame.from_dict()
- DataFrame.from_items()
- DataFrame.from_records()
- DataFrame.ftypes
- DataFrame.ge()
- DataFrame.get()
- DataFrame.get_dtype_counts()
- DataFrame.get_ftype_counts()
- DataFrame.get_value()
- DataFrame.get_values()
- DataFrame.groupby()
- DataFrame.gt()
- DataFrame.head()
- DataFrame.hist()
- DataFrame.iat
- DataFrame.idxmax()
- DataFrame.idxmin()
- DataFrame.iloc
- DataFrame.index
- DataFrame.infer_objects()
- DataFrame.info()
- DataFrame.insert()
- DataFrame.interpolate()
- DataFrame.isin()
- DataFrame.isna()
- DataFrame.isnull()
- DataFrame.is_copy
- DataFrame.items()
- DataFrame.iteritems()
- DataFrame.iterrows()
- DataFrame.itertuples()
- DataFrame.ix
- DataFrame.join()
- DataFrame.keys()
- DataFrame.kurt()
- DataFrame.kurtosis()
- DataFrame.last()
- DataFrame.last_valid_index()
- DataFrame.le()
- DataFrame.loc
- DataFrame.lookup()
- DataFrame.lt()
- DataFrame.mad()
- DataFrame.mask()
- DataFrame.max()
- DataFrame.mean()
- DataFrame.median()
- DataFrame.melt()
- DataFrame.memory_usage()
- DataFrame.merge()
- DataFrame.min()
- DataFrame.mod()
- DataFrame.mode()
- DataFrame.mul()
- DataFrame.multiply()
- DataFrame.ndim
- DataFrame.ne()
- DataFrame.nlargest()
- DataFrame.notna()
- DataFrame.notnull()
- DataFrame.nsmallest()
- DataFrame.nunique()
- DataFrame.pct_change()
- DataFrame.pipe()
- DataFrame.pivot()
- DataFrame.pivot_table()
- DataFrame.plot()
- 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()
- DataFrame.pop()
- DataFrame.pow()
- DataFrame.prod()
- DataFrame.product()
- DataFrame.quantile()
- DataFrame.query()
- DataFrame.radd()
- DataFrame.rank()
- DataFrame.rdiv()
- DataFrame.reindex()
- DataFrame.reindex_axis()
- DataFrame.reindex_like()
- DataFrame.rename()
- DataFrame.rename_axis()
- DataFrame.reorder_levels()
- DataFrame.replace()
- DataFrame.resample()
- DataFrame.reset_index()
- DataFrame.rfloordiv()
- DataFrame.rmod()
- DataFrame.rmul()
- DataFrame.rolling()
- DataFrame.round()
- DataFrame.rpow()
- DataFrame.rsub()
- DataFrame.rtruediv()
- DataFrame.sample()
- DataFrame.select()
- DataFrame.select_dtypes()
- DataFrame.sem()
- DataFrame.set_axis()
- DataFrame.set_index()
- DataFrame.set_value()
- DataFrame.shape
- DataFrame.shift()
- DataFrame.size
- DataFrame.skew()
- DataFrame.slice_shift()
- DataFrame.sortlevel()
- DataFrame.sort_index()
- DataFrame.sort_values()
- DataFrame.squeeze()
- DataFrame.stack()
- DataFrame.std()
- DataFrame.style
- DataFrame.sub()
- DataFrame.subtract()
- DataFrame.sum()
- DataFrame.swapaxes()
- DataFrame.swaplevel()
- DataFrame.T
- DataFrame.tail()
- DataFrame.take()
- DataFrame.to_clipboard()
- DataFrame.to_csv()
- DataFrame.to_dense()
- DataFrame.to_dict()
- DataFrame.to_excel()
- DataFrame.to_feather()
- DataFrame.to_gbq()
- DataFrame.to_hdf()
- DataFrame.to_html()
- DataFrame.to_json()
- DataFrame.to_latex()
- DataFrame.to_msgpack()
- DataFrame.to_panel()
- DataFrame.to_parquet()
- DataFrame.to_period()
- DataFrame.to_pickle()
- DataFrame.to_records()
- DataFrame.to_sparse()
- DataFrame.to_stata()
- DataFrame.to_string()
- DataFrame.to_timestamp()
- DataFrame.to_xarray()
- DataFrame.transform()
- DataFrame.transpose()
- DataFrame.truediv()
- DataFrame.truncate()
- DataFrame.tshift()
- DataFrame.tz_convert()
- DataFrame.tz_localize()
- DataFrame.unstack()
- DataFrame.update()
- DataFrame.values
- DataFrame.var()
- DataFrame.where()
- DataFrame.xs()
- DataFrame.__iter__()
- SparseDataFrame.to_coo()
DatetimeIndex
- DatetimeIndex.ceil()
- DatetimeIndex.date
- DatetimeIndex.day
- DatetimeIndex.dayofweek
- DatetimeIndex.dayofyear
- DatetimeIndex.day_name()
- DatetimeIndex.floor()
- DatetimeIndex.freq
- DatetimeIndex.freqstr
- DatetimeIndex.hour
- DatetimeIndex.indexer_at_time()
- DatetimeIndex.indexer_between_time()
- DatetimeIndex.inferred_freq
- DatetimeIndex.is_leap_year
- DatetimeIndex.is_month_end
- DatetimeIndex.is_month_start
- DatetimeIndex.is_quarter_end
- DatetimeIndex.is_quarter_start
- DatetimeIndex.is_year_end
- DatetimeIndex.is_year_start
- DatetimeIndex.microsecond
- DatetimeIndex.minute
- DatetimeIndex.month
- DatetimeIndex.month_name()
- DatetimeIndex.nanosecond
- DatetimeIndex.normalize()
- DatetimeIndex.quarter
- DatetimeIndex.round()
- DatetimeIndex.second
- DatetimeIndex.snap()
- DatetimeIndex.strftime()
- DatetimeIndex.time
- DatetimeIndex.to_frame()
- DatetimeIndex.to_period()
- DatetimeIndex.to_perioddelta()
- DatetimeIndex.to_pydatetime()
- DatetimeIndex.to_series()
- DatetimeIndex.tz
- DatetimeIndex.tz_convert()
- DatetimeIndex.tz_localize()
- DatetimeIndex.week
- DatetimeIndex.weekday
- DatetimeIndex.weekofyear
- DatetimeIndex.year
- DatetimeIndex[source]
Extensions
- api.extensions.ExtensionArray[source]
- api.extensions.ExtensionDtype[source]
- ExtensionArray.argsort()
- ExtensionArray.astype()
- ExtensionArray.copy()
- ExtensionArray.dtype
- ExtensionArray.factorize()
- ExtensionArray.fillna()
- ExtensionArray.isna()
- ExtensionArray.nbytes
- ExtensionArray.ndim
- ExtensionArray.shape
- ExtensionArray.take()
- ExtensionArray.unique()
- ExtensionDtype.construct_from_string()
- ExtensionDtype.is_dtype()
- ExtensionDtype.kind
- ExtensionDtype.name
- ExtensionDtype.names
- ExtensionDtype.type
- pandas.api.extensions.register_dataframe_accessor()
- pandas.api.extensions.register_index_accessor()
- pandas.api.extensions.register_series_accessor()
Frequencies
- pandas.tseries.frequencies.to_offset()
General functions
- pandas.bdate_range()
- pandas.concat()
- pandas.crosstab()
- pandas.cut()
- pandas.date_range()
- pandas.eval()
- pandas.factorize()
- pandas.get_dummies()
- pandas.infer_freq()
- pandas.interval_range()
- pandas.isna()
- pandas.isnull()
- pandas.melt()
- pandas.merge()
- pandas.merge_asof()
- pandas.merge_ordered()
- pandas.notna()
- pandas.notnull()
- pandas.period_range()
- pandas.pivot()
- pandas.pivot_table()
- pandas.qcut()
- pandas.test()
- pandas.timedelta_range()
- pandas.to_datetime()
- pandas.to_numeric()
- pandas.to_timedelta()
- pandas.unique()
- pandas.wide_to_long()
General utility functions
- exception pandas.errors.DtypeWarning[source]
- exception pandas.errors.EmptyDataError[source]
- exception pandas.errors.OutOfBoundsDatetime
- exception pandas.errors.ParserError[source]
- exception pandas.errors.ParserWarning[source]
- exception pandas.errors.PerformanceWarning[source]
- exception pandas.errors.UnsortedIndexError[source]
- exception pandas.errors.UnsupportedFunctionCall[source]
- option_context()
- pandas.api.types.infer_dtype()
- pandas.api.types.is_bool()
- pandas.api.types.is_bool_dtype()
- pandas.api.types.is_categorical()
- pandas.api.types.is_categorical_dtype()
- pandas.api.types.is_complex()
- pandas.api.types.is_complex_dtype()
- pandas.api.types.is_datetime64tz_dtype()
- pandas.api.types.is_datetime64_any_dtype()
- pandas.api.types.is_datetime64_dtype()
- pandas.api.types.is_datetime64_ns_dtype()
- pandas.api.types.is_datetimetz()
- pandas.api.types.is_dict_like()
- pandas.api.types.is_extension_type()
- pandas.api.types.is_file_like()
- pandas.api.types.is_float()
- pandas.api.types.is_float_dtype()
- pandas.api.types.is_hashable()
- pandas.api.types.is_int64_dtype()
- pandas.api.types.is_integer()
- pandas.api.types.is_integer_dtype()
- pandas.api.types.is_interval()
- pandas.api.types.is_interval_dtype()
- pandas.api.types.is_iterator()
- pandas.api.types.is_list_like()
- pandas.api.types.is_named_tuple()
- pandas.api.types.is_number()
- pandas.api.types.is_numeric_dtype()
- pandas.api.types.is_object_dtype()
- pandas.api.types.is_period()
- pandas.api.types.is_period_dtype()
- pandas.api.types.is_re()
- pandas.api.types.is_re_compilable()
- pandas.api.types.is_scalar()
- pandas.api.types.is_signed_integer_dtype()
- pandas.api.types.is_sparse()
- pandas.api.types.is_string_dtype()
- pandas.api.types.is_timedelta64_dtype()
- pandas.api.types.is_timedelta64_ns_dtype()
- pandas.api.types.is_unsigned_integer_dtype()
- pandas.api.types.pandas_dtype()
- pandas.api.types.union_categoricals()
- pandas.describe_option()
- pandas.get_option()
- pandas.reset_option()
- pandas.set_option()
- pandas.testing.assert_frame_equal()
- pandas.testing.assert_index_equal()
- pandas.testing.assert_series_equal()
GroupBy
- DataFrameGroupBy.agg()
- DataFrameGroupBy.all()
- DataFrameGroupBy.any()
- DataFrameGroupBy.bfill()
- DataFrameGroupBy.boxplot()
- DataFrameGroupBy.corr
- DataFrameGroupBy.corrwith
- DataFrameGroupBy.count()
- DataFrameGroupBy.cov
- DataFrameGroupBy.cummax()
- DataFrameGroupBy.cummin()
- DataFrameGroupBy.cumprod()
- DataFrameGroupBy.cumsum()
- DataFrameGroupBy.describe()
- DataFrameGroupBy.diff
- DataFrameGroupBy.ffill()
- DataFrameGroupBy.fillna
- DataFrameGroupBy.filter()
- DataFrameGroupBy.hist
- DataFrameGroupBy.idxmax
- DataFrameGroupBy.idxmin
- DataFrameGroupBy.mad
- DataFrameGroupBy.pct_change()
- DataFrameGroupBy.plot
- DataFrameGroupBy.quantile
- DataFrameGroupBy.rank()
- DataFrameGroupBy.resample()
- DataFrameGroupBy.shift()
- DataFrameGroupBy.size()
- DataFrameGroupBy.skew
- DataFrameGroupBy.take
- DataFrameGroupBy.tshift
- GroupBy.aggregate()
- GroupBy.all()
- GroupBy.any()
- GroupBy.apply()
- GroupBy.bfill()
- GroupBy.count()
- GroupBy.cumcount()
- GroupBy.ffill()
- GroupBy.first()
- GroupBy.get_group()
- GroupBy.groups
- GroupBy.head()
- GroupBy.indices
- GroupBy.last()
- GroupBy.max()
- GroupBy.mean()
- GroupBy.median()
- GroupBy.min()
- GroupBy.ngroup()
- GroupBy.nth()
- GroupBy.ohlc()
- GroupBy.pct_change()
- GroupBy.pipe()
- GroupBy.prod()
- GroupBy.rank()
- GroupBy.sem()
- GroupBy.size()
- GroupBy.std()
- GroupBy.sum()
- GroupBy.tail()
- GroupBy.transform()
- GroupBy.var()
- GroupBy.__iter__()
- Grouper()
- SeriesGroupBy.is_monotonic_decreasing
- SeriesGroupBy.is_monotonic_increasing
- SeriesGroupBy.nlargest
- SeriesGroupBy.nsmallest
- SeriesGroupBy.nunique()
- SeriesGroupBy.unique
- SeriesGroupBy.value_counts()
Index
- Index.all()
- Index.any()
- Index.append()
- Index.argmax()
- Index.argmin()
- Index.argsort()
- Index.asof()
- Index.asof_locs()
- Index.astype()
- Index.base
- Index.contains()
- Index.copy()
- Index.data
- Index.delete()
- Index.difference()
- Index.drop()
- Index.dropna()
- Index.drop_duplicates()
- Index.dtype
- Index.dtype_str
- Index.duplicated()
- Index.empty
- Index.equals()
- Index.factorize()
- Index.fillna()
- Index.flags
- Index.format()
- Index.get_duplicates()
- Index.get_indexer()
- Index.get_indexer_for()
- Index.get_indexer_non_unique()
- Index.get_level_values()
- Index.get_loc()
- Index.get_slice_bound()
- Index.get_value()
- Index.get_values()
- Index.groupby()
- Index.hasnans
- Index.has_duplicates
- Index.identical()
- Index.inferred_type
- Index.insert()
- Index.intersection()
- Index.isin()
- Index.isna()
- Index.isnull()
- Index.is_()
- Index.is_all_dates
- Index.is_boolean()
- Index.is_categorical()
- Index.is_floating()
- Index.is_integer()
- Index.is_interval()
- Index.is_lexsorted_for_tuple()
- Index.is_mixed()
- Index.is_monotonic
- Index.is_monotonic_decreasing
- Index.is_monotonic_increasing
- Index.is_numeric()
- Index.is_object()
- Index.is_unique
- Index.item()
- Index.itemsize
- Index.join()
- Index.map()
- Index.max()
- Index.memory_usage()
- Index.min()
- Index.name
- Index.names
- Index.nbytes
- Index.ndim
- Index.notna()
- Index.notnull()
- Index.nunique()
- Index.putmask()
- Index.ravel()
- Index.reindex()
- Index.rename()
- Index.repeat()
- Index.searchsorted()
- Index.set_names()
- Index.set_value()
- Index.shape
- Index.shift()
- Index.size
- Index.slice_indexer()
- Index.slice_locs()
- Index.sortlevel()
- Index.sort_values()
- Index.str()
- Index.strides
- Index.summary()
- Index.symmetric_difference()
- Index.T
- Index.take()
- Index.tolist()
- Index.to_frame()
- Index.to_native_types()
- Index.to_series()
- Index.transpose()
- Index.union()
- Index.unique()
- Index.values
- Index.value_counts()
- Index.view()
- Index.where()
- Index[source]
Input/Output
- ExcelFile.parse()
- HDFStore.append()
- HDFStore.get()
- HDFStore.info()
- HDFStore.keys()
- HDFStore.put()
- HDFStore.select()
- pandas.io.json.build_table_schema()
- pandas.io.json.json_normalize()
- pandas.read_clipboard()
- pandas.read_csv()
- pandas.read_excel()
- pandas.read_feather()
- pandas.read_fwf()
- pandas.read_gbq()
- pandas.read_hdf()
- pandas.read_html()
- pandas.read_json()
- pandas.read_msgpack()
- pandas.read_parquet()
- pandas.read_pickle()
- pandas.read_sas()
- pandas.read_stata()
- pandas.read_table()
- StataReader.data()
- StataReader.data_label()
- StataReader.value_labels()
- StataReader.variable_labels()
- StataWriter.write_file()
IntervalIndex
- IntervalIndex.closed
- IntervalIndex.contains()
- IntervalIndex.from_arrays()
- IntervalIndex.from_breaks()
- IntervalIndex.from_tuples()
- IntervalIndex.get_indexer()
- IntervalIndex.get_loc()
- IntervalIndex.is_non_overlapping_monotonic
- IntervalIndex.left
- IntervalIndex.length
- IntervalIndex.mid
- IntervalIndex.right
- IntervalIndex.values
- IntervalIndex[source]
Manual
- 1. Installation
- 2. Package overview
- 3. 10 Minutes to pandas
- 4. Tutorials
- 5. Cookbook
- 6. Intro to Data Structures
- 7. Essential Basic Functionality
- 8. Working with Text Data
- 9. Options and Settings
- 10. Indexing and Selecting Data
- 11. MultiIndex / Advanced Indexing
- 12. Computational tools
- 13. Working with missing data
- 14. Group By: split-apply-combine
- 15. Merge, join, and concatenate
- 16. Reshaping and Pivot Tables
- 17. Time Series / Date functionality
- 18. Time Deltas
- 19. Categorical Data
- 20. Visualization
- 21. Styling
- 22. IO Tools (Text, CSV, HDF5, …)
- 23. Enhancing Performance
- 24. Sparse data structures
- 25. Frequently Asked Questions (FAQ)
- 26. rpy2 / R interface
- 27. pandas Ecosystem
- 28. Comparison with R / R libraries
- 29. Comparison with SQL
- 30. Comparison with SAS
- 31. Comparison with Stata
- 32. API Reference
- 33. Developer
- 34. Extending Pandas
MultiIndex
- MultiIndex.droplevel()
- MultiIndex.from_arrays()
- MultiIndex.from_product()
- MultiIndex.from_tuples()
- MultiIndex.get_indexer()
- MultiIndex.get_level_values()
- MultiIndex.get_loc()
- MultiIndex.is_lexsorted()
- MultiIndex.labels
- MultiIndex.levels
- MultiIndex.levshape
- MultiIndex.names
- MultiIndex.nlevels
- MultiIndex.remove_unused_levels()
- MultiIndex.reorder_levels()
- MultiIndex.set_labels()
- MultiIndex.set_levels()
- MultiIndex.sortlevel()
- MultiIndex.swaplevel()
- MultiIndex.to_frame()
- MultiIndex.to_hierarchical()
- MultiIndex.unique()
- MultiIndex[source]
- pandas.IndexSlice
Numeric Index
- Float64Index[source]
- Int64Index[source]
- RangeIndex.from_range()
- RangeIndex[source]
- UInt64Index[source]
Panel
- Panel()
- Panel.abs()
- Panel.add()
- Panel.add_prefix()
- Panel.add_suffix()
- Panel.align()
- Panel.all()
- Panel.any()
- Panel.apply()
- Panel.asfreq()
- Panel.asof()
- Panel.astype()
- Panel.as_blocks()
- Panel.as_matrix()
- Panel.at
- Panel.at_time()
- Panel.axes
- Panel.between_time()
- Panel.bfill()
- Panel.blocks
- Panel.bool()
- Panel.clip()
- Panel.clip_lower()
- Panel.clip_upper()
- Panel.compound()
- Panel.conform()
- Panel.consolidate()
- Panel.convert_objects()
- Panel.copy()
- Panel.count()
- Panel.cummax()
- Panel.cummin()
- Panel.cumprod()
- Panel.cumsum()
- Panel.describe()
- Panel.div()
- Panel.divide()
- Panel.drop()
- Panel.dropna()
- Panel.dtypes
- Panel.empty
- Panel.eq()
- Panel.equals()
- Panel.ffill()
- Panel.fillna()
- Panel.filter()
- Panel.first()
- Panel.first_valid_index()
- Panel.floordiv()
- Panel.fromDict()
- Panel.from_dict()
- Panel.ftypes
- Panel.ge()
- Panel.get()
- Panel.get_dtype_counts()
- Panel.get_ftype_counts()
- Panel.get_value()
- Panel.get_values()
- Panel.groupby()
- Panel.gt()
- Panel.head()
- Panel.iat
- Panel.iloc
- Panel.infer_objects()
- Panel.interpolate()
- Panel.isna()
- Panel.isnull()
- Panel.items
- Panel.iteritems()
- Panel.ix
- Panel.join()
- Panel.keys()
- Panel.kurt()
- Panel.kurtosis()
- Panel.last()
- Panel.last_valid_index()
- Panel.le()
- Panel.loc
- Panel.lt()
- Panel.mad()
- Panel.major_axis
- Panel.major_xs()
- Panel.mask()
- Panel.max()
- Panel.mean()
- Panel.median()
- Panel.min()
- Panel.minor_axis
- Panel.minor_xs()
- Panel.mod()
- Panel.mul()
- Panel.multiply()
- Panel.ndim
- Panel.ne()
- Panel.notna()
- Panel.notnull()
- Panel.pct_change()
- Panel.pipe()
- Panel.pop()
- Panel.pow()
- Panel.prod()
- Panel.product()
- Panel.radd()
- Panel.rank()
- Panel.rdiv()
- Panel.reindex()
- Panel.reindex_axis()
- Panel.reindex_like()
- Panel.rename()
- Panel.rename_axis()
- Panel.replace()
- Panel.resample()
- Panel.rfloordiv()
- Panel.rmod()
- Panel.rmul()
- Panel.round()
- Panel.rpow()
- Panel.rsub()
- Panel.rtruediv()
- Panel.sample()
- Panel.select()
- Panel.sem()
- Panel.set_axis()
- Panel.set_value()
- Panel.shape
- Panel.shift()
- Panel.size
- Panel.skew()
- Panel.slice_shift()
- Panel.sort_index()
- Panel.sort_values()
- Panel.squeeze()
- Panel.std()
- Panel.sub()
- Panel.subtract()
- Panel.sum()
- Panel.swapaxes()
- Panel.swaplevel()
- Panel.tail()
- Panel.take()
- Panel.to_clipboard()
- Panel.to_dense()
- Panel.to_excel()
- Panel.to_frame()
- Panel.to_hdf()
- Panel.to_json()
- Panel.to_latex()
- Panel.to_msgpack()
- Panel.to_pickle()
- Panel.to_sparse()
- Panel.to_sql()
- Panel.to_xarray()
- Panel.transpose()
- Panel.truediv()
- Panel.truncate()
- Panel.tshift()
- Panel.tz_convert()
- Panel.tz_localize()
- Panel.update()
- Panel.values
- Panel.var()
- Panel.where()
- Panel.xs()
- Panel.__iter__()
PeriodIndex
- PeriodIndex.asfreq()
- PeriodIndex.day
- PeriodIndex.dayofweek
- PeriodIndex.dayofyear
- PeriodIndex.daysinmonth
- PeriodIndex.days_in_month
- PeriodIndex.end_time
- PeriodIndex.freq
- PeriodIndex.freqstr
- PeriodIndex.hour
- PeriodIndex.is_leap_year
- PeriodIndex.minute
- PeriodIndex.month
- PeriodIndex.quarter
- PeriodIndex.qyear
- PeriodIndex.second
- PeriodIndex.start_time
- PeriodIndex.strftime()
- PeriodIndex.to_timestamp()
- PeriodIndex.tz_convert()
- PeriodIndex.tz_localize()
- PeriodIndex.week
- PeriodIndex.weekday
- PeriodIndex.weekofyear
- PeriodIndex.year
- PeriodIndex[source]
Plotting
- pandas.plotting.andrews_curves()
- pandas.plotting.bootstrap_plot()
- pandas.plotting.deregister_matplotlib_converters()
- pandas.plotting.lag_plot()
- pandas.plotting.parallel_coordinates()
- pandas.plotting.radviz()
- pandas.plotting.register_matplotlib_converters()
- pandas.plotting.scatter_matrix()
Resampling
- Resampler.aggregate()
- Resampler.apply()
- Resampler.asfreq()
- Resampler.backfill()
- Resampler.bfill()
- Resampler.count()
- Resampler.ffill()
- Resampler.fillna()
- Resampler.first()
- Resampler.get_group()
- Resampler.groups
- Resampler.indices
- Resampler.interpolate()
- Resampler.last()
- Resampler.max()
- Resampler.mean()
- Resampler.median()
- Resampler.min()
- Resampler.nearest()
- Resampler.nunique()
- Resampler.ohlc()
- Resampler.pad()
- Resampler.pipe()
- Resampler.prod()
- Resampler.sem()
- Resampler.size()
- Resampler.std()
- Resampler.sum()
- Resampler.transform()
- Resampler.var()
- Resampler.__iter__()
Scalars
- Interval
- Interval.closed
- Interval.closed_left
- Interval.closed_right
- Interval.left
- Interval.length
- Interval.mid
- Interval.open_left
- Interval.open_right
- Interval.right
- Period
- Period.asfreq()
- Period.day
- Period.dayofweek
- Period.dayofyear
- Period.daysinmonth
- Period.days_in_month
- Period.end_time
- Period.freq
- Period.freqstr
- Period.hour
- Period.is_leap_year
- Period.minute
- Period.month
- Period.now()
- Period.ordinal
- Period.quarter
- Period.qyear
- Period.second
- Period.start_time
- Period.strftime()
- Period.to_timestamp()
- Period.week
- Period.weekday
- Period.weekofyear
- Period.year
- Timedelta
- Timedelta.asm8
- Timedelta.ceil
- Timedelta.components
- Timedelta.days
- Timedelta.delta
- Timedelta.floor
- Timedelta.freq
- Timedelta.isoformat()
- Timedelta.is_populated
- Timedelta.max
- Timedelta.microseconds
- Timedelta.min
- Timedelta.nanoseconds
- Timedelta.resolution
- Timedelta.round
- Timedelta.seconds
- Timedelta.total_seconds()
- Timedelta.to_pytimedelta()
- Timedelta.to_timedelta64()
- Timedelta.value
- Timedelta.view()
- Timestamp
- Timestamp.asm8
- Timestamp.astimezone
- Timestamp.ceil
- Timestamp.combine()
- Timestamp.ctime()
- Timestamp.date()
- Timestamp.day
- Timestamp.dayofweek
- Timestamp.dayofyear
- Timestamp.daysinmonth
- Timestamp.days_in_month
- Timestamp.day_name
- Timestamp.dst()
- Timestamp.floor
- Timestamp.fold
- Timestamp.freq
- Timestamp.freqstr
- Timestamp.fromordinal()
- Timestamp.fromtimestamp()
- Timestamp.hour
- Timestamp.isocalendar()
- Timestamp.isoformat
- Timestamp.isoweekday()
- Timestamp.is_leap_year
- Timestamp.is_month_end
- Timestamp.is_month_start
- Timestamp.is_quarter_end
- Timestamp.is_quarter_start
- Timestamp.is_year_end
- Timestamp.is_year_start
- Timestamp.max
- Timestamp.microsecond
- Timestamp.min
- Timestamp.minute
- Timestamp.month
- Timestamp.month_name
- Timestamp.nanosecond
- Timestamp.normalize
- Timestamp.now()
- Timestamp.quarter
- Timestamp.replace
- Timestamp.resolution
- Timestamp.round
- Timestamp.second
- Timestamp.strftime()
- Timestamp.strptime()
- Timestamp.time()
- Timestamp.timestamp()
- Timestamp.timetuple()
- Timestamp.timetz()
- Timestamp.today()
- Timestamp.toordinal()
- Timestamp.to_datetime64()
- Timestamp.to_julian_date
- Timestamp.to_period
- Timestamp.to_pydatetime()
- Timestamp.tz
- Timestamp.tzinfo
- Timestamp.tzname()
- Timestamp.tz_convert
- Timestamp.tz_localize
- Timestamp.utcfromtimestamp()
- Timestamp.utcnow()
- Timestamp.utcoffset()
- Timestamp.utctimetuple()
- Timestamp.value
- Timestamp.week
- Timestamp.weekday()
- Timestamp.weekday_name
- Timestamp.weekofyear
- Timestamp.year
Series
- api.types.CategoricalDtype()
- Categorical()
- Categorical.categories
- Categorical.codes
- Categorical.dtype
- Categorical.from_codes()
- Categorical.ordered
- Categorical.__array__()
- CategoricalDtype.categories
- CategoricalDtype.ordered
- Series()
- Series.abs()
- Series.add()
- Series.add_prefix()
- Series.add_suffix()
- Series.agg()
- Series.aggregate()
- Series.align()
- Series.all()
- Series.any()
- Series.append()
- Series.apply()
- Series.argmax()
- Series.argmin()
- Series.argsort()
- Series.asfreq()
- Series.asobject
- Series.asof()
- Series.astype()
- Series.as_blocks()
- Series.as_matrix()
- Series.at
- Series.at_time()
- Series.autocorr()
- Series.axes
- Series.base
- Series.between()
- Series.between_time()
- Series.bfill()
- Series.blocks
- Series.bool()
- Series.cat()
- Series.cat.add_categories()
- Series.cat.as_ordered()
- Series.cat.as_unordered()
- Series.cat.categories
- Series.cat.codes
- Series.cat.ordered
- Series.cat.remove_categories()
- Series.cat.remove_unused_categories()
- Series.cat.rename_categories()
- Series.cat.reorder_categories()
- Series.cat.set_categories()
- Series.clip()
- Series.clip_lower()
- Series.clip_upper()
- Series.combine()
- Series.combine_first()
- Series.compound()
- Series.compress()
- Series.consolidate()
- Series.convert_objects()
- Series.copy()
- Series.corr()
- Series.count()
- Series.cov()
- Series.cummax()
- Series.cummin()
- Series.cumprod()
- Series.cumsum()
- Series.data
- Series.describe()
- Series.diff()
- Series.div()
- Series.divide()
- Series.divmod()
- Series.dot()
- Series.drop()
- Series.dropna()
- Series.drop_duplicates()
- Series.dt()
- Series.dt.ceil()
- Series.dt.components
- Series.dt.date
- Series.dt.day
- Series.dt.dayofweek
- Series.dt.dayofyear
- Series.dt.days
- Series.dt.daysinmonth
- Series.dt.days_in_month
- Series.dt.day_name()
- Series.dt.floor()
- Series.dt.freq
- Series.dt.hour
- Series.dt.is_leap_year
- Series.dt.is_month_end
- Series.dt.is_month_start
- Series.dt.is_quarter_end
- Series.dt.is_quarter_start
- Series.dt.is_year_end
- Series.dt.is_year_start
- Series.dt.microsecond
- Series.dt.microseconds
- Series.dt.minute
- Series.dt.month
- Series.dt.month_name()
- Series.dt.nanosecond
- Series.dt.nanoseconds
- Series.dt.normalize()
- Series.dt.quarter
- Series.dt.round()
- Series.dt.second
- Series.dt.seconds
- Series.dt.strftime()
- Series.dt.time
- Series.dt.total_seconds()
- Series.dt.to_period()
- Series.dt.to_pydatetime()
- Series.dt.to_pytimedelta()
- Series.dt.tz
- Series.dt.tz_convert()
- Series.dt.tz_localize()
- Series.dt.week
- Series.dt.weekday
- Series.dt.weekofyear
- Series.dt.year
- Series.dtype
- Series.dtypes
- Series.duplicated()
- Series.empty
- Series.eq()
- Series.equals()
- Series.ewm()
- Series.expanding()
- Series.factorize()
- Series.ffill()
- Series.fillna()
- Series.filter()
- Series.first()
- Series.first_valid_index()
- Series.flags
- Series.floordiv()
- Series.from_array()
- Series.from_csv()
- Series.ftype
- Series.ftypes
- Series.ge()
- Series.get()
- Series.get_dtype_counts()
- Series.get_ftype_counts()
- Series.get_value()
- Series.get_values()
- Series.groupby()
- Series.gt()
- Series.hasnans
- Series.head()
- Series.hist()
- Series.iat
- Series.idxmax()
- Series.idxmin()
- Series.iloc
- Series.index
- Series.infer_objects()
- Series.interpolate()
- Series.isin()
- Series.isna()
- Series.isnull()
- Series.is_copy
- Series.is_monotonic
- Series.is_monotonic_decreasing
- Series.is_monotonic_increasing
- Series.is_unique
- Series.item()
- Series.items()
- Series.itemsize
- Series.iteritems()
- Series.ix
- Series.keys()
- Series.kurt()
- Series.kurtosis()
- Series.last()
- Series.last_valid_index()
- Series.le()
- Series.loc
- Series.lt()
- Series.mad()
- Series.map()
- Series.mask()
- Series.max()
- Series.mean()
- Series.median()
- Series.memory_usage()
- Series.min()
- Series.mod()
- Series.mode()
- Series.mul()
- Series.multiply()
- Series.name
- Series.nbytes
- Series.ndim
- Series.ne()
- Series.nlargest()
- Series.nonzero()
- Series.notna()
- Series.notnull()
- Series.nsmallest()
- Series.nunique()
- Series.pct_change()
- Series.pipe()
- Series.plot()
- Series.plot.area()
- Series.plot.bar()
- Series.plot.barh()
- Series.plot.box()
- Series.plot.density()
- Series.plot.hist()
- Series.plot.kde()
- Series.plot.line()
- Series.plot.pie()
- Series.pop()
- Series.pow()
- Series.prod()
- Series.product()
- Series.ptp()
- Series.put()
- Series.quantile()
- Series.radd()
- Series.rank()
- Series.ravel()
- Series.rdiv()
- Series.reindex()
- Series.reindex_axis()
- Series.reindex_like()
- Series.rename()
- Series.rename_axis()
- Series.reorder_levels()
- Series.repeat()
- Series.replace()
- Series.resample()
- Series.reset_index()
- Series.rfloordiv()
- Series.rmod()
- Series.rmul()
- Series.rolling()
- Series.round()
- Series.rpow()
- Series.rsub()
- Series.rtruediv()
- Series.sample()
- Series.searchsorted()
- Series.select()
- Series.sem()
- Series.set_axis()
- Series.set_value()
- Series.shape
- Series.shift()
- Series.size
- Series.skew()
- Series.slice_shift()
- Series.sortlevel()
- Series.sort_index()
- Series.sort_values()
- Series.squeeze()
- Series.std()
- Series.str()
- Series.str.capitalize()
- Series.str.cat()
- Series.str.center()
- Series.str.contains()
- Series.str.count()
- Series.str.decode()
- Series.str.encode()
- Series.str.endswith()
- Series.str.extract()
- Series.str.extractall()
- Series.str.find()
- Series.str.findall()
- Series.str.get()
- Series.str.get_dummies()
- Series.str.index()
- Series.str.isalnum()
- Series.str.isalpha()
- Series.str.isdecimal()
- Series.str.isdigit()
- Series.str.islower()
- Series.str.isnumeric()
- Series.str.isspace()
- Series.str.istitle()
- Series.str.isupper()
- Series.str.join()
- Series.str.len()
- Series.str.ljust()
- Series.str.lower()
- Series.str.lstrip()
- Series.str.match()
- Series.str.normalize()
- Series.str.pad()
- Series.str.partition()
- Series.str.repeat()
- Series.str.replace()
- Series.str.rfind()
- Series.str.rindex()
- Series.str.rjust()
- Series.str.rpartition()
- Series.str.rsplit()
- Series.str.rstrip()
- Series.str.slice()
- Series.str.slice_replace()
- Series.str.split()
- Series.str.startswith()
- Series.str.strip()
- Series.str.swapcase()
- Series.str.title()
- Series.str.translate()
- Series.str.upper()
- Series.str.wrap()
- Series.str.zfill()
- Series.strides
- Series.sub()
- Series.subtract()
- Series.sum()
- Series.swapaxes()
- Series.swaplevel()
- Series.T
- Series.tail()
- Series.take()
- Series.tolist()
- Series.to_clipboard()
- Series.to_csv()
- Series.to_dense()
- Series.to_dict()
- Series.to_excel()
- Series.to_frame()
- Series.to_hdf()
- Series.to_json()
- Series.to_latex()
- Series.to_msgpack()
- Series.to_period()
- Series.to_pickle()
- Series.to_sparse()
- Series.to_sql()
- Series.to_string()
- Series.to_timestamp()
- Series.to_xarray()
- Series.transform()
- Series.transpose()
- Series.truediv()
- Series.truncate()
- Series.tshift()
- Series.tz_convert()
- Series.tz_localize()
- Series.unique()
- Series.unstack()
- Series.update()
- Series.valid()
- Series.values
- Series.value_counts()
- Series.var()
- Series.view()
- Series.where()
- Series.xs()
- Series.__iter__()
- SparseSeries.from_coo()
- SparseSeries.to_coo()
SQL Queries
- DataFrame.to_sql()
- pandas.read_sql()
- pandas.read_sql_query()
- pandas.read_sql_table()
Style
- io.formats.style.Styler()
- Styler.apply()
- Styler.applymap()
- Styler.background_gradient()
- Styler.bar()
- Styler.clear()
- Styler.env
- Styler.export()
- Styler.format()
- Styler.from_custom_template()
- Styler.hide_columns()
- Styler.hide_index()
- Styler.highlight_max()
- Styler.highlight_min()
- Styler.highlight_null()
- Styler.loader
- Styler.render()
- Styler.set_caption()
- Styler.set_precision()
- Styler.set_properties()
- Styler.set_table_attributes()
- Styler.set_table_styles()
- Styler.set_uuid()
- Styler.template
- Styler.to_excel()
- Styler.use()
- Styler.where()
TimedeltaIndex
- TimedeltaIndex.ceil()
- TimedeltaIndex.components
- TimedeltaIndex.days
- TimedeltaIndex.floor()
- TimedeltaIndex.inferred_freq
- TimedeltaIndex.microseconds
- TimedeltaIndex.nanoseconds
- TimedeltaIndex.round()
- TimedeltaIndex.seconds
- TimedeltaIndex.to_frame()
- TimedeltaIndex.to_pytimedelta()
- TimedeltaIndex.to_series()
- TimedeltaIndex[source]
Window
- EWM.corr()
- EWM.cov()
- EWM.mean()
- EWM.std()
- EWM.var()
- Expanding.aggregate()
- Expanding.apply()
- Expanding.corr()
- Expanding.count()
- Expanding.cov()
- Expanding.kurt()
- Expanding.max()
- Expanding.mean()
- Expanding.median()
- Expanding.min()
- Expanding.quantile()
- Expanding.skew()
- Expanding.std()
- Expanding.sum()
- Expanding.var()
- Rolling.aggregate()
- Rolling.apply()
- Rolling.corr()
- Rolling.count()
- Rolling.cov()
- Rolling.kurt()
- Rolling.max()
- Rolling.mean()
- Rolling.median()
- Rolling.min()
- Rolling.quantile()
- Rolling.skew()
- Rolling.std()
- Rolling.sum()
- Rolling.var()
- Window.mean()
- Window.sum()

pandas.Index.asof

Index.asof(label) [source]

For a sorted index, return the most recent label up to and including the passed label. Return NaN if not found.

See also

get_loc: asof is a thin wrapper around get_loc with method=’pad’

© 2008–2012, AQR Capital Management, LLC, Lambda Foundry, Inc. and PyData Development Team
Licensed under the 3-clause BSD License.
https://pandas.pydata.org/pandas-docs/version/0.23.4/generated/pandas.Index.asof.html