pandas_expand_collection_type_column.py

def expand_collection_type_column(df, target_col, col_names=None):
    # Expand the list into multiple columns
    df_expand = df[target_col].apply(pd.Series)
    # Concatenate the expanded data frame with the original one
    df = pd.concat([df, df_expand], axis=1).drop(['values'], axis=1)
    # Rename columns if passed in
    if col_names:
        df = df.rename(columns={index:name for index, name in enumerate(col_names)})
    return df