python 使用duckdb导入csv

 import duckdb

# Create a DuckDB connection

con = duckdb.connect('/mnt/d/duckdb.db')

# Create a table

con.execute("""

CREATE TABLE table5 AS

SELECT * FROM read_csv_auto('/mnt/d/5.csv',

    all_varchar=1,

    null_padding=true,

    strict_mode=false,

    ignore_errors=true)

""")

con.execute("CREATE TABLE table6 as select * from read_csv_auto('/mnt/d/5.csv',all_varchar=1,null_padding=true,strict_mode=false)")

con.sql('SHOW ALL TABLES')