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')
