PowerQuery Puzzle solved with R

January 2, 2024 | Numbers around us

#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 ...
[Read more...]

R Solution for Excel Puzzles

January 2, 2024 | Numbers around us

Puzzles no. 354–358PuzzlesAuthor: ExcelBIFrom this week all files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #354This puzzle comes up on Christmas (Dec, 25th), so it was not really suprisin...
[Read more...]

From R to excel: Part 1

January 2, 2024 | Zahier Nasrudin

Introduction Welcome welcome. In this blog post, we will be exploring: How to export multiple data frames into a single Excel file with multiple sheets using the writexl and openxlsx packages By the end of this post, you & I should have a solid understanding of how to export multiple data ...
[Read more...]

Most popular posts – 2023

January 2, 2024 | Eran Raviv

Welcome 2024. This blog is just a personal hobby. When I’m extra busy as I was this year the blog is a front-line casualty. This is why 2023 saw a weaker posting stream. Nonetheless I am pleased with just over 30K visits this year, with an average of roughly one minute ...
[Read more...]

Quantile Regression with Random Forests

January 1, 2024 | matloff

In my December 22 blog, I first introduced the classic parametric quantile regression (QR) concept. I then showed how one could use the qeML package to perform quantile regression nonparametrically, using the package’s qeKNN function for a k-Nearest Neighbors approach. A reader then asked if this could be applied to ...
[Read more...]

Favorite books of 2023

December 30, 2023 | Posts | Joshua Cook

This year, I made a cognizant push to read more frequently and consistently. I think I was successful, definitely improving over the previous year, and I finished 25 books this year. Below is a review of my favorite books from this year in order of how... [Read more...]

Reversion to the Mean: Unraveling a Pervasive Misconception in Business and Beyond

December 29, 2023 | Learning Machines

In the realm of business and leadership, one statistical phenomenon often goes unrecognized yet significantly influences our understanding of performance and success. This is the concept of reversion to the mean. This seemingly simple statistical occurrence can profoundly impact how we perceive management strategies, leadership effectiveness, and even the fate ...
[Read more...]

Python Rgonomics

December 28, 2023 | rstats | Emily Riederer

Interoperability was a key theme in open-source data languages in 2023. Ongoing innovations in Arrow (a language-agnostic in-memory standard for data storage), growing adoption of Quarto (the language-agnostic heir apparent to R Markdown), and even p... [Read more...]

100 days of Python and R

December 28, 2023 | R | Discindo

Today, together with a friend who is looking to get into data analytics, I started doing the 100 days of Python challenge at Replit. I thought it would be a good idea to do the challenges in R, because why not. :) So, I am at day 2 (whoohooo I did two ... [Read more...]
1 23 24 25 26 27 2,095