Skip to content

Instantly share code, notes, and snippets.

View dylanjmcconnell's full-sized avatar

Dylan McConnell dylanjmcconnell

View GitHub Profile
@dylanjmcconnell
dylanjmcconnell / corona.py
Created March 12, 2020 05:48
Gets the latest data from the Johns Hopkins COVID-19 tracker, via GitHub, via Nick
# 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):
@dylanjmcconnell
dylanjmcconnell / coal_2021.csv
Created February 18, 2022 13:04
NEM coal generation 2021 (GWh)
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.
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
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