issue_comments

Table actions

3 rows where author_association = "NONE" and user = 4641789 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

  • samwisehawkins · 3 ✖

author_association 1

  • NONE · 3 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
192248130 https://github.com/pydata/xarray/issues/780#issuecomment-192248130 https://api.github.com/repos/pydata/xarray/issues/780 MDEyOklzc3VlQ29tbWVudDE5MjI0ODEzMA== samwisehawkins 4641789 2016-03-04T11:43:28Z 2016-03-04T11:43:28Z NONE

Thanks, will have a look. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Index/dimension order not preserved when going from and to DataFrame 137920337
191341328 https://github.com/pydata/xarray/issues/780#issuecomment-191341328 https://api.github.com/repos/pydata/xarray/issues/780 MDEyOklzc3VlQ29tbWVudDE5MTM0MTMyOA== samwisehawkins 4641789 2016-03-02T17:33:32Z 2016-03-02T17:33:32Z NONE

Moreover, I've just realised that the resulting DataFrame has a different ordering of the rows. So as far as I can tell, in order to get back the same DataFrame in a round trip to and from a Dataset, you need to to reorder the levels of the column index, then resort the rows according to that column index.

I'm doing this round trip as I'm storing DataFrames as netcdf files, and want to check that I can get do the round trip properly.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Index/dimension order not preserved when going from and to DataFrame 137920337
191314070 https://github.com/pydata/xarray/issues/780#issuecomment-191314070 https://api.github.com/repos/pydata/xarray/issues/780 MDEyOklzc3VlQ29tbWVudDE5MTMxNDA3MA== samwisehawkins 4641789 2016-03-02T16:29:13Z 2016-03-02T16:29:13Z NONE

This can easily be corrected using reorder_levels, but would be nice if this was automatic.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Index/dimension order not preserved when going from and to DataFrame 137920337

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