Python in Excel for Data Analytics

Python in Excel for Data Analytics

George Mount

68,46 €
IVA incluido
Disponible
Editorial:
Packt Publishing
Año de edición:
2026
ISBN:
9781806696352
68,46 €
IVA incluido
Disponible

Selecciona una librería:

  • Librería Samer Atenea
  • Kálamo Books
  • Librería Elías (Asturias)
  • Librería Kolima (Madrid)
  • Librería Proteo (Málaga)

Learn how to use Python directly in Excel to clean data, build models, and create advanced visualizations. A practical guide for analysts who want to extend Excel without leaving the spreadsheet environment.Key Features:- Use Python inside Excel for real analytical workflows- Build visualizations, models, and simulations with ease- Combine Excel structure with Python’s analytical power Book Description:Excel is one of the most widely used tools for business analysis, but many analytical tasks quickly reach the limits of formulas and built-in features. Python in Excel changes that by allowing you to perform advanced analysis directly within the spreadsheet environment.This book shows how to combine Excel’s structure and usability with Python’s analytical power. You will learn how to move data between Excel and Python DataFrames, clean and transform datasets efficiently, and explore data using modern visualization techniques.As you progress, you will apply Python to real analytical problems including statistical testing, regression modeling, forecasting, and simulation. You will also learn how to integrate Python outputs into Excel dashboards and reports, creating workflows that are both powerful and practical.Designed for Excel users with no prior programming experience, this book introduces Python concepts gradually and focuses on real-world applications rather than theory. By the end, you will be able to extend Excel in meaningful ways, helping you analyze data more effectively and support better decision-making. What You Will Learn:- Use Python directly inside Excel cells- Move data between Excel and DataFrames- Clean and transform datasets efficiently- Build advanced visualizations with Python- Perform statistical analysis and modeling- Forecast trends using time series methods- Run simulations to evaluate uncertainty- Combine Python results with Excel reports Who this book is for:This book is for business, finance, and operations analysts who rely on Excel and want to go further with their analysis. It is ideal for professionals comfortable with formulas, tables, and PivotTables who want to explore Python without becoming programmers. Early-career data analysts, consultants, and Excel power users will benefit from learning how to extend Excel with more advanced analytical capabilities. Table of Contents- Getting Started with Python in Excel- Exploring and Analyzing Data with pandas- Visualizing Data with Seaborn- Performing Exploratory Data Analysis- Running Statistical Tests- Building Regression Models- Forecasting Time Series Data- Running Simulations and Scenario Models- Extracting Insights from Text Data- Integrating Python with Native Excel Features- Accelerating Analysis with AI Assistance- Continuing Your Python in Excel Journey

Artículos relacionados

  • Poetry Is Our Ministry to Touch the Heart
    Anelda Lukesia Ballard / Jean Anelda Scott
    Poetry is Our Ministry to Touch the Heart, was birthed when Anelda L. Ballard became ill. God spoke to her in a dream and said 'pick up a pen and write' by being obedient this book was written through the Holy Spirit. Anelda and her mother Jean A. Scott believes that God’s wants to heal a hurting heart. This book will inspire you and encourage you to never give up hope. Jesu...
    Disponible

    11,12 €

  • I soldati lunghi
    Pierluigi Romeo di Colloredo Mels
    Il 24 maggio 1915 il Regno d’Italia entrò nella Grande Guerra, che si sarebbe dimostrata il momento più alto e tragico della sua storia, a poco più di cinquant’anni dalla sua unificazione.In quella lotta tremenda durata quattro anni, la Brigata Granatieri di Sardegna , con i suoi due valorosi Reggimenti, i più antichi del Regio Esercito scrisse, nel grande quadro della guerra d...
    Disponible

    32,59 €

  • Five Beneath Philly
    Susan Bandy / Tom Richmond
    Allen Williams plans to make something of his life and escape South Philly and the work at Cross Brothers’ Meat Packing Plant. He prepares himself with excellent grades and an upcoming full-ride scholarship to climb out of South Philly forever. Then fate changes his whole world. An only son in a family of six, Allen suddenly finds himself responsible for his mother, grandmother...
    Disponible

    18,28 €

  • Forms
    Sharon Welch
    I am an award-winning artist and my works hang in private residences, community hospitals, businesses, and restaurants across the US and also abroad.  I live in Pierre, South Dakota. Since 2008 I have owned Sharon Welch Gallery and Studio where I paint and teach classes.  My theory is have fun, remove the fear of failure, experiment and let the child inside of you play.Very oft...
  • Ricordi di una ausiliaria
    Andrea Lombardi / Raffaella Duelli
    Le memorie di Raffaella Duelli, Volontaria nel Battaglione Barbarigo della Decima Flottiglia Mas iniziano con la partenza del Barbarigo da Roma, narrando la lunga marcia del reparto verso il nord, sotto il mitragliamento degli aerei Alleati. Quindi, è descritta vividamente l'ultima battaglia del Barbarigo sul Fronte Sud, dal Senio a Comacchio: gli appunti di Raffaella, giov...
    Disponible

    28,08 €

  • Why Didn’t You Ask?
    Panya Dixon
    From an early occurrence in her childhood to a perilous thirteen-year relationship, Panya Dixon too often suffered from various forms of physical, emotional, and sexual abuse. Conflicted between love and the pain her loved ones brought on her, she consistently had to fight for her life and her will to move on. Why Didn’t You Ask? is an expression of Panya’s truth—her trials, pa...
    Disponible

    20,35 €