R tricks

• Convert data from long to wide format
• Fetch data from a PostgreSQL database
• Format a number with leading zeros
• Concatenate a list of data frames
• Start a Docker container with RStudio and geospatial tools
• Mutate all numeric columns in a data frame
• Quickly visualize an sf object
• Generate a hexagonal grid covering an sf object
• Generate a global rectangular grid with sf
• Set environment variables from a file
• Plot a world map in ggplot2
• Use a string as variable name in a formula
• Read data from a Google Sheet
• Write a data frame to a PostgreSQL table
• Convert sf geometries to WKT