Helper script for converting Cezar ranking CSV to usable format

1 files changed, 9 insertions, 0 deletions

diff --git a/bin/convert-cezar-ranking-csv.py b/bin/convert-cezar-ranking-csv.py
new file mode 100644
index 0000000..4dcee92
--- /dev/null
+++ b/bin/convert-cezar-ranking-csv.py
@@ -0,0 +1,9 @@
+import csv, sys
+
+data = list(csv.reader(file(sys.argv[1]), delimiter=";"))
+
+output = csv.writer(file(sys.argv[2], 'w'))
+
+date = data[1][3]
+for row in data[4:-1]:
+    output.writerow([row[0], date, row[2], row[1]])