Publications by Numbers around us
PowerQuery Puzzle solved with R
#143–144PuzzlesAuthor: ExcelBIFrom this week all files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Suprisingly this week we have no time-related puzzles, they are rather transformations of tables.Puzzle #143In this puzzle we have some kind of log. Employees are entering values of observatio...
1674 sym R (858 sym/6 pcs) 8 img
Old Art, New Code: The Typesetter’s Guide to Memoization
n the world of programming, where complexity often intertwines with the need for efficiency, there exists a practice as ancient as it is modern: memoization. This concept, akin to the meticulous art of typesetting in the days of yore, stands as a testament to the timeless pursuit of optimization and reusability. Typesetters, in the era of physical ...
9787 sym R (2081 sym/3 pcs) 4 img
PowerQuery Puzzle solved with R
# 141–142Puzzles:PQ_141: content filePQ_142: content fileLast time I noted that usually PQ Puzzles are focused on times and dates. And… it confirms this week. Lets count it.PQ_141Rolling averages and other rolling calculations are very useful concepts because it can show us main trend cleaned from lower time granulation anomalies. In R we can...
2234 sym R (1562 sym/5 pcs) 8 img
R Solution for Excel Puzzles
Puzzles no. 349–353PuzzlesAuthor: ExcelBIPuzzles:#349: content file#350: content file#351: content file#352: content file#353: content fileLet dig in those numbers.Puzzle #349In this puzzle we have to translate “normal” (Arabic) numbers into Roman numerals. With one twist… Historically roman numerals has its limit (3899 if I recall prope...
2444 sym R (4189 sym/15 pcs) 14 img
S(00)7 — Agent with License for OOP
S(00)7 — Agent with License for OOPIn the realm of data science and statistical programming, R stands out for its rich set of features and libraries. Just like the iconic James Bond, also known as Agent 007, who never fails to amaze with his suave skills and an array of sophisticated gadgets, the R programming language has its own secret wea...
14369 sym R (6318 sym/15 pcs) 4 img
PowerQuery Puzzle solved with R
# 139–140Puzzles:PQ_139: content filePQ_140: content fileI noticed that usually Power Query puzzles are about time. Does it really a case in PQ that time related calculations are hard or tricky?PQ_139In this puzzle we have to extract informations about people days off for vacation. Table has person and date when that person was on day of. Our g...
1537 sym R (1764 sym/6 pcs) 8 img
R Solution for Excel Puzzles
Puzzles no. 339–343PuzzlesAuthor: ExcelBIPuzzles:#344: content file#345: content file#346: content file#347: content file#348: content fileLet dig in those numbers.Puzzle #344I am sure that you have heard about palindrome, but did you know katadromes? I haven’t heard about it before this puzzle. And what it is? Number in which digits are dec...
2466 sym R (4017 sym/14 pcs) 14 img
A Beautiful Mind: Writing Testable R Code
The Art of Testable CodeIn the intricate world of programming, particularly in the field of data science, the ability to write testable code stands as a hallmark of a skilled developer. Testable code is the backbone of reliable and maintainable software, ensuring that each piece of your code not only performs its intended function but does so unde...
6537 sym R (1056 sym/3 pcs) 4 img
PowerQuery Puzzle solved with R
# 137–138Puzzles:PQ_137: content filePQ_138: content filePQ_137Our goal today is to find out some data properties in table, but unfortunatelly they are weirdly nested in cells. It doesn’t look scary because we already know that many structured are nested like JSONs or XMLs. So today we have to unfold bowels of one table and join it with the se...
1664 sym R (1266 sym/6 pcs) 8 img
PowerQuery Puzzle solved with R
# 135–136Puzzles:PQ_135: content filePQ_136: content filePQ_135Lets imagine that we have binning machines in our sport centre. We can set how many balls need to be grouped in one bin/bucket/chest/whatever. We have 10 balls and machine is placing it in maximally 4 containers.Now basing on bin size set on machine we have to find what range of ball...
1628 sym R (1515 sym/4 pcs) 8 img