F# Data


Namespace: FSharp.Data.Runtime

Structural inference for CSV

Type extensions

Type extensionDescription
Signature: (inferRows:int * missingValues:string [] * cultureInfo:CultureInfo * schema:string * assumeMissingValues:bool * preferOptionals:bool * unitsOfMeasureProvider:IUnitsOfMeasureProvider option) -> PrimitiveInferedProperty list

Infers the types of the columns of a CSV file Parameters: inferRows - Number of rows to use for inference. If this is zero, all rows are used missingValues - The set of strings recogized as missing values cultureInfo - The culture used for parsing numbers and dates schema - Optional column types, in a comma separated list. Valid types are "int", "int64", "bool", "float", "decimal", "date", "guid", "string", "int?", "int64?", "bool?", "float?", "decimal?", "date?", "guid?", "int option", "int64 option", "bool option", "float option", "decimal option", "date option", "guid option" and "string option". You can also specify a unit and the name of the column like this: Name (type<unit>). You can also override only the name. If you don't want to specify all the columns, you can specify by name like this: 'ColumnName=type' assumeMissingValues - Assumes all columns can have missing values preferOptionals - when set to true, inference will prefer to use the option type instead of nullable types, double.NaN or "" for missing values * unitsOfMeasureProvider - optional function to resolve Units of Measure

CompiledName: CsvFile.InferColumnTypes

Fork me on GitHub