Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
MIME-Version: 1.0
In-Reply-To: <50B3E865.9070700@davea.name>
References: <CAKhY55M3iOhhMbn=VuwJ7OMz_JUHVxwGy1h_BDpfBY8jQ5aRkA@mail.gmail.com> <50B3E865.9070700@davea.name>
Date: Mon, 26 Nov 2012 23:27:58 +0100
Subject: Re: Compare list entry from csv files
From: Anatoli Hristov <tolidtm@gmail.com>
To: d@davea.name
Content-Type: text/plain; charset=UTF-8
Cc: python-list@python.org
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.302.1353968881.29569.python-list@python.org>
Lines: 79
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:33951

I understand, but in my case I have for sure the field "Name" in the
second file that contains at least the first or the last name on it...
So probably it should be possible:)
The Name "Billgatesmicrosoft" contains the word "Gates" so logically I
might find a solution for it.

Thanks

On Mon, Nov 26, 2012 at 11:08 PM, Dave Angel <d@davea.name> wrote:
> On 11/26/2012 04:08 PM, Anatoli Hristov wrote:
>> 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()
>
> You're trying to merge information from a second file into a first one,
> where the shared key is only a little bit similar.  Good luck.
>
> For example., in the first file, it might say  Susan; Gatley  and in the
> other file it might say Mom.   Good luck coming up with an algorthm to
> match those.
>
> Now if you are assured that the two will be identical except for spaces,
> then you could reduce both keys to the same format and then match them.
> Or if you want to say they're within a Soundex definition of each
> other.  Or if you want to claim that they'll have the same words in
> them, but not necessarily the same order.
>
> But if these files are really as randomly connected as you say, then the
> best you can probably do is to write two programs.  First is where you
> take the names from each file and produce a 3rd file associating the
> ones that are obvious (according to some algorithm), then build a list
> of exceptions.  Then allow a human being to edit that file.  Then the
> second file uses it to merge the first two files for your final pass.
>
>
> --
>
> DaveA
>