comparison two CSV files, filter reject.csv result and export new csv

johnny liu answered on September 8, 2023 Popularity 1/10 Helpfulness 1/10

answer comparison two CSV files, filter reject.csv result and export new csv

comparison two CSV files, filter reject.csv result and export new csv

Comment

# comparison two csv, filter reject.csv result and export new csv
# 過濾掉reject.csv的清單，並輸出新的csv
require 'csv'

# Initialize a hash to store data from reject.csv
reject_hash = {}

# Read reject.csv and build a hash
CSV.foreach('reject.csv') do |row|
  email = row[0]
  reject_hash[email] = true
end

# Read original.csv, exclude data from reject.csv, and write the result to export.csv
CSV.open('export.csv', 'w') do |csv|
  CSV.foreach('original.csv') do |row|
    email = row[0]
    unless reject_hash.key?(email)
      csv << [email]
    end
  end
end

Popularity 1/10 Helpfulness 1/10 Language ruby

Source: Grepper

Tags: comparison csv export filter ruby

Link to this answer
Share Copy Link

Contributed on Sep 08 2023

johnny liu

0 Answers Avg Quality 2/10

comparison two CSV files, filter reject.csv result and export new csv

Contents

More Related Answers

comparison two CSV files, filter reject.csv result and export new csv

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.