{{ header }}
.. currentmodule:: pandas
.. autosummary:: :toctree: generated/ Series
Axes
.. autosummary:: :toctree: generated/ Series.index
.. autosummary:: :toctree: generated/ Series.values Series.dtype Series.ftype Series.shape Series.nbytes Series.ndim Series.size Series.strides Series.itemsize Series.base Series.T Series.memory_usage Series.hasnans Series.flags Series.empty Series.dtypes Series.ftypes Series.data Series.is_copy Series.name Series.put
.. autosummary:: :toctree: generated/ Series.astype Series.infer_objects Series.convert_objects Series.copy Series.bool Series.to_period Series.to_timestamp Series.to_list Series.get_values
.. autosummary:: :toctree: generated/ Series.get Series.at Series.iat Series.loc Series.iloc Series.__iter__ Series.iteritems Series.items Series.keys Series.pop Series.item Series.xs
For more information on .at
, .iat
, .loc
, and
.iloc
, see the :ref:`indexing documentation <indexing>`.
.. autosummary:: :toctree: generated/ Series.add Series.sub Series.mul Series.div Series.truediv Series.floordiv Series.mod Series.pow Series.radd Series.rsub Series.rmul Series.rdiv Series.rtruediv Series.rfloordiv Series.rmod Series.rpow Series.combine Series.combine_first Series.round Series.lt Series.gt Series.le Series.ge Series.ne Series.eq Series.product Series.dot
.. autosummary:: :toctree: generated/ Series.apply Series.agg Series.aggregate Series.transform Series.map Series.groupby Series.rolling Series.expanding Series.ewm Series.pipe
.. autosummary:: :toctree: generated/ Series.abs Series.all 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.factorize Series.kurt Series.mad Series.max Series.mean Series.median Series.min Series.mode Series.nlargest Series.nsmallest Series.pct_change Series.prod Series.quantile Series.rank Series.sem Series.skew Series.std Series.sum Series.var Series.kurtosis Series.unique Series.nunique Series.is_unique Series.is_monotonic Series.is_monotonic_increasing Series.is_monotonic_decreasing Series.value_counts Series.compound
.. autosummary:: :toctree: generated/ Series.align Series.drop Series.droplevel Series.drop_duplicates Series.duplicated Series.equals Series.first Series.head Series.idxmax Series.idxmin Series.isin Series.last Series.reindex Series.reindex_like Series.rename Series.rename_axis Series.reset_index Series.sample Series.select Series.set_axis Series.take Series.tail Series.truncate Series.where Series.mask Series.add_prefix Series.add_suffix Series.filter
.. autosummary:: :toctree: generated/ Series.isna Series.notna Series.dropna Series.fillna Series.interpolate
.. autosummary:: :toctree: generated/ Series.argsort Series.argmin Series.argmax Series.reorder_levels Series.sort_values Series.sort_index Series.swaplevel Series.unstack Series.searchsorted Series.ravel Series.repeat Series.squeeze Series.view
.. autosummary:: :toctree: generated/ Series.append Series.replace Series.update
.. autosummary:: :toctree: generated/ Series.asfreq Series.asof Series.shift Series.first_valid_index Series.last_valid_index Series.resample Series.tz_convert Series.tz_localize Series.at_time Series.between_time Series.tshift Series.slice_shift
Series.dt
can be used to access the values of the series as
datetimelike and return several properties.
These can be accessed like Series.dt.<property>
.
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_attribute.rst Series.dt.date Series.dt.time Series.dt.timetz Series.dt.year Series.dt.month Series.dt.day Series.dt.hour Series.dt.minute Series.dt.second Series.dt.microsecond Series.dt.nanosecond Series.dt.week Series.dt.weekofyear Series.dt.dayofweek Series.dt.weekday Series.dt.dayofyear Series.dt.quarter Series.dt.is_month_start Series.dt.is_month_end Series.dt.is_quarter_start Series.dt.is_quarter_end Series.dt.is_year_start Series.dt.is_year_end Series.dt.is_leap_year Series.dt.daysinmonth Series.dt.days_in_month Series.dt.tz Series.dt.freq
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_method.rst Series.dt.to_period Series.dt.to_pydatetime Series.dt.tz_localize Series.dt.tz_convert Series.dt.normalize Series.dt.strftime Series.dt.round Series.dt.floor Series.dt.ceil Series.dt.month_name Series.dt.day_name
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_attribute.rst Series.dt.qyear Series.dt.start_time Series.dt.end_time
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_attribute.rst Series.dt.days Series.dt.seconds Series.dt.microseconds Series.dt.nanoseconds Series.dt.components
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_method.rst Series.dt.to_pytimedelta Series.dt.total_seconds
Series.str
can be used to access the values of the series as
strings and apply several methods to it. These can be accessed like
Series.str.<function/property>
.
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_method.rst 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.index 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.rstrip Series.str.slice Series.str.slice_replace Series.str.split Series.str.rsplit 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.str.isalnum Series.str.isalpha Series.str.isdigit Series.str.isspace Series.str.islower Series.str.isupper Series.str.istitle Series.str.isnumeric Series.str.isdecimal Series.str.get_dummies
Pandas and third-party libraries can extend NumPy's type system (see :ref:`extending.extension-types`).
.. autosummary:: :toctree: generated/ array
Pandas defines a custom data type for representing data that can take only a
limited, fixed set of values. The dtype of a Categorical
can be described by
a :class:`pandas.api.types.CategoricalDtype`.
.. autosummary:: :toctree: generated/ :template: autosummary/class_without_autosummary.rst api.types.CategoricalDtype
.. autosummary:: :toctree: generated/ api.types.CategoricalDtype.categories api.types.CategoricalDtype.ordered
Categorical data can be stored in a :class:`pandas.Categorical`
.. autosummary:: :toctree: generated/ :template: autosummary/class_without_autosummary.rst Categorical
The alternative :meth:`Categorical.from_codes` constructor can be used when you have the categories and integer codes already:
.. autosummary:: :toctree: generated/ Categorical.from_codes
The dtype information is available on the Categorical
.. autosummary:: :toctree: generated/ Categorical.dtype Categorical.categories Categorical.ordered Categorical.codes
np.asarray(categorical)
works by implementing the array interface. Be aware, that this converts
the Categorical back to a NumPy array, so categories and order information is not preserved!
.. autosummary:: :toctree: generated/ Categorical.__array__
A Categorical
can be stored in a Series
or DataFrame
.
To create a Series of dtype category
, use cat = s.astype(dtype)
or
Series(..., dtype=dtype)
where dtype
is either
- the string
'category'
- an instance of :class:`~pandas.api.types.CategoricalDtype`.
If the Series is of dtype CategoricalDtype
, Series.cat
can be used to change the categorical
data. This accessor is similar to the Series.dt
or Series.str
and has the
following usable methods and properties:
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_attribute.rst Series.cat.categories Series.cat.ordered Series.cat.codes
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_method.rst Series.cat.rename_categories Series.cat.reorder_categories Series.cat.add_categories Series.cat.remove_categories Series.cat.remove_unused_categories Series.cat.set_categories Series.cat.as_ordered Series.cat.as_unordered
Series.plot
is both a callable method and a namespace attribute for
specific plotting methods of the form Series.plot.<kind>
.
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_callable.rst Series.plot
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_method.rst 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
.. autosummary:: :toctree: generated/ Series.hist
.. autosummary:: :toctree: generated/ Series.to_pickle Series.to_csv Series.to_dict Series.to_excel Series.to_frame Series.to_xarray Series.to_hdf Series.to_sql Series.to_msgpack Series.to_json Series.to_sparse Series.to_dense Series.to_string Series.to_clipboard Series.to_latex
.. autosummary:: :toctree: generated/ SparseSeries.to_coo SparseSeries.from_coo
.. autosummary:: :toctree: generated/ :template: autosummary/accessor_attribute.rst Series.sparse.npoints Series.sparse.density Series.sparse.fill_value Series.sparse.sp_values
.. autosummary:: :toctree: generated/ Series.sparse.from_coo Series.sparse.to_coo