Question 109778 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

Creating a column containing the other columns as a JSON object?

I’m trying add a column to my dataframe that contains the information from the other columns as a json object

My dataframe looks like this:

col_1 col_2
1 1
2 2

I’m then trying to add the json column using the following

    for i, row in df:
        i_val = row.to_json()
        df.at[i,'raw_json'] = i_val

However it results in a "cascaded" dataframe where the json appears twice

col_1 col_2 raw_json
1 1 {"col_1":1,"col_2":1,"raw_json":{"col_1":1,"col_2":1}}
2 2 {"col_1":2,"col_2":2,"raw_json":{"col_1":2,"col_2":2}}

I’m expecting it to look like the following

col_1 col_2 raw_json
1 1 {"col_1":1,"col_2":1}
2 2 {"col_1":2,"col_2":2}
Tags:

2

Answers


  1. 0

    use df.to_json(orient='records')

    df['raw_json'] = df.to_json(orient='records')


   col_1  col_2                                       raw_json
0      1      1  [{"col_1":1,"col_2":1},{"col_1":2,"col_2":2}]
1      2      2  [{"col_1":1,"col_2":1},{"col_1":2,"col_2":2}]
    Login or Signup to reply.
  2. 0

    Using a list comp and itterrows (your expected has a dict if you want json you can remove the [0]):

    df["raw_json"] = [pd.DataFrame(data=[row], columns=df.columns).to_dict(orient="records")[0] for _, row in df.iterrows()]
print(df)

    Output:

       col_1  col_2                  raw_json
0      1      1  {'col_1': 1, 'col_2': 1}
1      2      2  {'col_1': 2, 'col_2': 2}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search