Pandas Series¶
This is basic Pandas* data structure representing a dataframe column. In NumPy* terms this is one-dimensional ndarray with axis labels.
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 |
|
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¶
- 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 andbytes.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 standardstr.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()
orre.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 standardstr.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.