September 2024
Intermediate to advanced
338 pages
9h 21m
Spanish
Content preview from Python para Excel
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 7. Manipulación de archivos de Excel con pandas
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
Tras seis capítulos de intensas introducciones a las herramientas, Python y pandas, te daré un respiro y comenzaré este capítulo con un caso práctico que te permitirá poner en práctica tus conocimientos recién adquiridos: con sólo diez líneas de código de pandas, consolidarás decenas de archivos de Excel en un informe de Excel, listo para enviar a tus jefes. Después del caso práctico, te daré una introducción más detallada a las herramientas que pandas ofrece para trabajar con archivos de Excel: la función read_excel y la clase ExcelFile para leer, y el método to_excel y la clase ExcelWriter para escribir archivos de Excel. pandas no depende de la aplicación Excel para leer y escribir archivos de Excel, lo que significa que todos los ejemplos de código de este capítulo se ejecutan en cualquier lugar donde se ejecute Python, incluido Linux.
Caso práctico: Informes en Excel
Este estudio de caso de se inspira en algunos proyectos reales de elaboración de informes en los que he participado en los últimos años. Aunque los proyectos se llevaron a cabo en sectores completamente distintos -como las telecomunicaciones, el marketing digital y las finanzas-, eran muy similares: el punto de partida suele ser un directorio con archivos de Excel que deben procesarse en un informe de Excel, a menudo mensual, semanal o ...
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.