Open durraniu opened 3 months ago
There's this code to get penguins data from duckdb in lab 2:
import duckdb con = duckdb.connect('my-db.duckdb') df = con.execute("SELECT * FROM penguins").fetchdf().dropna() con.close()
But penguins data does not exist as a table in duckdb yet. I suggest adding this after creating con:
con
from palmerpenguins import penguins penguins_df = penguins.load_penguins().dropna() con.sql("CREATE TABLE penguins AS SELECT * FROM penguins_df")
There's this code to get penguins data from duckdb in lab 2:
But penguins data does not exist as a table in duckdb yet. I suggest adding this after creating
con
: