Create Vector from Matrix Spreadsheet

Author: Greta Peterson, Golden Helix, Inc.

This script transforms a spreadsheet into a tall-skinny formatted vector. The user will choose which column type to transform and it will result in a child spreadsheet node. If the user selects genotypic columns, the allele delimiter can optionally be removed or replaced.


Create Vector from Matrix Spreadsheet.py

Download Documentation Documentation

Recommended Directory Location

Save the script to the following directory:
*..\Application Data\Golden Helix SVS\UserScripts\Spreadsheet\File

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 Spreadsheet File menu.


Need a Custom Script?

Scripts

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.

Python Learning Resources