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.

This document explores essential functions for handling strings in R, particularly in the context of data analysis. Through practical examples, it covers key functions like print, cat, paste, and message, demonstrating how each can be used to display, manipulate, and control text output. With a focus on a hypothetical dataset of customer feedback, the document illustrates string handling techniques that are invaluable when processing textual data for sentiment analysis, reporting, and data labeling. A colorful summary table provides a quick reference to these functions, helping readers streamline their approach to working with string data in R