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
#r "../packages/FSharp.Data.2.0.9/lib/portable-net40+sl5+wp8+win8/FSharp.Data.dll" | |
open FSharp.Data | |
type censusDataContext = CsvProvider<"https://portalvhdspgzl51prtcpfj.blob.core.windows.net/censuschicken/AK.TXT"> | |
type stateCodeContext = CsvProvider<"https://portalvhdspgzl51prtcpfj.blob.core.windows.net/censuschicken/states.csv"> | |
let stateCodes = stateCodeContext.Load("https://portalvhdspgzl51prtcpfj.blob.core.windows.net/censuschicken/states.csv"); | |
let stopwatch = new System.Diagnostics.Stopwatch() |
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
#r "../packages/FSharp.Data.2.0.15/lib/net40/FSharp.Data.dll" | |
open System | |
open System.IO | |
open System.Net | |
open System.Text | |
open FSharp.Data | |
open System.Threading | |
open System.Text.RegularExpressions |
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
//Make sure you install WebApi.Client via Nuget | |
//install-package Microsoft.AspNet.WebApi.Client | |
#r @"C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.5\System.Net.Http.dll" | |
#r @"..\packages\Microsoft.AspNet.WebApi.Client.5.2.2\lib\net45\System.Net.Http.Formatting.dll" | |
open System | |
open System.Net.Http | |
open System.Net.Http.Headers | |
open System.Net.Http.Formatting |
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
#r @"C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.5\System.Net.Http.dll" | |
#r @"..\packages\Microsoft.AspNet.WebApi.Client.5.2.2\lib\net45\System.Net.Http.Formatting.dll" | |
#r @"..\packages\FSharp.Data.2.1.0\lib\net40\FSharp.Data.dll" | |
open System | |
open FSharp.Data | |
open System.Net.Http | |
open System.Net.Http.Headers | |
open System.Net.Http.Formatting | |
open System.Collections.Generic |
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
#r "../packages/FSharp.Data.2.1.1/lib/net40/FSharp.Data.dll" | |
open System.IO | |
open FSharp.Data | |
type context = HtmlProvider<"../data/RealEstateSample.html"> | |
type houseValuation = {addressOne:string; addressTwo:string; addressThree:string; assessedValue:string} | |
let createUri(id: int) = | |
"http://services.wakegov.com/realestate/Account.asp?id=" + id.ToString("D7") |
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
#r "../packages/FSharp.Data.2.1.1/lib/net40/FSharp.Data.dll" | |
open System.Net | |
open System.Text | |
open FSharp.Data | |
type context = HtmlProvider<"../data/HouseSearchSample01.html"> | |
type context' = HtmlProvider<"../data/HouseSearchSample02.html"> | |
type SearchCriteria = {streetTemplateValue:string; |
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
#r "../packages/FSharp.Data.2.1.1/lib/net40/FSharp.Data.dll" | |
#r "../packages/Microsoft.Azure.Documents.Client.0.9.2-preview/lib/net40/Microsoft.Azure.Documents.Client.dll" | |
#r "../packages/Newtonsoft.Json.4.5.11/lib/net40/Newtonsoft.Json.dll" | |
#load "SchoolAssignments.fsx" | |
open System | |
open System.IO | |
open FSharp.Data | |
open System.Linq |
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
#r "../packages/FSharp.Data.2.1.1/lib/net40/FSharp.Data.dll" | |
#r "../packages/Microsoft.Azure.Documents.Client.0.9.2-preview/lib/net40/Microsoft.Azure.Documents.Client.dll" | |
#r "../packages/Newtonsoft.Json.4.5.11/lib/net40/Newtonsoft.Json.dll" | |
#r "C:/Program Files (x86)/Reference Assemblies/Microsoft/Framework/.NETFramework/v4.5.1/System.Net.Http.dll" | |
open System | |
open System.IO | |
open FSharp.Data | |
open System.Linq | |
open Newtonsoft.Json |
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
#Create Wake County Scores From NC State Scores | |
WakeCountyScores <- NCScores[NCScores$District == 'Wake County Schools',] | |
#Join SchoolNameMatch to Wake County Scores | |
WakeCountyScores <- merge(x=WakeCountyScores, y=SchoolNameMatch, by.x="School", by.y="WCPSS") | |
#Join Property Values | |
WakeCountyScores <- merge(x=WakeCountyScores, y=SchoolValuation, by.x="Property", by.y="SchooName") | |
#Remove Property column |
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
namespace Newtonsoft.Json.Converters | |
open Microsoft.FSharp.Reflection | |
open Newtonsoft.Json | |
open System | |
type IdiomaticDuConverter() = | |
inherit JsonConverter() | |
[<Literal>] |
OlderNewer