home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

1 row where author_association = "MEMBER", issue = 596352097 and user = 5821660 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

  • kmuehlbauer · 1 ✖

issue 1

  • Masking and preserving int type · 1 ✖

author_association 1

  • MEMBER · 1 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
610799451 https://github.com/pydata/xarray/issues/3955#issuecomment-610799451 https://api.github.com/repos/pydata/xarray/issues/3955 MDEyOklzc3VlQ29tbWVudDYxMDc5OTQ1MQ== kmuehlbauer 5821660 2020-04-08T07:31:26Z 2020-04-08T07:42:03Z MEMBER

There has been a lot of discussion about the int vs nan problem in the past, here one issue #1194. My question for xarray-devs would be too, if there is some idea on adapting to the pandas scheme?

In the time being, you might just go the other way round (isel before where) and this little hack:

```python

overwrite fill_values with 0

sub = xr.where(z_indices == fill_value, 0, z_indices)

isel with sub and mask with where

indexed_array = val_arr.isel(z=sub).where(z_indices != fill_value) `` Update: Nevermind, this will make theindexed_arraya float. You might use the samewhere-machinery and overwrite with afill_value ` of your liking:

```python

overwrite fill_values with 0

sub = xr.where(z_indices == fill_value, 0, z_indices)

isel with sub and mask with where

indexed_array = val_arr.isel(z=sub) indexed_array = xr.where(z_indices == fill_value, fill_value, indexed_array) ``` I can't immediately see, but there might be a cleaner way to achieve this.

{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Masking and preserving int type 596352097

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 30.058ms · About: xarray-datasette