Skip to Main Content
Extending Excel with Python and R
book

Extending Excel with Python and R

by Steven Sanderson, David Kun
April 2024
Beginner to intermediate content levelBeginner to intermediate
344 pages
7h 56m
English
Packt Publishing
Content preview from Extending Excel with Python and R

12

Data Analysis and Visualization with R and Python in Excel – A Case Study

In this final chapter, we are going to perform an analysis—visualization and a simple model—built with data from Excel and place all those outcomes back into it. This can be useful when there is a lot of data, or the calculations themselves are best suited to being done outside of Excel.

First, we will start with importing our data and then performing some data exploration via visualizations. For this chapter, we are going to use the diamonds dataset from the R package called ggplot2. We will view the data where the price is the outcome and look at it via different facets of the diamond’s characteristics. After the visualizations are done, we will perform some simple ...

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.
Start your free trial

You might also like

Data Visualization with Python and JavaScript, 2nd Edition

Data Visualization with Python and JavaScript, 2nd Edition

Kyran Dale
Python for Excel

Python for Excel

Felix Zumstein

Publisher Resources

ISBN: 9781804610695Supplemental Content