Pandas
keyboard_arrow_down 655 guides
chevron_leftSorting and Restructuring DataFrames
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Pandas DataFrame | explode method
schedule Aug 11, 2023
Last updated local_offer
Tags Python●Pandas
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
Pandas DataFrame.explode(~) method unwraps array-likes such as lists, tuples, Series and NumPy arrays vertically. If the array-like is empty, a missing value (NaN) will be placed for that row.
Note that the indexes will be duplicated for the unwrapped rows.
Parameters
1. column | string or tuple of string
The label of the columns to unwrap.
Return Value
A new DataFrame with the array-likes unwrapped.
Examples
Consider the following DataFrame that contains some lists:
df = pd.DataFrame({"A":[1,[2,3],[]], "B":[4,5,6]})df
A B0 1 41 [2,3] 52 [] 6
To unwrap all the lists in column A:
df.explode("A")
A B0 1 41 2 51 3 52 NaN 6
Notice the following:
the row that had
[]is nowNaN.the index
1appears twice since it contained a list of 2 items.
* * *
As a side note, to reset the index, you can use reset_index(~) like so:
df.explode("A").reset_index(drop=True)
A B0 1 41 2 52 3 53 NaN 6
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official Pandas Documentation
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.explode.html
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
