issue_comments

Table actions

1 row where issue = 181005061 and user = 12929592 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

  • slharris · 1 ✖

issue 1

  • convert xarray dataset to local timezone · 1 ✖

author_association 1

id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
251577702 https://github.com/pydata/xarray/issues/1036#issuecomment-251577702 https://api.github.com/repos/pydata/xarray/issues/1036 MDEyOklzc3VlQ29tbWVudDI1MTU3NzcwMg== slharris 12929592 2016-10-05T04:14:59Z 2016-10-05T04:14:59Z NONE

Thank you - ds['time'].to_index() seems to work but I am having trouble replacing the UTC time in the ds with the converted local time in my new ds. I am using .update() because I want to override the original time. However, the time does not seem to have been changed following this step.

import pandas as pd import xray import pytz

ds = xray.open_mfdataset('/DATA/WRF///*T_SFC.nc')

time=ds['time'].to_index()

time_utc = time.tz_localize(pytz.UTC) au_tz = pytz.timezone('Australia/Sydney') time_local = time_utc.tz_convert(au_tz)

convert pandas datetimeindex to a series and then series to xarray dataarray and then to xray dataset

local_series=time_local.to_series() local_da=xray.DataArray.from_series(local_series) local_ds=xray.DataArray.to_dataset(local_da)

create a new dataset that replaces/updates the UTC time in the original dataset with the local time from the newly created dataset (in pandas)

new_ds=ds.update(local_ds)

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   convert xarray dataset to local timezone 181005061

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