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. Extreme Numerics.NET provides 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-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

• Accessing Databases Reading from data readers and converting to and from data tables.