Spreadsheet changes - Githubissues

wodanaz / Assembling_viruses

0 stars 0 forks source link

Spreadsheet changes #55

Closed johnbradley closed 2 years ago

johnbradley commented 3 years ago

Add 3 new tabs to the Spreadsheet.

Read Depths
- Pull in data from spike_depths.final.tab - rotating data
Pangolin Lineage
- Pull in data from the pangolin csv file
Metadata
- Pull in data from supermetadata.tab
- Add week_# column based on date column
- Add <year>_<month> column based on date column

Week 1 starts on Jan 1 2021, that means July 1, 2021 is week 26 and our current week is week 29 and tomorrow will be week 30. All this means, every new week starts on a Friday.

johnbradley commented 3 years ago

Looking back over the screenshot the "Month" column is formatted like "june_2021" so <month_name>_<year> instead of as I originally described above.

wodanaz commented 2 years ago

Cool, thanks. I also wanted to let you know that for the hospital samples, Chris decided to change the origin of week 1 to January 4th, 2021 instead of Jan 1st. That means weeks start on Monday rather than Friday.

Best,