Explode a column in dataframe in python (pandas)

Question

I'm trying to explode a column in python. Tried several options how to do so but nothing worked.

Input dataframe:

Column_1 Column_2 Column_3 Column_4 Column_5 ... Column_N
text     text     text     {'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': [text]}
text     text     text     {'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': [text]}
text     text     text     {'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': [text]}
text     text     text     {'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': [text]}

I need to keep every column but to explode the column Column_4 with columns: address1, address2 and so on with the values from the dict.

Column_1 Column_2 Column_3 address1 address2 address3 city zip_code ...Column_N
text     text     text     text     text     text     text text
text     text     text     text     text     text     text text
text     text     text     text     text     text     text text
text     text     text     text     text     text     text text

So, I need to keep every column from the input dataframe but to drop Column_4 for columns from the dicts.

Does this answer your question? [Splitting dictionary/list inside a Pandas Column into Separate Columns](https://stackoverflow.com/questions/38231591/splitting-dictionary-list-inside-a-pandas-column-into-separate-columns) — G. Anderson, Apr 22 '20 at 22:09
Please provide a [mcve], and share the data in a more convenient format. — AMC, Apr 22 '20 at 22:58

score 0 · Answer 1 · answered Apr 22 '20 at 22:42

import ast
from io import StringIO
# sample data
s = """Column_1|Column_2|Column_3|Column_4
text|text|text|{'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': ['text']}
text|text|text|{'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': ['text']}
text|text|text|{'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': ['text']}
text|text|text|{'address1': 'text', 'address2': None, 'address3': '', 'city': 'text', 'zip_code': 'text', 'country': 'text', 'state': 'text', 'display_address': ['text']}"""
df = pd.read_csv(StringIO(s), sep='|')
df['Column_4'] = df['Column_4'].apply(ast.literal_eval)
# end sample data

# list comprehension and concat dataframe
con = pd.concat([pd.DataFrame(x) for x in df['Column_4'].values.tolist()]).reset_index(drop=True)
# concat list of dataframe with the original df
new_df = pd.concat([df,con], axis=1)

Explode a column in dataframe in python (pandas)

1 Answers1