home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

1 row where issue = 819897789 and user = 43613877 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

  • observingClouds · 1 ✖

issue 1

  • Date missing in datetime accessor · 1 ✖

author_association 1

  • CONTRIBUTOR 1
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
790718449 https://github.com/pydata/xarray/issues/4983#issuecomment-790718449 https://api.github.com/repos/pydata/xarray/issues/4983 MDEyOklzc3VlQ29tbWVudDc5MDcxODQ0OQ== observingClouds 43613877 2021-03-04T15:52:38Z 2021-03-04T15:53:22Z CONTRIBUTOR

I didn't thought of using da.time.dt.floor("D"). This is indeed great to know, but as there seems to be more folks who are expecting da.time.dt.date to work, so I'd still like to see this implemented.

The time attribute that is already implemented has the same issue that it does not exists in cftime: ```python import numpy as np import pandas as pd import xarray as xr

attrs = {"units": "hours since 3000-01-01"} ds = xr.Dataset({"time": ("time", [0, 1, 2, 3], attrs)}) xr.decode_cf(ds).time.dt.time

AttributeError: 'CFTimeIndex' object has no attribute 'time'

`` I implemented thedateattribute in PR #4994. The usage ofdateandCFTimeIndexraises an explicit AttributeError now and mentions the usage offloor("D")`.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Date missing in datetime accessor 819897789

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]);
Powered by Datasette · Queries took 720.756ms · About: xarray-datasette