issue_comments

Table actions

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

  • convert xarray dataset to local timezone · 2 ✖
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
251540980 https://github.com/pydata/xarray/issues/1036#issuecomment-251540980 https://api.github.com/repos/pydata/xarray/issues/1036 MDEyOklzc3VlQ29tbWVudDI1MTU0MDk4MA== shoyer 1217238 2016-10-04T23:17:22Z 2016-10-04T23:17:22Z MEMBER

Do any of the tz_localize or astimezone lines work? If so, that would surprise me. We do not have any methods related to timezone support in xarray.

That said, it should probably work (not tested) to manipulate ds['time'].to_index() as a pandas Index and then save it back in an xarray Dataset.

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