home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

3 rows where author_association = "MEMBER" and issue = 109202603 sorted by updated_at descending

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 1

  • shoyer 3

issue 1

  • Aggregating NetCDF files · 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
144794506 https://github.com/pydata/xarray/issues/597#issuecomment-144794506 https://api.github.com/repos/pydata/xarray/issues/597 MDEyOklzc3VlQ29tbWVudDE0NDc5NDUwNg== shoyer 1217238 2015-10-01T17:30:55Z 2015-10-01T17:30:55Z MEMBER

So unfortunately there isn't an easy way to handle irregular data like this with xray. Before you put this stuff in a single dataset, you would need to align the time variables, probably by doing .reindex with the method argument, which lets you do nearest-neighbor interpolation, or by using .resample. That way, you could make, for example, a dataset with the latest image for each location at the start of each month.

The other option (probably also useful) is to only concatenate one spatial tile along time, so you don't need to do any interpolation or resampling. The should work out of the box with open_mfdataset.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Aggregating NetCDF files 109202603
144577690 https://github.com/pydata/xarray/issues/597#issuecomment-144577690 https://api.github.com/repos/pydata/xarray/issues/597 MDEyOklzc3VlQ29tbWVudDE0NDU3NzY5MA== shoyer 1217238 2015-09-30T23:59:04Z 2015-09-30T23:59:04Z MEMBER

It would probably be helpful to show the results of printing the several of these datasets when opened via open_dataset.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Aggregating NetCDF files 109202603
144577524 https://github.com/pydata/xarray/issues/597#issuecomment-144577524 https://api.github.com/repos/pydata/xarray/issues/597 MDEyOklzc3VlQ29tbWVudDE0NDU3NzUyNA== shoyer 1217238 2015-09-30T23:57:38Z 2015-09-30T23:57:38Z MEMBER

What do these different time range and geographical regions look like?

If they are adjacent and non-overlapping, then xray could be a very good fit and I can help whip up an example to get you started. If this is not the case (and I know that can be an issue with satellite data), then it's going to be more awkward to put them together into a single logical Dataset. It might make more sense to work with individual Datasets, e.g., at the level of an individual satellite image.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Aggregating NetCDF files 109202603

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