Pandas Series

This is basic Pandas* data structure representing a dataframe column. In NumPy* terms this is one-dimensional ndarray with axis labels.

Constructor

Series

One-dimensional ndarray with axis labels (including time series).

Attributes/Operators

Series.index

The index (axis labels) of the Series.

Series.array

The ExtensionArray of the data backing this Series or Index.

Unsupported by Intel SDC.

Series.values

Return Series as ndarray or ndarray-like depending on the dtype.

Series.dtype

Return the dtype object of the underlying data.

Unsupported by Intel SDC.

Series.shape

Return a tuple of the shape of the underlying data.

Series.nbytes

Return the number of bytes in the underlying data.

Unsupported by Intel SDC.

Series.ndim

Number of dimensions of the underlying data, by definition 1.

Series.size

Return the number of elements in the underlying data.

Series.T

Return the transpose, which is by definition self.

Series.memory_usage

Return the memory usage of the Series.

Unsupported by Intel SDC.

Series.hasnans

Return if I have any nans; enables various perf speedups.

Unsupported by Intel SDC.

Series.empty

Unsupported by Intel SDC.

Series.dtypes

Return the dtype object of the underlying data.

Unsupported by Intel SDC.

Series.name

Return name of the Series.

Unsupported by Intel SDC.

Series.put

Apply the put method to its values attribute if it has one.

Unsupported by Intel SDC.

Series.getitem

Get value(s) of Series by key.

Series.setitem

Set value to Series by index

Type Conversions

Series.astype

Cast a pandas object to a specified dtype dtype.

Series.infer_objects

Attempt to infer better dtypes for object columns.

Unsupported by Intel SDC.

Series.copy

Make a copy of this object’s indices and data.

Series.bool

Return the bool of a single element PandasObject.

Unsupported by Intel SDC.

Series.to_numpy

A NumPy ndarray representing the values in this Series or Index.

Unsupported by Intel SDC.

Series.to_period

Convert Series from DatetimeIndex to PeriodIndex with desired frequency (inferred from index if not passed).

Unsupported by Intel SDC.

Series.to_timestamp

Cast to DatetimeIndex of Timestamps, at beginning of period.

Unsupported by Intel SDC.

Series.to_list

Return a list of the values.

Unsupported by Intel SDC.

Series.get_values

Same as values (but handles sparseness conversions); is a view.

Unsupported by Intel SDC.

Series.__array__

Return the values as a NumPy array.

Unsupported by Intel SDC.

Indexing and Iteration

Series.get

Get item from object for given key (ex: DataFrame column).

Unsupported by Intel SDC.

Series.at

Access a single value for a row/column label pair.

Series.iat

Access a single value for a row/column pair by integer position.

Series.loc

Access a group of rows and columns by label(s) or a boolean array.

Series.iloc

Purely integer-location based indexing for selection by position.

Series.__iter__

Return an iterator of the values.

Unsupported by Intel SDC.

Series.items

Lazily iterate over (index, value) tuples.

Unsupported by Intel SDC.

Series.iteritems

Lazily iterate over (index, value) tuples.

Unsupported by Intel SDC.

Series.keys

Return alias for index.

Unsupported by Intel SDC.

Series.pop

Return item and drop from frame. Raise KeyError if not found.

Unsupported by Intel SDC.

Series.item

Return the first element of the underlying data as a python scalar.

Unsupported by Intel SDC.

Series.xs

Return cross-section from the Series/DataFrame.

Unsupported by Intel SDC.

For more information on .at, .iat, .loc, and .iloc, see the indexing documentation.

Binary Operator Functions

Series.add

Return Addition of series and other, element-wise (binary operator add).

Series.sub

Return Subtraction of series and other, element-wise (binary operator sub).

Series.mul

Return Multiplication of series and other, element-wise (binary operator mul).

Series.div

Return Floating division of series and other, element-wise (binary operator truediv).

Series.truediv

Return Floating division of series and other, element-wise (binary operator truediv).

Series.floordiv

Return Integer division of series and other, element-wise (binary operator floordiv).

Series.mod

Return Modulo of series and other, element-wise (binary operator mod).

Series.pow

Return Exponential power of series and other, element-wise (binary operator pow).

Series.radd

Return Addition of series and other, element-wise (binary operator radd).

Unsupported by Intel SDC.

Series.rsub

Return Subtraction of series and other, element-wise (binary operator rsub).

Unsupported by Intel SDC.

Series.rmul

Return Multiplication of series and other, element-wise (binary operator rmul).

Unsupported by Intel SDC.

Series.rdiv

Return Floating division of series and other, element-wise (binary operator rtruediv).

Unsupported by Intel SDC.

Series.rtruediv

Return Floating division of series and other, element-wise (binary operator rtruediv).

Unsupported by Intel SDC.

Series.rfloordiv

Return Integer division of series and other, element-wise (binary operator rfloordiv).

Unsupported by Intel SDC.

Series.rmod

Return Modulo of series and other, element-wise (binary operator rmod).

Unsupported by Intel SDC.

Series.rpow

Return Exponential power of series and other, element-wise (binary operator rpow).

Unsupported by Intel SDC.

Series.combine

Combine the Series with a Series or scalar according to func.

Unsupported by Intel SDC.

Series.combine_first

Combine Series values, choosing the calling Series’s values first.

Unsupported by Intel SDC.

Series.round

Round each value in a Series to the given number of decimals.

Unsupported by Intel SDC.

Series.lt

Return Less than of series and other, element-wise (binary operator lt).

Series.gt

Return Greater than of series and other, element-wise (binary operator gt).

Series.le

Return Less than or equal to of series and other, element-wise (binary operator le).

Series.ge

Return Greater than or equal to of series and other, element-wise (binary operator ge).

Series.ne

Return Not equal to of series and other, element-wise (binary operator ne).

Series.eq

Return Equal to of series and other, element-wise (binary operator eq).

Series.product

Return the product of the values for the requested axis.

Unsupported by Intel SDC.

Series.dot

Compute the dot product between the Series and the columns of other.

Unsupported by Intel SDC.

User-Defined Functions, GroupBy, Window

Series.apply

Invoke function on values of Series.

Series.agg

Aggregate using one or more operations over the specified axis.

Unsupported by Intel SDC.

Series.aggregate

Aggregate using one or more operations over the specified axis.

Unsupported by Intel SDC.

Series.transform

Call func on self producing a Series with transformed values and that has the same axis length as self.

Unsupported by Intel SDC.

Series.map

Map values of Series according to input correspondence.

Series.groupby

Group DataFrame or Series using a mapper or by a Series of columns.

Series.rolling

Provide rolling window calculations.

Series.expanding

Provide expanding transformations.

Unsupported by Intel SDC.

Series.ewm

Provide exponential weighted functions.

Unsupported by Intel SDC.

Series.pipe

Apply func(self, \*args, \*\*kwargs).

Unsupported by Intel SDC.

Computations, Descriptive Statistics

Series.abs

Return a Series/DataFrame with absolute numeric value of each element.

Series.all

Return whether all elements are True, potentially over an axis.

Unsupported by Intel SDC.

Series.any

Return whether any element is True, potentially over an axis.

Unsupported by Intel SDC.

Series.autocorr

Compute the lag-N autocorrelation.

Unsupported by Intel SDC.

Series.between

Return boolean Series equivalent to left <= series <= right.

Unsupported by Intel SDC.

Series.clip

Trim values at input threshold(s).

Unsupported by Intel SDC.

Series.corr

Compute correlation with other Series, excluding missing values.

Series.count

Return number of non-NA/null observations in the Series.

Series.cov

Compute covariance with Series, excluding missing values.

Series.cummax

Return cumulative maximum over a DataFrame or Series axis.

Unsupported by Intel SDC.

Series.cummin

Return cumulative minimum over a DataFrame or Series axis.

