将包含其他列的列创建为JSON对象？

dgiusagp 于 2023-02-20 发布在其他

关注(0)|答案(2)|浏览(130)

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} |

JSON

来源：https://stackoverflow.com/questions/75490195/creating-a-column-containing-the-other-columns-as-a-json-object

2条答案

按热度按时间

cbeh67ev1#

使用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}]

赞(0）回复(0）举报 2023-02-20

vlju58qv2#

使用一个列表comp和itterrows（你的预期有一个dict，如果你想要json，你可以删除[0]）：

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

输出：

col_1  col_2                  raw_json
0      1      1  {'col_1': 1, 'col_2': 1}
1      2      2  {'col_1': 2, 'col_2': 2}

赞(0）回复(0）举报 2023-02-20

我来回答

将包含其他列的列创建为JSON对象？

2条答案

相关问题

热门标签

最新问答