Replacing, excluding or imputing missing values is a basic operation that’s done in nearly all data cleaning processes. In my third blog post on Julia I give an overview of common solutions for replacing missing values. First, let’s create a dummy DataFrame as an example. Both columns, a and b,…
When I started coding in R, a couple of years ago, I was stunned by the assignment operator. In most — if not all — coding languages I know, assignment is done through the equal sign ‘=’, while in R, I was taught to do it through the backarrow ‘<-‘.…
Here’s my second blog post on Julia. For a simple simulation I needed some randomly generated numbers from a normal distribution. In Julia, there are multiple ways to generate them. But to really customize the distributions, you need a random number generator (RNG). Because I found the documentation to be…
I recently started working with Julia. I’ve been reading some great things about it and I felt I needed to try it out. As I’m working myself through a data science project, I plan on writing a couple of blog posts on stuff that needs some explanation. In this first…
One of the best things about RStudio is that it offers a splendid interface. You can always keep one eye on all the variables in the environment, and inspect data frames using the View() function or by clicking the spreadsheet icons. But sometimes you need to do some quick exploratory…
In this 2-part blog post I want to discuss two files that allow you to customize your R experience. In this part I discuss the .Renviron file. First I answer what it does, where you can find it and finally we get to the part where we actually use it.…
In this 2-part blog post I want to discuss two files that allow you to customize your R experience. In this part I discuss the .Rprofile file. Part 1: The .Renviron file Part 2: The .Rprofile file What is the .Rprofile file? The .Rprofile file runs right after the .Renviron…
In R you’ll use rbind, in Pandas you’ll use append, in SQL you’ll use UNION. But how do you append files in PowerQuery? In this example I will combine multiple files that contain data for every month of 2019. For convenience, I use the refundable pharmaceutical products in Belgium. Before…
Ze komen in alle smaken, kleuren, formaten en met variëteit aan talenten. Met ronkende titels: BI Consultant, Business Consultant, Data Consultant, Integration Consultant, Digital Customer Consultant, Culture and Engagement Consultant, Workforce Transformation Consultant of Technology Strategy Consultant. En als het echt niet meer op een visitekaartje mag passen is er…
Let’s start with saying that importing MS Access files into R can be easy, but it isn’t necessarily so. There’s some compatibility issues that you need to know about. This blog post elaborates on these errors and how I solved them. Import tables from an .mdb file Opening a connection…