Make Every Element Of The Series As A Separate Row

Overview:

  • The explode() method of pandas Series class makes a row out of each element present in the Series and returns the new series.
  • If the Series object has any sequences contained inside, each element present inside them (like a tuple, list, pandas Series and ndarray) are made as a separate row with the index of the sequence as the index of the new element.

 

Example:

import pandas as pds

 

# A heterogeneous list

hetero   = ["a", 1, 3.14, (2, 3, 5, 7), ["x", "y", "z"]];

 

# Create a pandas series from the list

series = pds.Series(hetero);

 

# Make the series flat

newSeries = series.explode();

 

print("Original Series:");

print(series);

 

print("Types of elements present in the pandas series:");

for element in hetero:

    print(type(element));

 

print("New Series:");

print(newSeries);

print("Types of elements present in the new series returned by calling explode():");

for element in newSeries:

    print(type(element));

 

Output:

Original Series:

0               a

1               1

2            3.14

3    (2, 3, 5, 7)

4       [x, y, z]

dtype: object

Types of elements present in the pandas series:

<class 'str'>

<class 'int'>

<class 'float'>

<class 'tuple'>

<class 'list'>

New Series:

0       a

1       1

2    3.14

3       2

3       3

3       5

3       7

4       x

4       y

4       z

dtype: object

Types of elements present in the new series returned by calling explode():

<class 'str'>

<class 'int'>

<class 'float'>

<class 'int'>

<class 'int'>

<class 'int'>

<class 'int'>

<class 'str'>

<class 'str'>

<class 'str'>

 


Copyright 2022 © pythontic.com