I have this following data:
Year Month Location Ship Class
2024 07 A Yes Humid
2024 03 A Yes Humid
2023 04 B Yes Humid
2022 04 A No Dry
2022 01 A No Dry
I would like to know how often in a given year a location was visited
I did a script but it didn’t give the right answer.
I would like to have the results as follows
Year Frequency Location Ship Class
2024 2 A Yes Humid
2024 1 A No Humid
2023 1 B Yes Humid
2022 2 A No Dry
Miora Felaniaina Andrianandras is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.