issue_comments

Table actions

5 rows where issue = 465984161 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

user 3

issue 1

  • Python 3.5.0-3.5.1 support · 5 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
510322576 https://github.com/pydata/xarray/issues/3089#issuecomment-510322576 https://api.github.com/repos/pydata/xarray/issues/3089 MDEyOklzc3VlQ29tbWVudDUxMDMyMjU3Ng== shoyer 1217238 2019-07-11T04:17:05Z 2019-07-11T04:17:05Z MEMBER

Sure, let's bump the minimum version requirement. I don't see this bothering many people.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Python 3.5.0-3.5.1 support 465984161
510245713 https://github.com/pydata/xarray/issues/3089#issuecomment-510245713 https://api.github.com/repos/pydata/xarray/issues/3089 MDEyOklzc3VlQ29tbWVudDUxMDI0NTcxMw== max-sixty 5635139 2019-07-10T21:58:43Z 2019-07-10T21:58:43Z MEMBER

This is any xarray install, not just the latest version

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Python 3.5.0-3.5.1 support 465984161
510245247 https://github.com/pydata/xarray/issues/3089#issuecomment-510245247 https://api.github.com/repos/pydata/xarray/issues/3089 MDEyOklzc3VlQ29tbWVudDUxMDI0NTI0Nw== crusaderky 6213168 2019-07-10T21:57:25Z 2019-07-10T21:57:25Z MEMBER

How comes there are that many hits on Python 2.7? xarray versions from the last 6 months won't even start on it

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Python 3.5.0-3.5.1 support 465984161
510149218 https://github.com/pydata/xarray/issues/3089#issuecomment-510149218 https://api.github.com/repos/pydata/xarray/issues/3089 MDEyOklzc3VlQ29tbWVudDUxMDE0OTIxOA== max-sixty 5635139 2019-07-10T17:12:05Z 2019-07-10T17:12:05Z MEMBER

I was also surprised by the prevalence of 3.5.

If I filtered down to this month, it's down to about half of each of 3.6 & 3.7, but still 20% of users on python3:

sql SELECT REGEXP_EXTRACT(details.python, r"^\d*\.\d*") version, COUNT(*) ct FROM `the-psf.pypi.downloads*` WHERE file.project = 'xarray' AND _TABLE_SUFFIX > FORMAT_DATE( '%Y%m%d', DATE_TRUNC(CURRENT_DATE(), month)) GROUP BY 1 ORDER BY 1

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Python 3.5.0-3.5.1 support 465984161
509878226 https://github.com/pydata/xarray/issues/3089#issuecomment-509878226 https://api.github.com/repos/pydata/xarray/issues/3089 MDEyOklzc3VlQ29tbWVudDUwOTg3ODIyNg== max-sixty 5635139 2019-07-10T02:06:36Z 2019-07-10T02:06:36Z MEMBER

There are de minimus 3.5.0-3.5.1 downloads (this is a screenshot of a subset but makes the point):

BigQuery query:

sql SELECT REGEXP_EXTRACT(details.python, r"[\d\.]*") version, COUNT(*) ct FROM `the-psf.pypi.downloads*` WHERE file.project = 'xarray' AND _TABLE_SUFFIX > FORMAT_DATE( '%Y%m%d', DATE_TRUNC(CURRENT_DATE(), year)) GROUP BY 1 ORDER BY 1

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Python 3.5.0-3.5.1 support 465984161

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);