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 the delimiter passed to the function. This function is an equivalent to str.join().

Parameters:

sepstr

Delimiter to use between list entries.

Returns:

Series/Index: object

The list entries concatenated by intervening occurrences of the delimiter.

Raises:

AttributeError

If the supplied Series contains neither strings nor lists.

See also

str.join

Standard library version of this method.

Series.str.split

Split strings around given separator/delimiter.

Notes

If any of the list items is not a string object, the result of the join will be NaN.

Examples

Example with a list that contains non-string elements.

>>> s = pd.Series([['lion', 'elephant', 'zebra'],
...  [1.1, 2.2, 3.3],
...  ['cat', np.nan, 'dog'],
...  ['cow', 4.5, 'goat'],
...  ['duck', ['swan', 'fish'], 'guppy']])
>>> s
0 [lion, elephant, zebra]
1 [1.1, 2.2, 3.3]
2 [cat, nan, dog]
3 [cow, 4.5, goat]
4 [duck, [swan, fish], guppy]
dtype: object

Join all lists using a ‘-’. The lists containing object(s) of types other than str will produce a NaN.

>>> s.str.join('-')
0 lion-elephant-zebra
1 NaN
2 NaN
3 NaN
4 NaN
dtype: object