fake_data <- data.frame(
site = c("A", "B", "C", "A", "B", "A", "B", "C", "A", "B", "A", "B", "A", "B", "C", "C",
"B", "A", "b", "C", "B", "C", "C", "A", "A", "A", "A", "B", "C", "C", "C"),
species_1 = c(7, 25, 30, 50, 38, 13, 5, 31, 34, 22, 41, 25, 22, 37, 39, 13,
45, 10, 40, 7, 28, 36, 19, 2, 12, 5, 16, 38, 27, 44, 44),
species_2 = c(9, 8, 1, 7, 9, 9, 4, 8, 1, 7, 1, 6, 4, 4, 7, 2,
8, 7, 2, 9, 9, 2, 6, 8, 6, 6, 17, 1, 8, 4, 4),
species_3 = c(190, 160, 70, 430, 310, 99, 530, 420, 371, 357, 198, 171, 463, 124, 254, 484,
435, 409, 122, 305, 410, 162, 473, 200, 401, 273, 421, 419, 293, 487, 487),
species_4 = c(2, 0, 4, 8, 6, 3, 7, 4, 2, NA, 35, 10, 6, 4, 8, 1,
1, 0, NA, 4, 6, 8, 10, 6, 2, 5, 10, 7, NA, NA, NA)
)