Busk at 21:40, 7 September 2023

2023-09-07T21:40:11Z

Busk: Created page with "# DataFrame to JSON for SQL This will do it for all columns all rows. ``` for i in df.columns: df[i] = [json.dumps(x) for x in df[i]] df.to_sql(name='fb1', con=cnx, index=F..."

2023-09-07T20:36:54Z

Created page with "# DataFrame to JSON for SQL This will do it for all columns all rows. ``` for i in df.columns: df[i] = [json.dumps(x) for x in df[i]] df.to_sql(name='fb1', con=cnx, index=F..."

New page

# DataFrame to JSON for SQL

This will do it for all columns all rows.
```
for i in df.columns:
df[i] = [json.dumps(x) for x in df[i]]
df.to_sql(name='fb1', con=cnx, index=False)
```

Assuming dataframe df
```
import pandas
import sqlite3

for i in df.columns:
df[i] = [json.dumps(x) for x in df[i]]

cnx = sqlite3.connect(f"db.sqlite3")
df.to_sql(name='table1', con=cnx, index=False)
```

@@ Line 2: / Line 2: @@
 This will do it for all columns all rows.
 ```
 for i in df.columns:
@@ Line 14: / Line 20: @@
 for i in df.columns:
-   df[i] = [json.dumps(x) for x in df[i]]
+   for i in df.columns:  df[i] =  df[i].astype("string")
 cnx = sqlite3.connect(f"db.sqlite3")
 df.to_sql(name='table1', con=cnx, index=False)
 ```

Pandas snippets - Revision history

Busk at 21:40, 7 September 2023

Busk: Created page with "# DataFrame to JSON for SQL This will do it for all columns all rows. ``` for i in df.columns: df[i] = [json.dumps(x) for x in df[i]] df.to_sql(name='fb1', con=cnx, index=F..."