Unsupported by Intel SDC.

Series.cumprod

Return cumulative product over a DataFrame or Series axis.

Unsupported by Intel SDC.

Series.cumsum

Return cumulative sum over a DataFrame or Series axis.

Series.describe

Generate descriptive statistics that summarize the central tendency, dispersion and shape of a dataset’s distribution, excluding NaN values.

Series.diff

First discrete difference of element.

Unsupported by Intel SDC.

Series.factorize

Encode the object as an enumerated type or categorical variable.

Unsupported by Intel SDC.

Series.kurt

Return unbiased kurtosis over requested axis using Fisher’s definition of kurtosis (kurtosis of normal == 0.0). Normalized by N-1.

Unsupported by Intel SDC.

Series.mad

Return the mean absolute deviation of the values for the requested axis.

Unsupported by Intel SDC.

Series.max

Return the maximum of the values for the requested axis.

Series.mean

Return the mean of the values for the requested axis.

Series.median

Return the median of the values for the requested axis.

Series.min

Return the minimum of the values for the requested axis.

Series.mode

Return the mode(s) of the dataset.

Unsupported by Intel SDC.

Series.nlargest

Return the largest n elements.

Series.nsmallest

Return the smallest n elements.

Series.pct_change

Percentage change between the current and a prior element.

Series.prod

Return the product of the values for the requested axis.

Series.quantile

Return value at the given quantile.

Series.rank

Compute numerical data ranks (1 through n) along axis.

Unsupported by Intel SDC.

Series.sem

Return unbiased standard error of the mean over requested axis.

Unsupported by Intel SDC.

Series.skew

Return unbiased skew over requested axis Normalized by N-1.

Unsupported by Intel SDC.

Series.std

Return sample standard deviation over requested axis.

Series.sum

Return the sum of the values for the requested axis.

Series.var

Return unbiased variance over requested axis.

Series.kurtosis

Return unbiased kurtosis over requested axis using Fisher’s definition of kurtosis (kurtosis of normal == 0.0). Normalized by N-1.

Unsupported by Intel SDC.

Series.unique

Return unique values of Series object.

Series.nunique

Return number of unique elements in the object.

Series.is_unique

Return boolean if values in the object are unique.

Unsupported by Intel SDC.

Series.is_monotonic

Return boolean if values in the object are monotonic_increasing.

Unsupported by Intel SDC.

Series.is_monotonic_increasing

Return boolean if values in the object are monotonic_increasing.

Unsupported by Intel SDC.

Series.is_monotonic_decreasing

Return boolean if values in the object are monotonic_decreasing.

Unsupported by Intel SDC.

Series.value_counts

Return a Series containing counts of unique values.

Series.compound

Return the compound percentage of the values for the requested axis.

Unsupported by Intel SDC.

Re-Indexing, Selection, Label Manipulation

Series.align

Align two objects on their axes with the specified join method for each axis Index.

Unsupported by Intel SDC.

Series.drop

Return Series with specified index labels removed.

Unsupported by Intel SDC.

Series.droplevel

Return DataFrame with requested index / column level(s) removed.

Unsupported by Intel SDC.

Series.drop_duplicates

Return Series with duplicate values removed.

Unsupported by Intel SDC.

Series.duplicated

Indicate duplicate Series values.

Unsupported by Intel SDC.

Series.equals

Test whether two objects contain the same elements.

Unsupported by Intel SDC.

Series.first

Convenience method for subsetting initial periods of time series data based on a date offset.

Unsupported by Intel SDC.

Series.head

Return the first n rows.

Series.idxmax

Return the row label of the maximum value.

Series.idxmin

Return the row label of the minimum value.

Series.isin

Check whether values are contained in Series.

Series.last

Convenience method for subsetting final periods of time series data based on a date offset.

Unsupported by Intel SDC.

Series.reindex

Conform Series to new index with optional filling logic, placing NA/NaN in locations having no value in the previous index. A new object is produced unless the new index is equivalent to the current one and copy=False.

