@extends("base.html") @require(htmlbase, view, pluginbase) @def content():

Text/CSV

Import data from flat-file text/CSV
Martin A. Fitzpatrick

Introduction

This plugin supports loading in data from CSV in a standardised format, with support for labels, classes, scales and data points. You can use this plugin to import data from any source not supported by other plugins by rearranging the data in Excel to fit the template and saving the file as CSV. Loading is semi-intelligent and will attempt to determine how you've laid out the data from headers, etc.

File Format

The format for import is as follows:

Sample/Experiment ID Classification Glucose Citrate Oxaloacetate Pyruvate ...N
1 A 0.4324 0.2343 1.2323 0.9393 0.8823
2 B 0.4030 0.2675 0.5055 0.9342 0.8393
3 B 0.4342 0.3565 0.5552 0.9787 0.8454
... ... ... ... ... ... ...

Note: This layout can be transposed (i.e. with rows as columns and vice versa) if required to fit within the limits of Excel. The correct orientation will be detected and imported data transposed back if neccessary.

Quick start

Arrange data in the correct layout format within Excel and export as CSV. Load the file using this plugin and the data will be displayed on the 'Table' tab. If your data appears to have a continuous scale (e.g. a spectra) a visualisation of this will be shown. If the data cannot be loaded/interpreted correctly an error message will be displayed to try and help.

@end