Publications by Numbers around us
Writing R Code the “Good Way”
Embracing the Tidyverse Style GuideHey there, fellow R coder! When it comes to writing code in R, making it functional is just the beginning. Trust me, I’ve been there — debugging code at 2 AM, wondering what I was thinking when I wrote that line. This is where the Tidyverse Style Guide comes to the rescue, transforming your functional cod...
8906 sym R (1880 sym/28 pcs) 4 img
PowerQuery Puzzle solved with R
#191–192PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #191Usually on Power Query Challenges we are getting some table transformations, but not this time. We have some pretty hardcore text manipulation here. What we have to do? Get from text only “words�...
2518 sym R (4689 sym/7 pcs) 14 img
R Solution for Excel Puzzles
Puzzles no. 474–478PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #478Waves of digits in style of Kanagawa wave, created by Dall-e3Today we get some numbers and our task was to detect which one of them are wavy. What does it mean? Digits in those numbers...
2782 sym R (3323 sym/15 pcs) 34 img
Joins Are No Mystery Anymore: Hands-On Tutorial — Part 3
Joins Are No Mystery Anymore: Hands-On Tutorial — Part 3Welcome back to the final installment of our series, “Joins Are No Mystery Anymore: Hands-On Tutorial.” In the previous weeks, we covered the foundational and advanced join techniques, including Inner Join, Left Join, Right Join, Full Join, Semi Join, Anti Join, Cross Join, Natural ...
11549 sym R (10951 sym/9 pcs) 4 img
PowerQuery Puzzle solved with R
#189–190PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #189We have sequential report of some weird acceptance process. Unfortunatelly we don’t know the rules, and we are suppose to only clean report to more digestible form. We need to check if after any ...
1735 sym R (2299 sym/7 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 469–473PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #469This task is suprisingly easy and interesting at once. We have sequence of letters separated with comma and space. They are not necessarily in proper order, but we need to mark them in ...
4839 sym R (4259 sym/14 pcs) 36 img
Joins Are No Mystery Anymore: Hands-On Tutorial — Part 2
Joins Are No Mystery Anymore: Hands-On Tutorial — Part 2Welcome back to the second part of our series, “Joins Are No Mystery Anymore: Hands-On Tutorial.” In the first part, we explored the foundational types of joins, including Inner Join, Left Join, Right Join, Full Join, and Semi Join. Through practical, real-life scenarios and step-by...
13403 sym R (12041 sym/10 pcs) 4 img
PowerQuery Puzzle solved with R
#187–188PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #187There are two ways of showing data and it really depends on what is the purpose of certain presentation. Sometimes we only need to show those data point that have any data in it, but sometimes we n...
2120 sym R (1543 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 464–468PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #464As you already now well, Vijay A. Verma aka ExcelBI love finding some unique sequences of numbers and then combine them, and this time is something like this again. Today we have evil n...
3520 sym R (3981 sym/14 pcs) 34 img
Joins Are No Mystery Anymore: Hands-On Tutorial — Part 1
Joins Are No Mystery Anymore: Hands-On Tutorial — Part 1Welcome! In this tutorial, I’ll be your guide as we unravel the mysteries of data joins in R. Whether you’re working with customer records, inventory lists, or historical documents, mastering data joins is essential for any data analyst or scientist. Together, we’ll explore a vari...
12459 sym R (12199 sym/10 pcs) 4 img