提取config.json文件中给定的csv文件中的数据

63lcw9qa 于 2022-11-26 发布在其他

关注(0)|答案(1)|浏览(92)

我有一个config.json文件，config.json中的数据是“”

{
    "mortalityfile":"C:/Users/DELL/mortality.csv"
    
}

死亡率文件是一个包含一些数据的csv文件。我想从cofig.json中提取csv文件数据。我编写的代码是

js = open('config.json').read()
results = []
for line in js:

    words = line.split(',')
    results.append((words[0:]))
print(results)

我得到的输出是我给出的源文件名。

[['{'], ['\n'], [' '], [' '], [' '], [' '], ['"'], ['m'], ['o'], ['r'], ['t'], ['a'], ['l'], ['i'], ['t'], ['y'], ['f'], ['i'], ['l'], ['e'], ['"'], [':'], ['"'], ['C'], [':'], ['/'], ['U'], ['s'], ['e'], ['r'], ['s'], ['/'], ['D'], ['E'], ['L'], ['L'], ['/'], ['m'], ['o'], ['r'], ['t'], ['a'], ['l'], ['i'], ['t'], ['y'], ['.'], ['c'], ['s'], ['v'], ['"'], ['\n'], [' '], [' '], [' '], [' '], ['\n'], ['}']]

我想通过python中的config.json提取存储在csv文件中的数据

JSON

来源：https://stackoverflow.com/questions/74546380/to-extract-the-data-in-a-csv-file-which-is-given-in-the-config-json-file

1条答案

按热度按时间

c86crjj01#

我认为您在阅读.csv文件和阅读.json文件时混淆了。

import json

# open the json
config_file = open('config.json')

# convert it to a dict
data = json.load(config_file)

# open your csv
with open(data['mortalityfile'], 'r') as f:
    # do stuff with you csv data
    csv_data = f.readlines()
    result = []
    for line in csv_data:
        split_line = line.rstrip().split(',')
        result.append(split_line)

print(result)

赞(0）回复(0）举报 2022-11-26

我来回答

提取config.json文件中给定的csv文件中的数据

1条答案

相关问题

热门标签

最新问答