issue_comments

Table actions

2 rows where author_association = "MEMBER", issue = 207283854 and user = 1217238 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: author_association, issue

user 1

  • shoyer · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
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]);