Re: [Tutor] Create a pivot table

2016-05-20 Thread Michael Selik
On Fri, May 20, 2016 at 8:42 AM Peter Otten <__pete...@web.de> wrote: > jarod_v6--- via Tutor wrote: > > I have tried the pandas way but unfortunately there is many duplicates . > > Please show your code in a small self-contained example, > the output it produces, and what exact output you want in

Re: [Tutor] Create a pivot table

2016-05-20 Thread Peter Otten
jarod_v6--- via Tutor wrote: Please address your posts to the whole list, not me specifically. I might read them all the same. Thank you. > Thanks s much for the help. I want to obtain table like this: > > >>csv.writer(sys.stdout, delimiter="\t").writerows(table) >>A100D33 D

Re: [Tutor] Create a pivot table

2016-05-19 Thread Peter Otten
jarod_v6--- via Tutor wrote: > 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', 'post