March 2025
Intermediate to advanced
308 pages
7h 6m
Spanish
Content preview from DuckDB: en funcionamiento
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 2. Importar datos a DuckDB
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
En el Capítulo 1, viste cómo puedes crear una base de datos DuckDB sencilla y cargar tablas en ella. En el mundo real, tus datos suelen proceder de distintas fuentes de datos y formatos de archivo, como CSV, Excel, Parquet o servidores de bases de datos. En este capítulo, aprenderás primero las distintas formas de crear tus bases de datos DuckDB, y después aprenderás a cargarlas utilizando diversas fuentes de datos. Al final de este capítulo, tendrás una idea clara de cómo trabajar con cada fuente de datos, así como consejos y trucos para tratar con ellas.
Crear bases de datos DuckDB
En esta sección, nos sumergiremos en las diferentes formas en que puedes crear bases de datos DuckDB y te ofreceremos sugerencias sobre qué métodos pueden adaptarse a tus propósitos.
La forma más sencilla de crear una base de datos DuckDB es utilizar la función connect() del módulo duckdb:
importduckdbconn=duckdb.connect()
La función connect() devuelve un objeto DuckDBPyConnection. Por defecto, esta sentencia abre una base de datos en memoria modificable, como se ve aquí:
conn=duckdb.connect(':memory:')
Si deseas crear una base de datos DuckDB que persista en el almacenamiento, establece el argumento database con el nombre de una base de datos, por ejemplo, mydb.duckdb (puedes utilizar cualquier extensión que desees para el nombre de archivo): ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.