Extending Excel with Python and R: Unlock the potential of analytics languages for advanced data manipulation and visualization

Sanderson, Steven, Kun, David

  • 出版商: Packt Publishing
  • 出版日期: 2024-04-30
  • 售價: $1,820
  • 貴賓價: 9.5$1,729
  • 語言: 英文
  • 頁數: 344
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1804610690
  • ISBN-13: 9781804610695
  • 相關分類: ExcelPython程式語言R 語言
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

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.

Table of Contents
  1. Reading Excel Spreadsheets
  2. Writing Excel Spreadsheets
  3. Executing VBA Code from R and Python
  4. Automating Further (Email Notifications and More)
  5. Formatting Your Excel sheet
  6. Inserting ggplot2/matplotlib Graphs
  7. Pivot Tables (tidyquant in R and with win32com and pypiwin32 in Python)/Summary Table {gt}
  8. Exploratory Data Analysis with R and Python
  9. Statistical Analysis: Linear and Logistic Regression
  10. Time Series Analysis: Statistics, Plots, and Forecasting
  11. Calling R/Python Locally from Excel Directly or via an API
  12. Data Analysis and Visualization with R and Python for Excel Data - A Case Study

商品描述(中文翻譯)

無縫地將Python和R程式語言與基於試算表的數據分析相結合,以最大化生產力

主要特點
- 使用R和Python對Excel數據進行高級數據分析和可視化技術
- 使用探索性數據分析和樞紐分析表進一步深入了解數據
- 使用VBA或API端點將R和Python代碼直接集成到Excel中
- 購買印刷版或Kindle書籍將包含免費的PDF電子書

書籍描述
對於企業來說,數據分析和可視化對於明智的決策至關重要;然而,Excel的限制可能使這些任務耗時且具有挑戰性。《使用Python和R擴展Excel》是一本由專家Steven Sanderson(healthyverse R套件的作者)和David Kun(Functional Analytics的聯合創始人,該公司負責R、Python和其他數據科學語言的ownR平台工程解決方案)撰寫的改變遊戲規則的資源。

這本全面指南通過將Python和R與Excel集成,改變了您處理基於試算表的數據的方式,自動化任務,執行統計分析並創建強大的可視化效果。通過閱讀本書,您將了解如何進行探索性數據分析、時間序列分析,甚至集成API以實現最大效率。無論您是初學者還是專家,本書都具備了解鎖定Excel的全部潛力並將您的數據分析技能提升到更高水平所需的一切。

通過閱讀本書,您將能夠從Excel中導入數據,使用R或Python對其進行操作,並在所需時將結果推回Excel以與他人共享。

您將學到什麼
- 使用R和Python庫讀寫Excel文件
- 使用R和Python腳本自動化Excel任務
- 使用R和Python執行Excel VBA宏
- 使用R和Python套件格式化Excel工作表
- 在Excel中使用ggplot2和Matplotlib創建圖表
- 使用統計方法和時間序列分析分析Excel數據
- 探索從Excel調用R和Python函數的各種方法

本書適合對象
- 如果您是數據分析師、數據科學家、量化分析師或數據從業人員,並希望提升您的Excel技能,並通過R和Python擴展您的數據分析能力,那麼本書適合您。它提供了對所涵蓋主題的全面介紹,適合初學者和中級學習者。只需基本了解Excel、Python和R即可開始。

目錄
1. 讀取Excel試算表
2. 寫入Excel試算表
3. 從R和Python執行VBA代碼
4. 進一步自動化(電子郵件通知等)
5. 格式化Excel工作表
6. 插入ggplot2/matplotlib圖表
7. 樞紐分析表(R中的tidyquant和Python中的win32com和pypiwin32)/摘要表{gt}
8. 使用R和Python進行探索性數據分析
9. 統計分析:線性和邏輯回歸
10. 時間序列分析:統計、圖表和預測
11. 直接從Excel或通過API調用R/Python
12. 使用R和Python進行Excel數據的數據分析和可視化-案例研究