Python convert string of dictionary to dataframe

Question

I have a large string which has data in the following format:

str = '{"Item":"0","ADDRESS_ON_URL":"702-hartman-st-houston-tx-77007"},{"Item":"1","ADDRESS_ON_URL":"818-reinicke-st-houston-tx-77007"}'

I am looking to create a dataframe of the above data with desired output as following:

Item    ADDRESS_ON_URL
 0      702-hartman-st-houston-tx-77007
 1      818-reinicke-st-houston-tx-77007

I am not even sure how to approach the above.

TIA

Andrej Kesely · Accepted Answer · 2021-05-14 20:29:00Z

1

Use pd.read_json() with lines=True:

s = '{"Item":"0","ADDRESS_ON_URL":"702-hartman-st-houston-tx-77007"},{"Item":"1","ADDRESS_ON_URL":"818-reinicke-st-houston-tx-77007"}'

df = pd.read_json(s, lines=True)
print(df)

Prints:

   Item                    ADDRESS_ON_URL
0     0   702-hartman-st-houston-tx-77007
1     1  818-reinicke-st-houston-tx-77007

answered May 14, 2021 at 20:29

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

1 Comment

Zanam Over a year ago

lines = True .. was the important trick here :) first I tried just read_json and it wasn't working

Collectives™ on Stack Overflow

Python convert string of dictionary to dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related