def test_tabular(): if(not on_travis): return a = Tabular('spike/excel.xlsx') print(a,a[0]) assert(len(a) == 3) assert(len(a[0]) == 3) assert(a[0][0] == 'name') assert(a[1]['name'] == 'pagal') assert(a['name'][0] == 'pagal') assert(len(a['name']) == 2) a.write_csv('test.csv') a.write_json('test.json') a.write_xls('test.xlsx') # strict a.load_xls('spike/strict.xlsx',strict=True) assert(len(a) == 8) b = Tabular('test.xlsx') assert(len(b) == 3) assert(len(b[0]) == 3) assert(b[0][0] == 'name') assert(b[1]['name'] == 'pagal') assert(b['name'][0] == 'pagal') assert(len(b['name']) == 2) c = Tabular('test.csv') c = Tabular('test.json')
def extract_output(): data = [[ "Sno", "N", "Cap", "SA", "SA-time", "ACO", "ACO-time", "ACO-SA", "ACO-SA-time", "Kmean-SA", "Kmean-SA-time" ]] for i in range(100): cities = City.generate_cities() n = len(cities) cap = 10 if n <= 60 else 20 c_ret, t_ret, h_ret = run(cities, cap, disp=False) tabular_ret = [i + 1, n, cap] for a, b in zip(c_ret, t_ret): tabular_ret.append(a) tabular_ret.append(b) data.append(tabular_ret) print(Tabular([tabular_ret])) tabular = Tabular(data) tabular.write_json('output/out.json') tabular.write_xls('output/data.xls')