Cleaning tables with merged cells
Tidying data with problematic line breaks
Posts by Tag
- dplyr 13
- rstats 12
- rspatial 9
- GIS 9
- unheadr 9
- ggplot 7
- tidyr 7
- ggplot2 6
- sf 6
- stringi 5
- dogs 5
- spreadsheets 5
- SIG 5
- regex 4
- purrr 4
- gganimate 4
- Excel 3
- datavis 3
- mastos 3
- ggtree 3
- genomics 3
- gather 3
- melt 3
- tidyeval 3
- excel 3
- pdf 3
- nbastatr 3
- scientific conference 2
- random forests 2
- reshape2 2
- sig 2
- capas raster 2
- minmax 2
- mammals 2
- Fisher 2
- Schweizer 2
- marti 2
- club de galanes 2
- tidytext 2
- phylo 2
- dataviz 2
- reduce 2
- separate 2
- tidyverse 2
- tabulizer 2
- bump chart 2
- clippy 2
- readxl 2
- tidyxl 2
- unbreak 2
- tidy eval 2
- merged cells 2
- gifs 2
- munging 2
- sp 2
- DAPC 2
- retriever 2
- pupper 2
- xlsx 2
- reproducibility 2
- scripts 2
- version 2
- gis 2
- seals 2
- mapping 2
- NBA 2
- airball 2
- rspatiales 2
- QGIS 2
- MaxEnt 2
- cleaning 2
- rayshader 2
- rayrender 2
- urban 2
- hares 1
- pikas 1
- rabbits 1
- MCMCglmm 1
- Probit model 1
- extinction risk 1
- postdoctoral 1
- Museum 1
- Switzerland 1
- review 1
- mammal research 1
- bibliometrics 1
- outcomes 1
- party 1
- grapcongenerator 1
- editing 1
- manuscript formatting 1
- dotwhisker 1
- rgbif 1
- geonames 1
- SCB 1
- geosphere 1
- Mammal review 1
- authorship 1
- comparative method 1
- discovery 1
- olinguito 1
- Peromyscus schmidly 1
- -Presentation 1
- titles 1
- -Twitter 1
- SciComm 1
- dodged barplot 1
- R 1
- merge and center 1
- count how many 1
- everything() 1
- species names 1
- separators 1
- rgdal 1
- Twitter 1
- encoding 1
- O metric 1
- ggmap 1
- co-occurrence 1
- r en tu idioma 1
- graficas 1
- ggalt 1
- ggforce 1
- artyfarty 1
- LINCglobal 1
- en tu idioma 1
- Estrada 1
- Science Advances 1
- conservation 1
- collections 1
- francais 1
- trop mimi 1
- joining 1
- ROpensci 1
- el gerente 1
- elerre 1
- Jeff Hanson 1
- ape 1
- Paradis 1
- Roboto 1
- forcats 1
- rvest 1
- scraping 1
- hrbr 1
- Brent 1
- matrix 1
- model matrix 1
- evaluation 1
- spreadsheet 1
- ridgeline plots 1
- beeswarm 1
- violin 1
- golden retriever 1
- iterate 1
- untangle 1
- dog rescue 1
- datos horrendos 1
- iteraciones 1
- adopción canina 1
- rtweet 1
- bayesian 1
- cats 1
- we rate dogs 1
- each element 1
- walk 1
- phylo objects 1
- geom 1
- scale 1
- slice 1
- labradors 1
- akc 1
- pup 1
- habromys 1
- mzfc 1
- reithro 1
- el loco 1
- pdf table hell 1
- spreadsheet hell 1
- package development 1
- tile plots 1
- luna 1
- espacial 1
- pptx 1
- pdftools 1
- bar chart 1
- errorbar 1
- tesseract 1
- ocr 1
- subheaders 1
- beard 1
- booker 1
- hoops 1
- analytics 1
- Admixture 1
- Structure 1
- akc 2019 1
- Jenny 1
- tidy 1
- data organization 1
- ggparty 1
- partykit 1
- ArcView 1
- bolded 1
- formatting 1
- merging 1
- italic 1
- meaningful formatting 1
- AKC 1
- stars 1
- styler 1
- ggbump 1
- kennel club 1
- bold 1
- PCA 1
- factominer 1
- gghighlight 1
- definitive edition 1
- wololo 1
- mapply 1
- Reduce 1
- bubble 1
- spline 1
- rats 1
- omnivore 1
- paper 1
- rodents 1
- trophic 1
- ArcGIS pirata 1
- ENM 1
- cracked ArcGIS 1
- SDM 1
- wrangling 1
- awk 1
- sed 1
- GFW 1
- pathtracing 1
- shades 1
- 3D 1
- gafas 1
- popgen 1
- adegenet 1
- ggh4x 1
- rattus 1
- packages 1
- versions 1
- sections 1
- code blocks 1
- IDE 1
- RStudio 1
- rap 1
- hip hop 1
- travelling 1
- update 1
- release 1
- ggsvg 1
- waffles 1
- vector images 1
- facets 1
- mash 1
- colnames 1
- messy 1
- merged 1
- annotater 1
- SQL 1
- BigQuery 1
- GitHub 1
- code comments 1
- cast 1
- reshape 1
- caniformia 1
- phylogenetic 1
- cleansing 1
- office 1
- format 1
- dates 1
- janitor 1
- gtcars 1
- fs 1
- walk2 1
- filepath 1
- file names 1
- gt 1
- stickers 1
- logos 1
- pkgs 1
dplyr
Merging rows in R
Verb-like function to identify and merge rows
Unnesting unsplittable strings
Tidyng human-readable data by inserting suitable separators.
More on extracting data from PDFs
Cleaning data from the US Financial Disclosure Reports featured in the A.B. Tran and H. Wickham live data challenge.
Get top values by group (animated)
Animated explanation of dplyr::top_n() and code to create the gif.
Unbreaking values with R
Wrangling grouped data with broken values and NA/empty rows per variable per group.
Apply functions to grouped data and write each element to disk
Split a table by a grouping variable, apply functions to each element, and export to separate files.
Using Tidy Evaluation to untangle header rows
An R function to put interspersed header rows into their own column.
Tidy tables for collections-based research (Part 2)
Wrangling commonly-used data formats. Part 2 - Compound values.
Tidy tables for collections-based research (Part 1)
Wrangling commonly-used data formats. Part 1 - GenBank accession tables.
Matrix Indexing
Recoding binary dummy variables into factors. Includes tidyverse and base R approaches.
Valore máximos y mínimos para datos agrupados
Cómo identificar los valores máximos o mínimos de una variable para datos agrupados utilizando R y dplyr.
Top and bottom values for groups
Using R and dplyr to extract minimum or maximum (or both) variable values within groups.
rstats
High-latitude maps
Plotting seal observations in Antarctica with R and ggplot2.
Mapas de altas latitudes en R
Ilustrando la distribución de dos especies de focas antárticas con R y ggplot2.
SIG con R - Actualización
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
Valore máximos y mínimos para datos agrupados
Cómo identificar los valores máximos o mínimos de una variable para datos agrupados utilizando R y dplyr.
Top and bottom values for groups
Using R and dplyr to extract minimum or maximum (or both) variable values within groups.
Diverging bar plots
Making diverging stacked bar plots in R using ggplot.
Grouping points
Four ways to draw polygons around groups of points using ggplot2.
Agrupando Puntos
Cuatro maneras de agrupar puntos en dos dimensiones con ggplot.
Measuring point overlap
Measuring spatial overlap with point data.
Science Is Global
Emoji flags, international research, and tweet analysis in R.
R para tareas espaciales
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
Labeled barplots in ggplot2
Visualizing grouped values using labeled side-by-side bars in ggplot2.
rspatial
Rendering thematic maps in 3D
Using rayshader to render ggplot2 maps in 3D.
Filter data before reading with awk and R
Command line tools + R to read large Global Fishing Watch data efficiently.
Raster calculations on stars objects
Using R as a GIS - raster calculation (reclass, sum) and plotting.
Extracting raster values into polygon attributes using R
Getting or calculating the values from an underlying raster using stars and sf
Riqueza de especies usando R y sf
Alternativas a los SIG para calcular riqueza de especies con una cuadrícula.
Species richness analysis with R and sf
Quantify and plot spatially-intersecting features.
Crisp spatial figures with R, ggplot2, and sf
Pretty plotting of point and polygon features.
Mapas nítidos con R, ggplot2 y sf
Figuras espaciales con puntos y polígonos.
Getting elevation data for point occurrences in R using rgbif
Using R to fetch elevation for lat/long data through an API.
GIS
Rendering thematic maps in 3D
Using rayshader to render ggplot2 maps in 3D.
Filter data before reading with awk and R
Command line tools + R to read large Global Fishing Watch data efficiently.
Raster calculations on stars objects
Using R as a GIS - raster calculation (reclass, sum) and plotting.
SIG con R - Objetos stars
Análsis espaciales con R - suma, reclasificación y visualización de rasters.
Extracting raster values into polygon attributes using R
Getting or calculating the values from an underlying raster using stars and sf
Riqueza de especies usando R y sf
Alternativas a los SIG para calcular riqueza de especies con una cuadrícula.
Species richness analysis with R and sf
Quantify and plot spatially-intersecting features.
Crisp spatial figures with R, ggplot2, and sf
Pretty plotting of point and polygon features.
Mapping local and cross-boundary conservation research
Mapping spatial patterns in conservation research using R and ICCB 2011 presentation data.
unheadr
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
Cleaning tables with merged cells
Tidying data with problematic line breaks
Fixing broken and irregular column headers
Useful function from unheadr for data cleaning
Bold indicates negative
Flattening spreadsheet cell formatting to usable character strings.
Data Rectangling Resource Roundup
Links to material on Data Rectangling.
From photo to tibble
Digitizing and rectangling a restaurant menu.
Spreadsheet hijinks
The results from crowd-sourcing a suitable term for a common spreadsheet practice.
More on extracting data from PDFs
Cleaning data from the US Financial Disclosure Reports featured in the A.B. Tran and H. Wickham live data challenge.
Animate your data wrangling
Using gganimate to animate the data-munging process.
ggplot
Set the breaks!
Omitting items from legends in ggplot2.
Set the breaks!
Omitting items from legends in ggplot2.
The tRee of dog bReeds (version 2)
Manipulate and visualize data describing dog breeds and how they are related.
Diverging bar plots
Making diverging stacked bar plots in R using ggplot.
Grouping points
Four ways to draw polygons around groups of points using ggplot2.
Agrupando Puntos
Cuatro maneras de agrupar puntos en dos dimensiones con ggplot.
Research patterns in new species of mammals
Summary and visualization of research effort for recently described species of terrestrial mammals. Includes R code and data.
tidyr
Cleaning tables with merged cells
Tidying data with problematic line breaks
Merging rows in R
Verb-like function to identify and merge rows
Unnesting unsplittable strings
Tidyng human-readable data by inserting suitable separators.
Tidyeval meets PDF table hell
Using tidy evaluation to fix values broken up across rows.
Tidy tables for collections-based research (Part 2)
Wrangling commonly-used data formats. Part 2 - Compound values.
Tidy tables for collections-based research (Part 1)
Wrangling commonly-used data formats. Part 1 - GenBank accession tables.
Matrix Indexing
Recoding binary dummy variables into factors. Includes tidyverse and base R approaches.
ggplot2
Filter data before reading with awk and R
Command line tools + R to read large Global Fishing Watch data efficiently.
Dog breed popularity bump chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2020.
Dog breed popularity chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2019.
Dog breeds bump chart
Plotting how popularity rankings for dog breeds change through time.
Visualizando pares de variables independientes
Graficando dos variables independientes sin usar ejes duales.
Labeled barplots in ggplot2
Visualizing grouped values using labeled side-by-side bars in ggplot2.
sf
High-latitude maps
Plotting seal observations in Antarctica with R and ggplot2.
Mapas de altas latitudes en R
Ilustrando la distribución de dos especies de focas antárticas con R y ggplot2.
SIG con R - Actualización
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
Extracting raster values into polygon attributes using R
Getting or calculating the values from an underlying raster using stars and sf
Riqueza de especies usando R y sf
Alternativas a los SIG para calcular riqueza de especies con una cuadrícula.
Species richness analysis with R and sf
Quantify and plot spatially-intersecting features.
stringi
Using Tidy Evaluation to untangle header rows
An R function to put interspersed header rows into their own column.
Good dogs (and their names)
Extracting dog names from tweets by WeRateDogs.
What’s in a name?
Text analysis applied to mammalian common names.
ggpup: place two random dog images next to any ggplot object
Using web scraping, raster objects and gridExtra to add images to your plots.
Science Is Global
Emoji flags, international research, and tweet analysis in R.
dogs
Waffle charts with svg images
Creating waffle charts with ggsvg
The tRee of dog bReeds (version 2)
Manipulate and visualize data describing dog breeds and how they are related.
The tRee of dog bReeds
Working with data describing dog breeds and how they are related.
Good dogs (and their names)
Extracting dog names from tweets by WeRateDogs.
ggpup: place two random dog images next to any ggplot object
Using web scraping, raster objects and gridExtra to add images to your plots.
spreadsheets
New packages - hexsession & forgts
Recent releases
Bold indicates negative
Flattening spreadsheet cell formatting to usable character strings.
Data Rectangling Resource Roundup
Links to material on Data Rectangling.
This is what happens when you encode data as cell formatting in Excel
Extracting and wrangling data encoded as text formatting in multi-sheet Excel files.
Reshaping and tidying data from awkward spreadsheet formats
Wrangle duplicated variable names, weird header rows, and footnotes.
SIG
Mapas tridimensionales en R
Utilizando el paquete rayshader para generar mapas fotorealistas a partir de objectos ggplot.
Riqueza de especies usando R y sf
Alternativas a los SIG para calcular riqueza de especies con una cuadrícula.
Species richness analysis with R and sf
Quantify and plot spatially-intersecting features.
Crisp spatial figures with R, ggplot2, and sf
Pretty plotting of point and polygon features.
Mapas nítidos con R, ggplot2 y sf
Figuras espaciales con puntos y polígonos.
regex
Data Cleaning with R
New Course Available - Clean your data more quickly and efficiently than ever before
Unnesting unsplittable strings
Tidyng human-readable data by inserting suitable separators.
Good dogs (and their names)
Extracting dog names from tweets by WeRateDogs.
What’s in a name?
Text analysis applied to mammalian common names.
purrr
PDF to PPT via RMarkdown
How was this not a thing already?
Apply functions to grouped data and write each element to disk
Split a table by a grouping variable, apply functions to each element, and export to separate files.
Limpiando datos en R
Algunos pasos para reacomodar tablas con columnas repetidas, encabezados que no pertenecen, y notas al pie de página.
Reshaping and tidying data from awkward spreadsheet formats
Wrangle duplicated variable names, weird header rows, and footnotes.
gganimate
Shot distances and court locations for NBA games
Follow up post - Download, plot, and animate per-game shooting data.
Animate shot distances for NBA games
Download, plot, and animate per-game shooting data.
Get top values by group (animated)
Animated explanation of dplyr::top_n() and code to create the gif.
Animate your data wrangling
Using gganimate to animate the data-munging process.
Excel
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
Formatted spreadsheets in R
Import and work with formatted spreadsheet data
pls don’t do this :(
Easy changes to make before sharing tabular data with others.
datavis
Less bar charts with error bars please
ggplot2 alternatives to dynamite plunger plots
More on diverging stacked bar plots
My take on the SkepticalScience global warming figure using ggplot, includes R code and data.
Grouping points
Four ways to draw polygons around groups of points using ggplot2.
mastos
New publication: Arboreal rodent movement ecology
Tracking two species of Neotropical cloud forest rodents in three dimensions.
Novedades en la literatura mastozoológica, abril 2017
Resumen del seminario mensual de actualización en literatura científica del grupo de Mastozoología, MZFC-UNAM.
Novedades en la literatura mastozoológica, marzo 2017
Resumen del seminario mensual de actualización en literatura científica del grupo de Mastozoología, MZFC-UNAM.
ggtree
Plotting phylogenies with collapsed and labeled nodes
Iteration made easy with purrr
The tRee of dog bReeds (version 2)
Manipulate and visualize data describing dog breeds and how they are related.
The tRee of dog bReeds
Working with data describing dog breeds and how they are related.
genomics
Plots for model-based clustering of ancestral populations
Plot models of population structure with ggplot for arbitrary values of K.
The tRee of dog bReeds (version 2)
Manipulate and visualize data describing dog breeds and how they are related.
The tRee of dog bReeds
Working with data describing dog breeds and how they are related.
gather
You ‘tidyr::complete()’ me
Complete sequences from start and end values stored in separate columns
Tidy tables for collections-based research (Part 2)
Wrangling commonly-used data formats. Part 2 - Compound values.
Tidy tables for collections-based research (Part 1)
Wrangling commonly-used data formats. Part 1 - GenBank accession tables.
melt
You ‘tidyr::complete()’ me
Complete sequences from start and end values stored in separate columns
Tidy tables for collections-based research (Part 2)
Wrangling commonly-used data formats. Part 2 - Compound values.
Tidy tables for collections-based research (Part 1)
Wrangling commonly-used data formats. Part 1 - GenBank accession tables.
tidyeval
Merging rows in R
Verb-like function to identify and merge rows
Tidyeval meets PDF table hell
Using tidy evaluation to fix values broken up across rows.
Using Tidy Evaluation to untangle header rows
An R function to put interspersed header rows into their own column.
excel
Bold indicates negative
Flattening spreadsheet cell formatting to usable character strings.
Spreadsheet hijinks
The results from crowd-sourcing a suitable term for a common spreadsheet practice.
This is what happens when you encode data as cell formatting in Excel
Extracting and wrangling data encoded as text formatting in multi-sheet Excel files.
PDF to PPT via RMarkdown
How was this not a thing already?
Unnesting unsplittable strings
Tidyng human-readable data by inserting suitable separators.
More on extracting data from PDFs
Cleaning data from the US Financial Disclosure Reports featured in the A.B. Tran and H. Wickham live data challenge.
nbastatr
Quantifying point overlap for NBA shot chart data
Find the most and least similar shot patterns for basketall players.
Shot distances and court locations for NBA games
Follow up post - Download, plot, and animate per-game shooting data.
Animate shot distances for NBA games
Download, plot, and animate per-game shooting data.
scientific conference
If you present will you publish?
Why study the publication rates of presentations at ecology, evolution, and conservation conferences.
Trends in mammal research in Mexico 1991-2012
Summary of research presented at scientific meetings of the Mexican Mammalogy Society (AMMAC) 1991-2012.
random forests
ggplot2 visualization of conditional inference trees
Plotting conditional inference trees with dichotomous responses in R, a grammar of graphics implementation
Plotting conditional inference trees
Example code for visualizing binary trees with dichotomous responses in R, focused on extinction risk modeling.
reshape2
You ‘tidyr::complete()’ me
Complete sequences from start and end values stored in separate columns
pls don’t do this :(
Easy changes to make before sharing tabular data with others.
sig
SIG con R - Actualización
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
R para tareas espaciales
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
capas raster
SIG con R - Actualización
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
R para tareas espaciales
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
minmax
Valore máximos y mínimos para datos agrupados
Cómo identificar los valores máximos o mínimos de una variable para datos agrupados utilizando R y dplyr.
Top and bottom values for groups
Using R and dplyr to extract minimum or maximum (or both) variable values within groups.
mammals
Who is Who?
Matching taxonomic names; joint post with Manuela González-Suárez.
Top and bottom values for groups
Using R and dplyr to extract minimum or maximum (or both) variable values within groups.
Fisher
Rongeurs
La morphologie permet de prédire le régime alimentaire et mode de locomotion des rongeurs.
Rodent ecomorphology in a phylogenetic context
Summary of our new publication ‘Morphology captures diet and locomotor types in rodents’.
Schweizer
Rongeurs
La morphologie permet de prédire le régime alimentaire et mode de locomotion des rongeurs.
Rodent ecomorphology in a phylogenetic context
Summary of our new publication ‘Morphology captures diet and locomotor types in rodents’.
marti
Novedades en la literatura mastozoológica, abril 2017
Resumen del seminario mensual de actualización en literatura científica del grupo de Mastozoología, MZFC-UNAM.
Novedades en la literatura mastozoológica, marzo 2017
Resumen del seminario mensual de actualización en literatura científica del grupo de Mastozoología, MZFC-UNAM.
club de galanes
Novedades en la literatura mastozoológica, abril 2017
Resumen del seminario mensual de actualización en literatura científica del grupo de Mastozoología, MZFC-UNAM.
Novedades en la literatura mastozoológica, marzo 2017
Resumen del seminario mensual de actualización en literatura científica del grupo de Mastozoología, MZFC-UNAM.
tidytext
PCA with Age of Empires II data
Data cleaning, Principal Component Analysis, and visualization of AoE2 data.
What’s in a name?
Text analysis applied to mammalian common names.
phylo
Plotting phylogenies with collapsed and labeled nodes
Iteration made easy with purrr
The tRee of dog bReeds
Working with data describing dog breeds and how they are related.
dataviz
Less bar charts with error bars please
ggplot2 alternatives to dynamite plunger plots
The tRee of dog bReeds
Working with data describing dog breeds and how they are related.
reduce
Plotting phylogenies with collapsed and labeled nodes
Iteration made easy with purrr
Matrix Indexing
Recoding binary dummy variables into factors. Includes tidyverse and base R approaches.
separate
Tidy tables for collections-based research (Part 2)
Wrangling commonly-used data formats. Part 2 - Compound values.
Tidy tables for collections-based research (Part 1)
Wrangling commonly-used data formats. Part 1 - GenBank accession tables.
tidyverse
Tidyeval meets PDF table hell
Using tidy evaluation to fix values broken up across rows.
Set the breaks!
Omitting items from legends in ggplot2.
tabulizer
More on extracting data from PDFs
Cleaning data from the US Financial Disclosure Reports featured in the A.B. Tran and H. Wickham live data challenge.
Tidyeval meets PDF table hell
Using tidy evaluation to fix values broken up across rows.
bump chart
Dog breed popularity chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2019.
Dog breeds bump chart
Plotting how popularity rankings for dog breeds change through time.
clippy
Spreadsheet hijinks
The results from crowd-sourcing a suitable term for a common spreadsheet practice.
This is what happens when you encode data as cell formatting in Excel
Extracting and wrangling data encoded as text formatting in multi-sheet Excel files.
readxl
Bold indicates negative
Flattening spreadsheet cell formatting to usable character strings.
This is what happens when you encode data as cell formatting in Excel
Extracting and wrangling data encoded as text formatting in multi-sheet Excel files.
tidyxl
Bold indicates negative
Flattening spreadsheet cell formatting to usable character strings.
This is what happens when you encode data as cell formatting in Excel
Extracting and wrangling data encoded as text formatting in multi-sheet Excel files.
unbreak
unheadr
A package to handle awkwardky-structured data with multiple header rows or values broken across multiple rows.
Unbreaking values with R
Wrangling grouped data with broken values and NA/empty rows per variable per group.
tidy eval
unheadr
A package to handle awkwardky-structured data with multiple header rows or values broken across multiple rows.
Unbreaking values with R
Wrangling grouped data with broken values and NA/empty rows per variable per group.
merged cells
unheadr
A package to handle awkwardky-structured data with multiple header rows or values broken across multiple rows.
Unbreaking values with R
Wrangling grouped data with broken values and NA/empty rows per variable per group.
gifs
Get top values by group (animated)
Animated explanation of dplyr::top_n() and code to create the gif.
Animate your data wrangling
Using gganimate to animate the data-munging process.
munging
Data Cleaning with R
New Course Available - Clean your data more quickly and efficiently than ever before
Spreadsheet hijinks
The results from crowd-sourcing a suitable term for a common spreadsheet practice.
sp
Crisp spatial figures with R, ggplot2, and sf
Pretty plotting of point and polygon features.
Mapas nítidos con R, ggplot2 y sf
Figuras espaciales con puntos y polígonos.
DAPC
Plotting model-based clusters of population genetic structure
Plotting Structure, DAPC, or Admixture results with ggplot2.
Plots for model-based clustering of ancestral populations
Plot models of population structure with ggplot for arbitrary values of K.
retriever
Dog breed popularity bump chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2020.
Dog breed popularity chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2019.
pupper
Dog breed popularity bump chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2020.
Dog breed popularity chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2019.
xlsx
Tidying formatted spreadsheets with unheadr
Rectangling formatted spreadsheet data
Formatted spreadsheets in R
Import and work with formatted spreadsheet data
reproducibility
annotater 0.2.0
Annotate R code with details on the packages being loaded
annotater
RStudio addins to annotate R code with details on the packages being loaded
scripts
annotater 0.2.0
Annotate R code with details on the packages being loaded
annotater
RStudio addins to annotate R code with details on the packages being loaded
version
annotater 0.2.0
Annotate R code with details on the packages being loaded
annotater
RStudio addins to annotate R code with details on the packages being loaded
gis
High-latitude maps
Plotting seal observations in Antarctica with R and ggplot2.
Mapas de altas latitudes en R
Ilustrando la distribución de dos especies de focas antárticas con R y ggplot2.
seals
High-latitude maps
Plotting seal observations in Antarctica with R and ggplot2.
Mapas de altas latitudes en R
Ilustrando la distribución de dos especies de focas antárticas con R y ggplot2.
mapping
High-latitude maps
Plotting seal observations in Antarctica with R and ggplot2.
Mapas de altas latitudes en R
Ilustrando la distribución de dos especies de focas antárticas con R y ggplot2.
NBA
NBA player names in hip hop lyrics
Tidy text manipulation and plotting.
Intersecting consecutive pairs of list elements in R
An example with NBA postseason data.
airball
NBA player names in hip hop lyrics
Tidy text manipulation and plotting.
Intersecting consecutive pairs of list elements in R
An example with NBA postseason data.
rspatiales
Mapas tridimensionales en R
Utilizando el paquete rayshader para generar mapas fotorealistas a partir de objectos ggplot.
SIG con R - Objetos stars
Análsis espaciales con R - suma, reclasificación y visualización de rasters.
QGIS
Raster calculations on stars objects
Using R as a GIS - raster calculation (reclass, sum) and plotting.
SIG con R - Objetos stars
Análsis espaciales con R - suma, reclasificación y visualización de rasters.
MaxEnt
Raster calculations on stars objects
Using R as a GIS - raster calculation (reclass, sum) and plotting.
SIG con R - Objetos stars
Análsis espaciales con R - suma, reclasificación y visualización de rasters.
cleaning
Cleaning tables with merged cells
Tidying data with problematic line breaks
Data Cleaning with R
New Course Available - Clean your data more quickly and efficiently than ever before
rayshader
Mapas tridimensionales en R
Utilizando el paquete rayshader para generar mapas fotorealistas a partir de objectos ggplot.
Rendering thematic maps in 3D
Using rayshader to render ggplot2 maps in 3D.
rayrender
Mapas tridimensionales en R
Utilizando el paquete rayshader para generar mapas fotorealistas a partir de objectos ggplot.
Rendering thematic maps in 3D
Using rayshader to render ggplot2 maps in 3D.
urban
NBA player names in hip hop lyrics
Tidy text manipulation and plotting.
Plotting model-based clusters of population genetic structure
Plotting Structure, DAPC, or Admixture results with ggplot2.
hares
Lagomorph research
Inaugural blog post, May 2015. Summary of recent research on Lagomorpha (rabbits, hares, pikas).
pikas
Lagomorph research
Inaugural blog post, May 2015. Summary of recent research on Lagomorpha (rabbits, hares, pikas).
rabbits
Lagomorph research
Inaugural blog post, May 2015. Summary of recent research on Lagomorpha (rabbits, hares, pikas).
MCMCglmm
Ordinal extinction risk models
Modeling IUCN Red List data as an ordered response variable. A reproducible #rstats example for terrestrial carnivores.
Probit model
Ordinal extinction risk models
Modeling IUCN Red List data as an ordered response variable. A reproducible #rstats example for terrestrial carnivores.
extinction risk
Ordinal extinction risk models
Modeling IUCN Red List data as an ordered response variable. A reproducible #rstats example for terrestrial carnivores.
postdoctoral
Postdoc!
Update on my upcoming position and thoughts on the job hunt.
Museum
Postdoc!
Update on my upcoming position and thoughts on the job hunt.
Switzerland
Postdoc!
Update on my upcoming position and thoughts on the job hunt.
review
Trends in mammal research in Mexico 1991-2012
Summary of research presented at scientific meetings of the Mexican Mammalogy Society (AMMAC) 1991-2012.
mammal research
Trends in mammal research in Mexico 1991-2012
Summary of research presented at scientific meetings of the Mexican Mammalogy Society (AMMAC) 1991-2012.
bibliometrics
If you present will you publish?
Why study the publication rates of presentations at ecology, evolution, and conservation conferences.
outcomes
If you present will you publish?
Why study the publication rates of presentations at ecology, evolution, and conservation conferences.
party
Plotting conditional inference trees
Example code for visualizing binary trees with dichotomous responses in R, focused on extinction risk modeling.
grapcongenerator
Plotting conditional inference trees
Example code for visualizing binary trees with dichotomous responses in R, focused on extinction risk modeling.
editing
Section lengths in scientific papers
How long is the average section in a research article? Includes code for downloading and plotting data for five journals.
manuscript formatting
Section lengths in scientific papers
How long is the average section in a research article? Includes code for downloading and plotting data for five journals.
dotwhisker
Section lengths in scientific papers
How long is the average section in a research article? Includes code for downloading and plotting data for five journals.
rgbif
Getting elevation data for point occurrences in R using rgbif
Using R to fetch elevation for lat/long data through an API.
geonames
Getting elevation data for point occurrences in R using rgbif
Using R to fetch elevation for lat/long data through an API.
SCB
Mapping local and cross-boundary conservation research
Mapping spatial patterns in conservation research using R and ICCB 2011 presentation data.
geosphere
Mapping local and cross-boundary conservation research
Mapping spatial patterns in conservation research using R and ICCB 2011 presentation data.
Mammal review
Extinction risk research in mammals
Trends and patterns in mammal extinction risk research, and thoughts on writing a sole-author paper.
comparative method
Extinction risk research in mammals
Trends and patterns in mammal extinction risk research, and thoughts on writing a sole-author paper.
discovery
Research patterns in new species of mammals
Summary and visualization of research effort for recently described species of terrestrial mammals. Includes R code and data.
olinguito
Research patterns in new species of mammals
Summary and visualization of research effort for recently described species of terrestrial mammals. Includes R code and data.
Peromyscus schmidly
Research patterns in new species of mammals
Summary and visualization of research effort for recently described species of terrestrial mammals. Includes R code and data.
-Presentation
Presentations section and Biotweeps
Brief updates, March 2016
titles
Presentations section and Biotweeps
Brief updates, March 2016
Presentations section and Biotweeps
Brief updates, March 2016
SciComm
Presentations section and Biotweeps
Brief updates, March 2016
dodged barplot
Labeled barplots in ggplot2
Visualizing grouped values using labeled side-by-side bars in ggplot2.
R
Labeled barplots in ggplot2
Visualizing grouped values using labeled side-by-side bars in ggplot2.
merge and center
pls don’t do this :(
Easy changes to make before sharing tabular data with others.
count how many
Basic biodiversity data-wrangling operations
Manipulating variables and content in biodiversity datasets using base R and dplyr.
everything()
Basic biodiversity data-wrangling operations
Manipulating variables and content in biodiversity datasets using base R and dplyr.
species names
Basic biodiversity data-wrangling operations
Manipulating variables and content in biodiversity datasets using base R and dplyr.
separators
Basic biodiversity data-wrangling operations
Manipulating variables and content in biodiversity datasets using base R and dplyr.
rgdal
R para tareas espaciales
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
Science Is Global
Emoji flags, international research, and tweet analysis in R.
encoding
Science Is Global
Emoji flags, international research, and tweet analysis in R.
O metric
Measuring point overlap
Measuring spatial overlap with point data.
ggmap
Measuring point overlap
Measuring spatial overlap with point data.
co-occurrence
Measuring point overlap
Measuring spatial overlap with point data.
r en tu idioma
Agrupando Puntos
Cuatro maneras de agrupar puntos en dos dimensiones con ggplot.
graficas
Agrupando Puntos
Cuatro maneras de agrupar puntos en dos dimensiones con ggplot.
ggalt
Grouping points
Four ways to draw polygons around groups of points using ggplot2.
ggforce
Grouping points
Four ways to draw polygons around groups of points using ggplot2.
artyfarty
Diverging bar plots
Making diverging stacked bar plots in R using ggplot.
LINCglobal
Diverging bar plots
Making diverging stacked bar plots in R using ggplot.
en tu idioma
Valore máximos y mínimos para datos agrupados
Cómo identificar los valores máximos o mínimos de una variable para datos agrupados utilizando R y dplyr.
Estrada
The world’s primates are in trouble
Brief updates on our new publication reviewing the primate extinction crisis.
Science Advances
The world’s primates are in trouble
Brief updates on our new publication reviewing the primate extinction crisis.
conservation
The world’s primates are in trouble
Brief updates on our new publication reviewing the primate extinction crisis.
collections
Rodent ecomorphology in a phylogenetic context
Summary of our new publication ‘Morphology captures diet and locomotor types in rodents’.
francais
Rongeurs
La morphologie permet de prédire le régime alimentaire et mode de locomotion des rongeurs.
trop mimi
Rongeurs
La morphologie permet de prédire le régime alimentaire et mode de locomotion des rongeurs.
joining
Who is Who?
Matching taxonomic names; joint post with Manuela González-Suárez.
ROpensci
Who is Who?
Matching taxonomic names; joint post with Manuela González-Suárez.
el gerente
Visualizando pares de variables independientes
Graficando dos variables independientes sin usar ejes duales.
elerre
Visualizando pares de variables independientes
Graficando dos variables independientes sin usar ejes duales.
Jeff Hanson
Making sense of trees
Extracting edge lengths from R phylo objects.
ape
Making sense of trees
Extracting edge lengths from R phylo objects.
Paradis
Making sense of trees
Extracting edge lengths from R phylo objects.
Roboto
More on diverging stacked bar plots
My take on the SkepticalScience global warming figure using ggplot, includes R code and data.
forcats
More on diverging stacked bar plots
My take on the SkepticalScience global warming figure using ggplot, includes R code and data.
rvest
ggpup: place two random dog images next to any ggplot object
Using web scraping, raster objects and gridExtra to add images to your plots.
scraping
ggpup: place two random dog images next to any ggplot object
Using web scraping, raster objects and gridExtra to add images to your plots.
hrbr
What’s in a name?
Text analysis applied to mammalian common names.
Brent
Good dogs (and their names)
Extracting dog names from tweets by WeRateDogs.
matrix
Matrix Indexing
Recoding binary dummy variables into factors. Includes tidyverse and base R approaches.
model matrix
Matrix Indexing
Recoding binary dummy variables into factors. Includes tidyverse and base R approaches.
evaluation
Using Tidy Evaluation to untangle header rows
An R function to put interspersed header rows into their own column.
spreadsheet
Using Tidy Evaluation to untangle header rows
An R function to put interspersed header rows into their own column.
ridgeline plots
Jumping dogs and density plots
Plotting density distributions with the underlying data as a point swarm.
beeswarm
Jumping dogs and density plots
Plotting density distributions with the underlying data as a point swarm.
violin
Jumping dogs and density plots
Plotting density distributions with the underlying data as a point swarm.
golden retriever
Jumping dogs and density plots
Plotting density distributions with the underlying data as a point swarm.
iterate
Reshaping and tidying data from awkward spreadsheet formats
Wrangle duplicated variable names, weird header rows, and footnotes.
untangle
Reshaping and tidying data from awkward spreadsheet formats
Wrangle duplicated variable names, weird header rows, and footnotes.
dog rescue
Reshaping and tidying data from awkward spreadsheet formats
Wrangle duplicated variable names, weird header rows, and footnotes.
datos horrendos
Limpiando datos en R
Algunos pasos para reacomodar tablas con columnas repetidas, encabezados que no pertenecen, y notas al pie de página.
iteraciones
Limpiando datos en R
Algunos pasos para reacomodar tablas con columnas repetidas, encabezados que no pertenecen, y notas al pie de página.
adopción canina
Limpiando datos en R
Algunos pasos para reacomodar tablas con columnas repetidas, encabezados que no pertenecen, y notas al pie de página.
rtweet
Comparing dog and cat ratings
Downloading, comparing, and visualizing Twitter ratings for dogs and cats.
bayesian
Comparing dog and cat ratings
Downloading, comparing, and visualizing Twitter ratings for dogs and cats.
cats
Comparing dog and cat ratings
Downloading, comparing, and visualizing Twitter ratings for dogs and cats.
we rate dogs
Comparing dog and cat ratings
Downloading, comparing, and visualizing Twitter ratings for dogs and cats.
each element
Apply functions to grouped data and write each element to disk
Split a table by a grouping variable, apply functions to each element, and export to separate files.
walk
Apply functions to grouped data and write each element to disk
Split a table by a grouping variable, apply functions to each element, and export to separate files.
phylo objects
The tRee of dog bReeds (version 2)
Manipulate and visualize data describing dog breeds and how they are related.
geom
Set the breaks!
Omitting items from legends in ggplot2.
scale
Set the breaks!
Omitting items from legends in ggplot2.
slice
Tidyeval meets PDF table hell
Using tidy evaluation to fix values broken up across rows.
labradors
Dog breeds bump chart
Plotting how popularity rankings for dog breeds change through time.
akc
Dog breeds bump chart
Plotting how popularity rankings for dog breeds change through time.
pup
Dog breeds bump chart
Plotting how popularity rankings for dog breeds change through time.
habromys
New publication: Arboreal rodent movement ecology
Tracking two species of Neotropical cloud forest rodents in three dimensions.
mzfc
New publication: Arboreal rodent movement ecology
Tracking two species of Neotropical cloud forest rodents in three dimensions.
reithro
New publication: Arboreal rodent movement ecology
Tracking two species of Neotropical cloud forest rodents in three dimensions.
el loco
New publication: Arboreal rodent movement ecology
Tracking two species of Neotropical cloud forest rodents in three dimensions.
pdf table hell
Unbreaking values with R
Wrangling grouped data with broken values and NA/empty rows per variable per group.
spreadsheet hell
unheadr
A package to handle awkwardky-structured data with multiple header rows or values broken across multiple rows.
package development
unheadr
A package to handle awkwardky-structured data with multiple header rows or values broken across multiple rows.
tile plots
Animate your data wrangling
Using gganimate to animate the data-munging process.
luna
Get top values by group (animated)
Animated explanation of dplyr::top_n() and code to create the gif.
espacial
Mapas nítidos con R, ggplot2 y sf
Figuras espaciales con puntos y polígonos.
pptx
PDF to PPT via RMarkdown
How was this not a thing already?
pdftools
PDF to PPT via RMarkdown
How was this not a thing already?
bar chart
Less bar charts with error bars please
ggplot2 alternatives to dynamite plunger plots
errorbar
Less bar charts with error bars please
ggplot2 alternatives to dynamite plunger plots
tesseract
From photo to tibble
Digitizing and rectangling a restaurant menu.
ocr
From photo to tibble
Digitizing and rectangling a restaurant menu.
subheaders
From photo to tibble
Digitizing and rectangling a restaurant menu.
beard
Animate shot distances for NBA games
Download, plot, and animate per-game shooting data.
booker
Shot distances and court locations for NBA games
Follow up post - Download, plot, and animate per-game shooting data.
hoops
Quantifying point overlap for NBA shot chart data
Find the most and least similar shot patterns for basketall players.
analytics
Quantifying point overlap for NBA shot chart data
Find the most and least similar shot patterns for basketall players.
Admixture
Plots for model-based clustering of ancestral populations
Plot models of population structure with ggplot for arbitrary values of K.
Structure
Plots for model-based clustering of ancestral populations
Plot models of population structure with ggplot for arbitrary values of K.
akc 2019
Dog breed popularity chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2019.
Jenny
Data Rectangling Resource Roundup
Links to material on Data Rectangling.
tidy
Data Rectangling Resource Roundup
Links to material on Data Rectangling.
data organization
Data Rectangling Resource Roundup
Links to material on Data Rectangling.
ggparty
ggplot2 visualization of conditional inference trees
Plotting conditional inference trees with dichotomous responses in R, a grammar of graphics implementation
partykit
ggplot2 visualization of conditional inference trees
Plotting conditional inference trees with dichotomous responses in R, a grammar of graphics implementation
ArcView
Extracting raster values into polygon attributes using R
Getting or calculating the values from an underlying raster using stars and sf
bolded
Formatted spreadsheets in R
Import and work with formatted spreadsheet data
formatting
Formatted spreadsheets in R
Import and work with formatted spreadsheet data
merging
Merging rows in R
Verb-like function to identify and merge rows
italic
Tidying formatted spreadsheets with unheadr
Rectangling formatted spreadsheet data
meaningful formatting
Tidying formatted spreadsheets with unheadr
Rectangling formatted spreadsheet data
AKC
Tidying formatted spreadsheets with unheadr
Rectangling formatted spreadsheet data
stars
SIG con R - Actualización
Extraer valores de uno o más raster a partir de coordenadas xy usando R.
styler
annotater
RStudio addins to annotate R code with details on the packages being loaded
ggbump
Dog breed popularity bump chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2020.
kennel club
Dog breed popularity bump chart
Plotting how popularity rankings for dog breeds change through time, (p)updated for 2020.
bold
Bold indicates negative
Flattening spreadsheet cell formatting to usable character strings.
PCA
PCA with Age of Empires II data
Data cleaning, Principal Component Analysis, and visualization of AoE2 data.
factominer
PCA with Age of Empires II data
Data cleaning, Principal Component Analysis, and visualization of AoE2 data.
gghighlight
PCA with Age of Empires II data
Data cleaning, Principal Component Analysis, and visualization of AoE2 data.
definitive edition
PCA with Age of Empires II data
Data cleaning, Principal Component Analysis, and visualization of AoE2 data.
wololo
PCA with Age of Empires II data
Data cleaning, Principal Component Analysis, and visualization of AoE2 data.
mapply
Intersecting consecutive pairs of list elements in R
An example with NBA postseason data.
Reduce
Intersecting consecutive pairs of list elements in R
An example with NBA postseason data.
bubble
Intersecting consecutive pairs of list elements in R
An example with NBA postseason data.
spline
Intersecting consecutive pairs of list elements in R
An example with NBA postseason data.
rats
Classifying rodent diets
New publication
omnivore
Classifying rodent diets
New publication
paper
Classifying rodent diets
New publication
rodents
Classifying rodent diets
New publication
trophic
Classifying rodent diets
New publication
ArcGIS pirata
SIG con R - Objetos stars
Análsis espaciales con R - suma, reclasificación y visualización de rasters.
ENM
SIG con R - Objetos stars
Análsis espaciales con R - suma, reclasificación y visualización de rasters.
cracked ArcGIS
Raster calculations on stars objects
Using R as a GIS - raster calculation (reclass, sum) and plotting.
SDM
Raster calculations on stars objects
Using R as a GIS - raster calculation (reclass, sum) and plotting.
wrangling
Data Cleaning with R
New Course Available - Clean your data more quickly and efficiently than ever before
awk
Filter data before reading with awk and R
Command line tools + R to read large Global Fishing Watch data efficiently.
sed
Filter data before reading with awk and R
Command line tools + R to read large Global Fishing Watch data efficiently.
GFW
Filter data before reading with awk and R
Command line tools + R to read large Global Fishing Watch data efficiently.
pathtracing
Rendering thematic maps in 3D
Using rayshader to render ggplot2 maps in 3D.
shades
Rendering thematic maps in 3D
Using rayshader to render ggplot2 maps in 3D.
3D
Mapas tridimensionales en R
Utilizando el paquete rayshader para generar mapas fotorealistas a partir de objectos ggplot.
gafas
Mapas tridimensionales en R
Utilizando el paquete rayshader para generar mapas fotorealistas a partir de objectos ggplot.
popgen
Plotting model-based clusters of population genetic structure
Plotting Structure, DAPC, or Admixture results with ggplot2.
adegenet
Plotting model-based clusters of population genetic structure
Plotting Structure, DAPC, or Admixture results with ggplot2.
ggh4x
Plotting model-based clusters of population genetic structure
Plotting Structure, DAPC, or Admixture results with ggplot2.
rattus
Plotting model-based clusters of population genetic structure
Plotting Structure, DAPC, or Admixture results with ggplot2.
packages
Sharing nice code with addins and IDE tools
Five tools to make R code cleaner and more reproducible.
versions
Sharing nice code with addins and IDE tools
Five tools to make R code cleaner and more reproducible.
sections
Sharing nice code with addins and IDE tools
Five tools to make R code cleaner and more reproducible.
code blocks
Sharing nice code with addins and IDE tools
Five tools to make R code cleaner and more reproducible.
IDE
Sharing nice code with addins and IDE tools
Five tools to make R code cleaner and more reproducible.
RStudio
Sharing nice code with addins and IDE tools
Five tools to make R code cleaner and more reproducible.
rap
NBA player names in hip hop lyrics
Tidy text manipulation and plotting.
hip hop
NBA player names in hip hop lyrics
Tidy text manipulation and plotting.
travelling
NBA player names in hip hop lyrics
Tidy text manipulation and plotting.
update
annotater 0.2.0
Annotate R code with details on the packages being loaded
release
annotater 0.2.0
Annotate R code with details on the packages being loaded
ggsvg
Waffle charts with svg images
Creating waffle charts with ggsvg
waffles
Waffle charts with svg images
Creating waffle charts with ggsvg
vector images
Waffle charts with svg images
Creating waffle charts with ggsvg
facets
Waffle charts with svg images
Creating waffle charts with ggsvg
mash
Fixing broken and irregular column headers
Useful function from unheadr for data cleaning
colnames
Fixing broken and irregular column headers
Useful function from unheadr for data cleaning
messy
Fixing broken and irregular column headers
Useful function from unheadr for data cleaning
merged
Fixing broken and irregular column headers
Useful function from unheadr for data cleaning
annotater
What are people commenting about their loaded packages?
Exploring code comments about R package calls on GitHub
SQL
What are people commenting about their loaded packages?
Exploring code comments about R package calls on GitHub
BigQuery
What are people commenting about their loaded packages?
Exploring code comments about R package calls on GitHub
GitHub
What are people commenting about their loaded packages?
Exploring code comments about R package calls on GitHub
code comments
What are people commenting about their loaded packages?
Exploring code comments about R package calls on GitHub
cast
You ‘tidyr::complete()’ me
Complete sequences from start and end values stored in separate columns
reshape
You ‘tidyr::complete()’ me
Complete sequences from start and end values stored in separate columns
caniformia
Plotting phylogenies with collapsed and labeled nodes
Iteration made easy with purrr
phylogenetic
Plotting phylogenies with collapsed and labeled nodes
Iteration made easy with purrr
cleansing
Cleaning tables with merged cells
Tidying data with problematic line breaks
office
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
format
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
dates
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
janitor
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
gtcars
Filenames to variables
Putting information recorded in filenames into the data rectangle
fs
Filenames to variables
Putting information recorded in filenames into the data rectangle
walk2
Filenames to variables
Putting information recorded in filenames into the data rectangle
filepath
Filenames to variables
Putting information recorded in filenames into the data rectangle
file names
Filenames to variables
Putting information recorded in filenames into the data rectangle
gt
New packages - hexsession & forgts
Recent releases
stickers
New packages - hexsession & forgts
Recent releases
logos
New packages - hexsession & forgts
Recent releases
pkgs
New packages - hexsession & forgts
Recent releases