Question

I need help Structuring data into certain dictionaries in Python to help answer a few questions. I have a CSV file and i need help looping thru the data to get an output similar to this. where the keys are the region (for data_by_region) or country (for data_by_country) and the values are dictionaries where the years are the keys. Based on this information i need a few dictionaries one being called data_by_region and another called data_by_country. Her is a link to the CSV file if anyone can help:

https://docs.google.com/document/d/1v68_QQX7Tn96l-b0LMO9YZ4ZAn_KWDMUJboa6LEyPr8/edit?usp=sharing

"Western Africa" : {

2005: {
    "Population annual rate of increase (percent)": 2.6,
"Total fertility rate (children per women)": 6,
"Infant mortality for both sexes (per 1,000 live births)": 95.7,
"Life expectancy at birth for both sexes (years)": 49.3,
"Life expectancy at birth for males (years)": 48.4,
"Life expectancy at birth for females (years)": 50.2
},
2010: { 
    
    },
2015: {
    

Answer 1

If you have any doubts, please give me comment...

Code:

import csv

with open("data.csv") as csv_file:

data = {}

csv_reader = csv.reader(csv_file, delimiter=',')

l_c = 0

for row in csv_reader:

if(l_c==0):

l_c+=1

continue

row[2] = int(row[2])

if row[1] not in data:

data[row[1]] = {}

if row[2] not in data[row[1]]:

data[row[1]][row[2]] = {}

data[row[1]][row[2]][row[3]] = float(row[4].replace(",", ""))

print(data)