I'm excited to introduce a new content series! Each week:
Monday: Introduction to one of my packages.
Tuesday: Exploration of a specific R.
Wednesday: Integration of VBA and R.
Thursday: Practical examples.
Friday: Insights and snippets from my book, "Extending Excel with Python and R"
Learn how to split strings and get the first element in R using base R, stringi, and stringr. Check out my latest post for examples and tips. Give it a try and share your experiences!
The TidyDensity package now includes new functions to calculate the Akaike Information Criterion (AIC) for various distributions, streamlining model quality assessment. Use functions like util_negative_binomial_aic() to automate AIC calculations, ensuring precise model evaluation.
📊 Enhance Your Excel Skills with R! 📊 I wrote an R function using RDCOMClient to count sheets in an Excel workbook.
This tool automates Excel tasks, boosting productivity. Learn more techniques like this in my new book co-authored with David Kun: "Extending Excel with Python and R." Discover practical tips to enhance your data analysis skills. Get your copy here: https://packt.link/oTyZJ
Easily retrieve and analyze CMS metadata with customizable searches using .title, .keyword, and .modified_date. Choose data versions ("current", "archive", "all") and filter by media type ("all", "csv", "API", "other"). It returns a tidy tibble with essential metadata.
Learn how to handle rows in R containing specific strings using base R's grep() and dplyr's filter() with str_detect(). Select or drop rows efficiently and enhance your data manipulation skills. Give it a try with your datasets for better data cleaning and organization.