to extract the data in a csv file which is given in the config.json file

Question

i have a config.json file and the data inside the config.json is ""

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

and the mortality file is a csv file with some data..i want to extract the csv file data from the cofig.json.The code which i wrote is

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

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

and i am geeting the output as the sourcefilename which i given..

[['{'], ['\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'], ['}']]

i want to extract the data which is stored in the csv file through config.json in the python

Answer 1

I think you are confusing reading your .csv and reading your .json files.

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)