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
MIME-Version: 1.0
Date: Mon, 26 Nov 2012 22:08:08 +0100
Subject: Compare list entry from csv files
From: Anatoli Hristov <tolidtm@gmail.com>
To: python-list@python.org
Content-Type: text/plain; charset=UTF-8
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.298.1353964091.29569.python-list@python.org>
Lines: 43
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:33945

Hello,

I'm trying to complete a namebook CSV file with missing phone numbers
which are in another CSV file.
the namebook file is structured:
First name;Lastname; Address; City; Country; Phone number, where the
phone number is missing.

The phonebook file is structured as:
Name; phone, where the name shows first and last name and sometimes
they are written together like "BillGates" or "Billgatesmicrosoft".

I'm importing the files as lists ex.: phonelist" ["First name", "Last
name","address","City"."Country","phone"],[etc...]
in the loop I can compare the entry for ex. "Bill Gates" in the field
"BillGatesmicrosoft" but I can't index it so I can only take the phone
number from the file with the phones and insert it to field in the
Namebook. Can you please give me an advice?

Thanks


import csv

origf = open('c:/Working/Test_phonebook.csv', 'rt')
phonelist = []

try:
    reader = csv.reader(origf, delimiter=';')
    for row in reader:
        phonelist.append(row)
finally:
    origf.close()

secfile = open('c:/Working/phones.csv', 'rt')
phones = []

try:
    readersec = csv.reader(secfile, delimiter=';')
    for row in readersec:
        phones.append(row)
finally:
    secfile.close()