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
install.packages("dplyr") | |
install.packages("ChainLadder") | |
library(ChainLadder) | |
library(dplyr) | |
# Based on this documentation here: https://rdrr.io/cran/ChainLadder/man/qpaid.html | |
applyProjectionMethod <- function(rectTriangle, projectionMethod) { | |
originYearCount <- nrow(rectTriangle) |
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/ExcelDataReader/lib/net45/Excel.dll" | |
#r "../packages/SharpZipLib/lib/20/ICSharpCode.SharpZipLib.dll" | |
open Excel | |
open System.IO | |
open System.Data | |
open System.Xml | |
let extractData fileName sheetName = | |
use stream = File.Open(fileName, FileMode.Open, FileAccess.Read) |
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
// Comparison of Basic Data Analysis using Core Seq, Array functions and FLinq | |
open System | |
// Test Data | |
let scoreData = | |
[| ("Jack", 4000); ("Jack", 5000); ("Jill", 3000); ("Tom", 1000); ("Jill", 6000) |] | |
let regionData = | |
[| ("Jack", "Region 1"); ("Sally", "Region 2"); ("Tom", "Region 3") |] |