Amanda Devine amdevine

Define custom Excel functions with `LAMBDA()` and `LET()`

LAMBDA functions

https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67

LAMBDA can be used to write custom functions with inputs that you specify. LAMBDA functions can be saved in the Name Manager and then called from any cell in the workbook.

Might be good to define an Excel template with built-in LAMBDA functions?

R: Working with tabular datasets and visualizing data

Links

Lessons

1. Make table

Make tabular data into a table (Insert → Table). Assign a short name to the table (Table Design → Table Name).

Table: taxa

	A	B	C	D	E	F
1	kingdom	phylum	class	order	family	genus
2	Animalia	Mollusca	Gastropoda	Neogastropoda	Fasciolariidae	Fasciolaria

Taxa of Tracheophytes

This gist contains plant taxa considered tracheophytes for resources that do not recognize "Tracheophyta" as a division.

BOLD

Division	Tracheophyte?
~~Bryophyta~~	No
~~Chlorophyta~~	No

record_id	month	day	year	plot_id	species_id	sex	hindfoot_length	weight
31711	1	21	2001	1	PB	F	26.0	25.0
31712	1	21	2001	1	DM	M	37.0	43.0
31713	1	21	2001	1	PB	M	29.0	44.0
31714	1	21	2001	1	DO	M	34.0	53.0
31715	1	21	2001	2	OT	M	20.0	27.0
31716	1	21	2001	2	RM	M	17.0	11.0
31717	1	21	2001	2	NL	M	33.0	121.0
31718	1	21	2001	2	DM	F	34.0	44.0
31719	1	21	2001	2	PB	M	26.0	42.0

Porting Jon Schwabish's World Tile Grid Map to ggplot2.

Tutorial for Maarten Lambrechts's implementation with ggplot2 (i.e. this gist) can be found here: https://www.maartenlambrechts.com/2017/10/22/tutorial-a-worldtilegrid-with-ggplot2.html

	# Adapted from Automate the Boring Stuff with Python
	# https://automatetheboringstuff.com/2e/chapter10/

	import shutil, os
	from pathlib import Path

	dir = Path.cwd() / 'data_directory'

	for f in os.listdir(dir):

	# Use dplyr package
	library(dplyr)

	# Create example data frame
	data <- data.frame(personal_id = c(1, 2, 3, 4, 5, 6),
	name = c('Albert', 'Beth', 'Cindy', 'David', 'Eugene', 'Fred'),
	household_id = c('1H', '1H', '2H', '2H', '3H', '3H'),
	score1 = c(3, NA, 1, NA, 1, NA),
	score2 = c(5, NA, NA, 2, 2, NA),
	score3 = c(NA, 'banana', 'cherry', NA, 'eggplant', NA),