Series¶
Constructor¶
|
One-dimensional ndarray with axis labels (including time series). |
Attributes¶
Axes
The index (axis labels) of the Series. |
The ExtensionArray of the data backing this Series or Index. |
|
Return Series as ndarray or ndarray-like depending on the dtype. |
|
Return the dtype object of the underlying data. |
|
Return a tuple of the shape of the underlying data. |
|
Return the number of bytes in the underlying data. |
|
Number of dimensions of the underlying data, by definition 1. |
|
Return the number of elements in the underlying data. |
|
Return the transpose, which is by definition self. |
|
|
Return the memory usage of the Series. |
Return if I have any nans; enables various perf speedups. |
|
Return the dtype object of the underlying data. |
|
Conversion¶
|
Cast a pandas object to a specified dtype |
|
Convert columns to best possible dtypes using dtypes supporting |
|
Attempt to infer better dtypes for object columns. |
|
Make a copy of this object’s indices and data. |
|
Return the bool of a single element PandasObject. |
|
A NumPy ndarray representing the values in this Series or Index. |
|
Convert Series from DatetimeIndex to PeriodIndex with desired frequency (inferred from index if not passed). |
|
Cast to DatetimeIndex of Timestamps, at beginning of period. |
|
Return a list of the values. |
|
Return the values as a NumPy array. |
Indexing, iteration¶
|
Get item from object for given key (ex: DataFrame column). |
Access a single value for a row/column label pair. |
|
Access a single value for a row/column pair by integer position. |
|
Access a group of rows and columns by label(s) or a boolean array. |
|
Purely integer-location based indexing for selection by position. |
|
|
Return an iterator of the values. |
|
Lazily iterate over (index, value) tuples. |
|
Lazily iterate over (index, value) tuples. |
|
Return alias for index. |
|
Return item and drop from frame. |
|
Return the first element of the underlying data as a python scalar. |
|
Return cross-section from the Series/DataFrame. |
For more information on .at
, .iat
, .loc
, and
.iloc
, see the indexing documentation.
Binary operator functions¶
|
Return Addition of series and other, element-wise (binary operator add). |
|
Return Subtraction of series and other, element-wise (binary operator sub). |
|
Return Multiplication of series and other, element-wise (binary operator mul). |
|
Return Floating division of series and other, element-wise (binary operator truediv). |
|
Return Floating division of series and other, element-wise (binary operator truediv). |
|
Return Integer division of series and other, element-wise (binary operator floordiv). |
|
Return Modulo of series and other, element-wise (binary operator mod). |
|
Return Exponential power of series and other, element-wise (binary operator pow). |
|
Return Addition of series and other, element-wise (binary operator radd). |
|
Return Subtraction of series and other, element-wise (binary operator rsub). |
|
Return Multiplication of series and other, element-wise (binary operator rmul). |
|
Return Floating division of series and other, element-wise (binary operator rtruediv). |
|
Return Floating division of series and other, element-wise (binary operator rtruediv). |
|
Return Integer division of series and other, element-wise (binary operator rfloordiv). |
|
Return Modulo of series and other, element-wise (binary operator rmod). |
|
Return Exponential power of series and other, element-wise (binary operator rpow). |
|
Combine the Series with a Series or scalar according to func. |
|
Combine Series values, choosing the calling Series’s values first. |
|
Round each value in a Series to the given number of decimals. |
|
Return Less than of series and other, element-wise (binary operator lt). |
|
Return Greater than of series and other, element-wise (binary operator gt). |
|
Return Less than or equal to of series and other, element-wise (binary operator le). |
|
Return Greater than or equal to of series and other, element-wise (binary operator ge). |
|
Return Not equal to of series and other, element-wise (binary operator ne). |
|
Return Equal to of series and other, element-wise (binary operator eq). |
|
Return the product of the values for the requested axis. |
|
Compute the dot product between the Series and the columns of other. |
Function application, groupby & window¶
|
Invoke function on values of Series. |
|
Aggregate using one or more operations over the specified axis. |
|
Aggregate using one or more operations over the specified axis. |
|
Call |
|
Map values of Series according to input correspondence. |
|
Group Series using a mapper or by a Series of columns. |
|
Provide rolling window calculations. |
|
Provide expanding transformations. |
|
Provide exponential weighted functions. |
|
Apply func(self, *args, **kwargs). |
Computations / descriptive stats¶
|
Return a Series/DataFrame with absolute numeric value of each element. |
|
Return whether all elements are True, potentially over an axis. |
|
Return whether any element is True, potentially over an axis. |
|
Compute the lag-N autocorrelation. |
|
Return boolean Series equivalent to left <= series <= right. |
|
Trim values at input threshold(s). |
|
Compute correlation with other Series, excluding missing values. |
|
Return number of non-NA/null observations in the Series. |
|
Compute covariance with Series, excluding missing values. |
|
Return cumulative maximum over a DataFrame or Series axis. |
|
Return cumulative minimum over a DataFrame or Series axis. |
|
Return cumulative product over a DataFrame or Series axis. |
|
Return cumulative sum over a DataFrame or Series axis. |
|
Generate descriptive statistics. |
|
First discrete difference of element. |
|
Encode the object as an enumerated type or categorical variable. |
|
Return unbiased kurtosis over requested axis. |
|
Return the mean absolute deviation of the values for the requested axis. |
|
Return the maximum of the values for the requested axis. |
|
Return the mean of the values for the requested axis. |
|
Return the median of the values for the requested axis. |
|
Return the minimum of the values for the requested axis. |
|
Return the mode(s) of the dataset. |
|
Return the largest n elements. |
|
Return the smallest n elements. |
|
Percentage change between the current and a prior element. |
|
Return the product of the values for the requested axis. |
|
Return value at the given quantile. |
|
Compute numerical data ranks (1 through n) along axis. |
|
Return unbiased standard error of the mean over requested axis. |
|
Return unbiased skew over requested axis. |
|
Return sample standard deviation over requested axis. |
|
Return the sum of the values for the requested axis. |
|
Return unbiased variance over requested axis. |
|
Return unbiased kurtosis over requested axis. |
|
Return unique values of Series object. |
|
Return number of unique elements in the object. |
Return boolean if values in the object are unique. |
|
Return boolean if values in the object are monotonic_increasing. |
|
Return boolean if values in the object are monotonic_increasing. |
|
Return boolean if values in the object are monotonic_decreasing. |
|
|
Return a Series containing counts of unique values. |
Reindexing / selection / label manipulation¶
|
Align two objects on their axes with the specified join method. |
|
Return Series with specified index labels removed. |
|
Return DataFrame with requested index / column level(s) removed. |
|
Return Series with duplicate values removed. |
|
Indicate duplicate Series values. |
|
Test whether two objects contain the same elements. |
|
Method to subset initial periods of time series data based on a date offset. |
|
Return the first n rows. |
|
Return the row label of the maximum value. |
|
Return the row label of the minimum value. |
|
Check whether values are contained in Series. |
|
Method to subset final periods of time series data based on a date offset. |
|
Conform Series to new index with optional filling logic. |
|
Return an object with matching indices as other object. |
|
Alter Series index labels or name. |
|
Set the name of the axis for the index or columns. |
|
Generate a new DataFrame or Series with the index reset. |
|
Return a random sample of items from an axis of object. |
|
Assign desired index to given axis. |
|
Return the elements in the given positional indices along an axis. |
|
Return the last n rows. |
|
Truncate a Series or DataFrame before and after some index value. |
|
Replace values where the condition is False. |
|
Replace values where the condition is True. |
|
Prefix labels with string prefix. |
|
Suffix labels with string suffix. |
|
Subset the dataframe rows or columns according to the specified index labels. |
Missing data handling¶
|
Detect missing values. |
|
Detect existing (non-missing) values. |
|
Return a new Series with missing values removed. |
|
Fill NA/NaN values using the specified method. |
|
Interpolate values according to different methods. |
Reshaping, sorting¶
|
Override ndarray.argsort. |
|
Return a ndarray of the minimum argument indexer. |
|
Return an ndarray of the maximum argument indexer. |
|
Rearrange index levels using input order. |
|
Sort by the values. |
|
Sort Series by index labels. |
|
Swap levels i and j in a |
|
Unstack, a.k.a. |
|
Transform each element of a list-like to a row, replicating the index values. |
|
Find indices where elements should be inserted to maintain order. |
|
Return the flattened underlying data as an ndarray. |
|
Repeat elements of a Series. |
|
Squeeze 1 dimensional axis objects into scalars. |
|
Create a new view of the Series. |
Combining / joining / merging¶
|
Concatenate two or more Series. |
|
Replace values given in to_replace with value. |
|
Modify Series in place using non-NA values from passed Series. |
Accessors¶
Pandas provides dtype-specific methods under various accessors.
These are separate namespaces within Series
that only apply
to specific data types.
Data Type |
Accessor |
---|---|
Datetime, Timedelta, Period |
|
String |
|
Categorical |
|
Sparse |
Datetimelike properties¶
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>
.
Datetime properties¶
Returns numpy array of python datetime.date objects (namely, the date part of Timestamps without timezone information). |
|
Returns numpy array of datetime.time. |
|
Returns numpy array of datetime.time also containing timezone information. |
|
The year of the datetime. |
|
The month as January=1, December=12. |
|
The month as January=1, December=12. |
|
The hours of the datetime. |
|
The minutes of the datetime. |
|
The seconds of the datetime. |
|
The microseconds of the datetime. |
|
The nanoseconds of the datetime. |
|
The week ordinal of the year. |
|
The week ordinal of the year. |
|
The day of the week with Monday=0, Sunday=6. |
|
The day of the week with Monday=0, Sunday=6. |
|
The ordinal day of the year. |
|
The quarter of the date. |
|
Indicates whether the date is the first day of the month. |
|
Indicates whether the date is the last day of the month. |
|
Indicator for whether the date is the first day of a quarter. |
|
Indicator for whether the date is the last day of a quarter. |
|
Indicate whether the date is the first day of a year. |
|
Indicate whether the date is the last day of the year. |
|
Boolean indicator if the date belongs to a leap year. |
|
The number of days in the month. |
|
The number of days in the month. |
|
Return timezone, if any. |
|
Datetime methods¶
|
Cast to PeriodArray/Index at a particular frequency. |
|
Return the data as an array of native Python datetime objects. |
|
Localize tz-naive Datetime Array/Index to tz-aware Datetime Array/Index. |
|
Convert tz-aware Datetime Array/Index from one time zone to another. |
|
Convert times to midnight. |
|
Convert to Index using specified date_format. |
|
Perform round operation on the data to the specified freq. |
|
Perform floor operation on the data to the specified freq. |
|
Perform ceil operation on the data to the specified freq. |
|
Return the month names of the DateTimeIndex with specified locale. |
|
Return the day names of the DateTimeIndex with specified locale. |
Period properties¶
Timedelta properties¶
Number of days for each element. |
|
Number of seconds (>= 0 and less than 1 day) for each element. |
|
Number of microseconds (>= 0 and less than 1 second) for each element. |
|
Number of nanoseconds (>= 0 and less than 1 microsecond) for each element. |
|
Return a Dataframe of the components of the Timedeltas. |
Timedelta methods¶
|
Return an array of native datetime.timedelta objects. |
|
Return total duration of each element expressed in seconds. |
String handling¶
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>
.
|
Convert strings in the Series/Index to be capitalized. |
|
Convert strings in the Series/Index to be casefolded. |
|
Concatenate strings in the Series/Index with given separator. |
|
Filling left and right side of strings in the Series/Index with an additional character. |
|
Test if pattern or regex is contained within a string of a Series or Index. |
|
Count occurrences of pattern in each string of the Series/Index. |
|
Decode character string in the Series/Index using indicated encoding. |
|
Encode character string in the Series/Index using indicated encoding. |
|
Test if the end of each string element matches a pattern. |
|
Extract capture groups in the regex pat as columns in a DataFrame. |
|
For each subject string in the Series, extract groups from all matches of regular expression pat. |
|
Return lowest indexes in each strings in the Series/Index where the substring is fully contained between [start:end]. |
|
Find all occurrences of pattern or regular expression in the Series/Index. |
|
Extract element from each component at specified position. |
|
Return lowest indexes in each strings where the substring is fully contained between [start:end]. |
|
Join lists contained as elements in the Series/Index with passed delimiter. |
|
Compute the length of each element in the Series/Index. |
|
Filling right side of strings in the Series/Index with an additional character. |
|
Convert strings in the Series/Index to lowercase. |
|
Remove leading and trailing characters. |
|
Determine if each string matches a regular expression. |
|
Return the Unicode normal form for the strings in the Series/Index. |
|
Pad strings in the Series/Index up to width. |
|
Split the string at the first occurrence of sep. |
|
Duplicate each string in the Series or Index. |
|
Replace occurrences of pattern/regex in the Series/Index with some other string. |
|
Return highest indexes in each strings in the Series/Index where the substring is fully contained between [start:end]. |
|
Return highest indexes in each strings where the substring is fully contained between [start:end]. |
|
Filling left side of strings in the Series/Index with an additional character. |
|
Split the string at the last occurrence of sep. |
|
Remove leading and trailing characters. |
|
Slice substrings from each element in the Series or Index. |
|
Replace a positional slice of a string with another value. |
|
Split strings around given separator/delimiter. |
|
Split strings around given separator/delimiter. |
|
Test if the start of each string element matches a pattern. |
|
Remove leading and trailing characters. |
|
Convert strings in the Series/Index to be swapcased. |
|
Convert strings in the Series/Index to titlecase. |
|
Map all characters in the string through the given mapping table. |
|
Convert strings in the Series/Index to uppercase. |
|
Wrap long strings in the Series/Index to be formatted in paragraphs with length less than a given width. |
|
Pad strings in the Series/Index by prepending ‘0’ characters. |
|
Check whether all characters in each string are alphanumeric. |
|
Check whether all characters in each string are alphabetic. |
|
Check whether all characters in each string are digits. |
|
Check whether all characters in each string are whitespace. |
|
Check whether all characters in each string are lowercase. |
|
Check whether all characters in each string are uppercase. |
|
Check whether all characters in each string are titlecase. |
|
Check whether all characters in each string are numeric. |
|
Check whether all characters in each string are decimal. |
|
Split each string in the Series by sep and return a DataFrame of dummy/indicator variables. |
Categorical accessor¶
Categorical-dtype specific methods and attributes are available under
the Series.cat
accessor.
The categories of this categorical. |
|
Whether the categories have an ordered relationship. |
|
Return Series of codes as well as the index. |
|
Rename categories. |
|
Reorder categories as specified in new_categories. |
|
Add new categories. |
|
Remove the specified categories. |
|
Remove categories which are not used. |
|
Set the categories to the specified new_categories. |
|
Set the Categorical to be ordered. |
|
Set the Categorical to be unordered. |
Sparse accessor¶
Sparse-dtype specific methods and attributes are provided under the
Series.sparse
accessor.
The number of non- |
|
The percent of non- |
|
Elements in data that are fill_value are not stored. |
|
An ndarray containing the non- |
|
Create a Series with sparse values from a scipy.sparse.coo_matrix. |
|
Create a scipy.sparse.coo_matrix from a Series with MultiIndex. |
Metadata¶
Series.attrs
is a dictionary for storing global metadata for this Series.
Warning
Series.attrs
is considered experimental and may change without warning.
Dictionary of global attributes on this object. |
Plotting¶
Series.plot
is both a callable method and a namespace attribute for
specific plotting methods of the form Series.plot.<kind>
.
|
Series plotting accessor and method |
|
Draw a stacked area plot. |
|
Vertical bar plot. |
|
Make a horizontal bar plot. |
|
Make a box plot of the DataFrame columns. |
|
Generate Kernel Density Estimate plot using Gaussian kernels. |
|
Draw one histogram of the DataFrame’s columns. |
|
Generate Kernel Density Estimate plot using Gaussian kernels. |
|
Plot Series or DataFrame as lines. |
|
Generate a pie plot. |
|
Draw histogram of the input series using matplotlib. |
Serialization / IO / conversion¶
|
Pickle (serialize) object to file. |
|
Write object to a comma-separated values (csv) file. |
|
Convert Series to {label -> value} dict or dict-like object. |
|
Write object to an Excel sheet. |
|
Convert Series to DataFrame. |
|
Return an xarray object from the pandas object. |
|
Write the contained data to an HDF5 file using HDFStore. |
|
Write records stored in a DataFrame to a SQL database. |
|
Convert the object to a JSON string. |
|
Render a string representation of the Series. |
|
Copy object to the system clipboard. |
|
Render object to a LaTeX tabular, longtable, or nested table/tabular. |
|
Print Series in Markdown-friendly format. |