Katti’s Blog

Pivoting your tables with Tidyr: Part II

Converting “long” to “wide” format
R
functions
tidyr
pivot

This post demonstrates how to use pivot_wider() to convert your long data to wide data. This is part 2 of the Pivoting your tables with Tidyr series.
Aug 29, 2022
Vishal Katti

Pivoting your tables with Tidyr: Part I

Converting “wide” to “long” format
R
functions
tidyr
pivot

This post demonstrates how to use pivot_longer() to convert your wide data to long data. This is part 1 of the Pivoting your tables with Tidyr series.
Jul 8, 2022
Vishal Katti

Writing Robust R Functions

Some designs to validate function arguments.
R
functions

This post demonstrates some techniques to make your R user-defined functions unbreakable (well, almost!) by checking if function arguments are missing, incorrect data type or just down-right invalid values and how to return meaningful error messages.
Jan 18, 2022
Vishal Katti

Unholy Trinity of R, Excel VBA and Powerpoint - Part 2 of 2

Using R to trigger Excel VBA macros to create PowerPoint presentations
R
Excel
VBA
PowerPoint
openxlsx
RDCOMClient

This post demonstrates how to run VBA macros in Excel which in turn creates Presentations based off PowerPoint Templates.
Dec 29, 2021
Vishal Katti

Unholy Trinity of R, Excel VBA and Powerpoint - Part 1 of 2

Using R to trigger Excel VBA macros to create PowerPoint presentations!
R
Excel
VBA
PowerPoint

This post demonstrates how to create a PowerPoint template based off your custom/corporate Presentation/Report and VBA-enabled Excel file that would populate the report.
Oct 19, 2021
Vishal Katti

Interactive Drill-down Tables using {reactable}

How to create multi-level tables with hidden rows
R
reactable
drill-down

This post demonstrates how to use the {reactable} package to create multi-level drill-down tables having hidden rows
Jul 27, 2021
Vishal Katti

Programming with R {dplyr} - As I Understand It!!

How to create your own functions using {dplyr}
R
dplyr
functions

This post demonstrates how to write your own dynamic functions using popular dplyr verbs like select(), filter(), mutate(), arrange() and group_by() with summarise().
Jul 17, 2021
Vishal Katti
No matching items