- Make sure all your data files are the only thing in the folder (e.g., no metadata)
- Run excel-to-csv.py: python excel-to-csv.py *xlsx to convert all the excel files to csv (See Step 4 also)
- Check to make sure each file has a corresponding csv file
- Open each csv file and remove all the header files (Alternately, you can do this before step 2 as excel files). Note, I think biomark creates these headers differently for each run, so I just remove them manually
- Combine these into one data file by running: python combine-biomark-csv.py *csv (This is why you cannot have any other csvs besides what you want combined in this location)
- Metadata: Each row should be unique in the metadata, an example is shown in the metadata folder. Your sample name header should be "Name". You should have as many rows in your metadata (besides the header) as unique Name in your data table.
- Standards: Concentrations of standards should be in the biomark output, or at least that is how this program works, it assumes your rConc is accurate in your data table
*Notes any typos in the standards will break this program! So you want to make sure all names are consistent throughout.
A summary of how the program works is that it merges the metadata of samples to the biomark data observed on them. It also subsets the standards (by gene and plate) and produces the standard curves for them.