#!/usr/bin/env python # coding: utf-8 # In[2]: import json, numpy as np, pandas as pd # In[8]: d=json.load(file('data.json','r')) # In[15]: e=d.copy() for i in d: for j in d[i]: e[i][j]=sum(d[i][j].values()) # In[18]: json.dump(e,file('pop.json','w'))