Skip to content

Instantly share code, notes, and snippets.

@mpentler
Created January 1, 2025 15:26
Show Gist options
  • Save mpentler/74e1c5be41fa92b1e18e2ae53f4e6a74 to your computer and use it in GitHub Desktop.
Save mpentler/74e1c5be41fa92b1e18e2ae53f4e6a74 to your computer and use it in GitHub Desktop.
Find replace aircraft database rows from another file
import csv
with open('aircraft.csv', 'r', newline='') as db_csvfile:
db_reader = csv.reader(db_csvfile, delimiter = ';')
db_data = list(db_reader)
with open('replacements.csv', 'r', newline='') as replacements_csvfile:
replacements_reader = csv.reader(replacements_csvfile, delimiter = ';')
replacements_data = list(replacements_reader)
for row in replacements_data:
hex_to_replace = row[0]
print("Finding hex " + hex_to_replace)
for db_row in db_data:
if hex_to_replace in db_row[0]:
print("Matched hex!")
db_row = row
replacements_csvfile.close()
db_csvfile.close()
print("Writing new list...")
with open('aircraft.csv', 'w', newline='') as db_newcsvfile:
db_new = csv.writer(db_newcsvfile, delimiter = ';')
for row in db_data:
db_new.writerow(row)
db_newcsvfile.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment