john bush johntbush
johntbush
/ gist:7f2ba8d7c4771664693e2b416869a8cf
Last active
August 7, 2017 19:35
sample rating metrics from CDC message
This file contains hidden or 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
| { | |
| "type": "update", | |
| "msg": { | |
| "env_id": "af44d7ff-c069-482b-aee8-82f0a562ca99", | |
| "env_name": "HPi EMEA Prod", | |
| "database": "HPiProd", | |
| "sql_dns": "HPiProdSQL.traxtech.com", | |
| "table": "EXCEPTIONS", | |
| "updated_date": "2017-08-07T18:15:14Z", | |
| "is_delete": false, |
johntbush
/ gist:2c9817717f20a74a180480d5bb349820
Last active
August 7, 2017 19:35
rating metrics from source
This file contains hidden or 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
| { | |
| "type" : "source", | |
| "data" :{ | |
| "VendLabl": "TNT", | |
| "FbId": "FBLL1000681002182280595", | |
| "FbNId": 3.2013620087288801E18, | |
| "BilledAmt": 2.52, | |
| "BilledCurrency": "EUR", | |
| "RatedAmt": 2.52, | |
| "RatedCurrency": "EUR", |
This file contains hidden or 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
| import pandas as pd | |
| import timeit | |
| import numpy as np | |
| import StringIO | |
| import io | |
| def generate_csv(width,height): | |
| df = pd.DataFrame(np.random.randint(0, 1000000, size=(height, width))) |
johntbush
/ implicit_params.scala
Last active
April 6, 2017 03:48
This file contains hidden or 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
| def p(implicit i:Int) = print(i) | |
| implicit val v=2 | |
| p | |
| p(1) | |
| //legal | |
| def pp(a:Int)(implicit i:Int) = println(a,i) | |
| def pp(a:Int)(implicit i:Int, b:Long) = println(a,i,b) | |
| def pp(implicit i:Int, b:Long) = println(i,b) |
This file contains hidden or 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
| /* | |
| A pattern match includes a sequence of alternatives, each starting with the keyword case. | |
| Each alternative includes a pattern and one or more expressions, which will be evaluated | |
| if the pattern matches. An arrow symbol => separates the pattern from the expressions. | |
| */ | |
| def matchTest(x: Int): String = x match { | |
| case 1 => "one" | |
| case 2 => "two" |
This file contains hidden or 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
| val optionHelloWorld = Option("Hello World") | |
| val optionNil:Option[String] = None | |
| Option(null) | |
| if (optionHelloWorld.isDefined) optionHelloWorld.get | |
| if (optionNil.isEmpty) "nothing here" | |
| if (optionHelloWorld.isDefined) optionHelloWorld.get else "nothing here" |
johntbush
/ gist:c9424089c81147d27987a186dea26d09
Created
February 10, 2017 16:08
This file contains hidden or 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
| { | |
| "RateDetails": { | |
| "FbId": "FBLL1000691004813140001", | |
| "LineNum": 3, | |
| "RateScac": "KWEO_Onesource", | |
| "TemplateId": "41228.40293", | |
| "ICSNum": "663485", | |
| "RatingCategory ": "RatedEqualsBilledUnvalidated", | |
| "RatingDetails": "Rated at 12 USD Flat using AirOceanAccessorials in ICS 663485 for KWEO_Onesource for accessorial for this shipment EffectiveDate (10/25/2016 12:00:00 AM), ChargeCode (DFO), Qualifier (ORIGIN HANDLING AND DOCUM), OriginPort_Airport (THBKK), OriginCity (PHET BURI), OriginCountry (TH), OriginPostalCodeRange (10110), DestinationPort_Airport (CNSHA), DestinationCity (SHANGHAI), DestinationCountry (CN), DestinationPostalCodeRange (200131), ServiceLevel (LCL), ServiceScope (LCL), WeightRange (1000), QuantityRange (1). This is rated equals billed at 12 USD ..These are unknown missing LocationID, Subcarrier, OriginState, OriginZone, OriginRegion, DestinationState, DestinationZone, DestinationRegion, EquipmentType, FlowIndentifier, MileageBandRange.These are undefined Qualifier (ORIGIN HANDLI |
johntbush
/ gist:86eecd5fb0b9242c4e388ff7aa92b9c1
Created
January 23, 2017 23:42
This file contains hidden or 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
| import requests | |
| import json | |
| def reimport(id): | |
| r = requests.get("{}/config/{}".format(sheets_api, id)).json() | |
| data = r['data'] | |
| print str('loaded: ' + str(data)) | |
| requests.delete("{}/config/{}".format(sheets_api, id)) | |
| partitionkeys = data['partitionkeys'] | |
| default = data['default'] |
johntbush
/ gist:3a182a8258d6d402beef45aa62b147f4
Last active
December 29, 2016 15:36
This file contains hidden or 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
| { | |
| "concept" : "bill weight qualifier", | |
| "description" : "normalize the FB_WT_QUAL field that is part of the FRGHT_BL ", | |
| "rules" : [ | |
| { | |
| "field" : "AL_CNTRY_CODE_ORIG", | |
| "rules" : [ | |
| { | |
| "type":"expr", | |
| "expression" :"AL_CNTRY_CODE_ORIG IN ('US','USA','UNITED STATES')", |
johntbush
/ gist:c66266f9ff94730377969f174a566665
Created
December 28, 2016 23:13
This file contains hidden or 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
| /****** Object: StoredProcedure [DNorm].[usp_Data_ModeDerivation] Script Date: 12/21/2016 12:36:54 PM ******/ | |
| SET ANSI_NULLS ON | |
| GO | |
| SET QUOTED_IDENTIFIER ON | |
| GO | |
| use NormLogic | |
| Go |