Read in an additional sheet of plate data which identifies what samples were run on each column of each plate.
The easiest way to do this would be a three-step process.
Read all the .xlsx files, and return a spreadsheet which contains the .xlsx filename in the first column, allowing the user to fill in the sample name of each column.
perform normalisation while changing the column name
(optional) collect all into one big data.frame
An alternative way would be forcing naming standards, but would imaginably be difficult.
Needs consideration of taking in plate metadata in both long and wide formatting.
Read in an additional sheet of plate data which identifies what samples were run on each column of each plate. The easiest way to do this would be a three-step process.
An alternative way would be forcing naming standards, but would imaginably be difficult.
Needs consideration of taking in plate metadata in both long and wide formatting.