Unsupported by Intel SDC.

Series.reindex_like

Return an object with matching indices as other object.

Unsupported by Intel SDC.

Series.rename

Alter Series index labels or name.

Series.rename_axis

Set the name of the axis for the index or columns.

Unsupported by Intel SDC.

Series.reset_index

Generate a new DataFrame or Series with the index reset.

Unsupported by Intel SDC.

Series.sample

Return a random sample of items from an axis of object.

Unsupported by Intel SDC.

Series.set_axis

Assign desired index to given axis.

Unsupported by Intel SDC.

Series.take

Return the elements in the given positional indices along an axis.

Series.tail

Return the last n rows.

Unsupported by Intel SDC.

Series.truncate

Truncate a Series or DataFrame before and after some index value.

Unsupported by Intel SDC.

Series.where

Replace values where the condition is False.

Unsupported by Intel SDC.

Series.mask

Replace values where the condition is True.

Unsupported by Intel SDC.

Series.add_prefix

Prefix labels with string prefix.

Unsupported by Intel SDC.

Series.add_suffix

Suffix labels with string suffix.

Unsupported by Intel SDC.

Series.filter

Subset rows or columns of dataframe according to labels in the specified index.

Unsupported by Intel SDC.

Missing Data Handling

Series.isna

Detect missing values.

Series.notna

Detect existing (non-missing) values.

Series.dropna

Return a new Series with missing values removed.

Series.fillna

Fill NA/NaN values using the specified method.

Series.interpolate

Interpolate values according to different methods.

Unsupported by Intel SDC.

Re-Shaping, Sorting

Series.argsort

Override ndarray.argsort. Argsorts the value, omitting NA/null values, and places the result in the same locations as the non-NA values.

Series.argmin

Return the row label of the minimum value.

Unsupported by Intel SDC.

Series.argmax

Return the row label of the maximum value.

Unsupported by Intel SDC.

Series.reorder_levels

Rearrange index levels using input order.

Unsupported by Intel SDC.

Series.sort_values

Sort by the values.

Series.sort_index

Sort Series by index labels.

Unsupported by Intel SDC.

Series.swaplevel

Swap levels i and j in a MultiIndex.

Unsupported by Intel SDC.

Series.unstack

Unstack, a.k.a. pivot, Series with MultiIndex to produce DataFrame. The level involved will automatically get sorted.

Unsupported by Intel SDC.

Series.explode

Transform each element of a list-like to a row, replicating the index values.

Unsupported by Intel SDC.

Series.searchsorted

Find indices where elements should be inserted to maintain order.

Unsupported by Intel SDC.

Series.ravel

Return the flattened underlying data as an ndarray.

Unsupported by Intel SDC.

Series.repeat

Repeat elements of a Series.

Unsupported by Intel SDC.

Series.squeeze

Squeeze 1 dimensional axis objects into scalars.

Unsupported by Intel SDC.

Series.view

Create a new view of the Series.

Unsupported by Intel SDC.

Combining, Joining, Merging

Series.append

Concatenate two or more Series.

Series.replace

Replace values given in to_replace with value.

Unsupported by Intel SDC.

Series.update

Modify Series in place using non-NA values from passed Series. Aligns on index.

Unsupported by Intel SDC.

Time Series

Series.asfreq

Convert TimeSeries to specified frequency.

Unsupported by Intel SDC.

Series.asof

Return the last row(s) without any NaNs before where.

Unsupported by Intel SDC.

Series.shift

Shift index by desired number of periods with an optional time freq.

Series.first_valid_index

Return index for first non-NA/null value.

Unsupported by Intel SDC.

Series.last_valid_index

Return index for last non-NA/null value.

Unsupported by Intel SDC.

Series.resample

Resample time-series data.

Unsupported by Intel SDC.

Series.tz_convert

Convert tz-aware axis to target time zone.

Unsupported by Intel SDC.

Series.tz_localize

Localize tz-naive index of a Series or DataFrame to target time zone.

