search

hagenaue / bHRbLR_Enrichment_Stress_BehaviorAndHormoneData

Code used for the analysis of behavioral and hormonal data within the publication "Adolescent environmental enrichment induces social resilience and alters neural gene expression in a selectively bred rodent model with anxious phenotype" by O'Connor, Hagenauer, et al.
1 stars 0 forks source link

Dealing with Animal IDs in different spreadsheets #8

Closed hagenaue closed 4 years ago

hagenaue commented 4 years ago

We have two new spreadsheets of data, and of course they again have animal IDs with mismatched format. https://umich.box.com/s/32y862ssm3wm5cu24z9mrfw5rhyebk7q

We would like these animal IDs to be in the same format as our master spreadsheet: https://github.com/hagenaue/Angela_HRLR_StressEnrichData/blob/master/HRLR_EE_Stress_AllBehavData_forR_withNewCORTOxytIL6_SI_SDScoresFixed_FixedFormatIDs_TimeOnTop.csv

... so that we can join them together.

hagenaue commented 4 years ago

Problems to conquer related to this: 1) There are multiple spreadsheets in each file, as well as graphs mixed in, so we need to pull out the data columns and make them into individual .csv file.

hagenaue commented 4 years ago
  1. When matching animal IDs, sometimes there are issues with additional spaces, hyphens, etc, and sometimes those additional spaces are hidden.
hagenaue commented 4 years ago
  1. Some of the animal IDs are identical except for the spacing and hyphens. I think there are only a few cases and they are in different groups, so you have reference the group information to make sure everything is correct, and can't easily just use automated functions to remove spaces and hyphens for all subjects.
hagenaue commented 4 years ago
  1. Finally, try joining the master spreadsheet and these new datasets in R and make sure they work.
liamctf commented 4 years ago

I've uploaded the files to the Box folder. I thought I had already done so earlier in the week, but apparently it didn't go through (sorry about that).