This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# This script will get the latest data from the Jons Hopkins GitHub repo https://github.com/CSSEGISandData | |
# Loads into data frame (doesn't save) and parses dates, - in long form by default. | |
# Modified from Nick Evershed's version https://gist.github.com/nickjevershed | |
import requests | |
import pandas as pd | |
import datetime | |
from io import BytesIO | |
def getData(_long=True): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DUID | ENERGY | |
---|---|---|
BW01 | 3968.365133 | |
BW02 | 2623.948049 | |
BW03 | 3928.011757 | |
BW04 | 3927.731316 | |
ER01 | 3305.976061 | |
ER02 | 3528.751854 | |
ER03 | 3908.614273 | |
ER04 | 2402.080655 | |
GSTONE1 | 554.183107 |
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SETTLEMENTDATE,TUMUT3,SNOWYP | |
2020-01-01 00:00:00,0.0,0.0 | |
2020-01-01 00:05:00,0.0,0.0 | |
2020-01-01 00:10:00,0.0,0.0 | |
2020-01-01 00:15:00,0.0,0.0 | |
2020-01-01 00:20:00,0.0,0.0 | |
2020-01-01 00:25:00,0.0,0.0 | |
2020-01-01 00:30:00,0.0,0.0 | |
2020-01-01 00:35:00,0.0,0.0 | |
2020-01-01 00:40:00,0.0,0.0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
index | dayofyear | temp | year | |
---|---|---|---|---|
0 | 0 | 12.311 | 1979 | |
1 | 1 | 12.293 | 1979 | |
2 | 2 | 12.274 | 1979 | |
3 | 3 | 12.23 | 1979 | |
4 | 4 | 12.273 | 1979 | |
5 | 5 | 12.299 | 1979 | |
6 | 6 | 12.214 | 1979 | |
7 | 7 | 12.237 | 1979 | |
8 | 8 | 12.222 | 1979 |