Python : Compare two csv files and print out differences

by

The problem is that you are comparing each line in fileone to the same line in filetwo. As soon as there is an extra line in one file you will find that the lines are never equal again. Try this:

with open('old.csv', 'r') as t1, open('new.csv', 'r') as t2:
    fileone = t1.readlines()
    filetwo = t2.readlines()

with open('update.csv', 'w') as outFile:
    for line in filetwo:
        if line not in fileone:
            outFile.write(line)

More Related Contents:

  1. How to write a python code which copies a unique column from an output file to a .csv file
  2. How can I convert JSON to CSV?
  3. Skip the headers when editing a csv file using Python
  4. How to add a new column to a CSV file?
  5. Skip rows during csv import pandas
  6. How to avoid Python/Pandas creating an index in a saved csv?
  7. datetime dtypes in pandas read_csv
  8. Python CSV error: line contains NULL byte
  9. How do I convert this list of dictionaries to a csv file?
  10. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  11. sort csv by column
  12. csv.Error: iterator should return strings, not bytes
  13. Pandas read csv file with float values results in weird rounding and decimal digits
  14. Why does csvwriter.writerow() put a comma after each character?
  15. Key error when selecting columns in pandas dataframe after read_csv
  16. How to delete columns in a CSV file?
  17. Prevent pandas read_csv treating first row as header of column names
  18. Is it possible to keep the column order using csv.DictReader?
  19. ValueError : I/O operation on closed file
  20. Writing to a particular cell using csv module in python
  21. Writing List of Strings to Excel CSV File in Python
  22. Load CSV file with PySpark
  23. Python UTF-16 CSV reader
  24. Read specific columns with pandas or other python module
  25. load csv into 2D matrix with numpy for plotting
  26. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  27. Strip white spaces from CSV file
  28. How to add a new column to the beginning of the rows of a CSV file?
  29. Python Parse CSV Correctly
  30. start index at 1 for Pandas DataFrame

Leave a Comment