Mercurial > repos > jjohnson > pandas_pivot_table
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__() |