Publications by Numbers around us
R Solution for Excel Puzzles
Puzzles no. 334–338PuzzlesAuthor: ExcelBIPuzzles:# 334: content file# 335: content file# 336: content file# 337: content file# 338: content fileLets dive into solutions!Puzzle 334We are given pairs of numbers and we have to find if they are amicable. But what does it mean? That mean that numbers are like they are complementing each other one fa...
3534 sym R (5756 sym/19 pcs) 14 img
Catch Me If You Can: Exception Handling in R
The Importance of Error HandlingIn the multifaceted world of R programming, particularly when navigating the intricate paths of data analysis, robust error handling is not merely a precaution; it’s an essential pillar of reliable and trustworthy code development. Picture this: you’re deep into a complex data analysis task, your script meticulo...
7507 sym R (4208 sym/3 pcs) 4 img
PowerQuery Puzzle solved with R
# 133–134This weekend brought us two stories, two puzzles which have to things in common: they are pretty hard and difficulties were both linked to time dimension.Puzzles:PQ_133: content filePQ_134: content filePQ_133In first puzzle we have data about electricity consumption measured in some points of time during two days across three meters. It...
3218 sym R (2709 sym/8 pcs) 8 img
R Solution for Excel Puzzles
Week 47 — Puzzles no. 329–333PuzzlesAuthor: ExcelBIPuzzles:# 329: content file# 330: content file# 331: content file# 332: content file# 333: content fileLets dive into solutions!Puzzle 329In this puzzle we were asked to generate first 50 elements of Iccanobif sequence. Wait what? It is Fibonacci backwords… and that is exactly our goal ...
2607 sym R (7830 sym/23 pcs) 14 img
Winning Teams Point Balances
Excel BI’s Excel Challenge #304 — solved in RDefining the PuzzleThe puzzle revolves around sports team statistics and their respective weightages. Each team has matches that are either Wins (W), Draws (D), or Losses (L). These are given weightages of 1, 0, and -1, respectively. The challenge is to determine the top three teams based on th...
1920 sym R (1652 sym/5 pcs) 4 img
All Primes After Removal Single Digits
Excel BI’s Excel Challenge #303— solved in RDefining the PuzzleOur puzzle revolves around identifying numbers that, when any digit is removed, still remain prime. Let’s take a closer look:Example 1: Consider the number 371.Removing the first digit (3) gives 71, which is prime.Removing the second digit (7) gives 31, which is prime.Removi...
2267 sym R (1643 sym/6 pcs) 4 img
Boosting Your Data Weights: Training Accurate Models with tidymodels
In the captivating realm of machine learning, myriad techniques continually evolve to enhance predictive accuracy, offering innovative pathways for problem-solving. One such dynamic method is “boosting.” Imagine, if you will, the rigorous regimen of weightlifting. Each session targets heavier weights, challenging the lifter to push past previou...
8340 sym R (1612 sym/9 pcs) 6 img
Vigenere Cypher Grid
Excel BI’s Excel Challenge #302— solved in RIntroductionToday’s Excel BI puzzle is available here. It is pure generational work today. We have to create from scratch so called Vigenere grid. Exercise file today is purely for comparison reason: file.Defining the PuzzleThe puzzle in question revolves around the Vigenere Cipher Grid, a crypto...
1631 sym R (1201 sym/5 pcs) 4 img
The Fast and the Curious: Optimizing R
The Need for Speed in RIn the realm of data science, where the landscape is ever-changing and data volumes are incessantly swelling, speed and efficiency in processing aren’t mere conveniences — they’re indispensable. As we unveil the second chapter of our series, we turn the spotlight onto a crucial yet often understated aspect of R pro...
12687 sym R (5583 sym/10 pcs) 6 img
R Solutions for Excel Puzzles
Week 46 — Puzzles no. 323–328First time after few weeks I decided to slightly change my way of publishing this format of content. I used to publish daily, then every 2 or 3 days, but I realized that summary of all puzzles weekly will be my way.Host of our puzzles is publishing 7 puzzles a week: 5 for Excel (Mon-Fri) and 2 for Power Query ...
3684 sym R (9251 sym/28 pcs) 16 img