data visual & comm A6

Vicor Godoy - Jorge Cáceres

Our weekly tradition, from 28th to 31st of October 2024

This publication demonstrates techniques for handling data streams in R, focusing on reading from and writing to Excel files, essential for real-time data processing and analytics. Using packages like readxl and writexl, the guide explores how to establish file connections, efficiently read data from Excel files, and save processed results back to new files. It also includes a colorful summary table that highlights key functions for managing file connections in R. This resource provides practical steps for anyone working with dynamic data sources and cloud-based storage, bridging local R workflows with real-time data needs.

This publication explores methods for capturing and handling operating system command output within R, specifically tailored for Windows users. It demonstrates how to use R's system and system2 functions to execute the tasklist command, capturing the output as a character vector for easy manipulation and analysis. Additionally, the guide explains how to structure command output into data frames using the fread function from the data.table package. With practical examples and a summary table of command execution functions, this resource provides insights into integrating system-level data directly into R workflows, enhancing capabilities for system monitoring, automation, and data collection.