Matplotlib Alternatives Popularity Contest

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

WITH key_word_table AS
(
  SELECT 'matplotlib' AS key_word UNION
  SELECT 'seaborn' UNION
  SELECT 'plotly' UNION
  SELECT 'bokeh' UNION
  --SELECT 'gnuplot' UNION
  SELECT 'altair' UNION
  SELECT 'pygal'
  )
SELECT key_word_table.key_word, 
SUM(CAST(ViewCount AS BIGINT))AS viewed, 
Count(Posts.ViewCount) as question,
SUM(CASE WHEN ((Posts.AnswerCount < 1) AND (Posts.ClosedDate IS NULL)) THEN 1 ELSE 0 END) 
                               As unanswered_question                             
FROM Posts JOIN key_word_table ON Posts.Tags 
          LIKE CONCAT('%<', key_word_table.key_word,'>%')
WHERE Posts.PostTypeId = 1 
AND Posts.Tags LIKE '%<%' 
GROUP BY key_word
ORDER BY viewed DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results