issue_comments

Table actions

1 row where user = 34008825 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

  • carlos-rpg · 1 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
755190063 https://github.com/pydata/xarray/issues/4765#issuecomment-755190063 https://api.github.com/repos/pydata/xarray/issues/4765 MDEyOklzc3VlQ29tbWVudDc1NTE5MDA2Mw== carlos-rpg 34008825 2021-01-06T09:33:11Z 2021-01-06T13:45:01Z NONE

I think that works as intended, although the error message could definitely be better.

Series is limited to 1D arrays, so we have to convert DataArray objects with more than one dimension using stack. If the object already has a MultiIndex this fails because we don't support da.stack(xy=['x', 'y']).stack(xyz=['xy', 'z']).

It's a pity because having a partial MultiIndex DataArray helps a lot if there are lots of combinations of x and y with NA values. My reason to transfort into a pandas object is that I need to groupby by 3 dimensions.

EDIT: I have found a strange workaround: da.stack(xy=['x', 'y']).to_dask_dataframe().compute()

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Conversions to Pandas objects fail when mixtures of Index and MultiIndex are present 778863478

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]);