Home

User Documentation

Getting Started
Learn More
Explore in Detail
Get Inspired

Contributor Documentation

Getting Started
Learn More
Explore in Detail
Get Inspired

Quick Links

Software Manual
AstroDiscuss
GitHub
API Reference

Documentation Versions

Public Release
8.2.0
8.1.0
8.0.0
7.2.0
7.1.0
7.0.0
6.0.0
3.9.0
3.5.0

ISIS 2

Documentation
Tutorials
Technical Documents
USGS

ISIS Application Documentation


csv2table

Printer Friendly View | TOC | Home

Convert a CSV file to a table and attach it to a cube

Overview Parameters Example 1

Description

This application converts a CSV file to a table and attaches it to a cube. The first row of the CSV will be used as the fieldnames for the table. The contents of the CSV file will be converted to floating point numbers before they are inserted into the table.

A single table field with multiple values will be created for consecutive CSV columns with the same column name followed by an index inside parentheses. The index must start at zero and increase from left to right. For example a CSV header line like: "A, B(0), B(1), B(2), C", will create three table fields, A with size=1, B with size=3, and C with size=1.


Categories


Related Objects and Documents

Applications


History

Jesse Mapel2018-09-04 Original version
Stuart Sides2021-03-20 Added ability to convert CSV files with indicies into table field arrays instead of individual table fields.

Parameter Groups

Files

Name Description
csvInput CSV filename
labelInput table label PVL filename
toOutput cube filename

Table

Name Description
tablenameThe name of the table
X

Files: csv


Description

Input CSV filename. The first row of this file will be used as the table field names.

Type filename
File Mode input
Filter *.csv
Close Window
X

Files: label


Description

Input table label PVL filename. This is expected to be a flat PVL file where all of the keywords and their values will be added to the tabel label.

Type filename
File Mode input
Internal Default None
Filter *.pvl
Close Window
X

Files: to


Description

Output cube filename that the table will be attached to

Type cube
File Mode output
Filter *.cub
Close Window
X

Table: tablename


Description

A table will be created with this name on the output cube using the data from the CSV file. If a table with this name already exists on the cube it will be overwritten.

Type string
Close Window

Example 1

Write a simple table

Description

Write a simple csv file to a cube.

Command Line

csv2table csv=test.csv tablename=TestTable to=isisTruth.cub
In this example, csv2table will write a table called TestTable on isisTruth.cub with the contents of test.csv.