Ruby csv - delete row if column is empty

Question

Trying to delete rows from the csv file here with Ruby without success.

How can I tell that all rows, where column "newprice" is empty, should be deleted?

require 'csv' 
guests = CSV.table('new.csv', headers:true)

guests.each do |guest_row|
  p guests.to_s 
end

price = CSV.foreach('new.csv', headers:true) do |row|
  puts row['newprice'] 
end 

guests.delete_if('newprice' = '')

File.open('new_output.csv', 'w') do |f|
  f.write(guests.to_csv)
end

Thanks!

steenslag · Accepted Answer · 2015-06-27 21:23:23Z

1

Almost there. The table method changes the headers to symbols, and delete_if takes a block, the same way as each and open.

require 'csv' 
guests = CSV.table('test.csv', headers:true)

guests.each do |guest_row|
  p guest_row.to_s 
end

guests.delete_if do |row| 
  row[:newprice].nil?
end

File.open('test1.csv', 'w') do |f|
  f.write(guests.to_csv)
end

edited Jun 27, 2015 at 21:23

answered Jun 27, 2015 at 20:53

steenslag

80.2k16 gold badges144 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

steenslag Over a year ago

Ah yes, I used the other block form and forgot about it. Corrected.

Collectives™ on Stack Overflow

Ruby csv - delete row if column is empty

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related