Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!nuzba.szn.dk!pnx.dk!amsnews11.chello.com!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Date: Wed, 01 Feb 2012 01:06:15 +0000
From: MRAB <python@mrabarnett.plus.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
To: python-list@python.org
Subject: Re: the script can not go through all the list, anyone could help, would be highly appreciated, thanks a lot !
References: <244c26a3.9ac.13536369f41.Coremail.crazy_pipi_lu@163.com>
In-Reply-To: <244c26a3.9ac.13536369f41.Coremail.crazy_pipi_lu@163.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: list
Reply-To: python-list@python.org
Newsgroups: comp.lang.python
Message-ID: <mailman.5274.1328058336.27778.python-list@python.org>
Lines: 68
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:19672

On 01/02/2012 00:00, Para wrote:
> the script can not go through all the list, anyone could help, would be
> highly appreciated, thanks a lot !
>
> output:
> initial 7 lines:
> [9379, 'G', '0.1830']
> [9378, 'G', '0.1752']
> [9377, 'G', '0.1929']
> [9375, 'G', '0.1950']
> [9370, 'G', '0.1872']
> [937, 'G', '0.1931']
> [93, 'G', '0.1974']
> processing:
> code_K = 93 rate_K = -1 len_K = 1 len_G = 7
> code_K = 93 rate_K = 0.1830 code_G = 9379 rate_G = 0.1830
> code_K = 93 rate_K = 0.1929 code_G = 9377 rate_G = 0.1929
> code_K = 93 rate_K = 0.1929 code_G = 9370 rate_G = 0.1872
> code_K = 93 rate_K = 0.1974 code_G = 93 rate_G = 0.1974
> final 3 lines:
> [9378, 'G', '0.1752']
> [9375, 'G', '0.1950']
> [937, 'G', '0.1931']
>
>
> code:
> ...... # read data from .csv
> print "initial", len(list_G), "lines:"
> for row_G in list_G:
>     print row_G
>
> print "processing:"
> for row_K in list_K:
>     code_K = str(row_K[0])
>     rate_K = -1
>     len_K = len(list_K)
>     len_G = len(list_G)
>     print "code_K =", code_K, "rate_K =", rate_K, "len_K =", len_K, "len_G =", len_G
>     for row_G in list_G:
>         code_G = str(row_G[0])
>         rate_G = str(row_G[2])
>         if re.match(code_K, code_G):
>             if rate_K < rate_G:
>                 rate_K = rate_G
>             print "code_K =", code_K, "rate_K =", rate_K, "code_G =", code_G,
>             "rate_G =", rate_G
>             list_G.remove(row_G)
>
> print "final", len(list_G), "lines:"
> for row_G in list_G:
> print row_G

rate_K is initially a number (rate_K = -1), but rate_G is a string. If
you want to compare numeric values, make sure that they are both
numbers. (In Python 3 it will complain if you say x < y when one of
them is a string and the other is a number; in Python 2 it will return
a consistent but arbitrary result.)

The re.match(code_K, code_G) checks whether code_G start with code_K.
It is better to use code_G.startswith(code_K) instead.

Also, you have:

     for row_G in list_G:
         ...
         list_G.remove(row_G)

Don't add or remove items in a list over which you are iterating.