Publications by Numbers around us
PowerQuery Puzzle solved with R
#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 occurance, not looking at fact how many times their appear in document. I can tell you that at the beg...
1818 sym R (1912 sym/8 pcs) 16 img
R Solution for Excel Puzzles
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 to one given. Given number doesn’t have to be square itself. But it is really easy if you t...
2989 sym R (2774 sym/15 pcs) 34 img
Mastering purrr: From Basic Maps to Functional Magic in R
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 breeze, transforming and manipulating them like a data wizard.With purrr, you...
18014 sym R (12219 sym/41 pcs) 6 img
PowerQuery Puzzle solved with R
#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 to be transformed to kind of payment schedule. We have lenght of contract, interest rate increa...
1704 sym R (1430 sym/6 pcs) 16 img
R Solution for Excel Puzzles
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 insigthful info. We have to find the length of each sequence, but in some of the, there are ranges w...
2531 sym R (3365 sym/16 pcs) 34 img
Shiny and Beyond: Mastering Interactive Web Applications with R and Appsilon Packages
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 building such applications using R. It enables data scientists and analysts to transform their analyses...
17031 sym R (9196 sym/19 pcs) 22 img
PowerQuery Puzzle solved with R
#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 direction of activities. In first one we have stacked and pivoted table cut to section, and we...
1838 sym R (1387 sym/6 pcs) 16 img
R Solution for Excel Puzzles
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 and twist them. We need to find out if one word is second one’s rotated version, which means ...
2753 sym R (3255 sym/17 pcs) 32 img
The Rebus Code: Unveiling the Secrets of Regex in R
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 from Dan Brown’s “The Da Vinci ...
17182 sym R (4041 sym/11 pcs) 4 img
R Solution for Excel Puzzles
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 number, spell it one by one, counting how many of them were present in digit. Like: there are two ...
2780 sym R (4988 sym/15 pcs) 16 img