0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT year(p.CreationDate) +
       (month(p.CreationDate)-1) /12. yr_month, 
       TagName,
       count(*) questions
       --log(count(*)) log_questions
FROM Posts p, PostTags pt, Tags t
WHERE 1=1
AND p.id = pt.PostId
AND t.id = pt.TagId
--AND t.TagName = ##tag:string?weka##
/*
AND t.TagName in ('weka',
                  'pandas', 
                  'numpy',
                  'vowpalwabbit',
                  'theano',
                  --'mahout',
                  'scikit-learn',
                  --'matlab',
                  'julia-lang'
                  --,'r'  -- Not included because it swamps others
                  )
*/
AND t.tagName in (
  'tensorflow','pytorch','keras','torch','caffe', 'theano'
  --,'deeplearning4j', 'pybrain' -- recommend visualizing on log scale
)
AND year(p.CreationDate) >= year(getdate()) - 1  
GROUP BY year(p.CreationDate), month(p.CreationDate), tagname
order by year(p.CreationDate), month(p.CreationDate)

view current version

edited may 17 17 David Marx

created jan 12 15 anonymous