You're reading from Extending Excel with Python and R Unlock the potential of analytics languages for advanced data manipulation and visualization

Product type Paperback

Published in Apr 2024

Publisher Packt

ISBN-13 9781804610695

Length 344 pages

Edition 1st Edition

Languages

Python

Tools

Excel

Concepts

Data Analysis

Authors (2):

Steven Sanderson

Kun

View More author details

Table of Contents (20) Chapters

Preface

1. Part 1:The Basics – Reading and Writing Excel Files from R and Python

2. Chapter 1: Reading Excel Spreadsheets FREE CHAPTER

3. Chapter 2: Writing Excel Spreadsheets

4. Chapter 3: Executing VBA Code from R and Python

5. Chapter 4: Automating Further – Task Scheduling and Email

6. Part 2: Making It Pretty – Formatting, Graphs, and More

7. Chapter 5: Formatting Your Excel Sheet

8. Chapter 6: Inserting ggplot2/matplotlib Graphs

9. Chapter 7: Pivot Tables and Summary Tables

10. Part 3: EDA, Statistical Analysis, and Time Series Analysis

11. Chapter 8: Exploratory Data Analysis with R and Python

12. Chapter 9: Statistical Analysis: Linear and Logistic Regression

13. Chapter 10: Time Series Analysis: Statistics, Plots, and Forecasting

14. Part 4: The Other Way Around – Calling R and Python from Excel

15. Chapter 11: Calling R/Python Locally from Excel Directly or via an API

16. Part 5: Data Analysis and Visualization with R and Python for Excel Data – A Case Study

17. Chapter 12: Data Analysis and Visualization with R and Python in Excel – A Case Study

18. Index

Why subscribe?

19. Other Books You May Enjoy

Installing and understanding the tasksheduleR library

The taskscheduleR R package allows you to schedule R scripts or processes with the Windows task scheduler. This means that you can automate R processes on specific time points from within R itself. The package is basically a wrapper around the Schtasks.exe functionality. Schtasks.exe is a command line tool that allows you to create, delete, query, change, run, and finish scheduled tasks on a local or remote computer. To use taskscheduleR, you first need to install the package from CRAN. Once the package is installed, you can use the following functions to schedule R scripts:

taskscheduler_create(): This function creates a new scheduled task.
taskscheduler_remove(): This function removes an existing scheduled task. If you are using version 1.8, then the function is taskscheduler_delete().
taskscheduler_get(): This function gets the information about an existing scheduled task.

The taskscheduler_create() function...