[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