Python Forum
Match CSV files for difference
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Match CSV files for difference
#3
Ok, so maybe the reason is elsewhere. I'm using a code looking like this:

import csv, os
os.chdir(r"C:\Users\me\Desktop\compare files")
file1_list = []
file1 = open(r"file 1.csv")
file1_reader_obj = csv.reader(file1)
file1_data = list(file1_reader_obj)
for row in file1_data:
    x = file1_data.index(row)
    file1_list.append(file1_data[x][1])
And I just figured out I'm a moron since I already passed the file into list. So, I can use something like this to compare both files:
for row in file1_list:
    x = file1_list.index(row)
    if file1_list[x][1] in file2_list:
        continue
    else:
        print (RPT0706_list[x][1])
Now the issue is that both files are structured like list of lists:
Output:
[['1', 'a', 'a', 'a'], ['2', 'b', 'b', 'b'], ['3', 'c', 'c', 'c'], ['4', 'd', 'd', 'd'], ['5', 'e', 'e', 'e'], ['6', 'f', 'f', 'f']]
And I just have to check if the first item in the inner list of file1 (e.g 1, 2, 3, etc.) is listed as first item somewhere within inner lists in file2.

Let me know if I'm not making any sense. I'm still learning an art of expressing your thoughts when it comes to programming issues :)
Reply


Messages In This Thread
Match CSV files for difference - by Cuz - Dec-17-2018, 06:19 PM
RE: Match CSV files for difference - by Cuz - Dec-18-2018, 01:12 PM
RE: Match CSV files for difference - by ichabod801 - Dec-18-2018, 01:25 PM
RE: Match CSV files for difference - by Cuz - Dec-18-2018, 02:16 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Move Files based on partial Match mohamedsalih12 2 713 Sep-20-2023, 07:38 PM
Last Post: snippsat
  Open and read multiple text files and match words kozaizsvemira 3 6,640 Jul-07-2021, 11:27 AM
Last Post: Larz60+
  python 3 find difference between 2 files pd007 2 2,070 May-22-2020, 01:16 AM
Last Post: Larz60+
  Look for match in two files and print out in the first file Batistuta 0 1,549 Mar-03-2020, 02:27 PM
Last Post: Batistuta
  Difference Between 2 files enigma619 3 2,678 Dec-21-2019, 01:39 PM
Last Post: Gribouillis
  How to match two CSV files timlamont 9 5,437 Oct-01-2019, 05:54 PM
Last Post: timlamont
  Python Script to Produce Difference Between Files and Resolve DNS Query for the Outpu sultan 2 2,445 May-22-2019, 07:20 AM
Last Post: buran
  Compare two large CSV files for a match Python_Newbie9 3 5,728 Apr-22-2019, 08:49 PM
Last Post: ichabod801

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020