Re: extracting duplicates from CSV file by specific fields

2009-04-28 Thread VP
Thanks guys! Tested, seems working. CSV file: - "a.a","sn-01" "b.b","sn-02" "c.c","sn-03" "d.d","sn-04" "e.e","sn-05" "f.f","sn-06" "g.g","sn-07" "h.h","sn-08" "i.i","sn-09" "a.a","sn-10" "k.k","sn-02" "i.i","sn-09" Source: - #!/usr/bin/env python import csv unqs = [] dups = []

Re: extracting duplicates from CSV file by specific fields

2009-04-28 Thread Rhodri James
On Wed, 29 Apr 2009 01:53:24 +0100, VP wrote: Hi, I have a csv file: 'aaa.111', 'T100', 'pn123', 'sn111' 'aaa.111', 'T200', 'pn123', 'sn222' 'bbb.333', 'T300', 'pn123', 'sn333' 'ccc.444', 'T400', 'pn123', 'sn444' 'ddd', 'T500', 'pn123', 'sn555' 'eee.666', 'T600', 'pn123', 'sn444' 'fff.777', 'T

Re: extracting duplicates from CSV file by specific fields

2009-04-28 Thread MRAB
VP wrote: Hi, I have a csv file: 'aaa.111', 'T100', 'pn123', 'sn111' 'aaa.111', 'T200', 'pn123', 'sn222' 'bbb.333', 'T300', 'pn123', 'sn333' 'ccc.444', 'T400', 'pn123', 'sn444' 'ddd', 'T500', 'pn123', 'sn555' 'eee.666', 'T600', 'pn123', 'sn444' 'fff.777', 'T700', 'pn123', 'sn777' How can I extr

extracting duplicates from CSV file by specific fields

2009-04-28 Thread VP
Hi, I have a csv file: 'aaa.111', 'T100', 'pn123', 'sn111' 'aaa.111', 'T200', 'pn123', 'sn222' 'bbb.333', 'T300', 'pn123', 'sn333' 'ccc.444', 'T400', 'pn123', 'sn444' 'ddd', 'T500', 'pn123', 'sn555' 'eee.666', 'T600', 'pn123', 'sn444' 'fff.777', 'T700', 'pn123', 'sn777' How can I extract duplicat