issue_comments

Table actions

2 rows where issue = 28600785 and user = 1217238 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 · 2 ✖

issue 1

  • OpenDAP loaded Dataset has lon/lats with type 'object'. · 2 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
38417320 https://github.com/pydata/xarray/issues/39#issuecomment-38417320 https://api.github.com/repos/pydata/xarray/issues/39 MDEyOklzc3VlQ29tbWVudDM4NDE3MzIw shoyer 1217238 2014-03-24T07:21:02Z 2014-03-24T07:21:02Z MEMBER

I believe this was fixed by #54.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   OpenDAP loaded Dataset has lon/lats with type 'object'. 28600785
36484122 https://github.com/pydata/xarray/issues/39#issuecomment-36484122 https://api.github.com/repos/pydata/xarray/issues/39 MDEyOklzc3VlQ29tbWVudDM2NDg0MTIy shoyer 1217238 2014-03-03T06:14:38Z 2014-03-03T06:14:38Z MEMBER

This is because coordinates are loaded as pandas.Index objects... which don't always faithfully preserve the type of the underlying object (see https://github.com/pydata/pandas/issues/6471).

I believe serialization should still work though thanks to a work around I added for dtype=object. Do let me know if this is not the case. One solution to make this less awkward would be to wrap pandas.Index in something that keeps track of the dtype of the original arguments for use in mathematical expression.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   OpenDAP loaded Dataset has lon/lats with type 'object'. 28600785

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