# pandas.DataFrame.explode

`DataFrame.``explode`(column: Union[str, Tuple]) → pandas.core.frame.DataFrame

  Transform each element of a list-like to a row, replicating the index values.

  New in version 0.25.0.

  Parameters: | column : str or tuple

  Returns:

  DataFrame

  > Exploded lists to rows of the subset columns; index will be duplicated for these rows.

  Raises:

  ValueError :

  > if columns of the frame are not unique.

  See also

  `DataFrame.unstack`
    Pivot a level of the (necessarily hierarchical) index labels
  `DataFrame.melt`
    Unpivot a DataFrame from wide format to long format
  `Series.explode`
    Explode a DataFrame from list-like columns to long format.

  Notes

  This routine will explode list-likes including lists, tuples, Series, and np.ndarray. The result dtype of the subset rows will be object. Scalars will be returned unchanged. Empty list-likes will result in a np.nan for that row.

  Examples

      >>> df = pd.DataFrame({'A': [[1, 2, 3], 'foo', [], [3, 4]], 'B': 1})
      >>> df
                 A  B
      0  [1, 2, 3]  1
      1        foo  1
      2         []  1
      3     [3, 4]  1

      >>> df.explode('A')
           A  B
      0    1  1
      0    2  1
      0    3  1
      1  foo  1
      2  NaN  1
      3    3  1
      3    4  1

Scroll To Top