This repository was archived by the owner on Feb 1, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 45
Input file formats
Kathe Todd-Brown edited this page Nov 20, 2017
·
1 revision
Current examples cover flat text files or Excel sheets. These files fall into two formats
- horizontal tales where entries are by row (common)
- vertical tables where entries are by columns (rare)
Multiple tables within data sets are linked via identifies such as site names, profile name, or study name.
For example if there are three tables one with study information
| col1 | col2 |
|---|---|
| study name | Rural urban divide |
| author name | Mary Null |
| institute | Money Pot |
one field site information
| site_name | latitude | longitude | date | biome |
|---|---|---|---|---|
| Super secret site | 45.65 | -69.65 | 2012-07-21 | aquatic |
| Town square | 40.75 | -73.98 | 2000-01-01 | urban |
and a second with layer information.
| site_name | profile_name | soil org C | soil org C (sigma) | soil org C (unit) | soil org C (method) | bulk density (g cm-3) | pH | time on shelf (yrs) |
|---|---|---|---|---|---|---|---|---|
| Super secret site | sediment_10 | 0.3 | 1.2 | g cm-3 | lab method 4 | 1 | 7 | 0 |
| Super secret site | sediment_30 | 0.1 | 2 | g cm-3 | lab method 4 | 1.02 | 3 | 0 |
| Super secret site | sediment_10 | 0.3 | 1.2 | mg cm-3 | lab method 6 | 0.5 | 7 | 10 |