def advanced_statistics(): (yearmin, yearmax, ctrlist) = (1500, 2020, '') config = configuration() handles = [] if request.args.get('handle'): handledataset = request.args.get('handle') handledataset = handledataset.replace(" ", '') if request.args.get('dataset'): dataset = request.args.get('dataset') handles.append(dataset) if request.args.get('yearmin'): yearmin = request.args.get('yearmin') if request.args.get('yearmax'): yearmax = request.args.get('yearmax') if request.args.get('ctrlist'): ctrlist = request.args.get('ctrlist') modern = moderncodes(config['modernnames'], config['apiroot']) jsonapi = config['apiroot'] + '/api/datasets?handle=' + str(handledataset) (panel, cleanedpanel, names) = loadpanel(jsonapi, yearmin, yearmax, ctrlist) (header, data, countries, handles, vhandles) = advpanel2dict(cleanedpanel) ctrlimit = 200 #result = panel2csv(header, data, thisyear, countries, handles, vhandles, ctrlimit, modern) #maindataframe = data2statistics(handles, cleanedpanel) #showhtml = statistics_tojson(maindataframe, modern) data = handle2statistics(handles, cleanedpanel) showhtml = statistics2table(data) return showhtml
def advanced_statistics(): handle = 'Panel[%27hdl%3A10622/4X6NCK%27%2C%20%27hdl%3A10622/I0YK5M%27%2C%20%27hdl%3A10622/ZWRBOY%27]' handle = "Panel['hdl:10622/4X6NCK', 'hdl:10622/F16UDU', 'hdl:10622/I0YK5M']" handle = handle.replace(" ", '') print handle yearmin = '1990' yearmax = '2010' ctrlist = '' ctrlist = '250,276' config = configuration() modern = moderncodes(config['modernnames'], config['apiroot']) jsonapi = config['apiroot'] + '/api/datasets?handle=' + str(handle) (panel, cleanedpanel) = loadpanel(jsonapi, yearmin, yearmax, ctrlist) (header, data, countries, handles, vhandles) = advpanel2dict(cleanedpanel) ctrlimit = 200 #result = panel2csv(header, data, thisyear, countries, handles, vhandles, ctrlimit, modern) maindataframe = data2statistics(handles, cleanedpanel) showhtml = statistics_tojson(maindataframe, modern) return showhtml