使用Pandas将数据从CSV格式转换成JSON，处理大量字段名称

Question

试图获取一个像这样的文件

并使用下面的代码将其转换为Json。它没有正确打印值。除顶列以外的值都打印为空。你知道吗

import numpy as np
import pandas as pd
import csv
import json


df = pd.read_csv('1mins data.csv', 'r', ",")
df.head()
fieldnames = df.columns[1:-1]
print(fieldnames[:])

jsonfile = open('1mins data.json', 'w')
fieldnames=fieldnames
reader = csv.DictReader( df, fieldnames)
for row in reader:
    json.dump(row, jsonfile)
    jsonfile.write('\n')

在接受了下面的建议之后，我已经更新了脚本。你知道吗

import numpy as np
import pandas as pd
import csv
import json


df = pd.read_csv('1mins data.csv', 'r', ",")
df.head()

df.columns[1:-1].to_json(path_or_buf='1minsdata.json')

现在我收到这个错误

AttributeError: 'Index' object has no attribute 'to_json'

通过这样做来修复它

    import numpy as np
import pandas as pd
import csv
import json


df = pd.read_csv('1mins data.csv', 'r', ",")
df.set_index('Time')df.to_json()

df.to_json(path_or_buf='1mins data.json')
df.to_json()

提前谢谢

Answer 1

您可以使用

df.to_json()

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_json.html