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', 'orange', 'numpy', --'matlab', 'julia-lang' --,'r' -- Not included because it swamps others ) */ AND t.tagName in ( 'pandas', 'numpy' --,'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)