Philippe Massicotte

When duckdb meets dplyr!

I like DuckDB 🦆. I am excited to see that it is now possible to use it with dplyr using the fantastic duckplyr package which gives us another way to bridge dplyr with DuckDB.

Philippe Massicotte

Segmenting linestring into points of equal distance

This will be a quick one, but I thought it was worth sharing (at least for future me). I was recently trying to segment a line into points of equal distances. I must say…

Philippe Massicotte

Unlocking Cloud Data: A Step-by-Step Guide to Reading and Transforming Spatial Data with DuckDB

Simple Features

In this blog post, I will show you how to read and transform spatial data hosted in the cloud with DuckDB¹. I will use the nycflights13, a popular dataset for learning data…

Philippe Massicotte

Separating/exploding spatial features with R

It has been a while since I posted something! But today I wanted to quickly experiment and create a map where I could separate/explode the spatial geometries. Let’s first…

Philippe Massicotte

Hanukkah of data 2022

If you are looking for some data science challenges, don’t look anymore, Hanukkah of Data is there for you. You can think of it as similar to Advent of Code but tailored…

Philippe Massicotte

Uptating Ubuntu packages crashed my renv R project

I am using renv quite a lot. Recently, I had to return to an older project that was using this package to manage package dependencies. When I tried to load tidyverse, I got…

Philippe Massicotte

Removing white spaces around plots in R Markdown / Quarto

When plotting spatial data, such as a geographical map, maintaining a proper aspect ratio is important. Whereas knitr::plot_crop() works fine to crop a file, how can we do…

Philippe Massicotte

How to read AMSR2 sea ice data with terra

Today I was trying to read AMSR2 sea ice data. I was surprised to discover that the files do not include coordinates or projection information. Data and coordinates are…

Philippe Massicotte

Beautiful equations in R Markdown and Quarto

Package discovery

When writing dynamic documents in R (either R Markdown or Quarto), it can be useful to display model equations. I recently discovered equatiomatic, a very nice package that…

Philippe Massicotte

Changing spatial resolution of a raster with terra

Lately, I was working on a project and I needed to change the spatial resolution of a GeoTIFF to match that of another one. After looking around, I posted a question on…

Philippe Massicotte

Reading multiples CSV files using readr

Data manipulation

If you are beginning in R, chances are that you have used read.csv() to import CSV files into R. While this function works perfectly fine, it can only read one file at a…

Philippe Massicotte

Choosing the right geographic projection with the crsuggest R package

When creating maps, choosing an appropriate geographical projection is often a difficult task (at least for me). There are plenty of projections to choose from, and none can…

Philippe Massicotte

Extracting raster values using the stars R package

For a long time, I have been using the raster package to manipulate raster data in R. Slowly, I am trying to work my way out with the new stars package. In this post, I am…

Philippe Massicotte

How to change the language of dates in R

Recently, I had to make a ggplot2 graphic with data that contained dates. Let’s create some sample data with dates.

Philippe Massicotte

Removing borders around ggplot2 graphs

Recently I was participating in the 30DayMapChallenge where people were invited to make a map based on a different daily theme for one whole month.

Philippe Massicotte

Visualizing the decrease of Artic sea ice extent

It is well known that the Arctic sea ice extent is decreasing at an increasing pace. As stated by the National Snow & Ice Data Center:

Philippe Massicotte