Extending-Excel-with-Python-and-R

KO | EN

gitlite — search

#javascript #python #react #typescript #android #rust #linux #docker #macos #nodejs #java #awesome #pytorch #open-source

Extending-Excel-with-Python-and-R

(★ 61)

Extending Excel with Python and R, published by Packt

Extending-Excel-with-Python-and-R 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

---

## Join Our Newsletters 📬

### DataPro  
*The future of AI is unfolding. Don’t fall behind.*

Stay ahead with [**DataPro**](https://landing.packtpub.com/subscribe-datapronewsletter/?link_from_packtlink=yes), the free weekly newsletter for data scientists, AI/ML researchers, and data engineers.  
From trending tools like **PyTorch**, **scikit-learn**, **XGBoost**, and **BentoML** to hands-on insights on **database optimization** and real-world **ML workflows**, you’ll get what matters, fast.

> Stay sharp with [DataPro](https://landing.packtpub.com/subscribe-datapronewsletter/?link_from_packtlink=yes). Join **115K+ data professionals** who never miss a beat.

---

### BIPro  
*Business runs on data. Make sure yours tells the right story.*

[**BIPro**](https://landing.packtpub.com/subscribe-bipro-newsletter/?link_from_packtlink=yes) is your free weekly newsletter for BI professionals, analysts, and data leaders.  
Get practical tips on **dashboarding**, **data visualization**, and **analytics strategy** with tools like **Power BI**, **Tableau**, **Looker**, **SQL**, and **dbt**.

> Get smarter with [BIPro](https://landing.packtpub.com/subscribe-bipro-newsletter/?link_from_packtlink=yes). Trusted by **35K+ BI professionals**, see what you’re missing.

# Extending Excel with Python and R

This is the code repository for [Extending Excel with Python and R](https://www.packtpub.com/product/extending-excel-with-python-and-r/9781804610695), published by Packt.

**Unlock the potential of analytics languages for advanced data manipulation and visualization**

## What is this book about?

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](https://www.amazon.com/Extending-Excel-Python-manipulation-visualization/dp/1804610690/ref=sr_1_1?sr=8-1) today!

## Instructions and Navigations
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).

### Software and Hardware List

| 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) | |

### Related products <Other books you may enjoy>
* Data Modeling with Microsoft Excel [[Packt]](https://www.packtpub.com/product/data-modeling-with-microsoft-excel/9781803240282) [[Amazon]](https://www.amazon.com/Data-Modeling-Microsoft-Excel-comprehensive/dp/1803240288/ref=sr_1_1?sr=8-1)
  
* Building Interactive Dashboards in Microsoft 365 Excel  [[Packt]](https://www.packtpub.com/product/building-interactive-dashboards-in-microsoft-365-excel/9781803237299) [[Amazon]](https://www.amazon.com/Building-Interactive-Dashboards-Microsoft-Excel/dp/1803237295/ref=sr_1_1?sr=8-1)
  
## Get to Know the Authors
**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.

Extending-Excel-with-Python-and-R

Extending-Excel-with-Python-and-R 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Extending-Excel-with-Python-and-R

Extending-Excel-with-Python-and-R 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README