exploding a multi dictionnary columns

Question

I have a data that contains +15 columns all of them with dictionnary as values. all of the dictionnary has the same keys but different values depending on th column and the key of course. i need to explode them into on data that has the keys as index;this a part of the data

i ve tried this code ! but it only work on one column. i have to do it for all 15 columns and merge them.

data = pd.DataFrame([[i, k, v] for i, d in df[['halstead_vol', 'cyclomatic_complexity']].values for k, v in d.items()],
                  columns=['halstead_vol', 'cyclomatic_complexity', 'h1'])

Please provide a minimal reproducible input and the expected output, currently the question is too vague to give a clear answer without guessing what you might want — mozway
– mozway, Commented Nov 30, 2022 at 10:02

Oghli · Accepted Answer · 2022-11-30 14:49:10Z

0

If you check explode function documentation in pandas, to explode multiple column you can achieve that in this format:

DataFrame.explode(list(col1col2col3...))

for your case:

df.explode(list('halstead_volcyclomatic_complexityh1'), ignore_index=True)

For dictionary values try this:

new_df = df['halstead_vol'].apply(pd.Series)

Also check this thread on SO for more info.

edited Nov 30, 2022 at 14:49

answered Nov 30, 2022 at 10:14

Oghli

2,4111 gold badge18 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

taha elbermaki Over a year ago

it works only for lists! it doesn't work for dictionnary

Oghli Over a year ago

@tahaelbermaki try dictionary code.

Collectives™ on Stack Overflow

exploding a multi dictionnary columns

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related