| # MIT No Attribution | |
| # | |
| # Copyright 2022 Ben Kehoe | |
| # | |
| # Permission is hereby granted, free of charge, to any person obtaining a copy of this | |
| # software and associated documentation files (the "Software"), to deal in the Software | |
| # without restriction, including without limitation the rights to use, copy, modify, | |
| # merge, publish, distribute, sublicense, and/or sell copies of the Software, and to | |
| # permit persons to whom the Software is furnished to do so. | |
| # |
| ZIP,LAT,LNG | |
| 00601,18.180555, -66.749961 | |
| 00602,18.361945, -67.175597 | |
| 00603,18.455183, -67.119887 | |
| 00606,18.158327, -66.932928 | |
| 00610,18.295366, -67.125135 | |
| 00612,18.402253, -66.711397 | |
| 00616,18.420412, -66.671979 | |
| 00617,18.447538, -66.557681 |
| ## split apply combine by various R idioms | |
| d <- data.frame(x = rnorm(10), group = 1:10, index = 1:10) | |
| modfun <- function(x, offset = NULL) { | |
| if (is.null(offset)) offset <- -3:5 | |
| x <- x[rep(1, each = length(offset)), ] | |
| ## modify? (a dummy example, but we used similar with real data) | |
| x$index <- x$index + offset | |
| x | |
| } | |
| ## apply to expand the rows out by modfun |
| -- Code came from the article here:' | |
| -- https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/ | |
| --Declare temp table to drive later tables | |
| DECLARE @StartDate DATE = '20000101', @NumberOfYears INT = 30; | |
| -- prevent set or regional settings from interfering with | |
| -- interpretation of dates / literals | |
| SET DATEFIRST 7; |
This script can help you find and remove unused AWS snapshots and volumes.
There is hardcoded list of regions that it searches, adjust the value to suit your needs.
Use snapshot.py snapshot-report to generate report.csv containing information about all snapshots.
snapshot.py snapshot-cleanup lets you interactively delete snapshot if it finds it is referencing unexisting resources.
./snapshots.py --help
| import json, datetime | |
| class RoundTripEncoder(json.JSONEncoder): | |
| DATE_FORMAT = "%Y-%m-%d" | |
| TIME_FORMAT = "%H:%M:%S" | |
| def default(self, obj): | |
| if isinstance(obj, datetime.datetime): | |
| return { | |
| "_type": "datetime", | |
| "value": obj.strftime("%s %s" % ( |
| """ | |
| Invocation: python time_dimension.py [start_date] [end_date] | |
| """ | |
| from datetime import datetime, timedelta | |
| import sys | |
| start_date = datetime.strptime(sys.argv[1], '%Y-%m-%d') | |
| end_date = datetime.strptime(sys.argv[2], '%Y-%m-%d') |