Extending Excel with Python and R Unlock the Potential of Analytics Languages for Advanced Data Manipulation and Visualization

Book Cover
Average Rating
Author
Sanderson, Steven,
Published
Birmingham : Packt Publishing, Limited, 2024.
Status
Available Online

Description

Loading Description...

More Details

Format
Edition
1st edition.
Language
English
ISBN
9781804615546, 1804615544

Notes

General Note
Description based upon print version of record.
General Note
Cell formatting
Description
Seamlessly integrate the Python and R programming languages with spreadsheet-based data analysis to maximize productivity Key Features Perform advanced data analysis and visualization techniques with R and Python on Excel data Use exploratory data analysis and pivot table analysis for deeper insights into your data Integrate R and Python code directly into Excel using VBA or API endpoints Purchase of the print or Kindle book includes a free PDF eBook Book Description For businesses, data analysis and visualization are crucial for informed decision-making; however, Excel's limitations can make these tasks time-consuming and challenging. Extending Excel with Python and R is a game changer resource written by experts Steven Sanderson, the author of the healthyverse suite of R packages, and David Kun, co-founder of Functional Analytics, the company behind the ownR platform engineering solution for R, Python, and other data science languages. This comprehensive guide transforms the way you work with spreadsheet-based data by integrating Python and R with Excel to automate tasks, execute statistical analysis, and create powerful visualizations. Working through the chapters, you'll find out how to perform exploratory data analysis, time series analysis, and even integrate APIs for maximum efficiency. Whether you're a beginner or an expert, this book has everything you need to unlock Excel's full potential and take your data analysis skills to the next level. By the end of this book, you'll be able to import data from Excel, manipulate it in R or Python, and perform the data analysis tasks in your preferred framework while pushing the results back to Excel for sharing with others as needed. What you will learn Read and write Excel files with R and Python libraries Automate Excel tasks with R and Python scripts Use R and Python to execute Excel VBA macros Format Excel sheets using R and Python packages Create graphs with ggplot2 and Matplotlib in Excel Analyze Excel data with statistical methods and time series analysis Explore various methods to call R and Python functions from Excel Who this book is for If you're a data analyst or data scientist, or a quants, actuaries, or data practitioner looking to enhance your Excel skills and expand your data analysis capabilities with R and Python, this book is for you. It provides a comprehensive introduction to the topics covered, making it suitable for both beginners and intermediate learners. A basic understanding of Excel, Python, and R is all you need to get started.
Local note
O'Reilly O'Reilly Online Learning: Academic/Public Library Edition

Discover More

Also in this Series

Checking series information...

More Like This

  • Data Science Programming All-In-One for Dummies Cover
  • Building data science applications with FastAPI: develop, manage, and deploy efficient machine learning applications with Python Cover
  • Advancing into analytics: from Excel to Python and R Cover
  • R for data science: import, tidy, transform, visualize, and model data Cover
  • Extending Power BI with Python and R: perform advanced analysis using the power of analytical languages Cover
  • LEARNING MICROSOFT POWER BI: transforming data into insights Cover
  • Analyzing social media networks with NodeXL: insights from a connected world Cover
  • Microsoft Power BI Performance Best Practices: a Comprehensive Guide to Building Consistently Fast Power BI Solutions Cover
  • Spark in Action: Covers Apache Spark 3 with Examples in Java, Python, and Scala Cover
  • Data Wrangling with JavaScript Cover
  • Data cleaning with Power BI: the definitive guide to transforming dirty data into actionable insights Cover
  • Beyond Spreadsheets with R Cover
  • Data analytics made easy: use machine learning and data storytelling in your work without writing... any code Cover
  • Introduction to statistical and machine learning methods for data science Cover
  • Feature engineering for machine learning: principles and techniques for data scientists Cover
  • 97 THINGS EVERY DATA ENGINEER SHOULD KNOW Cover
  • Social media data mining and analytics Cover
  • Data science projects with Python: a case study approach to successful data science projects using Python, pandas, and scikcit-learn Cover
  • Human-in-the-Loop Machine Learning Cover
  • Machine Learning with Python Cookbook: practical solutions from preprocessing to deep learning Cover
  • Data science: the hard parts : techniques for excelling at data science Cover
  • Hands-on data science with R: techniques to perform data manipulation and mining to build smart analytical models using R Cover
  • Big data analytics for intelligent healthcare management Cover
  • Learn data analysis with Python: lessons in coding Cover
  • Pandas cookbook: practical recipes for scientific computing, time series, and exploratory data analysis using Python Cover

