comparison pandas_pivot_table.py @ 2:6f05390deffa draft

"planemo upload for repository https://github.com/jj-umn/galaxytools/tree/master/pandas_pivot_table/ commit 1ca7433aaa606c636f796c75b6cfd8a080e2d5bc-dirty"
author jjohnson
date Wed, 16 Dec 2020 17:44:58 +0000
parents c02f59711eb6
children 4b65133e0722
comparison
equal deleted inserted replaced
1:c02f59711eb6 2:6f05390deffa
55 ) 55 )
56 p.add_argument( 56 p.add_argument(
57 '-N', '--fill_value', 57 '-N', '--fill_value',
58 default=None, 58 default=None,
59 help='fill value for missing values' 59 help='fill value for missing values'
60 )
61 p.add_argument(
62 '-f', '--float_format',
63 default='%0.6f',
64 help=''
60 ) 65 )
61 args = p.parse_args() 66 args = p.parse_args()
62 67
63 def getValueType(val): 68 def getValueType(val):
64 if val or 0. == val: 69 if val or 0. == val:
126 pdf = df.pivot_table(index=index, columns=columns, 131 pdf = df.pivot_table(index=index, columns=columns,
127 values=values, aggfunc=aggfunc, 132 values=values, aggfunc=aggfunc,
128 fill_value=fill_value) 133 fill_value=fill_value)
129 pdf_cols = ['_'.join(reversed(p)) if isinstance(p, tuple) else p 134 pdf_cols = ['_'.join(reversed(p)) if isinstance(p, tuple) else p
130 for p in pdf.columns.tolist()] 135 for p in pdf.columns.tolist()]
131 pdf.to_csv(args.output, sep='\t', float_format='%0.6f', header=pdf_cols) 136 pdf.to_csv(args.output,
137 sep='\t',
138 float_format=args.float_format,
139 header=pdf_cols)
132 140
133 141
134 if __name__ == "__main__": 142 if __name__ == "__main__":
135 __main__() 143 __main__()