Question 110892 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Separate nested dict inside a series column of a dataframe

dataframe

Trying to extract the username from the author column of the dataframe for each row, the author column is series & the individual values inside author is a dictionary.

Converting the author column directly to df & & changing the type of author column not helping to reach the goal.

I’m only able to reference the username via

df_item['author'][0]['username']

Trying to get a separate username column

id                  type   content        channel_id           username
1047404831062638613 0      It’s really..   1047331843898359849  lips
1047333443165499432 0      okay,thankyou   1047331843898359849   Mj
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    First convert the series to list then pass it to pandas dataframe and it takes care of the rest.

    df_new = DataFrame(list(df2["author"]))

  2. 0

    Did you try this:

    df['author_username'] = df['author'].apply(lambda x: x['username'])
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search