Articles by tomaztsql

Little useless-useful R functions – Colourful ggplot line graphs

July 16, 2021 | tomaztsql

How about some colours in line graph? Or even more wacky? Nevertheless, let’s create a function that generates some sample “mocked” data and draws a line chart: And run all together with three parameters: n – number of data points…Read more ›

Little useless-useful R functions – Is it raining yet?

July 12, 2021 | tomaztsql

Summer. Sunny weather. Vitamin D. And if you are missing vitamin Rain because you are growing a garden or simply want an inner cooling, hit this useless function to see, if there is a rain anywhere to be seen. Besides…Read more ›

Little useless-useful R functions – Inserting variable values into strings

July 9, 2021 | tomaztsql

Another useless function that could be found in many programming languages. For example typical Python sample, that everyone have encountered would be: Resulting in a string with: My Name is Tomaz and I write this post. So, let’s do something…Read more ›

Little useless-useful R functions – Looping through variable names and generating plots

May 24, 2021 | tomaztsql

Facets in ggplot2 are great for showing multiple plots on a single canvas. Assuming this usually covers many scenarios, there might be a case that you would want to save all the combinations of x and y variables in a…Read more ›

Using SQL for R data.frames with sqldf

April 27, 2021 | tomaztsql

There are many R packages for querying SQL Databases. Recently, I was looking into sqldf package | CRAN documentation. There are so many great advantages (simple running SQL statements, creating, loading, deleteing data to data.frames, connectivity to many databases, support…Read more › [Read more...]

Little useless-useful R functions – Letter frequency in a vector of numbers

March 22, 2021 | tomaztsql

So here is a useless fact. There is no letter A in numbers – written as words – from 1 to 100. And of course, we wanted to put this into the test and check if it holds the water.…Read more ›

Little useless-useful R functions – Using L-Systems for useless writing

February 17, 2021 | tomaztsql

Writing useless strings has been a focus of this series, and L-Systems (Lindenmayer Systems) are no different. It is a set or a string of characters that is rewritten on each iteration, following a set of rules. Probably the most…Read more ›

Little useless-useful R functions – Use pipe %>% in ggplot2

February 12, 2021 | tomaztsql

Using pipe %__% or chaining commands is very intuitive for creating following set of commands for data preparation. Visualization library ggplot in this manner uses sign “+” (plus) to do all the chaining. What if we would have to replace…Read more ›

Little useless-useful R functions – Useless R poem for Valentine

February 8, 2021 | tomaztsql

Gimmick not a poem, useless R code for your Valentine. Code for this heart shaped useless poem: And once you have the function persistent in your environment, just run: And for the poets, here the R version of the poem:…Read more ›

Little useless-useful R functions – R Version

February 3, 2021 | tomaztsql

Printing out R version is absolute no fun. So making it fun using the following useless-useful R function will make this little bit more interesting. Should be a print of “Hello R” with the version. Yes, I am rocking an…Read more ›

New features in Power BI for Data Analysts – Small multiples, Anomaly Detection and Zoom on visuals

January 21, 2021 | tomaztsql

Great new features have bundled and are now available in Power BI. With December 2020 update, all of the features described in this blog post will be available. Once you downloaded the latest update (as of writing of this blog,…Read more ›

My predictions for 2021 – Data and analytics

January 13, 2021 | tomaztsql

Year 2020 has had a tremendous impact on our lives and has driven many changes. Since last year was a year of radical changes (which we were or were not prepared for, but had to accept them), these will certainly…Read more ›

Little useless-useful R functions – Countdown number puzzle

January 11, 2021 | tomaztsql

The famous countdown game loved among mathematicians and people adoring numbers and why not find a way to check for solutions. So the game is (was) known as a TV show where then host would give a random 3-digit number…Read more ›

Little useless-useful R functions – Mathematical puzzle of Four fours

January 7, 2021 | tomaztsql

Yes. Playing with numbers is another call for useless R function. This time, we will be using a function that will find the simplest mathematical expression for a whole number from 0 to 9 (or even higher), using only:– common…Read more ›

Little useless-useful R functions – Create Pandas DataFrame from R data.frame

January 5, 2021 | tomaztsql

Fusion and stuff ? And since data science and data engineering is becoming a melting-pot of languages, here is another useless, yet some of you might find it useful, function that creates Python code for pandas DataFrame from R data.frame…Read more ›

Little useless-useful R functions – Playing stack of cards

January 3, 2021 | tomaztsql

This useless function is a self-played game of cards. Or you might call it vector or numbers. Creating a function that will play two players, both given a set of cards (represented with numbers). Ground rules are simple:– both players…Read more ›

Little useless-useful R functions – Folder Treemap

January 1, 2021 | tomaztsql

Welcome to new year 2021! Wish you all a great start and a healthy, prosperous and wonderful year. Brand new simple useless function will generate a Treemap with the value of subfolder size and the given names of the subfolder…Read more ›

Advent of 2020, Day 31 – Azure Databricks documentation, learning materials and additional resources

December 31, 2020 | tomaztsql

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating your first Azure Databricks cluster Dec 05: Understanding Azure Databricks cluster architecture, workers,…Read more › [Read more...]

Advent of 2020, Day 30 – Monitoring and troubleshooting of Apache Spark

December 30, 2020 | tomaztsql

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating your first Azure Databricks cluster Dec 05: Understanding Azure Databricks cluster architecture, workers,…Read more ›

Advent of 2020, Day 29 – Performance tuning for Apache Spark

December 29, 2020 | tomaztsql

Series of Azure Databricks posts: Dec 01: What is Azure Databricks Dec 02: How to get started with Azure Databricks Dec 03: Getting to know the workspace and Azure Databricks platform Dec 04: Creating your first Azure Databricks cluster Dec 05: Understanding Azure Databricks cluster architecture, workers,…Read more ›

« 1 … 3 4 5 6 7 … 10 »

Copyright © 2025 | MH Corporate basic by MH Themes