Pandas list of JSON element to python array

Question

I have a dataframe like so:

Store	matches
Murphy's	[{'domain': 'murphyscolumbus.com', 'location': 'Columbus, OH'}, {'domain': 'murphystampa.com', 'location': 'Tampa, FL'}]
Bill's	[{'domain': 'billsdallas.com', 'location': 'Dallas, TX'}, {'domain': 'billsorlando.com', 'location': 'Orlando, FL'}]

What I want is a dataframe like so:

Store	domains
Murphy's	['murphyscolumbus.com', 'murphystampa.com']
Bill's	['billsdallas.com','billsorlando.com']

I'm hoping for something less computationally expensive than something like a for loop that steps through as the dataframe is quite large.

Andrej Kesely · Accepted Answer · 2022-11-01 19:12:10Z

1

Try:

from ast import literal_eval

# apply literal_eval if necessary
df["matches"] = df["matches"].apply(literal_eval)

df["domains"] = df.pop("matches").apply(lambda x: [d["domain"] for d in x])
print(df)

Prints:

      Store                                  domains
0  Murphy's  [murphyscolumbus.com, murphystampa.com]
1    Bill's      [billsdallas.com, billsorlando.com]

answered Nov 1, 2022 at 19:12

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Pandas list of JSON element to python array

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