Publications by Numbers around us
PowerQuery Puzzle solved with R
#211–212PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #211Sometimes there is more than one team under your “jurisdiction” and you need to summarise data coming from different places. And we have it today. Most tricky part here is that we have multilev...
1593 sym R (1239 sym/6 pcs) 16 img
SQL of the Rings: One Language to Query Them All (with R)
Concise Tutorial for R Database InterfacesIn the Land of Databases, where the Data lies…In the vast and intricate world of data, much like the realms of Middle-earth, there lies a powerful force — SQL, the language of databases. SQL (Structured Query Language) has long been the One Language to query them all, a tool that allows us to retri...
25557 sym R (6371 sym/22 pcs) 4 img
PowerQuery Puzzle solved with R
#209–210PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #209Today we have task related to project management. We have project that consists of processes that consists of tasks. Each task has owner and duration. We need to find out when each person will end ...
1787 sym R (1587 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 519–523PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #519Today we need to find very complex number. No not complex in mathematical sense, but have very interesting properties. We have to find numbers which itself, its square and cube, has ide...
2947 sym R (3146 sym/15 pcs) 34 img
Why Every Data Scientist Needs the janitor Package
Lessons from Will Hunting and McGayverIn the world of data science, data cleaning is often seen as one of the most time-consuming and least glamorous tasks. Yet, it’s also one of the most critical. Without clean data, even the most sophisticated algorithms and models can produce misleading results. This is where the janitor package in R comes in...
18911 sym R (8365 sym/16 pcs) 4 img
PowerQuery Puzzle solved with R
#207–208PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #207Sometimes we have task that are somehow related to real life, not just mind-bending puzzles. And today we have cross table containing check if somebody has to work certain day (or maybe those are d...
1822 sym R (1773 sym/5 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 514–518PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #514Today we are searching for treasure. Exactly what we need is to find highest 2×2 submatrix within 5×5 matrix. Manually it would take maybe a minute, but we need to code it somehow. No...
2775 sym R (3247 sym/15 pcs) 34 img
PowerQuery Puzzle solved with R
#201–206PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #201We need to find out which customer had opportunity to buy specific product (and maybe bought). We receive two tables: one presenting time of customer activity and one presenting item availability. ...
4013 sym R (5308 sym/18 pcs) 40 img
R Solution for Excel Puzzles
Puzzles no. 499–413PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #499Interesting numbers are pretty often in scope of our puzzles. Today we have Lynch-Bell Numbers, and we need to find first 500 of them. Why they are special? Because of 4 conditions: non...
6725 sym R (14522 sym/42 pcs) 92 img
PowerQuery Puzzle solved with R
#199–200PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #199Data mining, maybe it is too big word for challenge we face today, but we need to dig up some information from given texts. Each of them have part number and order or delivery dates for each. Somet...
1637 sym R (1316 sym/6 pcs) 16 img