Publications by Numbers around us
PowerQuery Puzzle solved with R
#231–232PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #231Both puzzles this weekend are somehow related to logistics. In first one we need to complete data for invoice for each person placing order. We have classic transforming and joining problem. One tr...
1507 sym R (1179 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 574–578PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #574We have some weird military drill on numbers today. Like some seargent shouting “Every first out, step forward” and then we need to sort them in order of height. But we are doing it...
2785 sym R (2897 sym/15 pcs) 34 img
Data at Your Fingertips: Crafting Interactive Tables in R
Why Interactive Tables MatterWhen people think of tables, they often picture static rows and columns, a no-frills way to present data. But interactive tables are a whole different story! These tables let users engage with the data directly, exploring it in ways that feel almost hands-on. Adding features like sorting, filtering, and searching trans...
18581 sym R (5202 sym/12 pcs) 28 img
PowerQuery Puzzle solved with R
#229–230PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #229When somebody is working on a project for more than a month it doesn’t really matter for him individually. But accountants wouldn’t be happy if we throw cost into interval which is not month. S...
1639 sym R (1368 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 569–573PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #569Today we have some random strings thate need to process in certain way. We have to count every letter that don’t have pair. That is my shortway to say this. Officially first we need t...
3188 sym R (3752 sym/15 pcs) 34 img
Table It Like a Pro: Print-Ready Tables in R
You’ve probably been there — mention to someone that you work with data, and they say, “Oh, so you just make tables?” Tables, right? How hard could it be? It’s just rows and columns. But we know better, don’t we? Tables aren’t just a random dumping ground for numbers; they’re the quiet superheroes of the data world. They give st...
13254 sym R (2561 sym/7 pcs) 20 img
PowerQuery Puzzle solved with R
#227–228PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #227We are given two tables one with employees data, and second with conditional assignment of salary. There is kind of regular expression in there but not in official notation, but rather giving aster...
1706 sym R (1385 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 564–568PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #564Have you ever thought about sorting only part of given data, not even changing position where that data live… Like conductor showing one part of orchestra to change way they playing w...
3092 sym R (3665 sym/15 pcs) 34 img
Don’t Get Fooled by Numbers: Data Literacy as the New Survival Skill
Have you ever looked at a headline or a graph and thought, “Well, the numbers don’t lie, right?” It’s tempting to trust the stats we see around us — whether it’s a political poll, a study about coffee’s health benefits, or a chart showing the rise of inflation. We want data to be the ultimate truth-teller. But here’s the thing: ...
17028 sym 4 img
PowerQuery Puzzle solved with R
#225–226PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #225Sometimes we have nice tables with so called tidy data, where each observation mean one row. But this can cause creating vast areas of data in spreadsheet, that are hard to find and interpret. That...
1626 sym R (1289 sym/6 pcs) 16 img