PEN, Web Services, and Batchsubmit will be unavailable for maintenance from 8:00 - 10:00 PM EST, Sunday April 20th.

Support

Support Options

Submit a Support Ticket

 

inDEED - The CSV File Format

by Rachelle Howell, George A. Howlett

The CSV File Format

The CSV file format was created in order to provide additional information about data files and is optional for researchers. inDEED can utilize a non-formatted data file as long as it is saved as a csv file. An example of the full CSV file format is shown below.

# Project Name
# Project PI(s)
# Project Information…
Sensor_Data raw
Sensor_Name Clock LC_1 SG_1 SG_2
Sensor_Type Clock Load_Cell Strain_Gage Strain_Gage
Sensor_Direction n ns ew
Measurement_Type time force strain strain
Sensor_Unit seconds kip µ µ
Sensor_Time 0
0 0 0.00 0.00
0.5 2 0.010 -0.005

You can view a sample file with headers here: Sample_csv_file.csv (1.81 Kb, uploaded by Rachelle Howell 11 months 3 weeks)


In addition to the full CSV file format, a simplified CSV file format that includes only the sensor names and data can also be utilized by inDEED. The simplified CSV file is useful for projects that organize their data in multiple files. For such projects a single “header” CSV file can be used to load the sensor descriptions (Sensor_Data, Sensor_Name, Sensor_Type, Sensor_Direction, Measurement_Type, Sensor_Unit, and Sensor_Time). The “header” CSV file would contain the sensor descriptions only. The sensor data could be supplied in a single CSV file or multiple CSV files. An example of the simplified CSV file format is shown below.

Clock LC_1 SG_1 SG_2
0 0 0.00 0.00
0.5 2 0.010 -0.005
0.6 2 0.010 -0.005
0.7 1 0.050 -0.003


Any line staring with the # symbol is treated as text and is ignored by the Authoring and inDEED tools. The text lines provide the researcher with the opportunity to provide additional information about the experiment data files. The user can provide any number of text lines as long as they begin with the # symbol.

Additional fields include:

Sensor_Data — Defines the data type. Choices include raw, converted, corrected, or derived.

Sensor_Name — Defines the name of the sensor. The name can be any combination of letters, numbers, or symbols. When time is also provided, the sensor name should be Clock or Time in order to distinguish it from the other sensors.

Sensor_Type — Defines the kind of sensor being used. A full list of the sensor types identified by the inDEED development team can be seen below. It is important to note that the sensor type is case-sensitive and must be capitalized.

  • “Accelerometer”
  • “Acoustic Doppler Velocimeter”
  • “Conductivity Sensor”
  • “Cone Penetrometer”
  • “Displacement”
  • “Dynamic Measurement System”
  • “Inclinometer”
  • “Load Cell”
  • “Linear Variable Differential Transformer”
  • “Linear Position Encoder”
  • “Pressure”
  • “Pressure Transducer”
  • “Pore Pressure Transducer”
  • “Position Transducer”
  • “Strain Gage”
  • “String Potentiometer”
  • “Temperature”
  • “Time”
  • “Turbidity Sensor”
  • “Velocimeter”
  • “Voltage”
  • “Wave Gage”
  • “User Defined”

Sensor_Direction — Defines the orientation of the sensor on the specimen. A full list of the directions identified by the inDEED development team can be seen below. It is important to note that direction is case insensitive.

Description Direction
North South ns
East West ew
Up Down updown
Up up
Down down
North n
South s
East e
West w
Northwest nw
Southwest sw
Northeast ne
Southeast se
None “”

Measurement_Type — Defines the kind of measurement being taken. A full list of the measurement types identified by the inDEED development team can be seen below.

Sensor_Units — Defines the measurement unit for the sensor. It is important to note that this is the measurement unit for the data provided not the expected engineering unit for the sensor. For example, if you provide the raw data for an LVDT that outputs voltage, the “Sensor_Unit” would be volts not units of displacement. A full list of the sensor units identified by the inDEED development team can be seen below.

