summaryrefslogtreecommitdiff
path: root/scripts/json2csv.rb
blob: 03191def31020e448503149d27a9d3feba9090e2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#!/usr/bin/env ruby
require_relative '../../lazar/lib/lazar'
include OpenTox

results = JSON.parse File.read(ARGV[0])
puts "SMILES,#{File.basename(ARGV[0],".json").sub("pa_","").capitalize},Probability(0),Probability(1),Nr Neighbors,Warnings"
results.each do |id,r|
  s = Compound.find(id).smiles
	if r["value"]
		puts [
			s,
			r["value"],
			r["probabilities"]["0"],
			r["probabilities"]["1"],
			r["neighbors"].size,
			r["warnings"],
		].join(",")
	else
		r["neighbors"] ? n = r["neighbors"].size : n = nil
		puts [
			s,
			r["value"],
			nil,
			nil,
			n,
			r["warnings"],
		].join(",")
	end
end