issue_comments

Table actions

2 rows where author_association = "MEMBER", issue = 124664101 and user = 953992 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

  • jreback · 2 ✖

issue 1

  • BUG: Dataset.from_dataframe() losing dims? · 2 ✖

author_association 1

  • MEMBER · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
168565401 https://github.com/pydata/xarray/issues/699#issuecomment-168565401 https://api.github.com/repos/pydata/xarray/issues/699 MDEyOklzc3VlQ29tbWVudDE2ODU2NTQwMQ== jreback 953992 2016-01-04T02:05:33Z 2016-01-04T02:05:33Z MEMBER

ok, closing.

also FYI, these seem reasonable as a default.

``` In [9]: p = tm.makePanel()

In [10]: p Out[10]: <class 'pandas.core.panel.Panel'> Dimensions: 3 (items) x 30 (major_axis) x 4 (minor_axis) Items axis: ItemA to ItemC Major_axis axis: 2000-01-03 00:00:00 to 2000-02-11 00:00:00 Minor_axis axis: A to D

In [11]: p.to_xray() Out[11]: <xray.Dataset> Dimensions: (items: 3, major_axis: 30, minor_axis: 4) Coordinates: * items (items) object 'ItemA' 'ItemB' 'ItemC' * major_axis (major_axis) datetime64[ns] 2000-01-03 2000-01-04 2000-01-05 ... * minor_axis (minor_axis) object 'A' 'B' 'C' 'D' Data variables: None (items, major_axis, minor_axis) float64 -0.5374 0.5918 ...

In [12]: p = tm.makePanel4D()

In [13]: p Out[13]: <class 'pandas.core.panelnd.Panel4D'> Dimensions: 3 (labels) x 3 (items) x 30 (major_axis) x 4 (minor_axis) Labels axis: l1 to l3 Items axis: ItemA to ItemC Major_axis axis: 2000-01-03 00:00:00 to 2000-02-11 00:00:00 Minor_axis axis: A to D

In [14]: p.to_xray() Out[14]: <xray.Dataset> Dimensions: (items: 3, labels: 3, major_axis: 30, minor_axis: 4) Coordinates: * labels (labels) object 'l1' 'l2' 'l3' * items (items) object 'ItemA' 'ItemB' 'ItemC' * major_axis (major_axis) datetime64[ns] 2000-01-03 2000-01-04 2000-01-05 ... * minor_axis (minor_axis) object 'A' 'B' 'C' 'D' Data variables: None (labels, items, major_axis, minor_axis) float64 -0.5523 ... ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   BUG: Dataset.from_dataframe() losing dims? 124664101
168563184 https://github.com/pydata/xarray/issues/699#issuecomment-168563184 https://api.github.com/repos/pydata/xarray/issues/699 MDEyOklzc3VlQ29tbWVudDE2ODU2MzE4NA== jreback 953992 2016-01-04T01:33:31Z 2016-01-04T01:33:31Z MEMBER

ahh I c, so this is actually a 1-dim (len of 3), ok.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   BUG: Dataset.from_dataframe() losing dims? 124664101

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