Interactive Data Analysis of Biological Samples Utilizing the 96-Well Plate With R

ETM
26Feb17

A Common Data Production Method

The 96-Well Plate is common for data generation within the laboratory setting, and is useful for:

  • ELISA
  • ELISPOT
  • Cell propogation

Issue: Data is frequently manually analyzed, or analyzed with highly abstracted spreadsheet software.

96-Well Plate Example Data

print(plates[[1]])
      1     2     3     4     5     6     7     8     9    10    11    12
A 0.040 0.037 0.045 0.038 0.041 0.038 0.053 0.042 0.049 0.042 0.046 0.045
B 0.033 0.043 0.052 0.040 0.041 0.041 0.050 0.042 0.044 0.045 0.047 0.046
C 0.035 0.040 0.038 0.036 0.037 0.038 0.045 0.037 0.039 0.038 0.044 0.046
D 0.040 0.037 0.039 0.037 0.037 0.045 0.044 0.038 0.038 0.110 0.043 0.049
E 0.034 0.040 0.036 0.036 0.035 0.039 0.042 0.038 0.038 0.042 0.047 0.050
F 0.037 0.037 0.037 0.038 0.038 0.037 0.044 0.043 0.040 0.044 0.046 0.047
G 0.038 0.096 0.045 0.039 0.039 0.038 0.045 0.039 0.065 0.040 0.048 0.046
H 0.052 0.085 0.046 0.075 0.058 0.099 0.068 0.050 0.051 0.049 0.052 0.040

These Data are Amenable to Automated Statistical Subsetting

print(all.dat[(all.dat$response > mean(all.dat$response)+sd(all.dat$response)),])
    plate row column response
235     3   D      7    0.282
236     3   D      8    0.142
264     3   F     12    2.270
657     7   G      9    0.166

Conclusion

  • Manual analysis is time consuming and can result in human error
  • Scripted analyses can be run in real time
  • User interfaces produced with ShinyApps can allow for anyone to conduct the analyses