FasterCSV

ruby-talk
1

I am wanting to use faster_csv to read two csv files and
append columns to the first from the second and write to a temp file.

for example,

1st Csv
...............................................
id,name_first,name_last,email\n
1,Dave,Wilson,dave@wilson.com\n
2,James,Stevens,james@stevens.com\n

2nd Csv
.................................................
address_street,address_city,address_state\n
105 Street,Little Rock,AR\n
205 Street,Dallas,TX\n

Output
..............................................
id,name_first,name_last,email,address_street,address_city,address_state\n
1,Dave,Wilson,dave@wilson.com,105 Street,Little Rock,AR\n
2,James,Stevens,james@stevens.com,205 Street,Dallas,TX\n

I was hoping some one could point in me in the right direction on how to
get started with this.

Here is what I have so far.. As you can see that is just the first half
of the data.

.........................................................................

require "faster_csv"

class CSVReadWrite

def readwrite
  tempfile = "csvs/temp.csv"
   if File.exists?("csvs/temp.csv")
    File.delete("csvs/temp.csv")
   end
  File.new("csvs/temp.csv", "w")

  filenameusers = "csvs/Users.csv"
  filenameaddresses = "csvs/Addresses.csv"
  FasterCSV.foreach(filenameusers) do |line|

   @results = line[0], line[1] , line[2]

     FasterCSV.open("csvs/tempout.csv", "a") do |csv|
      csv << @results

       end

end

r1 = CSVReadWrite.new()
r1.readwrite

end

···

--
Posted via http://www.ruby-forum.com/.

2

What about something like:

require "rubygems"
require "faster_csv"

users = FCSV.open("csvs/Users.csv")
addresses = FCSV.open("csvs/Addresses.csv")
joined = FCSV.open("csvs/temp.csv", "w")

while (user = users.gets) and (address = addresses.gets)
   joined << user.fields + address.fields
end

[users, addresses, joined].map { |csv| csv.close }

__END__

Hope that helps.

James Edward Gray II

···

On May 7, 2008, at 4:55 PM, Kris Windham wrote:

I am wanting to use faster_csv to read two csv files and
append columns to the first from the second and write to a temp file.

for example,

1st Csv
...............................................
id,name_first,name_last,email\n
1,Dave,Wilson,dave@wilson.com\n
2,James,Stevens,james@stevens.com\n

2nd Csv
.................................................
address_street,address_city,address_state\n
105 Street,Little Rock,AR\n
205 Street,Dallas,TX\n

Output
..............................................
id
,name_first,name_last,email,address_street,address_city,address_state\n
1,Dave,Wilson,dave@wilson.com,105 Street,Little Rock,AR\n
2,James,Stevens,james@stevens.com,205 Street,Dallas,TX\n

I was hoping some one could point in me in the right direction on how to
get started with this.

3

James Gray wrote:

···

On May 7, 2008, at 4:55 PM, Kris Windham wrote:

,name_first,name_last,email,address_street,address_city,address_state
\n
1,Dave,Wilson,dave@wilson.com,105 Street,Little Rock,AR\n
2,James,Stevens,james@stevens.com,205 Street,Dallas,TX\n

I was hoping some one could point in me in the right direction on
how to
get started with this.

What about something like:

require "rubygems"
require "faster_csv"

users = FCSV.open("csvs/Users.csv")
addresses = FCSV.open("csvs/Addresses.csv")
joined = FCSV.open("csvs/temp.csv", "w")

while (user = users.gets) and (address = addresses.gets)
   joined << user.fields + address.fields
end

[users, addresses, joined].map { |csv| csv.close }

__END__

Hope that helps.

James Edward Gray II

That helps immensely.

Thank you for your quick response...
I have just started using fastercsv as opposed to the built-in csv ...

I have a lot yet to do with this, but that gets me started.

--
Posted via http://www.ruby-forum.com/\.