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! _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
