This is the code repository for Extending Excel with Python and R, published by Packt.
Unlock the potential of analytics languages for advanced data manipulation and visualization
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 book covers the following exciting features:
- 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
- rmat 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
If you feel this book is for you, get your copy today!
All of the code is organized into folders.
The code will look like the following:
install.packages("devtools")
# Install development version from GitHub
devtools::install_github(
'R-package/styledTables',
build_vignettes = TRUE
)
Following is what you need for this book: 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.
With the following software and hardware list you can run all code files present in the book (Chapter 1-12).
| Chapter | Software required | OS required |
|---|---|---|
| 1-12 | R | Windows (for the VBA parts), macOS, or Linux (for all content excluding VBA) |
| 1-12 | Python 3.11 | |
| 1-12 | Excel (including VBA) |
Steven Sanderson has been working in healthcare for almost 20 years with a focus in the last 12 years on analytics. Steve has spent those years working on dashboards, automations, and visualizations for clinical, finance and IT operations. Steven is also the author of the healthyverse suite of R packages which are in active development. Steven received his MPH from Stony Brook University School of Medicine Graduate Program in Public Health.
David Kun is the co-founder of Functional Analytics, the company behind the ownR platform engineering solution for R, Python and other data science languages. He is a qualified Actuary with two MSc’s concentrated on Mathematics. He has been using R since his MSc thesis in 2006 and Python since 2018.