예제 #1
0
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
예제 #2
0
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
예제 #3
0
            cdata = []
        
        cdata.append(i)
        countries[code] = cdata
        rcodes[code] = i
        i = i +1

    panelout = {}
    header = 'Country,'
    for handle in handles:
        header = header + str(handle) + ','
    header = header + str('Year')
    
    return (header, data, countries, handles, vhandles) 
        
panel = test_stats()
if panel:
    totalpanel = pd.concat(panel)
    cleanedpanel = totalpanel.dropna(axis=1, how='any')
    cleanedpanel = totalpanel

thisyear = 2010
config = configuration()
modern = moderncodes(config['modernnames'], config['apiroot'])
(header, data, countries, handles, vhandles) = panel2dict(cleanedpanel)           
ctrlimit = 200
result = panel2csv(header, data, thisyear, countries, handles, vhandles, ctrlimit, modern)
maindataframe = data2statistics(handles, cleanedpanel)
showhtml = statistics_tojson(maindataframe, modern)
print showhtml
예제 #4
0
        cdata.append(i)
        countries[code] = cdata
        rcodes[code] = i
        i = i + 1

    panelout = {}
    header = "Country,"
    for handle in handles:
        header = header + str(handle) + ","
    header = header + str("Year")

    return (header, data, countries, handles, vhandles)


panel = test_stats()
if panel:
    totalpanel = pd.concat(panel)
    cleanedpanel = totalpanel.dropna(axis=1, how="any")
    cleanedpanel = totalpanel

thisyear = 2010
config = configuration()
modern = moderncodes(config["modernnames"], config["apiroot"])
(header, data, countries, handles, vhandles) = panel2dict(cleanedpanel)
ctrlimit = 200
result = panel2csv(header, data, thisyear, countries, handles, vhandles, ctrlimit, modern)
maindataframe = data2statistics(handles, cleanedpanel)
showhtml = statistics_tojson(maindataframe, modern)
print showhtml