home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

3 rows where issue = 59032389 sorted by updated_at descending

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 2

  • shoyer 2
  • jhamman 1

issue 1

  • Cleanup (mostly documentation) · 3 ✖

author_association 1

  • MEMBER 3
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
76483784 https://github.com/pydata/xarray/pull/337#issuecomment-76483784 https://api.github.com/repos/pydata/xarray/issues/337 MDEyOklzc3VlQ29tbWVudDc2NDgzNzg0 shoyer 1217238 2015-02-27T22:22:47Z 2015-02-27T22:22:47Z MEMBER

Should season be listed in the "virtual variables" here: http://xray.readthedocs.org/en/latest/data-structures.html

Good catch

With the addition of the nan-safe functions, numpy is throwing a lot of warnings for things like "empty slices" (ocean grid cells in my example never have data). Its not a big deal to silence them but it is a bit annoying.

To fix this, you can install bottleneck (which will also make these operations much faster). We could also look into silencing the warnings. I'll add a note to the documentation somewhere.

Since ds.groupby('time.season').mean('time') returns a Dataset with a Coordinates variable named time.season, ds.sel(time.season='JJA') doesn't work for Python syntax reasons. So, I don't know if I would change the syntax used in my example (selecting my position). I'm not keen on this constructor: ds.sel(**{'time.season':'JJA'}). I'm wondering if it would be better to name the coordinates returned from "virtual variable" operations without the "time." portion. Just a thought.

This one is trickier. Let me make a new issue.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Cleanup (mostly documentation) 59032389
76448604 https://github.com/pydata/xarray/pull/337#issuecomment-76448604 https://api.github.com/repos/pydata/xarray/issues/337 MDEyOklzc3VlQ29tbWVudDc2NDQ4NjA0 jhamman 2443309 2015-02-27T18:44:55Z 2015-02-27T18:44:55Z MEMBER

@shoyer: I just ran the example and it still works without any modifications.

A few comments/questions: - Should season be listed in the "virtual variables" here: http://xray.readthedocs.org/en/latest/data-structures.html - With the addition of the nan-safe functions, numpy is throwing a lot of warnings for things like "empty slices" (ocean grid cells in my example never have data). Its not a big deal to silence them but it is a bit annoying. - Since ds.groupby('time.season').mean('time') returns a Dataset with a Coordinates variable named time.season, ds.sel(time.season='JJA') doesn't work for Python syntax reasons. So, I don't know if I would change the syntax used in my example (selecting my position). I'm not keen on this constructor: ds.sel(**{'time.season':'JJA'}). I'm wondering if it would be better to name the coordinates returned from "virtual variable" operations without the "time." portion. Just a thought.

I will still get you an updated version of the example.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Cleanup (mostly documentation) 59032389
76135102 https://github.com/pydata/xarray/pull/337#issuecomment-76135102 https://api.github.com/repos/pydata/xarray/issues/337 MDEyOklzc3VlQ29tbWVudDc2MTM1MTAy shoyer 1217238 2015-02-26T07:43:29Z 2015-02-26T07:43:29Z MEMBER

CC @jhamman

It would be awesome if you could update your example to work on xray 0.4 before I do the final release (there will be a release candidate).

I think the main change effecting this example that is that 'time.season' now returns strings like 'DFJ', not integers. See http://xray.readthedocs.org/en/latest/whats-new.html for more details.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Cleanup (mostly documentation) 59032389

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 1444.877ms · About: xarray-datasette
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows