result_to-csv1.py

import sys
import json

if __name__ == '__main__':
    results_file_name = sys.argv[1]
    csv_file = open(results_file_name.split('.json')[0]+'.csv','w')
    csv_file.write('name,solution_AG,exact_solution,Temps_exec\n')
    results_file = open(results_file_name,'r')
    data = json.load(results_file)
    for instance in data:
        csv_file.write(instance['name'].split('.')[0]+','+str(instance['results']['SA'][0]['num_bins'])+ ',' + str(instance['solution']) +','+str(instance['results']['SA'][0]['execution_time']).split(':')[2]+'\n')