Publications by Numbers around us
PowerQuery Puzzle solved with R
#165–166PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #165Today we get table with data which we suppose to transform into shape of Excel Pivot Tables (aka Crosstabs). Between grouped data rows we have to input group summaries and at very end — total...
2048 sym R (2249 sym/6 pcs) 10 img
Puzzles no. 409–413
Puzzles no. 409–413PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #409This puzzle is like splitting rock. Sometimes tables in Excel and other documents have merged cells or headers. It is not really comfortable for R, because we love clear tabular view th...
2623 sym R (3268 sym/14 pcs) 14 img
Navigating the Cosmos: Quarto, The Next Generation of Data Storytelling
Launching the Starship: An Introduction to QuartoIn the cosmic expanse of data science tools, a new starship has been unveiled — Quarto. Crafted from the essence of RMarkdown, Quarto is engineered to explore further, integrating more seamlessly with the universe of languages and tools used in data science, and providing a more powerful platf...
17456 sym R (1045 sym/7 pcs) 12 img
PowerQuery Puzzle solved with R
#163–164PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #163Some puzzle we receive are based on recognizing and checking certain patterns. I remember checking IPv6 addresses and validity of South African IDs, and today we have to check if license plates fro...
1739 sym R (1825 sym/6 pcs) 8 img
R Solution for Excel Puzzles
Puzzles no. 404–408PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #404Can analyst make something that looks good? Of course… Can analyst draw with numbers? Once more yeah. But today, like some times in past already, we have another way. I usually name m...
3065 sym R (4427 sym/15 pcs) 14 img
Mastering the Arcane: Advanced RMarkdown for Magical Data Science
Welcome to the next chapter in our exploration through the Enchanted Forest of Data, where the path becomes less trodden and the magic, more profound. As we delve deeper into the arcane arts of RMarkdown, we uncover tools and spells capable of transforming the complex into the captivating, the overwhelming into the understandable. Our journey begin...
21214 sym R (3369 sym/8 pcs) 16 img
PowerQuery Puzzle solved with R
#161–162PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #161This week comes with some of hardest challenges I faced on ExcelBI series. It was looking pretty straightforward, but later I realised what is going on. One of the least used measures describing se...
2161 sym R (2885 sym/5 pcs) 8 img
R Solution for Excel Puzzles
Puzzles no. 399–403PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #399Today we have been given a list of random strings containing of certain number of letters duplicated. And our task is to count how many of each letters are there and present it as alpha...
2791 sym R (5986 sym/15 pcs) 14 img
Navigating the Enchanted Forest of Data: A Tale of Reproducible Research with RMarkdown
Gathering Your Gear: Preparing for the Quest with RMarkdownStanding at the threshold of the Enchanted Forest of Data, you’re about to embark on a journey where insight and clarity emerge from the shadows of complexity. Your guide through this mystical realm is RMarkdown, a powerful tool that weaves the raw, untamed data into narratives of enlight...
17461 sym Python (1555 sym/12 pcs) 14 img
PowerQuery Puzzle solved with R
#159–160PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #159Today we have data about some salespeople. But they have only data about the months when they exceeded “norm” which is 100. Nonetheless those 100’s are also cost of employee so… We need to ...
1698 sym R (1173 sym/6 pcs) 8 img