Dynamic version of explode in Pandas?

Question

I am trying to write something similar to a CASE STATEMENT for Python, so my aim is to check whether the column is a list, and when True it should explode that column.

Static Version:

docs = json.loads(docs)
docs = json_normalize(docs).explode("values")

Dynamic Version (How I started it, but then couldn't figure out how to finish it, or if it's even the right way to do it ):

x = (docs.applymap(type) == list).all()
for i in x:
    np.where(i == True,......)

Any guidance or tips will be greatly appreciated.

check after apply explore to every column, if the row num is not changed, then it's the end. — Ferris
– Ferris, Commented Feb 10, 2021 at 9:09

jcoke · Accepted Answer · 2021-02-10 10:30:06Z

1

I Figured out how to dynamically explode a column:

docs = json.loads(docs)
docs = json_normalize(docs)
x = (docs.applymap(type) == list).all()
y = x.index[x].tolist()
for i in y:
    docs = docs.explode(i)
print(docs)

This checks whether the column is a list, if its True, it iterates over the column names and explodes each one.

answered Feb 10, 2021 at 10:30

jcoke

1,9013 gold badges21 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Dynamic version of explode in Pandas?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related