Published Reviews

Reviews from GoodReads

Loading GoodReads Reviews.

Citations

APA Citation, 7th Edition (style guide)

Sanderson, S., & Kun, D. (2024). Extending Excel with Python and R: Unlock the Potential of Analytics Languages for Advanced Data Manipulation and Visualization (1st edition.). Packt Publishing, Limited.

Chicago / Turabian - Author Date Citation, 17th Edition (style guide)

Sanderson, Steven and David, Kun. 2024. Extending Excel With Python and R: Unlock the Potential of Analytics Languages for Advanced Data Manipulation and Visualization. Birmingham: Packt Publishing, Limited.

Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)

Sanderson, Steven and David, Kun. Extending Excel With Python and R: Unlock the Potential of Analytics Languages for Advanced Data Manipulation and Visualization Birmingham: Packt Publishing, Limited, 2024.

Harvard Citation (style guide)

Sanderson, S. and Kun, D. (2024). Extending excel with python and R: unlock the potential of analytics languages for advanced data manipulation and visualization. 1st edn. Birmingham: Packt Publishing, Limited.

MLA Citation, 9th Edition (style guide)

Sanderson, Steven,, and David Kun. Extending Excel With Python and R: Unlock the Potential of Analytics Languages for Advanced Data Manipulation and Visualization 1st edition., Packt Publishing, Limited, 2024.

Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.

Staff View

Grouped Work ID
a2da2a96-f7cf-84f1-ce68-937a91229fcc-eng
Go To Grouped Work View in Staff Client

Grouping Information

Grouped Work IDa2da2a96-f7cf-84f1-ce68-937a91229fcc-eng
Full titleextending excel with python and r unlock the potential of analytics languages for advanced data manipulation and visualization
Authorsanderson steven
Grouping Categorybook
Last Update2025-01-24 12:33:29PM
Last Indexed2025-05-22 03:31:08AM

Book Cover Information

Image Sourcedefault
First LoadedJan 26, 2025
Last UsedMar 3, 2025

Marc Record

First DetectedDec 16, 2024 11:30:05 PM
Last File Modification TimeDec 17, 2024 08:29:15 AM
SuppressedRecord had no items

MARC Record

