issue_comments

Table actions

2 rows where author_association = "MEMBER" and issue = 103380276 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

user 2

issue 1

  • Dataset.to_dataframe() loses datetime64 timezone localization · 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
135989323 https://github.com/pydata/xarray/issues/552#issuecomment-135989323 https://api.github.com/repos/pydata/xarray/issues/552 MDEyOklzc3VlQ29tbWVudDEzNTk4OTMyMw== shoyer 1217238 2015-08-29T14:11:46Z 2015-08-29T14:11:46Z MEMBER

Xray relies on numpy's datetime64 dtype, which for better or worse does not store timezone. Pandas creates its own array type (wrapping numpy) to make timezone localization work properly, but I don't want to go to those lengths in xray. So I'm happy to push users to UTC for now, and wait until upstream improvements make it easier to customize array dtypes (for things like datetime types with timezones).

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Dataset.to_dataframe() loses datetime64 timezone localization 103380276
135198196 https://github.com/pydata/xarray/issues/552#issuecomment-135198196 https://api.github.com/repos/pydata/xarray/issues/552 MDEyOklzc3VlQ29tbWVudDEzNTE5ODE5Ng== jhamman 2443309 2015-08-26T22:44:20Z 2015-08-26T22:44:20Z MEMBER

Is this just the pandas repr behavior?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   Dataset.to_dataframe() loses datetime64 timezone localization 103380276

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