python pandas dataFrame create single json column of multiple columns value

Question

In python pandas dataFrame i wanted create single json column of multiple columns value.

Assuming following dataFrame:
Example:

| -   | col1 | col2 | col3 | col4|
| 1   | abc  | def  | ghi  |  8  |
| 2   | xab  | xcd  | xef  |  9  |

This is the result i want.

|     |col1 | json_col|br
|1    | abc |   {"col2":"def","col3":"ghi","col4":8}|
|2    | xab |   {"col2":"xcd","col3":"xef","col4":9}|

How can i create the single column(json type) of selected columns?

jezrael · Accepted Answer · 2017-06-07 13:17:08Z

14

You can use apply with to_json, last remove columns by drop:

cols = ['col2','col3','col4']
df['json_col'] = df[cols].apply(lambda x: x.to_json(), axis=1)
df = df.drop(cols, axis=1)
print (df)
   - col1                              json_col
0  1  abc  {"col2":"def","col3":"ghi","col4":8}
1  2  xab  {"col2":"xcd","col3":"xef","col4":9}

answered Jun 7, 2017 at 13:17

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

Shantanu Jain Over a year ago

Hi @jezrael, this method is failing when I want to convert only 1 column. I get this error: AttributeError: 'float' object has no attribute 'to_json' Can you please consider this case and let me know how to do it?

Tobias Feil Over a year ago

@ShantanuJain It'll work if you put the one column into a list, like when you're passing a list of more than 1 columns.

Collectives™ on Stack Overflow

python pandas dataFrame create single json column of multiple columns value

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related