Measurement Type Units Description
acceleration m/s2 meter per second squared (m/s2)
acceleration cm/s2 centimeter per second squared (cm/s2)
acceleration ft/s2 centimeter per second squared (cm/s2)
acceleration in/s2 centimeter per second squared (cm/s2)
acceleration g gravity (g)
angle rad radians (rad)
angle deg degrees (deg)
angle mil angular mil (mil)
angle grade grade
area km2 kilometer squared (km2)
area m2 meter squared (m2)
area cm2 centimeter squared (cm2)
area in2 inches squared (in2)
area ft2 foot squared (ft2)
conductance S siemens (S)
conductance mS millisiemens (mS)
conductance uS microsiemens (uS)
current A ampere (A)
current C/s coulomb per second (C/s)
damping Ns/m newton second per meter (Ns/m)
density kg/m3 kilogram per meter cubed (kg/m3)
density g/cm3 gram per centimeter cubed (g/cm3)
density mg/L milligrams per liter (mg/L)
density g/L grams per liter (mg/L)
displacement mm millimeter(mm)
displacement cm centimeter (cm)
displacement m meter(m)
displacement km meter(m)
displacement in inch (in)
displacement ft foot (ft)
energy J joule (J)
energy N-m Newton meter(N-m)
energy ft-lbf foot pound force (ft-lbf)
energy erg erg (erg)
energy Wh watt hour (Wh)
energy kWh kilowatt hour (m)
force N newton (N)
force kN kilonewton (kN)
force dyn dyne (dyn)
force lbf pound (lbf)
force kip kilopound (kip)
force kipf kilopound-force (kipf)
force kfp kilopound-force (kipf)
force kf kilopound-force (kipf)
frequency Hz hertz (Hz)
frequency kHz kilohertz (kHz)
frequency MHz megahertz (MHz)
frequency GHz gigahertz (GHz)
frequency THz terahertz (THz)
frequency rpm revolutions per minute (rpm)
frequency ω angular frequency (rad/sec)
impulse Ns newton second (Ns)
impulse dyn-s dyne second (dyn-s)
mass kg kilogram (kg)
mass g gram (g)
mass ton ton
mass lb pound
momentum kgm/s kilogram-meter per second (kgm/s)
momentum gcm/s gram-centimeter per second (gcm/s)
pressure/stress Pa pascal (Pa)
pressure/stress kPa kilopascal (kPa)
pressure/stress MPa megapascal (kPa)
pressure/stress GPa (GPa)
pressure/stress dyn/cm2 dyne per centimeter squared (dyn/cm2)
pressure/stress N/m2 newton per meter squared (N/m2)
pressure/stress psi pounds per square inch (psi)
pressure/stress ksi kilopounds per square inch (ksi)
pressure/stress psf pounds per square foot (psf)
pressure/stress atm atmosphere (atm)
pressure/stress bar bar
resistance ohm ohm
strain mm/mm millimeter per millimeter (mm/mm)
strain in/in inch per inch (in/in)
strain µ micro-strain (µ)
temperature C centigrade ©
temperature K kelvin (K)
temperature F fahrenheit (F)
time s second (s)
time m minute (m)
time h hour (h)
time ms millisecond (ms)
turbidity NTU Nephelometric Turbidity Units (NTU)
turbidity FTU Formazin Turbidity Units (FTU)
turbidity JTU Jackson Turbidity Units (JTU)
turbidity FNU Formazin Nephelometric Units (FNU)
velocity m/s meter per second (m/s)
velocity cm/s centimeter per second (cm/s)
voltage V volt (V)
voltage mV millivolt (mV)
volume ft3 cubic feet (ft3)
volume m3 cubic meter (m3)
volume cm3 cubic centimeter (cm3)
volume L liters (L)
volume mL milliliters (mL)
user  ? User defined

Created on , Last modified on