issue_comments

Table actions

3 rows where author_association = "MEMBER" and issue = 207283854 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

issue 1

  • variable length of a dimension in DataArray · 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
751364613 https://github.com/pydata/xarray/issues/1265#issuecomment-751364613 https://api.github.com/repos/pydata/xarray/issues/1265 MDEyOklzc3VlQ29tbWVudDc1MTM2NDYxMw== keewis 14808389 2020-12-26T15:05:59Z 2020-12-26T15:05:59Z MEMBER

instead of the workarounds mentioned in https://github.com/pydata/xarray/issues/1265#issuecomment-279464724 this should work once the integration with awkward is implemented (see also #4285)

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   variable length of a dimension in DataArray 207283854
279516519 https://github.com/pydata/xarray/issues/1265#issuecomment-279516519 https://api.github.com/repos/pydata/xarray/issues/1265 MDEyOklzc3VlQ29tbWVudDI3OTUxNjUxOQ== shoyer 1217238 2017-02-13T20:45:14Z 2017-02-13T20:45:14Z MEMBER

I'm definitely happy to look at a more realistic / complete example. My PhD work was actually doing quantum simulations.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   variable length of a dimension in DataArray 207283854
279464724 https://github.com/pydata/xarray/issues/1265#issuecomment-279464724 https://api.github.com/repos/pydata/xarray/issues/1265 MDEyOklzc3VlQ29tbWVudDI3OTQ2NDcyNA== shoyer 1217238 2017-02-13T17:40:02Z 2017-02-13T17:40:02Z MEMBER

Xarray adds labels to NumPy array, so it can't handle variable length arrays any better than NumPy.

Basically, your options are to either (a) store stored numpy arrays using dtype=object (not really recommended), (b) pad each array up to a common length with NaNs (used to mark missing values in xarray) or (c) put multiple variables in an xarray.Dataset and use different dimension names for the variable length dimension.

Depending on your exact use case, either (b) or (c) could be a good solution.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   variable length of a dimension in DataArray 207283854

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