issue_comments

Table actions

2 rows where issue = 1599044689 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

author_association 2

issue 1

  • shift time using frequency strings · 2 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
1445384782 https://github.com/pydata/xarray/issues/7558#issuecomment-1445384782 https://api.github.com/repos/pydata/xarray/issues/7558 IC_kwDOAMm_X85WJtJO arfriedman 76110149 2023-02-26T15:08:12Z 2023-02-26T15:08:12Z CONTRIBUTOR

Thanks @dcherian 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   shift time using frequency strings 1599044689
1444102119 https://github.com/pydata/xarray/issues/7558#issuecomment-1444102119 https://api.github.com/repos/pydata/xarray/issues/7558 IC_kwDOAMm_X85WEz_n dcherian 2448579 2023-02-24T17:36:09Z 2023-02-24T17:36:09Z MEMBER

Thanks @arfriedman . Here's how to solve it

``` python import pandas as pd

air["time"] = air.time + pd.Timedelta("1D") ```

Today shift operates in "index space" i.e. it ignores any coordinate labels and simply moves values along an axis by integer offsets. This is conceptually different to your proposal for supporting a frequency string. I can see it being useful though.

The addition above is what you would do to shift longitude values by 0.5 for example. Perhaps that would be a useful API addition as shift_labels?

Let's see what others think. 

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   shift time using frequency strings 1599044689

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