home / github

Menu
  • Search all tables
  • GraphQL API

issue_comments

Table actions
  • GraphQL API for issue_comments

4 rows where author_association = "NONE" and user = 23510121 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

  • zhonghua-zheng · 4 ✖

issue 1

  • Adding resample functionality to CFTimeIndex 4

author_association 1

  • NONE · 4 ✖
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
465294992 https://github.com/pydata/xarray/issues/2191#issuecomment-465294992 https://api.github.com/repos/pydata/xarray/issues/2191 MDEyOklzc3VlQ29tbWVudDQ2NTI5NDk5Mg== zhonghua-zheng 23510121 2019-02-19T20:22:28Z 2019-02-19T20:22:28Z NONE

@spencerkclark Very helpful!!! Thanks a million! :)

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Adding resample functionality to CFTimeIndex 327089588
464953041 https://github.com/pydata/xarray/issues/2191#issuecomment-464953041 https://api.github.com/repos/pydata/xarray/issues/2191 MDEyOklzc3VlQ29tbWVudDQ2NDk1MzA0MQ== zhonghua-zheng 23510121 2019-02-19T02:22:22Z 2019-02-19T02:22:58Z NONE

@spencerkclark Thank you very much for your help! I will install the development version on my local machine. Currently I am using NCAR Cheyenne to manipulate the climate data. What I am doing on Cheyenne as a detour is: xarray.assign_coords(time = xarray.indexes['time'].to_datetimeindex()) xarray.resample(time="D").mean("time") I hope NCAR will support the next release of xarray. A follow-up question is that when we using xarray to manipulate the large dataset such as <xarray.DataArray (time: 14600, lat: 192, lon: 288)> and want to save the results for further machine learning applications (e.g., using sklearn or XGBoost, even deep learning), what will be a good format to store the data on server or local machine that will be easily used by sklearn or XGBoost?

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Adding resample functionality to CFTimeIndex 327089588
464923777 https://github.com/pydata/xarray/issues/2191#issuecomment-464923777 https://api.github.com/repos/pydata/xarray/issues/2191 MDEyOklzc3VlQ29tbWVudDQ2NDkyMzc3Nw== zhonghua-zheng 23510121 2019-02-18T23:46:46Z 2019-02-18T23:46:59Z NONE

@zzheng93 this will be possible in the next release of xarray, so not quite yet, but soon. If you're in a hurry you could install the development version.

@spencerkclark Thank you very much :) I am new to the Xarray community. I am wondering if there is any instruction regarding installing the latest development version and how to implement the daily resampling function.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Adding resample functionality to CFTimeIndex 327089588
464875401 https://github.com/pydata/xarray/issues/2191#issuecomment-464875401 https://api.github.com/repos/pydata/xarray/issues/2191 MDEyOklzc3VlQ29tbWVudDQ2NDg3NTQwMQ== zhonghua-zheng 23510121 2019-02-18T20:56:02Z 2019-02-18T20:56:02Z NONE

Hi folks, I have some data like 2000-01-01 00:00:00, 2000-01-01 12:00:00, 2000-01-02 00:00:00, 2000-01-02 12:00:00. The index is cftime And I want to take the average within the same date and save the results. I am wondering if it is possible to resample them at a daily level (e.g., the results will be 2000-01-01 00:00:00 and 2000-01-02 00:00:00)?

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Adding resample functionality to CFTimeIndex 327089588

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 13.9ms · About: xarray-datasette