Re: Comparing Barcodes Between 2 Files?

From: Rogan Hamby <rhamby_at_nyob>
Date: Fri, 10 Nov 2017 22:00:21 +0000
To: CODE4LIB_at_LISTS.CLIR.ORG
If they’re strings and you’re a *nix user I’d export them to files, sort
them and use the comm command to generate a list of common values.

On Fri, Nov 10, 2017 at 16:17 Kyle Breneman <tomeconqueror_at_gmail.com> wrote:

> I have 2 Excel files, each with a column of barcodes.  I am supposed to
> determine which, if any, of the barcodes in the first file are also present
> in the second file.  Is writing a short Python program the best way to do
> this, or is there a more efficient way?  (There are about 300 items in the
> first file and about 1,000 items in the second file.)
>
> Regards,
> Kyle
>
-- 


Rogan Hamby

Data and Project Analyst

Equinox Open Library Initiative

phone:  1-877-OPEN-ILS (673-6457)

email:  rogan_at_EquinoxInitiative.org
web:  http://EquinoxInitiative.org
Received on Fri Nov 10 2017 - 17:01:37 EST