import csv def extract(csv_filename, output_filename): with open(output_filename, "w") as f: with open(csv_filename) as ff: for i in csv.DictReader(ff): f.write(i["sql"] + "\n") if __name__ == "__main__": csv_filename = "./cases_new_singer_st_sqlite.csv" output_filename = "./singer_pred.sql" extract(csv_filename, output_filename)