Unsupported by Intel SDC.

Series.at_time

Select values at particular time of day (e.g. 9:30AM).

Unsupported by Intel SDC.

Series.between_time

Select values between particular times of the day (e.g., 9:00-9:30 AM).

Unsupported by Intel SDC.

Series.tshift

Shift the time index, using the index’s frequency if available.

Unsupported by Intel SDC.

Series.slice_shift

Equivalent to shift without copying data. The shifted data will not include the dropped periods and the shifted axis will be smaller than the original.

Unsupported by Intel SDC.

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

dt

String

str

Categorical

cat

Sparse

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

Series.dt.date

Returns numpy array of python datetime.date objects (namely, the date part of Timestamps without timezone information).

Unsupported by Intel SDC.

Series.dt.time

Returns numpy array of datetime.time. The time part of the Timestamps.

Unsupported by Intel SDC.

Series.dt.timetz

Returns numpy array of datetime.time also containing timezone information. The time part of the Timestamps.

Unsupported by Intel SDC.

Series.dt.year

The year of the datetime.

Unsupported by Intel SDC.

Series.dt.month

The month as January=1, December=12.

Unsupported by Intel SDC.

Series.dt.day

The days of the datetime.

Unsupported by Intel SDC.

Series.dt.hour

The hours of the datetime.

Unsupported by Intel SDC.

Series.dt.minute

The minutes of the datetime.

Unsupported by Intel SDC.

Series.dt.second

The seconds of the datetime.

Unsupported by Intel SDC.

Series.dt.microsecond

The microseconds of the datetime.

Unsupported by Intel SDC.

Series.dt.nanosecond

The nanoseconds of the datetime.

Unsupported by Intel SDC.

Series.dt.week

The week ordinal of the year.

Unsupported by Intel SDC.

Series.dt.weekofyear

The week ordinal of the year.

Unsupported by Intel SDC.

Series.dt.dayofweek

The day of the week with Monday=0, Sunday=6.

Unsupported by Intel SDC.

Series.dt.weekday

The day of the week with Monday=0, Sunday=6.

Unsupported by Intel SDC.

Series.dt.dayofyear

The ordinal day of the year.

Unsupported by Intel SDC.

Series.dt.quarter

The quarter of the date.

Unsupported by Intel SDC.

Series.dt.is_month_start

Indicates whether the date is the first day of the month.

Unsupported by Intel SDC.

Series.dt.is_month_end

Indicates whether the date is the last day of the month.

Unsupported by Intel SDC.

Series.dt.is_quarter_start

Indicator for whether the date is the first day of a quarter.

Unsupported by Intel SDC.

Series.dt.is_quarter_end

Indicator for whether the date is the last day of a quarter.

Unsupported by Intel SDC.

Series.dt.is_year_start

Indicate whether the date is the first day of a year.

Unsupported by Intel SDC.

Series.dt.is_year_end

Indicate whether the date is the last day of the year.

Unsupported by Intel SDC.

Series.dt.is_leap_year

Boolean indicator if the date belongs to a leap year.

Unsupported by Intel SDC.

Series.dt.daysinmonth

The number of days in the month.

Unsupported by Intel SDC.

Series.dt.days_in_month

The number of days in the month.

Unsupported by Intel SDC.

Series.dt.tz

Return timezone, if any.

Unsupported by Intel SDC.

Series.dt.freq

Unsupported by Intel SDC.

Datetime methods

Series.dt.to_period

Cast to PeriodArray/Index at a particular frequency.

Unsupported by Intel SDC.

Series.dt.to_pydatetime

Return the data as an array of native Python datetime objects.

Unsupported by Intel SDC.

Series.dt.tz_localize

Localize tz-naive Datetime Array/Index to tz-aware Datetime Array/Index.

Unsupported by Intel SDC.

Series.dt.tz_convert

Convert tz-aware Datetime Array/Index from one time zone to another.

Unsupported by Intel SDC.

Series.dt.normalize

Convert times to midnight.

