blob: 5c0f97aac4ab24b1d0327cfe86d64e017b51f849 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
import pandas as pd
from serenitas.utils.db import dawn_engine
df = pd.read_csv("/home/serenitas/flint/irs_ticket.csv")
df.columns = (
df.columns.str.replace(" ", "_").str.replace("[()/]", "", regex=True).str.lower()
)
df.insert(0, "bbg_ticket_id", "test")
df.to_sql("irs_tickets", con=dawn_engine, index=False, if_exists="append")
|
