Mercurial > repos > bgruening > column_arrange_by_header
diff column_arrange.py @ 0:b84c81b7d762 draft
Uploaded
author | bgruening |
---|---|
date | Mon, 02 Mar 2015 09:59:32 -0500 |
parents | |
children | b97f0d9a31ff |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/column_arrange.py Mon Mar 02 09:59:32 2015 -0500 @@ -0,0 +1,20 @@ +#!/usr/bin/env python +import pandas as pd +import argparse + + +parser = argparse.ArgumentParser() +parser.add_argument('-i', '--input', help='Tabular Input File Name') +parser.add_argument('-o','--output', help='Tabular Output File') +parser.add_argument('-c', '--columns',nargs='+', help='Column Headers to Sort By') +args=parser.parse_args() + +cols=args.columns +table=pd.read_csv(args.input,sep='\t') +blist = list(table.columns) +for token in cols: + blist.remove(token) +sorted_table = table[args.columns + blist] +# write without index, seperated by tabs +sorted_table.to_csv(args.output,sep='\t',index=False) +