Countries didn't collect poll or report data on certain questions (i.e. "N/A") had those items excluded from the overall average.
From best to worst, the ranking for 2017 is: Canada, Israel, the EU, South Korea, the US, Switzerland, Japan, Malaysia, India, China, and Russia.
The US effectively got a D- average while the top country, Canada, got a C-.