csv转换为python中的json

Question

嘿，我在csv文件中有一些散列ID，比如

XbRPhe65YbC+xtgGQ8ukeZEr9xFOC4MEs9Z0wUidGSec公司= XbRPhe65YbC+xtgGQ8uksrqSUJ/HhTPj1d2pL0/vuGrHM=

我想将它们解析成python，并将它们包装在一些额外的代码中，比如

{“id”：“XbRPshe65YbC+xtGQ8ukqR2u2btfNeNe2gtcs72QbxPA=”，“timestamp”：“20150831”}

然后用一些JSON语法包装所有这些。然后作为post请求发送。问题是我似乎无法使它可读。似乎每样东西都订错了，我得到了额外的\。你知道吗

import os
import pandas as pd
from pprint import pprint

df=pd.read_csv('test.csv',sep=',',header=None)
df[0] = '{"id" :"' + df[0].astype(str) + '", "timestamp":"20150831"}, ' 

df = df[:-1] # removes last comma


test = 'hello'
data =[ { "ids":[ df[0]],
          "attributes":[
                {
                "name":"girl"
                },
                {
                "name":"size"
                }
                ]
        }
        ]

json1 = data.to_json()
print(json1)

Answer 1

我同意熊猫似乎不是最简单的工具。内置的库将非常有效：

import csv
import json

with open('test.csv', newline='') as csvfile:
    csvreader = csv.reader(csvfile)

    data = {
        "ids": [{"id": row[0], "timestamp": "20150831"} for row in csvreader],
        "attributes": [
            {"name": "girl"},
            {"name": "size"}
        ]
    }

json1 = json.dumps(data)
print(json1)