Unsupported by Intel SDC.

Series.dt.strftime

Convert to Index using specified date_format.

Unsupported by Intel SDC.

Series.dt.round

Perform round operation on the data to the specified freq.

Unsupported by Intel SDC.

Series.dt.floor

Perform floor operation on the data to the specified freq.

Unsupported by Intel SDC.

Series.dt.ceil

Perform ceil operation on the data to the specified freq.

Unsupported by Intel SDC.

Series.dt.month_name

Return the month names of the DateTimeIndex with specified locale.

Unsupported by Intel SDC.

Series.dt.day_name

Return the day names of the DateTimeIndex with specified locale.

Unsupported by Intel SDC.

Period properties

Series.dt.qyear

Unsupported by Intel SDC.

Series.dt.start_time

Unsupported by Intel SDC.

Series.dt.end_time

Unsupported by Intel SDC.

Timedelta properties

Series.dt.days

Number of days for each element.

Unsupported by Intel SDC.

Series.dt.seconds

Number of seconds (>= 0 and less than 1 day) for each element.

Unsupported by Intel SDC.

Series.dt.microseconds

Number of microseconds (>= 0 and less than 1 second) for each element.

Unsupported by Intel SDC.

Series.dt.nanoseconds

Number of nanoseconds (>= 0 and less than 1 microsecond) for each element.

Unsupported by Intel SDC.

Series.dt.components

Return a Dataframe of the components of the Timedeltas.

Unsupported by Intel SDC.

Timedelta methods

Series.dt.to_pytimedelta

Return an array of native datetime.timedelta objects.

Unsupported by Intel SDC.

Series.dt.total_seconds

Return total duration of each element expressed in seconds.

Unsupported by Intel SDC.

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>.

Series.str.capitalize

Convert strings in the Series/Index to be capitalized.

Series.str.casefold

Convert strings in the Series/Index to be casefolded.

Series.str.cat

Concatenate strings in the Series/Index with given separator.

Unsupported by Intel SDC.

Series.str.center

Filling left and right side of strings in the Series/Index with an additional character. Equivalent to str.center().

Series.str.contains

Test if pattern or regex is contained within a string of a Series or Index.

Unsupported by Intel SDC.

Series.str.count

Count occurrences of pattern in each string of the Series/Index.

Unsupported by Intel SDC.

Series.str.decode

Decode character string in the Series/Index using indicated encoding. Equivalent to str.decode() in python2 and bytes.decode() in python3.

Unsupported by Intel SDC.

Series.str.encode

Encode character string in the Series/Index using indicated encoding. Equivalent to str.encode().

Unsupported by Intel SDC.

Series.str.endswith

Test if the end of each string element matches a pattern.

Series.str.extract

Extract capture groups in the regex pat as columns in a DataFrame.

Unsupported by Intel SDC.

Series.str.extractall

For each subject string in the Series, extract groups from all matches of regular expression pat. When each subject string in the Series has exactly one match, extractall(pat).xs(0, level=’match’) is the same as extract(pat).

Unsupported by Intel SDC.

Series.str.find

Return lowest indexes in each strings in the Series/Index where the substring is fully contained between [start:end]. Return -1 on failure. Equivalent to standard str.find().

Series.str.findall

Find all occurrences of pattern or regular expression in the Series/Index.

Unsupported by Intel SDC.

Series.str.get

Extract element from each component at specified position.

Unsupported by Intel SDC.

Series.str.index

Return lowest indexes in each strings where the substring is fully contained between [start:end]. This is the same as str.find except instead of returning -1, it raises a ValueError when the substring is not found. Equivalent to standard str.index.

Unsupported by Intel SDC.

Series.str.join

Join lists contained as elements in the Series/Index with passed delimiter.

Unsupported by Intel SDC.

Series.str.len

Compute the length of each element in the Series/Index. The element may be a sequence (such as a string, tuple or list) or a collection (such as a dictionary).

Series.str.ljust

Filling right side of strings in the Series/Index with an additional character. Equivalent to str.ljust().

