Transfer fish data from `fish_data.csv` in onedrive to `habitat_confirmation.xls`

[Mateo9569]

Just a couple things that need to be done in raw file before the data can be copied and pasted directly into "Step 3"

• Species needs to be changed from acronyms to common name long form. Can import from fishbc::freshwaterfish and cross reference
• Grab reference number from step 1 for each site and paste into column in raw file. The macros in habitat_confirmation.xls don't allow you to copy and paste special into a sheet unless there are ref numbers.

I will add a code section for this in the pit_tags.R script in the project. And maybe just change the file name to fish_data_tidy.R. In the future if we collect fish data digitally we can add additional data wrangling code to this file.

[NewGraphEnvironment]

could read in fish_data.csv from onedrive directly and left_join select columns fromhabitat_confirmation.xls data to the fish data based on site vs copy paste to avoid transcription errors?

fishbc xref can be done at same time with script too perhaps.. Burn csv ready for cut and paste to data/inputs_raw perhaps