Publications by Numbers around us
PowerQuery Puzzle solved with R
#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 usual we have to transform table little bit, and make some kind of summary. So let bat swings.L...
1359 sym R (1473 sym/6 pcs) 8 img
Ainulindalë in R: Orchestrating Data Pipelines for World Creation
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 harmonious reality. Just as these divine voices layer upon each other to shape the physical and metap...
24408 sym R (4073 sym/10 pcs) 4 img
PowerQuery Puzzle solved with R
#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, person fails the subject. Then we have to find the...
1598 sym R (1540 sym/6 pcs) 8 img
R Solution for Excel Puzzles
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 matrix with values, and coordinate values as rows ...
3839 sym R (4333 sym/15 pcs) 14 img
Super Saiyan Data Skills: Mastering Big Data with R
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 and techniques, these modern-day warriors can tack...
10466 sym R (2193 sym/10 pcs) 14 img
PowerQuery Puzzle solved with R
#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 need to find their relationships. We only have first and last name and number of generation. So to...
1578 sym R (1778 sym/6 pcs) 8 img
R Solution for Excel Puzzles
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 matrix 20×5 with names of columns of Excel ...
2914 sym R (4382 sym/13 pcs) 16 img
Navigating the Data Pipes: An R Programming Journey with Mario Bros.
Welcome to the Mushroom KingdomIn the vast and varied landscape of data analysis, navigating through complex datasets and transformation processes can often feel like an adventure through unknown lands. For those who embark on this journey using R, there’s a powerful tool at their disposal, reminiscent of the magical pipes found in the iconic Mu...
13543 sym R (4560 sym/13 pcs) 10 img
PowerQuery Puzzle solved with R
#171–172PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #173One of contestants said: Why should we break such a nice table? Because indeed it is what we have to do: break table into cross-tab which is cross-tab only from appearance. We need to generate some...
1661 sym R (2412 sym/6 pcs) 8 img
R Solution for Excel Puzzles
Puzzles no. 429–433PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #429We all (I assume) know the Pythagorean theorem, thanks to which we can calculate sides of triangle. But today we have Pythagorean quadruples, which follows similar rules. Not to be too ...
2566 sym R (4626 sym/17 pcs) 16 img