home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

6 rows where issue = 185441216 sorted by updated_at descending

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 4

  • jhamman 2
  • mcgibbon 2
  • shoyer 1
  • stale[bot] 1

author_association 3

  • MEMBER 3
  • CONTRIBUTOR 2
  • NONE 1

issue 1

  • Add remaining date units to conventions.py · 6 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
457722283 https://github.com/pydata/xarray/issues/1062#issuecomment-457722283 https://api.github.com/repos/pydata/xarray/issues/1062 MDEyOklzc3VlQ29tbWVudDQ1NzcyMjI4Mw== stale[bot] 26384082 2019-01-25T20:47:52Z 2019-01-25T20:47:52Z NONE

In order to maintain a list of currently relevant issues, we mark issues as stale after a period of inactivity If this issue remains relevant, please comment here; otherwise it will be marked as closed automatically

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Add remaining date units to conventions.py 185441216
256541189 https://github.com/pydata/xarray/issues/1062#issuecomment-256541189 https://api.github.com/repos/pydata/xarray/issues/1062 MDEyOklzc3VlQ29tbWVudDI1NjU0MTE4OQ== mcgibbon 12307589 2016-10-27T04:01:55Z 2016-10-27T04:01:55Z CONTRIBUTOR

I think using a more informative error when particularly year and month are used would be the right way to go. It would also probably be fine to require integer months/years, but Pandas also has weird behavior:

In[6]: pd.to_timedelta(1, 'M') Out[6]: Timedelta('30 days 10:29:06') In[7]: pd.to_timedelta(1.5, 'M') Out[7]: Timedelta('30 days 10:29:06')

Because of this it would take a significant rework of decode_cf_datetime in conventions.py to actually implement integer months working properly.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Add remaining date units to conventions.py 185441216
256539119 https://github.com/pydata/xarray/issues/1062#issuecomment-256539119 https://api.github.com/repos/pydata/xarray/issues/1062 MDEyOklzc3VlQ29tbWVudDI1NjUzOTExOQ== jhamman 2443309 2016-10-27T03:42:14Z 2016-10-27T03:42:14Z MEMBER

@mcgibbon - I'm not sure what to do here then. There is a related discussion here that I think we should follow.

So I think we need a more informative error or to better use whatever error netcdf4 throws.

For the record, I never want a month to equal 30.42 days. I understand why UDUNITS did that (because units should vary with time) -- but they should have taken it up with those who decided on our calendar systems 😉.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Add remaining date units to conventions.py 185441216
256506227 https://github.com/pydata/xarray/issues/1062#issuecomment-256506227 https://api.github.com/repos/pydata/xarray/issues/1062 MDEyOklzc3VlQ29tbWVudDI1NjUwNjIyNw== mcgibbon 12307589 2016-10-26T23:27:43Z 2016-10-26T23:27:43Z CONTRIBUTOR

@jhamman It does sound sensible to have integer months accepted as a unit. However, Udunits isn't sensible (in this way), and CF conventions refer to Udunits. If we are to treat months as Udunits months, then each month is 30.42 or a similar number of days, and February 1st + 1 month is not the 1st of March.

The CF-compatible way to do it is have the length of a month be based on the length of a year for the current calendar. Even then it's not well defined since a common and leap year are different lengths...

At the very least it should be helpful to see an error message raised explaining why months and years aren't acceptable units when using them is attempted, possibly referring to this github issue.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Add remaining date units to conventions.py 185441216
256417556 https://github.com/pydata/xarray/issues/1062#issuecomment-256417556 https://api.github.com/repos/pydata/xarray/issues/1062 MDEyOklzc3VlQ29tbWVudDI1NjQxNzU1Ng== jhamman 2443309 2016-10-26T17:19:44Z 2016-10-26T17:19:44Z MEMBER

@mcgibbon - I actually just ran into this today as well. I'd be happy to see something sensible added to our decoding. To start, why don't we only allow decoding of these units when the values are (like) integers. 16 years since 2000-01-01 is easy enough to decode but partial months/years can get tricky and error-prone since 10.84 months since 2016-01-01 requires us to make some decisions about the length of the month/year.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Add remaining date units to conventions.py 185441216
256410357 https://github.com/pydata/xarray/issues/1062#issuecomment-256410357 https://api.github.com/repos/pydata/xarray/issues/1062 MDEyOklzc3VlQ29tbWVudDI1NjQxMDM1Nw== shoyer 1217238 2016-10-26T16:52:39Z 2016-10-26T16:52:39Z MEMBER

Indeed, NumPy converts these units inconsistently with Udunits:

```

np.timedelta64(1, 'Y').astype('timedelta64[D]') numpy.timedelta64(365,'D') ```

We currently convert all datetime arrays to ns resolution (for pandas compatibility), which means this would give possibly broken results.

But honestly, we haven't looked into this very much. If this would be a uniform improvement over the current state then it's worth considering.

CC @jhamman

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Add remaining date units to conventions.py 185441216

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]);
Powered by Datasette · Queries took 5845.031ms · About: xarray-datasette
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows