Subsetting based on an 'ID' number?

General
1

Hi there ! I've got a very very large data set (over 13 million entries). This data set represents tree ring widths (LARG_CERNE) collected for different trees (NO_ARBRE) at each site (ID_PET_MES). ESSENCE refers to the species the tree is. AN_CERNE is the year the tree ring width corresponds to.

Here is my issue: I want to organize or interrogate my data to be able to see at each site (ID_PET_MES) how many numbers of each species I have, so I can compare and select sites with the most trees of certain species. The only way I have managed this so far is to use the filter function to filter specific sites or specific species to create smaller data sets and then analyze them but I don't want to have to do this site by site as I have over 100 000 sites and it will take me too long.

For example in the image below. I want R to be able to tell me in the site with ID "40085030201" (first row), how many BOP trees do I have? How many EPN trees? How many CHR etc... And I want to do this for every site to be able to compare them.

Screenshot 2020-12-03 at 10.20.32
Screenshot 2020-12-03 at 10.20.321604×624 119 KB

Does anyone know how to do this?? Thank you

2

Something along the lines of

the_data %>% group_by(ID_field) %>% summarize(Count = sum(NO_ARBRE)

can't really say much more based on the screenshot

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.