test_files.runtime-spark.DataFrames.GroupbyClause3.jq Maven / Gradle / Ivy

Go to download
(:JIQS: ShouldRun; Output="({ "Language" : "Albanian", "Correct guesses" : 2 }, { "Language" : "Amharic", "Correct guesses" : 4 }, { "Language" : "Arabic", "Correct guesses" : 5 }, { "Language" : "Armenian", "Correct guesses" : 4 }, { "Language" : "Assyrian", "Correct guesses" : 8 }, { "Language" : "Bangla", "Correct guesses" : 3 }, { "Language" : "Bosnian", "Correct guesses" : 2 }, { "Language" : "Bulgarian", "Correct guesses" : 3 }, { "Language" : "Burmese", "Correct guesses" : 4 }, { "Language" : "Cantonese", "Correct guesses" : 2 }, { "Language" : "Czech", "Correct guesses" : 4 }, { "Language" : "Danish", "Correct guesses" : 3 }, { "Language" : "Dari", "Correct guesses" : 2 }, { "Language" : "Dinka", "Correct guesses" : 2 }, { "Language" : "Dutch", "Correct guesses" : 3 }, { "Language" : "Estonian", "Correct guesses" : 3 }, { "Language" : "Farsi", "Correct guesses" : 4 }, { "Language" : "Fijian", "Correct guesses" : 1 }, { "Language" : "Finnish", "Correct guesses" : 3 }, { "Language" : "French", "Correct guesses" : 7 }, { "Language" : "German", "Correct guesses" : 7 }, { "Language" : "Greek", "Correct guesses" : 1 }, { "Language" : "Gujarati", "Correct guesses" : 8 }, { "Language" : "Hebrew", "Correct guesses" : 10 }, { "Language" : "Hindi", "Correct guesses" : 5 }, { "Language" : "Hungarian", "Correct guesses" : 3 }, { "Language" : "Indonesian", "Correct guesses" : 5 }, { "Language" : "Italian", "Correct guesses" : 5 }, { "Language" : "Japanese", "Correct guesses" : 7 }, { "Language" : "Kannada", "Correct guesses" : 5 }, { "Language" : "Khmer", "Correct guesses" : 8 }, { "Language" : "Korean", "Correct guesses" : 3 }, { "Language" : "Kurdish", "Correct guesses" : 6 }, { "Language" : "Lao", "Correct guesses" : 7 }, { "Language" : "Latvian", "Correct guesses" : 5 }, { "Language" : "Macedonian", "Correct guesses" : 3 }, { "Language" : "Malay", "Correct guesses" : 3 }, { "Language" : "Malayalam", "Correct guesses" : 5 }, { "Language" : "Maltese", "Correct guesses" : 6 }, { "Language" : "Mandarin", "Correct guesses" : 8 }, { "Language" : "Nepali", "Correct guesses" : 7 }, { "Language" : "Norwegian", "Correct guesses" : 3 }, { "Language" : "Polish", "Correct guesses" : 4 }, { "Language" : "Portuguese", "Correct guesses" : 10 }, { "Language" : "Punjabi", "Correct guesses" : 7 }, { "Language" : "Romanian", "Correct guesses" : 7 }, { "Language" : "Russian", "Correct guesses" : 10 }, { "Language" : "Samoan", "Correct guesses" : 2 }, { "Language" : "Serbian", "Correct guesses" : 6 }, { "Language" : "Sinhalese", "Correct guesses" : 4 }, { "Language" : "Slovak", "Correct guesses" : 3 }, { "Language" : "Slovenian", "Correct guesses" : 3 }, { "Language" : "Somali", "Correct guesses" : 3 }, { "Language" : "Spanish", "Correct guesses" : 11 }, { "Language" : "Swahili", "Correct guesses" : 1 }, { "Language" : "Swedish", "Correct guesses" : 6 }, { "Language" : "Tagalog", "Correct guesses" : 4 }, { "Language" : "Tamil", "Correct guesses" : 5 }, { "Language" : "Thai", "Correct guesses" : 1 }, { "Language" : "Tigrinya", "Correct guesses" : 2 }, { "Language" : "Tongan", "Correct guesses" : 5 }, { "Language" : "Turkish", "Correct guesses" : 4 }, { "Language" : "Ukrainian", "Correct guesses" : 3 }, { "Language" : "Urdu", "Correct guesses" : 4 }, { "Language" : "Vietnamese", "Correct guesses" : 5 })" :)
for $i in json-file("./src/main/resources/queries/confusion_sample.json")
let $guess := $i."guess", $target := $i."target"
where $guess eq $target
group by $target
order by $target
return {"Language": $target,
        "Correct guesses": count($i)}