Aggregating CSV Data

[Axel_Erfurt]

something like this?

import csv

out_text = "Company,Sales,Sales Group\n"

with open('Data Python (version 1).csv', 'r', newline='') as f:
    reader = csv.reader(f, delimiter=',')
    header = next(reader)
    sortedChanels = sorted(reader, key=lambda row: int(row[1]), reverse=True)
    rows = sortedChanels

for row in rows:
    out_text += ",".join(row)
    out_text += "\n"
    

        
print(out_text)

with open("data_new.csv", "w") as f:
    f.write(out_text)

Output:
Company,Sales,Sales Group
Company 3,300000,High Sales
Company 5,215000,High Sales
Company 2,200000,High Sales
Company 8,190000,Medium Sales
Company 7,178000,Medium Sales
Company 1,150000,Medium Sales
Company 10,135000,Low Sales
Company 9,125000,Low Sales
Company 4,110000,Low Sales