sorting data

Beema shafreen beema.shafreen at gmail.com
Mon Oct 29 05:24:09 EDT 2007


hi all,
           I have problem to sort the data.. the file includes data as
follow.
file:
chrX:    123343123    123343182    A_16_P41787782
chrX:    123343417    123343476    A_16_P03762840
chrX:    123343460    123343519    A_16_P41787783
chrX:    12334336    12334395    A_16_P03655927
chrX:    123343756    123343815    A_16_P03762841
chrX:    123343807    123343866    A_16_P41787784
chrX:    123343966    123344024    A_16_P21578670
chrX:    123344059    123344118    A_16_P21578671
chrX:    12334438    12334497    A_16_P21384637
chrX:    123344776    123344828    A_16_P21578672
chrX:    123344811    123344870    A_16_P03762842
chrX:    123345165    123345224    A_16_P41787789
chrX:    123345360    123345419    A_16_P41787790
chrX:    123345380    123345439    A_16_P03762843
chrX:    123345481    123345540    A_16_P41787792
chrX:    123345873    123345928    A_16_P41787793
chrX:    123345891    123345950    A_16_P03762844


how do is sort the file based on the column 1 and 2 with values......
using sort option works for only one column and not for the other how do is
sort both 1 and 2nd column so that the third column does not change.....
my script:#sorting the file
start_lis = []
end_lis = []
fh = open('chromosome_location_346010.bed','r')
for line in fh.readlines():
        data = line.strip().split('\t')
        start = data[1].strip()
        end = data[2].strip()
        probe_id  = data[3].strip()
        start_lis.append(start)
       end_lis.append(end)
start_lis.sort()
end_lis.sort()
for k in start_lis:
     for i in end_lis
               print k , i , probe_id(this doesnot worK)
      result = start#end#probe_id ------->this doesnot work...
        print result

What is the error and how do is sort a file based on the two column  to get
the fourth column also with that.
regards
shafreen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20071029/5f596ccd/attachment.html>


More information about the Python-list mailing list