Databases
StackOverflow2013
Postsdbo
POHow to delete a line in file1 that appeared once or multiple times in file2 in python?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to delete a line in file1 that appeared once or multiple times in file2 in python?
    primarykey
    data
    text
    <p>I have two text files: file1 has 40 lines and file2 has 1.3 million lines I would like to compare every line in file1 with file2. If a line in file1 appeared once or multiple times in file2, this line(lines) should be deleted from file2 and remaining lines of file2 return to a third file3. I could painfully delete one line in file1 from file2 by manually copying the line, indicated as "unwanted_line" in my code. Does anyone knows how to do this in python. Thanks in advance for your assistance. Here's my code:</p> <pre><code> fname = open(raw_input('Enter input filename: ')) #file2 outfile = open('Value.txt','w') unwanted_line = "222" #This is in file1 for line in fname.readlines(): if not unwanted_line in line: # now remove unwanted_line from fname data =line.strip("unwanted_line") # write it to the output file outfile.write(data) print 'results written to:\n', os.getcwd()+'\Value.txt' </code></pre> <p>NOTE:</p> <p>This is how I got it to work for me. I would like to thank everyone who contributed towards the solution. I took your ideas here.I used set(),where intersection (common lines) of file1 with file2 is removed, then, the unique lines in file2 are return to file3. It might not be most elegant way of doing it, but it works for me. I respect everyone of your ideas, there are great and wonderful, it makes me feel python is the only programming language in the whole world. Thanks guys.</p> <pre><code> def diff_lines(filenameA,filenameB): fnameA = set(filenameA) fnameB = set(filenameB) data = [] #identify lines not common to both files #diff_line = fnameB ^ fnameA diff_line = fnameA.symmetric_difference(fnameB) data = list(diff_line) data.sort() return data </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser587646
    1. USuser587646
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAre the files sorted? If not, you should sort them it will make things much much easier.
      singulars
      1. POHow to delete a line in file1 that appeared once or multiple times in file2 in python?
      1. USGWW
    2. CO`grep -vFf file1 file2 > file3`
      singulars
      1. POHow to delete a line in file1 that appeared once or multiple times in file2 in python?
      1. USMattH
    3. CO@MattH nice one!
      singulars
      1. POHow to delete a line in file1 that appeared once or multiple times in file2 in python?
      1. USPaul
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload