piper.verbs.explode

piper.verbs.explode(df: pandas.core.frame.DataFrame, *args, **kwargs)pandas.core.frame.DataFrame[source]

Transform list-like column values to rows

This is a wrapper function rather than using e.g. df.explode() For details of args, kwargs - see help(pd.DataFrame.explode)

Examples

from piper.factory import sample_data

df = sample_data()
df = group_by(df, 'countries')
df = summarise(df, ids=('ids', set))
df.head()

  countries     ids
  Italy         {'B', 'C', 'D', 'A', 'E'}
  Portugal      {'B', 'C', 'A', 'D', 'E'}
  Spain         {'B', 'C', 'D', 'A', 'E'}
  Switzerland   {'B', 'C', 'A', 'D', 'E'}
  Sweden        {'B', 'C', 'A', 'D', 'E'}
explode(df, 'ids').head(8)

  countries     ids
  Italy         B
  Italy         C
  Italy         D
  Italy         A
  Italy         E
  Portugal      B
  Portugal      C
  Portugal      A
Parameters
  • df – dataframe

  • *args – arguments for wrapped function

  • **kwargs – keyword-parameters for wrapped function

Returns

Return type

A pandas DataFrame