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.

Overview

In this section:

Text-based formats

  • 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.

Databases