May 2026
Intermediate
418 pages
10h 50m
Italian
Content preview from Python per Excel (Italian Edition), 2nd Edition
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.
Capitolo 6. Introduzione a Python in Excel
Questo lavoro è stato tradotto utilizzando l'AI. Siamo lieti di ricevere il tuo feedback e i tuoi commenti: translation-feedback@oreilly.com
A questo punto, hai già lavorato un bel po' con i DataFrame di pandas e i notebook Jupyter, il che ti mette in una posizione eccellente per esplorare Python in Excel. Perché? Perché Python in Excel ti permette di trasformare le celle di Excel in celle di notebook Jupyter. Questo significa che Python in Excel serve principalmente per accedere a un motore di analisi e creazione di grafici migliore sotto forma di DataFrame di pandas e grafici Python. Tuttavia, non è in concorrenza con VBA o Office Scripts, poiché non supporta l'automazione di Excel né le funzioni personalizzate, ovvero quelle che puoi richiamare direttamente dalle celle di Excel, ad esempio =SUM().
Questo capitolo ti introdurrà ai concetti di base di Python in Excel: imparerai come scrivere codice Python in una cella di Excel e come trasformare un intervallo di Excel in un DataFrame di pandas e poi di nuovo in valori nativi di Excel. Scoprirai anche strumenti specifici forniti con Python in Excel, ad esempio l'editor Python. Ma prima, assicuriamoci che tu abbia tutto ciò che serve per eseguire Python in Excel!
Requisiti
Nonostante il nome " ", Python in Excel viene eseguito nel cloud Azure di Microsoft e non in Excel stesso: ogni volta che esegui una cella con codice Python, Excel invia i dati del foglio di calcolo al cloud dove viene ...
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.