amdevine

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

amdevine

R: Working with tabular datasets and visualizing data

Links

Lessons

• https://datacarpentry.org/R-ecology-lesson/02-starting-with-data.html
• https://datacarpentry.org/R-ecology-lesson/03-dplyr.html
• https://datacarpentry.org/R-ecology-lesson/04-visualization-ggplot2.html

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?

amdevine

# 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):