import csv

COLUMNS = [
    "Rank",
    "Overall Acc",
    "Model",
    "Model Link",
    "Organization",
    "License",
    "AST Summary",
    "Exec Summary",
    "Simple Function AST",
    "Multiple Functions AST",
    "Parallel Functions AST",
    "Parallel Multiple AST",
    "Simple Function Exec",
    "Multiple Functions Exec",
    "Parallel Functions Exec",
    "Parallel Multiple Exec",
    "Relevance Detection",
]

def parse_csv(text):
    lines = text.split('\n')
    lines = lines[1:]
    result = [COLUMNS]
    for i in range(len(lines)):
        row = lines[i].split(',')[:16]
        row.insert(0, i + 1)
        overall_acc = row.pop(5)
        row.insert(1, overall_acc)
        result.append(row)
    return result


with open('./data.csv', 'r') as file:
    csv_text = file.read()
    DATA = parse_csv(csv_text)

with open('./data.csv', 'w') as file:
    writer = csv.writer(file)
    writer.writerows(DATA)