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

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

#185–186PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Today we need to add index for employees. De facto, we need to assign them their number in order of their occuran...

Puzzles no. 459–463PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #459This episode first puzzle is based on pure math. We need to find next perfect square number...

Welcome back to the world of purrr! Last time (about a year ago), we spun a metaphorical yarn about the wonders of purrr in R. Today, we're rolling up our sleeves and diving into a hands-on tutorial. We're going to explore how purrr makes working with lists and vectors a ...

#183–184PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #183This Saturday we had quite interesting case to solve. We had table with rental agreements, which need ...

Puzzles no. 454–458PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #454Sombody was counting something, and as usually we have to check it and find the most insigt...

Introduction to Shiny and Interactive Web ApplicationsIn today’s data-driven world, the ability to create dynamic, interactive web applications is a highly valuable skill. Shiny, a package developed by RStudio, provides an elegant framework for buildin...

#181–182PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #181This weekend we have very interesting situation, because we are basing on the same data, but different...

Puzzles no. 449–453PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #449We are starting this week with rotating words. Wait what? No, we are not gonna swirl them a...

In the intricate world of data analysis, the task of text pattern recognition and extraction is akin to unlocking a secret cipher hidden within ancient manuscripts. This is the realm of regular expressions (regex), a powerful yet often underappreciated tool in the data scientist’s toolkit. Much like the cryptex ...

#179–180PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #179I must admit that I am not a big fan of baseball, but it doesn’t stop me before this challenge. As usu...

Puzzles no. 444–448PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #444This time we were spelling numbers. Yes, you heard it right. We were taking multidigit numb...

In the great, unfolding narrative of J.R.R. Tolkien’s Ainulindalë, the world begins not with a bang, nor a word, but with a song. The Ainur, divine spirits, sing into the void at the behest of Ilúvatar, their voices weaving together to create a harmoni...

#177–178PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #177We are about to create reports for three students, each of them have to pass 3 exams for each subject. If even one of them has mark lower than 40, ...

#177–178PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #177We are about to create reports for three students, each of them have to pass 3 exams for each subject. If even one of them has mark lower than 40, ...

Puzzles no. 439–443PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #439From time to time in ExcelBI challenges, hard puzzles come to us. And this time it was one of such situations. Input we were given was ...

Harnessing the power of big data is akin to mastering an incredible energy source. In the realm of data science, R serves as both a sanctuary and a training ground where data scientists, like the legendary fighters from “Dragon Ball,” elevate their abilities to new heights. With the right tools ...

#175–176PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #175Sometimes even common tables tell the story. Today we have table of people that are family, but we nee...

Puzzles no. 434–438PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #434Sometimes challenges we are facing have not really much with real world problems. And no. 434 is one of them. Our task this time was to make ...