open Deedle

open XPlot.GoogleCharts
open XPlot.GoogleCharts.Deedle

[<Literal>]
let moviesFile = __SOURCE_DIRECTORY__+  @"\..\Data\Movies.csv"

let moviesDf : Frame< int, string > = Frame.ReadCsv( moviesFile )

// Setting the Index of the movies data frame to that of the name of the movie / series
let indexedMoviesDf =
    moviesDf
    |> Frame.indexRowsString "Name"

let movieSeriesDf =
    indexedMoviesDf
    |> Frame.sliceRows[ "The Lord of the Rings Series"; "The Hobbit Series" ]