LEADER07343cam a22005057a 4500
001on1429722584
003OCoLC
00520241217082703.0
006m     o  d        
007cr cnu||||||||
008240420s2024    enk     o     000 0 eng d
019 |a 1429720963
020 |a 9781804615546
020 |a 1804615544
035 |a (OCoLC)1429722584|z (OCoLC)1429720963
037 |a 9781804610695|b O'Reilly Media
037 |a 10522582|b IEEE
040 |a EBLCP|b eng|c EBLCP|d YDX|d OCLCQ|d ORMDA|d IEEEE
049 |a MAIN
050 4|a QA76.9.D343
08204|a 006.3/12|2 23/eng/20240506
1001 |a Sanderson, Steven,|e author.
24510|a Extending Excel with Python and R|h [electronic resource] :|b Unlock the Potential of Analytics Languages for Advanced Data Manipulation and Visualization /|c Steven Sanderson, David Kun.
250 |a 1st edition.
260 |a Birmingham :|b Packt Publishing, Limited,|c 2024.
300 |a 1 online resource (345 p.)
500 |a Description based upon print version of record.
500 |a Cell formatting
5050 |a Cover -- Title Page -- Copyright and Credit -- Dedicated -- Contributors -- Table of Contents -- Preface -- Part 1: The Basics -- Reading and Writing Excel Files from R and Python -- Chapter 1: Reading Excel Spreadsheets -- Technical requirements -- Working with R packages for Excel manipulation -- Reading Excel files to R -- Installing and loading libraries -- Reading multiple sheets with readxl and a custom function -- Python packages for Excel manipulation -- Python packages for Excel manipulation -- Considerations -- Opening an Excel sheet from Python and reading the data -- Using pandas
5058 |a Using openpyxl -- Reading in multiple sheets with Python (openpyxl and custom functions) -- The importance of reading multiple sheets -- Using openpyxl to access sheets -- Reading data from each sheet -- Retrieving sheet data with openpyxl -- Combining data from multiple sheets -- Custom function for reading multiple sheets -- Customizing the code -- Summary -- Chapter 2: Writing Excel Spreadsheets -- Technical requirements -- Packages to write into Excel files -- writexl -- openxlsx -- xlsx -- A comprehensive recap and insights -- Creating and manipulating Excel sheets using Python
5058 |a Why export data to Excel? -- Keeping it simple -- exporting data to Excel with pandas -- Advanced mode -- openpyxl for Excel manipulation -- Creating a new workbook -- Adding sheets to the workbook -- Deleting a sheet -- Manipulating an existing workbook -- Choosing between openpyxl and pandas -- Other alternatives -- Summary -- Chapter 3: Executing VBA Code from R and Python -- Technical requirements -- Installing and explaining the RDCOMClient R library -- Installing RDCOMClient -- Executing sample VBA with RDCOMClient -- Integrating VBA with Python using pywin32
5058 |a Why execute VBA code from Python? -- Setting up the environment -- Error handling with the environment setup -- Writing and executing VBA code -- Automating Excel tasks -- Pros and cons of executing VBA from Python -- Summary -- Chapter 4: Automating Further -- Task Scheduling and Email -- Technical requirements -- Installing and understanding the tasksheduleR library -- Creating sample scripts -- RDCOMClient for Outlook -- Using the Microsoft365R and blastula packages -- Microsoft365R -- The blastula package -- Scheduling Python scripts -- Introduction to Python script scheduling
5058 |a Built-in scheduling options -- Third-party scheduling libraries -- Best practices and considerations for robust automation -- Email notifications and automation with Python -- Introduction to email notifications in Python -- Setting up email services -- Sending basic emails -- Sending email notifications for script status -- Summary -- Part 2: Making It Pretty -- Formatting, Graphs, and More -- Chapter 5: Formatting Your Excel Sheet -- Technical requirements -- Installing and using styledTables in R -- Installing and using basictabler in R -- Advanced options for formatting with Python
520 |a Seamlessly integrate the Python and R programming languages with spreadsheet-based data analysis to maximize productivity Key Features Perform advanced data analysis and visualization techniques with R and Python on Excel data Use exploratory data analysis and pivot table analysis for deeper insights into your data Integrate R and Python code directly into Excel using VBA or API endpoints Purchase of the print or Kindle book includes a free PDF eBook Book Description For businesses, data analysis and visualization are crucial for informed decision-making; however, Excel's limitations can make these tasks time-consuming and challenging. Extending Excel with Python and R is a game changer resource written by experts Steven Sanderson, the author of the healthyverse suite of R packages, and David Kun, co-founder of Functional Analytics, the company behind the ownR platform engineering solution for R, Python, and other data science languages. This comprehensive guide transforms the way you work with spreadsheet-based data by integrating Python and R with Excel to automate tasks, execute statistical analysis, and create powerful visualizations. Working through the chapters, you'll find out how to perform exploratory data analysis, time series analysis, and even integrate APIs for maximum efficiency. Whether you're a beginner or an expert, this book has everything you need to unlock Excel's full potential and take your data analysis skills to the next level. By the end of this book, you'll be able to import data from Excel, manipulate it in R or Python, and perform the data analysis tasks in your preferred framework while pushing the results back to Excel for sharing with others as needed. What you will learn Read and write Excel files with R and Python libraries Automate Excel tasks with R and Python scripts Use R and Python to execute Excel VBA macros Format Excel sheets using R and Python packages Create graphs with ggplot2 and Matplotlib in Excel Analyze Excel data with statistical methods and time series analysis Explore various methods to call R and Python functions from Excel Who this book is for If you're a data analyst or data scientist, or a quants, actuaries, or data practitioner looking to enhance your Excel skills and expand your data analysis capabilities with R and Python, this book is for you. It provides a comprehensive introduction to the topics covered, making it suitable for both beginners and intermediate learners. A basic understanding of Excel, Python, and R is all you need to get started.
590 |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition
650 0|a Data mining.|9 71797
650 0|a Data mining|x Computer programs.
7001 |a Kun, David,|e author.
77608|i Print version:|a Sanderson, Steven|t Extending Excel with Python and R|d Birmingham : Packt Publishing, Limited,c2024
85640|u https://library.access.arlingtonva.us/login?url=https://learning.oreilly.com/library/view/~/9781804610695/?ar|x O'Reilly|z eBook
938 |a ProQuest Ebook Central|b EBLB|n EBL31255746
938 |a ProQuest Ebook Central|b EBLB|n EBL31255746
938 |a YBP Library Services|b YANK|n 20985772
994 |a 92|b VIA
999 |c 360797|d 360797