csv到json，json.decoder.jsondeCoderror:预期值：第1行第1列（字符0）

Question

!python evaluation/mpd2csv.py --mpd_path "data" --out_path "data"

#mpd2csv.py
parser = argparse.ArgumentParser(description="Convert MPD")
parser.add_argument('--mpd_path', default=None, required=True)
tracks_file = open(path.join(args.out_path, 'tracks.csv'), 'w', newline='', encoding='utf8')
tracks_writer = csv.writer(tracks_file)

with open("data/tracks.csv", encoding='utf8') as json_file:
    data=json_file.read()

错误：“json.decoder.JSONDecodeError:预期值：第1行第1列（字符0）”

我想将tracks.csv文件更改为json文件。但是有一个错误。你怎么解决这个问题

Answer 1

在这里，我做了一个样本csv作为您的要求。看起来像

下面的代码将tracks.csv转换为tracks.json

Code:

#import required libraries
import pandas as pd
import json

#reading csv using pandas
tracks = pd.read_csv('tracks.csv')
#diplay csv
print(tracks)

#converting dataframe to json
json_data = tracks.to_json(orient='records')

#saving json data to the file tracks.json
with open('tracks.json','w') as json_file:
    json.dump(json_data, json_file)

您可以通过下面的代码读取tracks.json

Code:

#read json file
with open('tracks.json','r') as json_file:
    data = json_file.read()
json_output = json.loads(data)
print(json_output)

Output:

[{"tracknumber":1,"count":2},{"tracknumber":2,"count":4},{"tracknumber":3,"count":6},{"tracknumber":4,"count":8},{"tracknumber":5,"count":10}]

验证输出：

我希望这会有帮助