Busk: Created page with "# Prep for sqlite3 ``` import pandas as pd import sqlite3 def write_sql_from_dfs(): for table, df in dfs.items(): # loop through `dict` of dataframes uuids = [] for..."

2023-09-07T23:47:18Z

Created page with "# Prep for sqlite3 ``` import pandas as pd import sqlite3 def write_sql_from_dfs(): for table, df in dfs.items(): # loop through `dict` of dataframes uuids = [] for..."

New page

# Prep for sqlite3
```
import pandas as pd
import sqlite3
def write_sql_from_dfs():
for table, df in dfs.items(): # loop through `dict` of dataframes
uuids = []
for i in range(len(df.index)):
uuids.append(uuid.uuid4())
df.insert(0, "uuid", uuids)
df['timestamp'] = pd.Timestamp("now")
# df['timestamp'] = [pd.Timestamp("now") for _ in range(len(df.index))]
for i in df.columns:
for i in df.columns: df[i] = df[i].astype("string")
df.to_sql(name=table, con=cnx, if_exists='append', index=False)

def main():
global cnx
cnx = sqlite3.connect(f"mydb.sqlite3")
write_sql_from_dfs()

if __name__ == "__main__":
main()
```

Pandas sql - Revision history

Busk: Created page with "# Prep for sqlite3 ``` import pandas as pd import sqlite3 def write_sql_from_dfs(): for table, df in dfs.items(): # loop through `dict` of dataframes uuids = [] for..."