1 files changed, 28 insertions, 0 deletions
diff --git a/scripts/efsa2csv.rb b/scripts/efsa2csv.rb
new file mode 100755
index 0000000..56c69df
--- /dev/null
+++ b/scripts/efsa2csv.rb
@@ -0,0 +1,28 @@
+#!/usr/bin/env ruby
+require 'csv'
+require_relative '../../lazar/lib/lazar.rb'
+
+i = 0
+db = {}
+CSV.foreach(ARGV[0]) do |row|
+  begin
+    if i > 0 and row[11]
+      c = OpenTox::Compound.from_smiles(row[11]).smiles
+      if row[24].match(/Salmonella/i)
+        if row[25].match("TA 98") or row[25].match("TA 100")
+          if row[33].match(/Positiv/i)
+            db[c] = 1 # at least one positive result in TA 98 or TA 100
+          elsif row[33].match(/Negativ/i)
+            db[c] ||= 0
+          end
+        end
+      end
+    end
+  rescue
+  end
+  i += 1
+end
+
+dm.each do |s,v|
+  puts [s,v].join ","
+end