Vishal Katti - Katti’s Blog

Beyond 01/31/2024

Date Formats and why YYYY-MM-DD is the Goat!!

Date

ISO8601

R

Python

Excel

This post talks about the superiority of ISO 8601 Date format and why it matters in our day-to-day life.

Python - List Comprehension

Crafting Concise Lists with Python’s List Comprehensions

Python

List

This post demonstrates Python’s List Comprehension compared with the for loop and its usage.

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.

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.

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.

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.

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.

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

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().