Data Access Library User's Guide
Without data, there is no data analysis. Accessing data is an essential step in any data analysis work flow. The Extreme Optimization Numerical Libraries for .NET provide a unified API for loading and storing objects like data frames, vectors, and matrices from a variety of data sources. The unified API makes it very simple to switch between data sources.
In this section:
Data Files and Data Streams Basic design of the data access library.
Text Files The particulars of text-based formats.
Delimited text files Reading and writing delimited text formats such as Comma Separated Values (CSV) and Tab Separated Values (TSV).
Fixed-width Text Files Reading text files with fixed width columns.
Matrix Market Files A human-readable exchange format for dense or sparse vectors and matrices with real or complex elements.
JSON Serialization Reading and writing files in JSON format. Serializing and deserializing data frames, vectors, and matrices using the JSON.NET library.
Binary data formats
Matlab Files Reading Matlab®'s proprietary .mat file format.
R files Reading and writing files in R's .rda/.rdata and .rds formats.
Stata Files Reading data frames from stata®'s .dta files.
Accessing Databases Reading from data readers and converting to and from data tables.