Lab 2 - Add penguins dataframe to duckdb

[durraniu]

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:

from palmerpenguins import penguins
penguins_df = penguins.load_penguins().dropna()
con.sql("CREATE TABLE penguins AS SELECT * FROM penguins_df")