linaria | Zero-runtime CSS in JS library | Style Language library

I have compiled two tables with plant names from different sources (A and B), which I want to merge into a third table (C). Table A and B both use the species name as a unique value, and contain Dutch names as well. Like this:

I added linaria to my webpack config in a create-react-app project, so the eventual rule is like so:

I have one large dataset of which i made a subset per site (dataset contains multiple sites). I want to make a table per site in R markdown, but with the first three rows as header data. This because i want to use the add_header_above function from the KableExtra package. Now, when i call this function in my Markdown document, the file won't knit and i'm guessing its because the way the table is ordered (with header data now as variables in the table).

Here is the code i use put the subset in the desired format. I know its not tidy, but this is the format I need the table to be in. Below is a dput of this transformed subset.

I have a dataset with oppurtunistic species-observations per square kilometer per year (ranging from 1900 to 2019).

There are 139 different sites (square kilomters) in my dataset. I want to make a dataset where for each species for every year for every site, its presence or absence is stated with 1 or 0.

I think this is the appropriate format for including the length of the species-list per year per site in a GLM, to try and account for repeated visits to sites within years (See Szabo et al. 2010 sci-hub.tw/10.1890/09-0877.1 for application of this method).

Data now looks like: