Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Extending Excel with Python and R
  • Table Of Contents Toc
Extending Excel with Python and R

Extending Excel with Python and R

By : Steven Sanderson, David Kun
5 (5)
close
close
Extending Excel with Python and R

Extending Excel with Python and R

5 (5)
By: Steven Sanderson, David Kun

Overview of this book

– 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. – 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. – Both beginners and experts will get 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.
Table of Contents (20 chapters)
close
close
1
Part 1:The Basics – Reading and Writing Excel Files from R and Python
6
Part 2: Making It Pretty – Formatting, Graphs, and More
10
Part 3: EDA, Statistical Analysis, and Time Series Analysis
14
Part 4: The Other Way Around – Calling R and Python from Excel
16
Part 5: Data Analysis and Visualization with R and Python for Excel Data – A Case Study

Calling R/Python directly from Excel

In this section, we will dig into the ways you can call R and Python from Excel using the tools set up in the previous section. We will cover several ways of achieving this and give examples so that you can try them out as well.

Executing R with VBA and BERT

Another great way of calling R from Excel is via the VBA macro. This requires that a workbook be saved as a macro-enabled workbook. Since BERT is designed to work from Excel to R, the syntax of an R expression can be written in the VBA console and called with the following in VBA:

Application.Run "BERT.Exec", r

Let’s look at an easy example:

Sub PlotNormalDensity()
    r = "plot(density(rnorm(1000)))"
    Application.Run "BERT.Exec", r
End Sub

This will end up producing a plot of the density of a random normal distribution. Let’s see the output:

Figure 11.4 – Using BERT to call R from VBA

Figure 11.4 –...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Extending Excel with Python and R
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon