thinkerbot/hansen_lab

Utilities used in the Hansen Lab

hansen_lab's Issues

ECM gel analysis

Data consists of 4 gels, effectively with 3 columns (a,b,c) and 17 rows each.

|-|a|b|c|
|1|....
|2|...

Each cell is run independently and the results for each row is collated into a result file, ie there are 4*17 result files (although some were not run/generated so there is in fact several fewer) in Excel format.

for each gel
  for each result file
    for each protein accession
      determine if the protein was found
        if so, extract abundance, (a/b), (a/c), (b/c), etc.
        else register an empty line

dump results to file (result 4 files, x proteins each)

for each protein (ie 17 times)
  for each (a/b), (a/c), etc
    calculate total average
    scan for sections separated by 2 or more empty lines, average each section

across result files, for each protein
  generate graphic
  for each (a/b), (a/c), etc
    if all have the same number of sections
      list for each section
    else
      list average

Result:

| protein x | graphic | a/b | a/c, a/c | b/c | ...