Build Sample Collated Spreadsheet
Author: Autumn Laughbaum, GHI
This tool transposes and collates several spreadsheets together. The collated spreadsheet contains a row for each intersecting column in the original spreadsheets and several columns for each original row over all spreadsheets.
Build Sample Collated Spreadsheet.py
Recommended Directory Location
Save the script to the following directory:
*..\Application Data\Golden Helix SVS\UserScripts\SVS\Tools
Note: The Application Data folder is a hidden folder on many operating systems and its location varies between operating systems. The easiest way to locate this directory on your computer is to open SVS and go to Tools >Open Folder > UserScripts Folder. If saved to the proper folder, this script will be accessible from the SVS Tools menu.
Need a Custom Script?
Need a script and don't feel you have the bioinformatics expertise to write it yourself? Click the link below to request a custom script and we'll see what we can do to help.
Request Custom Script »
What is Python?
Python is a clear and powerful object-oriented programming language, comparable to Perl, Ruby, Scheme, or Java. Integrating Python into SVS provides full programmatic access to many of the software's features enabling the augmentation of existing tools, creating entirely new ones, automation of work flows, integration with other programs and more.