R and python questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

SELECT *, count(*) AS count FROM (
  SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS [month], 
    t.TagName as [tag]
  FROM Posts p 
    JOIN PostTags pt ON pt.PostId = p.Id
    JOIN Tags t ON t.Id = pt.TagId
  WHERE t.tagName IN ('pandas', 'scipy', 'numpy', 'matplotlib', 'r')
) as X
GROUP BY [tag], month
ORDER BY [tag], month

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results