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 True if there are any NaNs. | |
| Indicator whether Series/DataFrame is empty. | |
| Return the dtype object of the underlying data. | |
| Return the name of the Series. | |
| Get the properties associated with this pandas object. | |
| 
 | Return a new object with updated flags. | 
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 Series or DataFrame. | |
| 
 | A NumPy ndarray representing the values in this Series or Index. | 
| 
 | Convert Series from DatetimeIndex to PeriodIndex. | 
| 
 | 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. | |
| (DEPRECATED) Lazily iterate over (index, value) tuples. | |
| Return alias for index. | |
| 
 | Return item and drops from series. | 
| 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. | 
| 
 | Update null elements with value in the same location in 'other'. | 
| 
 | 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 over 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 an input mapping or function. | 
| 
 | Group Series using a mapper or by a Series of columns. | 
| 
 | Provide rolling window calculations. | 
| 
 | Provide expanding window calculations. | 
| 
 | Provide exponentially weighted (EW) calculations. | 
| 
 | Apply chainable functions that expect Series or DataFrames. | 
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. | 
| 
 | (DEPRECATED) Return the mean absolute deviation of the values over the requested axis. | 
| 
 | Return the maximum of the values over the requested axis. | 
| 
 | Return the mean of the values over the requested axis. | 
| 
 | Return the median of the values over the requested axis. | 
| 
 | Return the minimum of the values over the requested axis. | 
| 
 | Return the mode(s) of the Series. | 
| 
 | 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 over 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 over 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. | |
| (DEPRECATED) Return boolean if values in the object are monotonically increasing. | |
| Return boolean if values in the object are monotonically increasing. | |
| Return boolean if values in the object are monotonically 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 Series/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. | 
| 
 | Select 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. | 
| 
 | Whether elements in Series are contained in values. | 
| 
 | Select 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#
| 
 | Synonym for  | 
| 
 | Synonym for  | 
| 
 | Return a new Series with missing values removed. | 
| 
 | Synonym for  | 
| 
 | Fill NA/NaN values using the specified method. | 
| 
 | Fill NaN values using an interpolation method. | 
| Detect missing values. | |
| Series.isnull is an alias for Series.isna. | |
| Detect existing (non-missing) values. | |
| Series.notnull is an alias for Series.notna. | |
| 
 | Synonym for  | 
| 
 | Replace values given in to_replace with value. | 
Reshaping, sorting#
| 
 | Return the integer indices that would sort the Series values. | 
| 
 | Return int position of the smallest value in the Series. | 
| 
 | Return int position of the largest value in the Series. | 
| 
 | Rearrange index levels using input order. | 
| 
 | Sort by the values. | 
| 
 | Sort Series by index labels. | 
| 
 | Swap levels i and j in a  | 
| 
 | Unstack, also known as pivot, Series with MultiIndex to produce DataFrame. | 
| 
 | Transform each element of a list-like to a row. | 
| 
 | 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 / comparing / joining / merging#
| 
 | (DEPRECATED) Concatenate two or more Series. | 
| 
 | Compare to another Series and show the differences. | 
| 
 | Modify Series in place using 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  | |
| Returns numpy array of  | |
| Returns numpy array of  | |
| The year of the datetime. | |
| The month as January=1, December=12. | |
| The day of the datetime. | |
| 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. | |
| (DEPRECATED) The week ordinal of the year according to the ISO 8601 standard. | |
| (DEPRECATED) The week ordinal of the year according to the ISO 8601 standard. | |
| The day of the week with Monday=0, Sunday=6. | |
| 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 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 the timezone. | |
| Return the frequency object for this PeriodArray. | 
Datetime methods#
| Calculate year, week, and day according to the ISO 8601 standard. | |
| 
 | Cast to PeriodArray/Index at a particular frequency. | 
| Return the data as an array of  | |
| 
 | 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 with specified locale. | 
| 
 | Return the day names with specified locale. | 
Period properties#
| Get the Timestamp for the start of the period. | |
| Get the Timestamp for the end of the period. | 
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  | |
| 
 | 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. | 
| 
 | Pad left and right side of strings in the Series/Index. | 
| 
 | 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. | 
| 
 | Extract capture groups in the regex pat as columns in DataFrame. | 
| 
 | Return lowest indexes in each strings in the Series/Index. | 
| 
 | Find all occurrences of pattern or regular expression in the Series/Index. | 
| 
 | Determine if each string entirely matches a regular expression. | 
| Extract element from each component at specified position or with specified key. | |
| 
 | Return lowest indexes in each string in Series/Index. | 
| 
 | Join lists contained as elements in the Series/Index with passed delimiter. | 
| Compute the length of each element in the Series/Index. | |
| 
 | Pad right side of strings in the Series/Index. | 
| Convert strings in the Series/Index to lowercase. | |
| 
 | Remove leading characters. | 
| 
 | Determine if each string starts with a match of 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. | 
| 
 | Remove a prefix from an object series. | 
| 
 | Remove a suffix from an object series. | 
| 
 | Duplicate each string in the Series or Index. | 
| 
 | Replace each occurrence of pattern/regex in the Series/Index. | 
| 
 | Return highest indexes in each strings in the Series/Index. | 
| 
 | Return highest indexes in each string in Series/Index. | 
| 
 | Pad left side of strings in the Series/Index. | 
| 
 | Split the string at the last occurrence of sep. | 
| 
 | Remove 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 strings in Series/Index at specified line 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. | |
| 
 | Return DataFrame of dummy/indicator variables for Series. | 
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. | 
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 Series.attrs.
| 
 | Flags that apply to pandas objects. | 
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 of this dataset. | 
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. | 
| 
 | Print Series in Markdown-friendly format. |