[Tutor] Create a pivot table
jarod_v6 at libero.it
jarod_v6 at libero.it
Thu May 19 12:37:50 EDT 2016
Dear All!
This is my data from a file. I want to obtain a count table how many times c11 are present for each project and Samples and Program.
['Program', 'Sample', 'Featurename', 'Project'],
['A', 'A100', 'c11', 'post50'],
['A', 'A100', 'c12', 'post50'],
['A', 'A100', 'c14', 'post50'],
['A', 'A100', 'c67', 'post50'],
['A', 'A100', 'c76', 'post50'],
['B', 'A100', 'c11', 'post50'],
['B', 'A100', 'c99', 'post50'],
['B', 'D33', 'c33', 'post50'],
['B', 'D33', 'c31', 'post50'],
['C', 'D34', 'c32', 'post60'],
['C', 'D35', 'c33', 'post60'],
['C', 'D36', 'c11', 'post60'],
['C', 'D37', 'c45', 'post60'],
['C', 'D38', 'c36', 'post60'],
['C', 'D39', 'c37', 'post60']
I want to obtain pivot table with samples on columns and program as rown and the values I want fusionwhat it is the best way to do this?thanks in advance!
More information about the Tutor
mailing list