1 files changed, 17 insertions, 0 deletions
diff --git a/python/citco.py b/python/citco.py
new file mode 100644
index 00000000..8bfc38ae
--- /dev/null
+++ b/python/citco.py
@@ -0,0 +1,17 @@
+import pandas as pd
+from serenitas.utils.env import DAILY_DIR
+from serenitas.utils.db import dawn_engine
+
+
+def load_citco_report(fdir):
+    df = pd.read_csv(fdir)
+    df["row"] = df.index
+    df.columns = df.columns.str.lower()
+    df.columns = df.columns.str.replace(" ", "_")
+    return df
+
+
+if __name__ == "__main__":
+    fdir = DAILY_DIR / "Selene/onboarding/reporting/sample_report.csv"
+    df = load_citco_report(fdir)
+    df.to_sql("citco_reports", dawn_engine, if_exists="append", index=False)