Mercurial > repos > bgruening > column_arrange_by_header
view 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 source
#!/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)