search

gridstatus / gridstatusio

Python client for accessing the GridStatus.io Hosted API.
https://www.gridstatus.io
BSD 3-Clause "New" or "Revised" License
26 stars 3 forks source link

Timestamp issue on ERCOT SPP data pull? #16

Closed joshdr83 closed 10 months ago

joshdr83 commented 10 months ago

When I run the example "Retrieving data in local time", I still seeing the timestamp in UTC... It also looks like it isn't lining up with the ERCOT data that I am finding on the website.

image

image

Or the data are 4 hours off?

image

kmax12 commented 10 months ago

it looks like the time zone conversion isn't happening correctly and the date is staying in utc. if the utc conversion is accounted for, this data matches.

what version of the grid status client library are you using?

>>> import gridstatusio
>>> import pandas
>>> gridstatusio.__version__
'0.4.0'
>>> pandas.__version__
'2.0.1'
joshdr83 commented 10 months ago

Here is what I have:

image

kmax12 commented 10 months ago

thanks! i was able to reproduce and fix the error when I downgraded to that version of pandas.

just released version 0.5.0 of gridstatusio. if you upgrade to that, everything should work. let me know if the issue persists or you see any other problems

kmax12 commented 9 months ago

Hi Joshua - im not able to reproduce. can you share the code you are using the versions of pandas and gridstatus that you are using?

image