Search
Searching...
- pandas.Index.str (Python method, in pandas.Index.str)
- pandas.Series.str (Python method, in pandas.Series.str)
- pandas.Index.str
pandas.Index.str Index.str()[source] Vectorized string functions for Series and Index. NAs stay NA unless handled otherwise by a particular method. Patterned after Python’s string methods, with some inspiration from...
- pandas.Series.str
pandas.Series.str Series.str()[source] Vectorized string functions for Series and Index. NAs stay NA unless handled otherwise by a particular method. Patterned after Python’s string methods, with some inspiration fr...
- pandas.Series.str.capitalize
pandas.Series.str.capitalize Series.str.capitalize()[source] Convert strings in the Series/Index to be capitalized. Equivalent to str.capitalize(). Returns: Series or Index of object See also Series.str.lower...
- pandas.Series.str.casefold
pandas.Series.str.casefold Series.str.casefold()[source] Convert strings in the Series/Index to be casefolded. Equivalent to str.casefold(). Returns: Series or Index of object See also Series.str.lowerConvert...
- pandas.Series.str.cat
pandas.Series.str.cat Series.str.cat(others=None, sep=None, na_rep=None, join='left')[source] Concatenate strings in the Series/Index with given separator. If others is specified, this function concatenates the Seri...
- pandas.Series.str.center
pandas.Series.str.center Series.str.center(width, fillchar=' ')[source] Pad left and right side of strings in the Series/Index. Equivalent to str.center(). Parameters: widthintMinimum width of resulting string; ad...
- pandas.Series.str.contains
pandas.Series.str.contains Series.str.contains(pat, case=True, flags=0, na=None, regex=True)[source] Test if pattern or regex is contained within a string of a Series or Index. Return boolean Series or Index based o...
- pandas.Series.str.count
pandas.Series.str.count Series.str.count(pat, flags=0)[source] Count occurrences of pattern in each string of the Series/Index. This function is used to count the number of times a particular regex pattern is repeat...
- pandas.Series.str.decode
pandas.Series.str.decode Series.str.decode(encoding, errors='strict')[source] Decode character string in the Series/Index using indicated encoding. Equivalent to str.decode() in python2 and bytes.decode() in python3...
- pandas.Series.str.encode
pandas.Series.str.encode Series.str.encode(encoding, errors='strict')[source] Encode character string in the Series/Index using indicated encoding. Equivalent to str.encode(). Parameters: encodingstr errorsstr, op...
- pandas.Series.str.endswith
pandas.Series.str.endswith Series.str.endswith(pat, na=None)[source] Test if the end of each string element matches a pattern. Equivalent to str.endswith(). Parameters: patstr or tuple[str, …]Character sequence or...
- pandas.Series.str.extract
pandas.Series.str.extract Series.str.extract(pat, flags=0, expand=True)[source] Extract capture groups in the regex pat as columns in a DataFrame. For each subject string in the Series, extract groups from the first...
- pandas.Series.str.extractall
pandas.Series.str.extractall Series.str.extractall(pat, flags=0)[source] Extract capture groups in the regex pat as columns in DataFrame. For each subject string in the Series, extract groups from all matches of reg...
- pandas.Series.str.find
pandas.Series.str.find Series.str.find(sub, start=0, end=None)[source] Return lowest indexes in each strings in the Series/Index. Each of returned indexes corresponds to the position where the substring is fully con...
- pandas.Series.str.findall
pandas.Series.str.findall Series.str.findall(pat, flags=0)[source] Find all occurrences of pattern or regular expression in the Series/Index. Equivalent to applying re.findall() to all the elements in the Series/Ind...
- pandas.Series.str.fullmatch
pandas.Series.str.fullmatch Series.str.fullmatch(pat, case=True, flags=0, na=None)[source] Determine if each string entirely matches a regular expression. Parameters: patstrCharacter sequence or regular expression...
- pandas.Series.str.get
pandas.Series.str.get Series.str.get(i)[source] Extract element from each component at specified position or with specified key. Extract element from lists, tuples, dict, or strings in each element in the Series/Ind...
- pandas.Series.str.get_dummies
pandas.Series.str.get_dummies Series.str.get_dummies(sep='|')[source] Return DataFrame of dummy/indicator variables for Series. Each string in Series is split by sep and returned as a DataFrame of dummy/indicator va...
- pandas.Series.str.index
pandas.Series.str.index Series.str.index(sub, start=0, end=None)[source] Return lowest indexes in each string in Series/Index. Each of the returned indexes corresponds to the position where the substring is fully co...
- pandas.Series.str.isalnum
pandas.Series.str.isalnum Series.str.isalnum()[source] Check whether all characters in each string are alphanumeric. This is equivalent to running the Python string method str.isalnum() for each element of the Serie...
- pandas.Series.str.isalpha
pandas.Series.str.isalpha Series.str.isalpha()[source] Check whether all characters in each string are alphabetic. This is equivalent to running the Python string method str.isalpha() for each element of the Series/...
- pandas.Series.str.isdecimal
pandas.Series.str.isdecimal Series.str.isdecimal()[source] Check whether all characters in each string are decimal. This is equivalent to running the Python string method str.isdecimal() for each element of the Seri...
- pandas.Series.str.isdigit
pandas.Series.str.isdigit Series.str.isdigit()[source] Check whether all characters in each string are digits. This is equivalent to running the Python string method str.isdigit() for each element of the Series/Inde...
- pandas.Series.str.islower
pandas.Series.str.islower Series.str.islower()[source] Check whether all characters in each string are lowercase. This is equivalent to running the Python string method str.islower() for each element of the Series/I...
- pandas.Series.str.isnumeric
pandas.Series.str.isnumeric Series.str.isnumeric()[source] Check whether all characters in each string are numeric. This is equivalent to running the Python string method str.isnumeric() for each element of the Seri...
- pandas.Series.str.isspace
pandas.Series.str.isspace Series.str.isspace()[source] Check whether all characters in each string are whitespace. This is equivalent to running the Python string method str.isspace() for each element of the Series/...
- pandas.Series.str.istitle
pandas.Series.str.istitle Series.str.istitle()[source] Check whether all characters in each string are titlecase. This is equivalent to running the Python string method str.istitle() for each element of the Series/I...
- pandas.Series.str.isupper
pandas.Series.str.isupper Series.str.isupper()[source] Check whether all characters in each string are uppercase. This is equivalent to running the Python string method str.isupper() for each element of the Series/I...
- pandas.Series.str.join
pandas.Series.str.join Series.str.join(sep)[source] Join lists contained as elements in the Series/Index with passed delimiter. If the elements of a Series are lists themselves, join the content of these lists using...
- pandas.Series.str.len
pandas.Series.str.len Series.str.len()[source] 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). Returns...
- pandas.Series.str.ljust
pandas.Series.str.ljust Series.str.ljust(width, fillchar=' ')[source] Pad right side of strings in the Series/Index. Equivalent to str.ljust(). Parameters: widthintMinimum width of resulting string; additional cha...
- pandas.Series.str.lower
pandas.Series.str.lower Series.str.lower()[source] Convert strings in the Series/Index to lowercase. Equivalent to str.lower(). Returns: Series or Index of object See also Series.str.lowerConverts all charact...
- pandas.Series.str.lstrip
pandas.Series.str.lstrip Series.str.lstrip(to_strip=None)[source] Remove leading characters. Strip whitespaces (including newlines) or a set of specified characters from each string in the Series/Index from left sid...
- pandas.Series.str.match
pandas.Series.str.match Series.str.match(pat, case=True, flags=0, na=None)[source] Determine if each string starts with a match of a regular expression. Parameters: patstrCharacter sequence. casebool, default Tru...
- pandas.Series.str.normalize
pandas.Series.str.normalize Series.str.normalize(form)[source] Return the Unicode normal form for the strings in the Series/Index. For more information on the forms, see the unicodedata.normalize(). Parameters: fo...
- pandas.Series.str.pad
pandas.Series.str.pad Series.str.pad(width, side='left', fillchar=' ')[source] Pad strings in the Series/Index up to width. Parameters: widthintMinimum width of resulting string; additional characters will be fill...
- pandas.Series.str.partition
pandas.Series.str.partition Series.str.partition(sep=' ', expand=True)[source] Split the string at the first occurrence of sep. This method splits the string at the first occurrence of sep, and returns 3 elements co...
- pandas.Series.str.removeprefix
pandas.Series.str.removeprefix Series.str.removeprefix(prefix)[source] Remove a prefix from an object series. If the prefix is not present, the original string will be returned. Parameters: prefixstrRemove the pre...
- pandas.Series.str.removesuffix
pandas.Series.str.removesuffix Series.str.removesuffix(suffix)[source] Remove a suffix from an object series. If the suffix is not present, the original string will be returned. Parameters: suffixstrRemove the suf...
- pandas.Series.str.repeat
pandas.Series.str.repeat Series.str.repeat(repeats)[source] Duplicate each string in the Series or Index. Parameters: repeatsint or sequence of intSame value for all (int) or different value per (sequence). Ret...
- pandas.Series.str.replace
pandas.Series.str.replace Series.str.replace(pat, repl, n=-1, case=None, flags=0, regex=False)[source] Replace each occurrence of pattern/regex in the Series/Index. Equivalent to str.replace() or re.sub(), depending...
- pandas.Series.str.rfind
pandas.Series.str.rfind Series.str.rfind(sub, start=0, end=None)[source] Return highest indexes in each strings in the Series/Index. Each of returned indexes corresponds to the position where the substring is fully...
- pandas.Series.str.rindex
pandas.Series.str.rindex Series.str.rindex(sub, start=0, end=None)[source] Return highest indexes in each string in Series/Index. Each of the returned indexes corresponds to the position where the substring is fully...
- pandas.Series.str.rjust
pandas.Series.str.rjust Series.str.rjust(width, fillchar=' ')[source] Pad left side of strings in the Series/Index. Equivalent to str.rjust(). Parameters: widthintMinimum width of resulting string; additional char...
- pandas.Series.str.rpartition
pandas.Series.str.rpartition Series.str.rpartition(sep=' ', expand=True)[source] Split the string at the last occurrence of sep. This method splits the string at the last occurrence of sep, and returns 3 elements co...
- pandas.Series.str.rsplit
pandas.Series.str.rsplit Series.str.rsplit(pat=None, *, n=-1, expand=False)[source] Split strings around given separator/delimiter. Splits the string in the Series/Index from the end, at the specified delimiter stri...
- pandas.Series.str.rstrip
pandas.Series.str.rstrip Series.str.rstrip(to_strip=None)[source] Remove trailing characters. Strip whitespaces (including newlines) or a set of specified characters from each string in the Series/Index from right s...
- pandas.Series.str.slice
pandas.Series.str.slice Series.str.slice(start=None, stop=None, step=None)[source] Slice substrings from each element in the Series or Index. Parameters: startint, optionalStart position for slice operation. stop...
- pandas.Series.str.slice_replace
pandas.Series.str.slice_replace Series.str.slice_replace(start=None, stop=None, repl=None)[source] Replace a positional slice of a string with another value. Parameters: startint, optionalLeft index position to us...
- pandas.Series.str.split
pandas.Series.str.split Series.str.split(pat=None, *, n=-1, expand=False, regex=None)[source] Split strings around given separator/delimiter. Splits the string in the Series/Index from the beginning, at the specifie...
- pandas.Series.str.startswith
pandas.Series.str.startswith Series.str.startswith(pat, na=None)[source] Test if the start of each string element matches a pattern. Equivalent to str.startswith(). Parameters: patstr or tuple[str, …]Character seq...
- pandas.Series.str.strip
pandas.Series.str.strip Series.str.strip(to_strip=None)[source] Remove leading and trailing characters. Strip whitespaces (including newlines) or a set of specified characters from each string in the Series/Index fr...
- pandas.Series.str.swapcase
pandas.Series.str.swapcase Series.str.swapcase()[source] Convert strings in the Series/Index to be swapcased. Equivalent to str.swapcase(). Returns: Series or Index of object See also Series.str.lowerConverts...
- pandas.Series.str.title
pandas.Series.str.title Series.str.title()[source] Convert strings in the Series/Index to titlecase. Equivalent to str.title(). Returns: Series or Index of object See also Series.str.lowerConverts all charact...
- pandas.Series.str.translate
pandas.Series.str.translate Series.str.translate(table)[source] Map all characters in the string through the given mapping table. Equivalent to standard str.translate(). Parameters: tabledictTable is a mapping of...
- pandas.Series.str.upper
pandas.Series.str.upper Series.str.upper()[source] Convert strings in the Series/Index to uppercase. Equivalent to str.upper(). Returns: Series or Index of object See also Series.str.lowerConverts all charact...
- pandas.Series.str.wrap
pandas.Series.str.wrap Series.str.wrap(width, **kwargs)[source] Wrap strings in Series/Index at specified line width. This method has the same keyword parameters and defaults as textwrap.TextWrapper. Parameters: w...
- pandas.Series.str.zfill
pandas.Series.str.zfill Series.str.zfill(width)[source] Pad strings in the Series/Index by prepending ‘0’ characters. Strings in the Series/Index are padded with ‘0’ characters on the left of the string to reach a t...
- Version 0.18.0 (March 13, 2016)
...he xarray package, see here. The read_sas function has been enhanced to read sas7bdat files, see here. Addition of the .str.extractall() method, and API changes to the .str.extract() method and .str.cat() method. pd.test() top-level nose te...
- What’s new in 0.23.0 (May 15, 2018)
..._dummies now supports dtype argument Timedelta mod method Method .rank() handles inf values when NaN are present Series.str.cat has gained the join kwarg DataFrame.astype performs column-wise conversion to Categorical Other enhancements B...
- What’s new in 0.25.0 (July 18, 2019)
...Python version will be bumped to 3.6 in a future release. Warning Panel has been fully removed. For N-D labeled data structures, please use xarray Warning read_pickle() and read_msgpack() are only guaranteed backwards compatible back t...
- Working with text data
...Working with text data Text data types There are two ways to store text data in pandas: object -dtype NumPy array. StringDtype extension type. We recommend using StringDtype to store text data. Prior to pandas 1.0, object dtype was th...
- pandas.api.extensions.ExtensionArray._from_sequence_of_strings (Python method, in pandas.api.extensions.ExtensionArray._from_sequence_of_strings)
- pandas.api.types.is_string_dtype (Python function, in pandas.api.types.is_string_dtype)
- pandas.arrays.ArrowStringArray (Python class, in pandas.arrays.ArrowStringArray)
- pandas.arrays.StringArray (Python class, in pandas.arrays.StringArray)
- pandas.DataFrame.to_string (Python method, in pandas.DataFrame.to_string)
- pandas.DatetimeIndex.freqstr (Python property, in pandas.DatetimeIndex.freqstr)
- pandas.DatetimeIndex.strftime (Python method, in pandas.DatetimeIndex.strftime)
- pandas.errors.AbstractMethodError (Python exception, in pandas.errors.AbstractMethodError)
- pandas.io.formats.style.Styler.template_string (Python attribute, in pandas.io.formats.style.Styler.template_string)
- pandas.io.formats.style.Styler.to_string (Python method, in pandas.io.formats.style.Styler.to_string)
- pandas.Period.freqstr (Python attribute, in pandas.Period.freqstr)
- pandas.Period.strftime (Python method, in pandas.Period.strftime)
- pandas.PeriodIndex.freqstr (Python property, in pandas.PeriodIndex.freqstr)
- pandas.PeriodIndex.strftime (Python method, in pandas.PeriodIndex.strftime)
- pandas.plotting.bootstrap_plot (Python function, in pandas.plotting.bootstrap_plot)
- pandas.Series.dt.strftime (Python method, in pandas.Series.dt.strftime)
- pandas.Series.str.lstrip (Python method, in pandas.Series.str.lstrip)
- pandas.Series.str.rstrip (Python method, in pandas.Series.str.rstrip)
- pandas.Series.str.strip (Python method, in pandas.Series.str.strip)
- pandas.Series.to_string (Python method, in pandas.Series.to_string)
- pandas.StringDtype (Python class, in pandas.StringDtype)
- pandas.Timestamp.strftime (Python method, in pandas.Timestamp.strftime)
- pandas.Timestamp.strptime (Python method, in pandas.Timestamp.strptime)
- pandas.tseries.offsets.BQuarterBegin.freqstr (Python attribute, in pandas.tseries.offsets.BQuarterBegin.freqstr)
- pandas.tseries.offsets.BQuarterEnd.freqstr (Python attribute, in pandas.tseries.offsets.BQuarterEnd.freqstr)
- pandas.tseries.offsets.BusinessDay.freqstr (Python attribute, in pandas.tseries.offsets.BusinessDay.freqstr)
- pandas.tseries.offsets.BusinessHour.freqstr (Python attribute, in pandas.tseries.offsets.BusinessHour.freqstr)
- pandas.tseries.offsets.BusinessMonthBegin.freqstr (Python attribute, in pandas.tseries.offsets.BusinessMonthBegin.freqstr)
- pandas.tseries.offsets.BusinessMonthEnd.freqstr (Python attribute, in pandas.tseries.offsets.BusinessMonthEnd.freqstr)
- pandas.tseries.offsets.BYearBegin.freqstr (Python attribute, in pandas.tseries.offsets.BYearBegin.freqstr)
- pandas.tseries.offsets.BYearEnd.freqstr (Python attribute, in pandas.tseries.offsets.BYearEnd.freqstr)
- pandas.tseries.offsets.CustomBusinessDay.freqstr (Python attribute, in pandas.tseries.offsets.CustomBusinessDay.freqstr)
- pandas.tseries.offsets.CustomBusinessHour.freqstr (Python attribute, in pandas.tseries.offsets.CustomBusinessHour.freqstr)
- pandas.tseries.offsets.CustomBusinessMonthBegin.freqstr (Python attribute, in pandas.tseries.offsets.CustomBusinessMonthBegin.freqstr)
- pandas.tseries.offsets.CustomBusinessMonthEnd.freqstr (Python attribute, in pandas.tseries.offsets.CustomBusinessMonthEnd.freqstr)
- pandas.tseries.offsets.DateOffset.freqstr (Python attribute, in pandas.tseries.offsets.DateOffset.freqstr)
- pandas.tseries.offsets.Day.freqstr (Python attribute, in pandas.tseries.offsets.Day.freqstr)
- pandas.tseries.offsets.Easter.freqstr (Python attribute, in pandas.tseries.offsets.Easter.freqstr)
- pandas.tseries.offsets.FY5253.freqstr (Python attribute, in pandas.tseries.offsets.FY5253.freqstr)
- pandas.tseries.offsets.FY5253Quarter.freqstr (Python attribute, in pandas.tseries.offsets.FY5253Quarter.freqstr)
- pandas.tseries.offsets.Hour.freqstr (Python attribute, in pandas.tseries.offsets.Hour.freqstr)
- pandas.tseries.offsets.LastWeekOfMonth.freqstr (Python attribute, in pandas.tseries.offsets.LastWeekOfMonth.freqstr)
- pandas.tseries.offsets.Micro.freqstr (Python attribute, in pandas.tseries.offsets.Micro.freqstr)
- pandas.tseries.offsets.Milli.freqstr (Python attribute, in pandas.tseries.offsets.Milli.freqstr)
- pandas.tseries.offsets.Minute.freqstr (Python attribute, in pandas.tseries.offsets.Minute.freqstr)
- pandas.tseries.offsets.MonthBegin.freqstr (Python attribute, in pandas.tseries.offsets.MonthBegin.freqstr)
- pandas.tseries.offsets.MonthEnd.freqstr (Python attribute, in pandas.tseries.offsets.MonthEnd.freqstr)
- pandas.tseries.offsets.Nano.freqstr (Python attribute, in pandas.tseries.offsets.Nano.freqstr)
- pandas.tseries.offsets.QuarterBegin.freqstr (Python attribute, in pandas.tseries.offsets.QuarterBegin.freqstr)
- pandas.tseries.offsets.QuarterEnd.freqstr (Python attribute, in pandas.tseries.offsets.QuarterEnd.freqstr)
- pandas.tseries.offsets.Second.freqstr (Python attribute, in pandas.tseries.offsets.Second.freqstr)
- pandas.tseries.offsets.SemiMonthBegin.freqstr (Python attribute, in pandas.tseries.offsets.SemiMonthBegin.freqstr)
- pandas.tseries.offsets.SemiMonthEnd.freqstr (Python attribute, in pandas.tseries.offsets.SemiMonthEnd.freqstr)
- pandas.tseries.offsets.Tick.freqstr (Python attribute, in pandas.tseries.offsets.Tick.freqstr)
- pandas.tseries.offsets.Week.freqstr (Python attribute, in pandas.tseries.offsets.Week.freqstr)
- pandas.tseries.offsets.WeekOfMonth.freqstr (Python attribute, in pandas.tseries.offsets.WeekOfMonth.freqstr)
- pandas.tseries.offsets.YearBegin.freqstr (Python attribute, in pandas.tseries.offsets.YearBegin.freqstr)
- pandas.tseries.offsets.YearEnd.freqstr (Python attribute, in pandas.tseries.offsets.YearEnd.freqstr)
- Version 0.21.1 (December 12, 2017) > String
- 10 minutes to pandas
- Categorical data
- Chart visualization
- Comparison with SAS
- Comparison with spreadsheets
- Comparison with Stata
- Contributing to the code base
- Cookbook
- Developer
- Duplicate Labels
- Essential basic functionality
- How to create new columns derived from existing columns
- How to manipulate textual data
- Indexing and selecting data
- IO tools (text, CSV, HDF5, …)
- MultiIndex / advanced indexing
- Options and settings
- pandas arrays, scalars, and data types
- pandas docstring guide
- pandas.api.extensions.ExtensionArray._accumulate
- pandas.api.extensions.ExtensionArray._formatter
- pandas.api.extensions.ExtensionArray._hash_pandas_object
- pandas.api.extensions.ExtensionArray._reduce
- pandas.api.extensions.ExtensionArray.astype
- pandas.api.extensions.ExtensionArray.tolist
- pandas.api.extensions.ExtensionArray.view
- pandas.api.extensions.register_dataframe_accessor
- pandas.api.extensions.register_index_accessor
- pandas.api.extensions.register_series_accessor
- pandas.api.types.infer_dtype
- pandas.api.types.is_any_real_numeric_dtype
- pandas.api.types.is_bool_dtype
- pandas.api.types.is_complex_dtype
- pandas.api.types.is_datetime64_any_dtype
- pandas.api.types.is_datetime64_ns_dtype
- pandas.api.types.is_float_dtype
- pandas.api.types.is_int64_dtype
- pandas.api.types.is_integer_dtype
- pandas.api.types.is_numeric_dtype
- pandas.api.types.is_signed_integer_dtype
- pandas.api.types.is_string_dtype
- pandas.api.types.is_unsigned_integer_dtype
- pandas.array
- pandas.arrays.ArrowStringArray
- pandas.arrays.DatetimeArray
- pandas.arrays.PeriodArray
- pandas.arrays.SparseArray
- pandas.arrays.StringArray
- pandas.bdate_range
- pandas.core.groupby.DataFrameGroupBy.agg
- pandas.core.groupby.DataFrameGroupBy.aggregate
- pandas.core.groupby.DataFrameGroupBy.boxplot
- pandas.core.groupby.DataFrameGroupBy.hist
- pandas.core.groupby.DataFrameGroupBy.max
- pandas.core.groupby.DataFrameGroupBy.mean
- pandas.core.groupby.DataFrameGroupBy.min
- pandas.core.groupby.DataFrameGroupBy.pipe
- pandas.core.groupby.DataFrameGroupBy.plot
- pandas.core.groupby.DataFrameGroupBy.resample
- pandas.core.groupby.DataFrameGroupBy.rolling
- pandas.core.groupby.DataFrameGroupBy.shift
- pandas.core.groupby.DataFrameGroupBy.std
- pandas.core.groupby.DataFrameGroupBy.sum
- pandas.core.groupby.DataFrameGroupBy.transform
- pandas.core.groupby.DataFrameGroupBy.var
- pandas.core.groupby.SeriesGroupBy.agg
- pandas.core.groupby.SeriesGroupBy.aggregate
- pandas.core.groupby.SeriesGroupBy.hist
- pandas.core.groupby.SeriesGroupBy.max
- pandas.core.groupby.SeriesGroupBy.mean
- pandas.core.groupby.SeriesGroupBy.min