Vishal Katti
About
Blog
Courses
CV
Let’s Talk 1-on-1
Katti’s Blog
Categories
All
(9)
Date
(1)
Excel
(3)
ISO8601
(1)
List
(1)
PowerPoint
(2)
Python
(2)
R
(8)
RDCOMClient
(1)
VBA
(2)
dplyr
(1)
drill-down
(1)
functions
(4)
openxlsx
(1)
pivot
(2)
reactable
(1)
tidyr
(2)
Order By
Default
Title
Date - Oldest
Date - Newest
Author
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.
Feb 20, 2024
Vishal Katti
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.
Jan 6, 2024
Vishal Katti
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