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)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT Id, Body, Title, Tags, isPandas, ViewCount
FROM (
  SELECT TOP 10000 Id, Body, Title, Tags, ViewCount, 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 Id, Body, Title, Tags, ViewCount, 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