Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
From: "Prasad, Ramit" <ramit.prasad@jpmorgan.com>
To: Anatoli Hristov <tolidtm@gmail.com>, Neil Cerutti <neilc@norwich.edu>
Subject: RE: Compare list entry from csv files
Thread-Topic: Compare list entry from csv files
Thread-Index: AQHNzN+kXq9f0aqd0kiHIQxc9YkzCZgA8O8AgACCkQA=
Date: Thu, 29 Nov 2012 23:13:25 +0000
References: <CAKhY55M3iOhhMbn=VuwJ7OMz_JUHVxwGy1h_BDpfBY8jQ5aRkA@mail.gmail.com> <50B3E865.9070700@davea.name> <CAKhY55OUNvGFhCjZLS7HNoDydKqHxZrnaN+bWySCsmKSk1vqsw@mail.gmail.com> <50B43246.2010902@davea.name> <mailman.313.1354026304.29569.python-list@python.org> <ahk36lFeqmlU3@mid.individual.net> <mailman.320.1354042676.29569.python-list@python.org> <ahkmslFk897U1@mid.individual.net> <CAKhY55OdS7sHDpAg3kdnpqWH5yoORqzE0bTHJVgMWZSHqqZ4kQ@mail.gmail.com>
In-Reply-To: <CAKhY55OdS7sHDpAg3kdnpqWH5yoORqzE0bTHJVgMWZSHqqZ4kQ@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Cc: "python-list@python.org" <python-list@python.org>
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.374.1354232564.29569.python-list@python.org>
Lines: 45
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:34082

Anatoli Hristov wrote:=0D=0A> Hello,=0D=0A> =0D=0A> Tried to document a lit=
tle bit the script, but I'm not that good in that too :)=0D=0A> =0D=0A> The=
 only problem I have is that I cant compare other field than the=0D=0A> fir=
st one in=0D=0A> for ex_phone in phones:=0D=0A>         telstr =3D ex_phone=
[0]=2Elower()=0D=0A> When I use telstr =3D ex_phone[0]=2Elower() it says ou=
t of range and the=0D=0A> strange think is that the range is 6 I can't figu=
re that out=2E So when=0D=0A> I edit the csv I modify the look of the file =
and then I start the=0D=0A> script and it works, but I wanted to use more t=
han one condition and I=0D=0A> can't :(=0D=0A> =0D=0A> =0D=0A=0D=0ACan you =
print ex_phone first=2E You are opening the files in text mode=0D=0Aso I wo=
nder if the line endings are causing you to read and extra=0D=0A"line" in b=
etween=2E Can you try reading the csv as "rb" instead of =0D=0A"rt"?=0D=0A=
=0D=0A> =0D=0A> =0D=0A> import csv=0D=0A> =0D=0A> # Open the file with the =
names and addresses=0D=0A> origf =3D open('c:/Working/vpharma=2Ecsv', 'rt')=
=0D=0A> # Open the  file with the phone numbers=0D=0A> secfile =3D open('c:=
/Working/navori=2Ecsv', 'rt')=0D=0A> =0D=0A> # Creates the empty list with =
the names=0D=0A> namelist =3D []=0D=0A> # Creates the empty list with the p=
hone numbers=0D=0A> PHONELIST =3D []=0D=0A> =0D=0A> =0D=0A> # Reads the fil=
e with the names=0D=0A> # Format "Name","Phone"=0D=0A> names =3D csv=2Eread=
er(origf, delimiter=3D';')=0D=0A> =0D=0A> # Reads the file with the phone n=
umbers=0D=0A> # Format "First name","Lastname","Address","City","Country","=
Phone"=0D=0A> phones =3D csv=2Ereader(secfile, delimiter=3D';')=0D=0A> =0D=
=0A> # Creates a list with phone numbers=0D=0A> #for tel in phones:=0D=0A> =
#    PHONELIST=2Eappend(tel)=0D=0A> =0D=0A> =0D=0A> def finder(Compare_Name=
,rows):=0D=0A>     '''=0D=0A>     Compare the names from the namelist with =
the names from the phonelist=2E=0D=0A>     If the name match - then the pho=
ne number is added to the specified field=0D=0A>     '''=0D=0A>     for ex_=
phone in phones:=0D=0A>         telstr =3D ex_phone[0]=2Elower()=0D=0A>    =
     print telstr=0D=0A>         if telstr=2Efind(Compare_Name) >=3D 0:=0D=
=0A>             print "\nName found: %s" % Compare_Name=0D=0A>            =
 namelist[rows][-1] =3D ex_phone[-1]=2Elower()=0D=0A>         else:=0D=0A> =
            print "Not found %s" % Compare_Name=0D=0A>             pass=0D=
=0A>     return=0D=0A> =0D=0A> def name_find():=0D=0A>     rows =3D 0=0D=0A=
>     for row in names:=0D=0A>         namelist=2Eappend(row)=0D=0A>       =
  Compare_Name =3D row[1]=2Elower()=0D=0A>         finder(Compare_Name,rows=
)=0D=0A>         rows =3D rows+1=0D=0A> =0D=0A> if __name__ =3D=3D '__main_=
_':=0D=0A>     name_find()=0D=0A> =0D=0A> # Writes the list to a file=0D=0A=
> wfile  =3D open('c:/Working/ttest=2Ecsv', "wb")=0D=0A> writer =3D csv=2Ew=
riter(wfile, delimiter=3D';')=0D=0A> for insert in namelist:=0D=0A>     wri=
ter=2Ewriterow(insert)=0D=0A> wfile=2Eclose()=0D=0A=0D=0A=0D=0A~Ramit=0D=0A=
=0D=0A=0D=0AThis email is confidential and subject to important disclaimers=
 and=0D=0Aconditions including on offers for the purchase or sale of=0D=0As=
ecurities, accuracy and completeness of information, viruses,=0D=0Aconfiden=
tiality, legal privilege, and legal entity disclaimers,=0D=0Aavailable at h=
ttp://www=2Ejpmorgan=2Ecom/pages/disclosures/email=2E