Skip to content

Commit

Permalink
improve documentation
Browse files Browse the repository at this point in the history
  • Loading branch information
nhirschey committed Feb 21, 2021
1 parent 4697bfd commit 27e3573
Showing 1 changed file with 13 additions and 3 deletions.
16 changes: 13 additions & 3 deletions docs/library/CsvProvider.fsx
Original file line number Diff line number Diff line change
Expand Up @@ -236,9 +236,19 @@ rows separated by either semicolon or a colon. You can use:
It is quite common in statistical datasets for some values to be missing. If
you open the [`data/AirQuality.csv`](../data/AirQuality.csv) file you will see
that some values for the ozone observations are marked `#N/A`. Such values are
parsed as float and will be marked with `Double.NaN` in F#. The values `#N/A`, `NA`,
and `:` are recognized as missing values by default, but you can customize it by specifying
the `MissingValues` static parameter of `CsvProvider`.
parsed as float and will be marked with `Double.NaN` in F#. The values
"NaN", "NA", "N/A", "#N/A", ":", "-", "TBA", and "TBD"
are recognized as missing values by default, but you can customize it by specifying
the `MissingValues` static parameter of `CsvProvider` as a comma-separated string.
For example, to ignore "this" and "that" we could do:
*)


CsvProvider<"X,Y,Z\nthis,that,1.0",
MissingValues="this,that">.GetSample().Rows
(*** include-it ***)

(**
The following snippet calculates the mean of the ozone observations
excluding the `Double.NaN` values. We first obtain the `Ozone` property for
Expand Down

0 comments on commit 27e3573

Please sign in to comment.