issue_comments

Table actions

4 rows where user = 881019 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: issue_url, reactions, created_at (date), updated_at (date)

user 1

  • dhirschfeld · 4 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
507455821 https://github.com/pydata/xarray/issues/3068#issuecomment-507455821 https://api.github.com/repos/pydata/xarray/issues/3068 MDEyOklzc3VlQ29tbWVudDUwNzQ1NTgyMQ== dhirschfeld 881019 2019-07-01T23:03:12Z 2019-07-01T23:03:12Z NONE 
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Multidimensional dask coordinates unexpectedly computed 462859457
491103705 https://github.com/pydata/xarray/issues/2949#issuecomment-491103705 https://api.github.com/repos/pydata/xarray/issues/2949 MDEyOklzc3VlQ29tbWVudDQ5MTEwMzcwNQ== dhirschfeld 881019 2019-05-09T23:36:37Z 2019-05-09T23:36:37Z NONE

..so you'd need to do: ```python

series = array.to_series().copy(deep=False) series.index = series.index.copy(deep=False) series.index.name = 'shallow_copy' series.index.name 'shallow_copy' array.to_series().index.name 'forward_date' ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xr.DataArray.to_series returns a (mutable) view 442063346
491100027 https://github.com/pydata/xarray/issues/2949#issuecomment-491100027 https://api.github.com/repos/pydata/xarray/issues/2949 MDEyOklzc3VlQ29tbWVudDQ5MTEwMDAyNw== dhirschfeld 881019 2019-05-09T23:15:43Z 2019-05-09T23:15:43Z NONE

Unfortunately a shallow copy of a pandas series doesn't shallow copy it's index (I think it should): ```python

series = array.to_series().copy(deep=False) series.index.name = 'shallow_copy' array.to_series().index.name 'shallow_copy' # <--- I'd call this a pandas bug! ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xr.DataArray.to_series returns a (mutable) view 442063346
491062218 https://github.com/pydata/xarray/issues/2949#issuecomment-491062218 https://api.github.com/repos/pydata/xarray/issues/2949 MDEyOklzc3VlQ29tbWVudDQ5MTA2MjIxOA== dhirschfeld 881019 2019-05-09T20:53:19Z 2019-05-09T21:00:07Z NONE

Agreed that we definitely don't want to copy the data! I haven't.put in a PR as I think we're a bit hamstrung by pandas' behaviour here so I'm not quite sure how to fix it (without copying the data).

I'm unlikely to get around to a PR in the near term as I'm swamped (and can put up with deep copying the index for now). From my digging about I think the proper fix should be in pandas such that a shallow copy doesn't return a reference to the original name.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   xr.DataArray.to_series returns a (mutable) view 442063346

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