Python :: pandas 和json.dumps [英] Python :: pandas and json.dumps

问题描述

我正在使用熊猫从excel和json读取以创建json.

I'm using pandas to read from an excel and json to create a json.

for x in range(1,n)
    label = (df.columns[x]).strip()
    something = (df[df.columns[x]][i])
    print (label)
    print (something)

这给了我我正在阅读的excel中的全部内容...

This gives me exactly what I have in the excel I'm reading...

productTypes
"APPLE","BANANA"

当我执行json.dumps ...

When I do a json.dumps...

for x in range(1,n)
    label = (df.columns[x]).strip()
    something = (df[df.columns[x]][i])
    value = json.dumps(something)
    print (label)
    print (value)

这给了我

productTypes
"\"APPLE\",\"BANANA\""

我在json中需要的是...

What I need in my json is...

"productTypes":["APPLE","BANANA"]

有帮助吗?

推荐答案

在label和something中创建一个dict，然后执行json.dumps()

Create a dict out of the label and something and then do the json.dumps()

简单示例-

import json

label = 'productTypes'
something = ["APPLE","BANANA"]
print(json.dumps({label: something}))

输出

{"productTypes": ["APPLE", "BANANA"]}

因此，在您的情况下，请为label和something声明一个dict.像-

So in you case, declare a dict for label and something. Something like -

for x in range(1,n)
    label = (df.columns[x]).strip()
    something = (df[df.columns[x]][i])
    print (label)
    print (something)
    value = json.dumps({label: something})

这篇关于Python :: pandas 和json.dumps的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！