How to check for a column data and extract data on the same row? CSV on Ruby

Question

I am currently using Ruby for a CSV file and I am trying to print a column data given a condition.

Severity  Level
Least       1
Average     2
Normal      3
High        4
Severe      5

require "csv"
CSV.foreach('csvread.csv', :headers=>true) do |row|
  if (row[1] == 2) 
    puts row.inspect
  end
end

How do I select the Level column and print out the severity?

CSV file structure:

Severity;Level
Least;1
Average;2
Normal;3
High;4
Severe;5

Sebastián Palma · Accepted Answer · 2018-02-11 15:16:12Z

2

You can access to Security and Level, and any other value you define in your header as object['header'].

In this case the object is each row for the iteration, and the values are Severity and Level, so:

require 'csv'

file = '/path_to_data/data.csv'
CSV.foreach(file, headers: true, col_sep: ';') do |row|
  p [row['Severity'], row['Level']]
end

# ["Least", "1"]
# ["Average", "2"]
# ["Normal", "3"]
# ["High", "4"]
# ["Severe", "5"]

edited Feb 11, 2018 at 15:16

answered Feb 11, 2018 at 13:53

Sebastián Palma

33.6k6 gold badges45 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

How to check for a column data and extract data on the same row? CSV on Ruby

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related