Welcome to python-forum.io

I've started using this method for some rather large data sets to compare; 1st list 178k rows, 2nd 1.5million. Performance is pretty bad, is there a better way of approaching this? I've started look...

MJUk

Data Science

6,224

Jan-03-2018, 10:07 PM

Thread: Compare 2 Csv data sets, identify record with latest date
Post: RE: Compare 2 Csv data sets, identify record with ...

Got it thanks, your explanation is much clearer than doc ;)

MJUk

Data Science

6,224

Dec-04-2017, 07:22 PM

Thread: Compare 2 Csv data sets, identify record with latest date
Post: RE: Compare 2 Csv data sets, identify record with ...

I got this working, thanks: import csv import datetime csv1 = ('c:\data\opt\csv1.csv') csv2 = ('c:\data\opt\csv2.csv') source = csv.reader(open(csv1,'rb')) lookup = csv.reader(open(csv2,'rb')) for d...

MJUk

Data Science

6,224

Dec-04-2017, 01:04 PM

Thread: Compare 2 Csv data sets, identify record with latest date
Post: RE: Compare 2 Csv data sets, identify record with ...

Cheers, got it, having a moment. Will try again tonight.

MJUk

Data Science

6,224

Dec-03-2017, 12:41 PM

Thread: Compare 2 Csv data sets, identify record with latest date
Post: Compare 2 Csv data sets, identify record with late...

High level I'm trying to compare two sets of data 100k approx and identify matching records in the second file that have a later date. I can import Csv and lookup using sets but can't figure out how...

MJUk

Data Science

6,224

Dec-02-2017, 09:03 PM

Results

User Panel Messages

Announcements