Notes

import csv
import os

top_revenue = [] # list to hold top revenue records

output_file = "top_revenue.csv"
header = ["input", "cost", "revenue"]

# loop through each file in the directory
for filename in os.listdir("."):
if filename.endswith(".csv"):
with open(filename) as csv_file:
reader = csv.DictReader(csv_file)
for row in reader:
# check if the current row has more revenue than the lowest revenue in the top_revenue list
if len(top_revenue) < 10000 or float(row["revenue"]) > top_revenue[0]["revenue"]:
# add the current row to the top_revenue list
top_revenue.append(row)
# sort the top_revenue list by revenue in descending order
top_revenue.sort(key=lambda r: float(r["revenue"]), reverse=True)
# if the top_revenue list has more than 10000 records, remove the lowest revenue record
if len(top_revenue) > 10000:
top_revenue.pop(0)

# write the top 10000 revenue records to the output file
with open(output_file, "w", newline="") as csv_file:
writer = csv.writer(csv_file)
writer.writerow(header)
for row in top_revenue:
writer.writerow([row["input"], row["cost"], row["revenue"]])