Python Pandas and not Pandas questions from 2015 to 2020 12k rows

0

Please login or register to vote for this query.

(click on this box to dismiss)

Martial Arts Meta

Q&A about the site for students and teachers of all martial arts

SELECT *
FROM (
  SELECT TOP 10000 *, 0 AS isPandas
  FROM
    Posts p
  WHERE
     p.tags LIKE '%python-3.x%'
     AND p.tags NOT LIKE '%pandas%'
     AND p.CreationDate >= '2015-01-01'
     AND p.CreationDate < '2020-01-01'
  ORDER BY
    ViewCount DESC
 ) AS withPandas
UNION
SELECT TOP 2000 *, 1 AS isPandas
FROM
  Posts p
WHERE
   p.tags LIKE '%python-3.x%'
   AND p.tags LIKE '%pandas%'
   AND p.CreationDate >= '2015-01-01'
   AND p.CreationDate < '2020-01-01'
ORDER BY
  ViewCount DESC

Enter Parameters

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