this method is called by the previous method when reading in a CSV file. It is used only to get csv data into a column format so that the data type for each field can be determined.

Declaration

public static List<string[]> ConvertCSVRowsToListOfStringArrays(string[] csvRows, int rowStart, int rowEnd)

Parameters

Type	Name	Description
String[]	csvRows
Int32	rowStart
Int32	rowEnd

Returns

Type	Description
List<String[]>

| Improve this Doc View Source

DataTable2CSV(DataTable, String)

Declaration

public static void DataTable2CSV(DataTable dt, string strFilePath)

Parameters

Type	Name	Description
DataTable	dt
String	strFilePath

| Improve this Doc View Source

MakeItemArray(String[], Type[])

Declaration

public static object[] MakeItemArray(string[] fields, Type[] types)

Parameters

Type	Name	Description
String[]	fields
Type[]	types

Returns

Type	Description
Object[]

| Improve this Doc View Source

ReadColumnOfCsvFile(String, Int32, out String)

Returns the requested column of data from a CSV file and also returns the column header.

Declaration

public static double[] ReadColumnOfCsvFile(string fileName, int colNumber, out string header)

Parameters

Type	Name	Description
String	fileName
Int32	colNumber
String	header

Returns

Type	Description
Double[]

| Improve this Doc View Source

ReadCSVFile(String)

returns a list of the column values in a csv file plus the column headings ASSUMED to be doubles returns as lists of type double TODO Anthony to use the new U-BEAUT csv file reader.

Declaration

public static Tuple<List<string>, List<double[]>> ReadCSVFile(string csvFileName)

Parameters

Type	Name	Description
String	csvFileName

Returns

Type	Description
Tuple<List<String>, List<Double[]>>

| Improve this Doc View Source

ReadCSVFile2Dictionary(String)

returns a Dictionary of the column values in a csv file with column headings as keys ASSUMED to be doubles TODO Anthony to use the new U-BEAUT csv file reader.

Declaration

public static Dictionary<string, double[]> ReadCSVFile2Dictionary(string csvFileName)

Parameters

Type	Name	Description
String	csvFileName

Returns

Type	Description
Dictionary<String, Double[]>

| Improve this Doc View Source

ReadCSVFile2Matrix(String)

Declaration

public static double[, ] ReadCSVFile2Matrix(string csvFileName)

Parameters

Type	Name	Description
String	csvFileName

Returns

Type	Description
Double[,]

| Improve this Doc View Source

ReadCSVFileOfDoubles(String, Boolean, Boolean)

Declaration

public static List<double[]> ReadCSVFileOfDoubles(string csvFileName, bool skipHeader, bool skipFirstColumn)

Parameters

Type	Name	Description
String	csvFileName
Boolean	skipHeader
Boolean	skipFirstColumn

Returns

Type	Description
List<Double[]>

| Improve this Doc View Source

ReadCSVToTable(String, Boolean)

reads a CSV file into a Datatable and deduces the data type in each column.

Declaration

public static DataTable ReadCSVToTable(string filePath, bool isFirstRowHeader)

Parameters

Type	Name	Description
String	filePath
Boolean	isFirstRowHeader

Returns

Type	Description
DataTable

| Improve this Doc View Source

ReadCSVToTable(String, Boolean, Type[])

loads a data table with data in given csv file. If the column types are not given then default to string CALLED ONLY BY KIWI RECOGNIZER TO READ GROUND TRUTH TABLE.

Declaration

public static DataTable ReadCSVToTable(string filePath, bool isFirstRowHeader, Type[] types)

Parameters

Type	Name	Description
String	filePath
Boolean	isFirstRowHeader
Type[]	types

Returns

Type	Description
DataTable

| Improve this Doc View Source

WriteDictionaryOfDoubles2CSV(Dictionary<String, Double[]>, FileInfo)

Declaration

public static void WriteDictionaryOfDoubles2CSV(Dictionary<string, double[]> dictionary, FileInfo opFile)

Parameters

Type	Name	Description
Dictionary<String, Double[]>	dictionary
FileInfo	opFile