Series.str.lower

Convert strings in the Series/Index to lowercase.

Series.str.lstrip

Remove leading and trailing characters.

Series.str.match

Determine if each string matches a regular expression.

Unsupported by Intel SDC.

Series.str.normalize

Return the Unicode normal form for the strings in the Series/Index. For more information on the forms, see the unicodedata.normalize().

Unsupported by Intel SDC.

Series.str.pad

Pad strings in the Series/Index up to width.

Unsupported by Intel SDC.

Series.str.partition

Split the string at the first occurrence of sep.

Unsupported by Intel SDC.

Series.str.repeat

Duplicate each string in the Series or Index.

Unsupported by Intel SDC.

Series.str.replace

Replace occurrences of pattern/regex in the Series/Index with some other string. Equivalent to str.replace() or re.sub().

Unsupported by Intel SDC.

Series.str.rfind

Return highest indexes in each strings in the Series/Index where the substring is fully contained between [start:end]. Return -1 on failure. Equivalent to standard str.rfind().

Unsupported by Intel SDC.

Series.str.rindex

Return highest indexes in each strings where the substring is fully contained between [start:end]. This is the same as str.rfind except instead of returning -1, it raises a ValueError when the substring is not found. Equivalent to standard str.rindex.

Unsupported by Intel SDC.

Series.str.rjust

Filling left side of strings in the Series/Index with an additional character. Equivalent to str.rjust().

Series.str.rpartition

Split the string at the last occurrence of sep.

Unsupported by Intel SDC.

Series.str.rstrip

Remove leading and trailing characters.

Series.str.slice

Slice substrings from each element in the Series or Index.

Unsupported by Intel SDC.

Series.str.slice_replace

Replace a positional slice of a string with another value.

Unsupported by Intel SDC.

Series.str.split

Split strings around given separator/delimiter.

Unsupported by Intel SDC.

Series.str.rsplit

Split strings around given separator/delimiter.

Unsupported by Intel SDC.

Series.str.startswith

Test if the start of each string element matches a pattern.

Series.str.strip

Remove leading and trailing characters.

Series.str.swapcase

Convert strings in the Series/Index to be swapcased.

Series.str.title

Convert strings in the Series/Index to titlecase.

Series.str.translate

Map all characters in the string through the given mapping table. Equivalent to standard str.translate().

Unsupported by Intel SDC.

Series.str.upper

Convert strings in the Series/Index to uppercase.

Series.str.wrap

Wrap long strings in the Series/Index to be formatted in paragraphs with length less than a given width.

Unsupported by Intel SDC.

Series.str.zfill

Pad strings in the Series/Index by prepending ‘0’ characters.

Series.str.isalnum

Check whether all characters in each string are alphanumeric.

Series.str.isalpha

Check whether all characters in each string are alphabetic.

Series.str.isdigit

Check whether all characters in each string are digits.

Series.str.isspace

Check whether all characters in each string are whitespace.

Series.str.islower

Check whether all characters in each string are lowercase.

Series.str.isupper

Check whether all characters in each string are uppercase.

Series.str.istitle

Check whether all characters in each string are titlecase.

Series.str.isnumeric

Check whether all characters in each string are numeric.

Series.str.isdecimal

Check whether all characters in each string are decimal.

Series.str.get_dummies

Split each string in the Series by sep and return a DataFrame of dummy/indicator variables.

Unsupported by Intel SDC.

Categorical Accessor

Categorical-dtype specific methods and attributes are available under the Series.cat accessor.

Series.cat.categories

The categories of this categorical.

Unsupported by Intel SDC.

Series.cat.ordered

Whether the categories have an ordered relationship.

Unsupported by Intel SDC.

Series.cat.codes

Return Series of codes as well as the index.

Unsupported by Intel SDC.

Series.cat.rename_categories

Rename categories.

Unsupported by Intel SDC.

Series.cat.reorder_categories

Reorder categories as specified in new_categories.

