Overview
- A DataFrame column can have a Python sequence such as tuple, list as an element.
- Each element from such sequences can be made a row, using the explode() instance method, with values from other columns assuming the same values in the new row.
Example
# Example Python program that splits a Python sequence which
# is an element of a DataFrame into separate elements
import pandas as pds
aList = [1, 2, 3, 4];
aTuple = ("a", "b", "c", "d");
# Create a DataFrame
aDataFrame = pds.DataFrame([(aList, 100),
(aTuple, 200),
(30, 300),
([], 400)], columns = ["X", "Y"]);
print("Contents of the original DataFrame");
print(aDataFrame);
# Explode the column X
newDataFrame = aDataFrame.explode("X");
print("Contents of the DataFrame after exploding the column X:");
print(newDataFrame);Output
Contents of the original DataFrame
X Y
0 [1, 2, 3, 4] 100
1 (a, b, c, d) 200
2 30 300
3 [] 400
Contents of the DataFrame after exploding the column X:
X Y
0 1 100
0 2 100
0 3 100
0 4 100
1 a 200
1 b 200
1 c 200
1 d 200
2 30 300
3 NaN 400