R Archives - Data Cornering

by Janis Sturis May 15, 2020 Comments0

R

Multiple left joins in R

Here is a quick and easy way to perform multiple left joins in R with multiple data frames.

by Janis Sturis May 12, 2020 Comments0

CMD R

For me, it worked like this, but there is also modification needed in the actual batch file.

system("cmd.exe", input = paste('C:\\This\\Is\\Path\\Your.bat'))

1	system("cmd.exe", input = paste('C:\\This\\Is\\Path\\Your.bat'))

In the batch file, I…

by Janis Sturis May 7, 2020 Comments0

Sometimes it’s necessary to convert accented characters to non accented in R or Power BI for text analysis purposes. Accented characters might be…

by Janis Sturis May 5, 2020 Comments0

R

To concatenate, you can use R base functions paste and paste0 that are almost the same. The only difference is in the separator…

by Janis Sturis May 4, 2020 Comments0

R

Here is a quick and easy way hot to get the maximum or minimum value within each group in R in separate columns.…

by Janis Sturis January 1, 2020 Comments0

R RStudio

RStudio snippets are very handy when it comes to dealing with repetitive tasks. Here is how to modify RStudio snippets or create a…

by Janis Sturis December 27, 2019 Comments0

R

Here is how to calculate cumulative sum or count by using R built-in datasets.

by Janis Sturis December 26, 2019 Comments0

R

There are at least two ways how to fill down values in R data frame columns. The fastest way is to use zoo…

by Janis Sturis November 29, 2019 Comments0

R

In this post, I will explain the approach on how to combine numbers with R to find out which of them makes a…

by Janis Sturis November 28, 2019 Comments0

Here are multiple examples of how to add leading zeros in different ways and places. In these examples, I will add them to…