Unsupported by Intel SDC.

Series.cat.add_categories

Add new categories.

Unsupported by Intel SDC.

Series.cat.remove_categories

Remove the specified categories.

Unsupported by Intel SDC.

Series.cat.remove_unused_categories

Remove categories which are not used.

Unsupported by Intel SDC.

Series.cat.set_categories

Set the categories to the specified new_categories.

Unsupported by Intel SDC.

Series.cat.as_ordered

Set the Categorical to be ordered.

Unsupported by Intel SDC.

Series.cat.as_unordered

Set the Categorical to be unordered.

Unsupported by Intel SDC.

Sparse Accessor

Sparse-dtype specific methods and attributes are provided under the Series.sparse accessor.

Series.sparse.npoints

The number of non- fill_value points.

Unsupported by Intel SDC.

Series.sparse.density

The percent of non- fill_value points, as decimal.

Unsupported by Intel SDC.

Series.sparse.fill_value

Elements in data that are fill_value are not stored.

Unsupported by Intel SDC.

Series.sparse.sp_values

An ndarray containing the non- fill_value values.

Unsupported by Intel SDC.

Series.sparse.from_coo

Create a SparseSeries from a scipy.sparse.coo_matrix.

Unsupported by Intel SDC.

Series.sparse.to_coo

Create a scipy.sparse.coo_matrix from a SparseSeries with MultiIndex.

Unsupported by Intel SDC.

Plotting

Series.plot is both a callable method and a namespace attribute for specific plotting methods of the form Series.plot.<kind>.

Series.plot

Make plots of Series or DataFrame using the backend specified by the option plotting.backend. By default, matplotlib is used.

Unsupported by Intel SDC.

Series.plot.area

Draw a stacked area plot.

Unsupported by Intel SDC.

Series.plot.bar

Vertical bar plot.

Unsupported by Intel SDC.

Series.plot.barh

Make a horizontal bar plot.

Unsupported by Intel SDC.

Series.plot.box

Make a box plot of the DataFrame columns.

Unsupported by Intel SDC.

Series.plot.density

Generate Kernel Density Estimate plot using Gaussian kernels.

Unsupported by Intel SDC.

Series.plot.hist

Draw one histogram of the DataFrame’s columns.

Unsupported by Intel SDC.

Series.plot.kde

Generate Kernel Density Estimate plot using Gaussian kernels.

Unsupported by Intel SDC.

Series.plot.line

Plot Series or DataFrame as lines.

Unsupported by Intel SDC.

Series.plot.pie

Generate a pie plot.

Unsupported by Intel SDC.

Series.hist

Draw histogram of the input series using matplotlib.

Unsupported by Intel SDC.

Serialization, Input-Output, Conversion

Series.to_pickle

Pickle (serialize) object to file.

Unsupported by Intel SDC.

Series.to_csv

Write object to a comma-separated values (csv) file.

Unsupported by Intel SDC.

Series.to_dict

Convert Series to {label -> value} dict or dict-like object.

Unsupported by Intel SDC.

Series.to_excel

Write object to an Excel sheet.

Unsupported by Intel SDC.

Series.to_frame

Convert Series to DataFrame.

Unsupported by Intel SDC.

Series.to_xarray

Return an xarray object from the pandas object.

Unsupported by Intel SDC.

Series.to_hdf

Write the contained data to an HDF5 file using HDFStore.

Unsupported by Intel SDC.

Series.to_sql

Write records stored in a DataFrame to a SQL database.

Unsupported by Intel SDC.

Series.to_msgpack

Serialize object to input file path using msgpack format.

Unsupported by Intel SDC.

Series.to_json

Convert the object to a JSON string.

Unsupported by Intel SDC.

Series.to_string

Render a string representation of the Series.

Unsupported by Intel SDC.

Series.to_clipboard

Copy object to the system clipboard.

Unsupported by Intel SDC.

Series.to_latex

Render an object to a LaTeX tabular environment table.

Unsupported by Intel SDC.