Extending Excel with Python and R

Extending Excel with Python and R

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

Kun, David; Sanderson, Steven

Packt Publishing Limited

04/2024

344

Mole

9781804610695

Pré-lançamento - envio 15 a 20 dias após a sua edição

Descrição não disponível.
Table of Contents

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