An online plankton time-series analysis and visualization toolkit.
Data Format Instructions:|
General Data Layout and Format Concept:|
COPEPODITE will read incoming time-series data in a simple,keyword-labeled, comma-delimited ("comma separated values", CSV) format. This format can be generated by Excel and many other database/statistical/spreadsheet programs. The COPEPODITE data format consists of a single row of "column headers", the gray-colored first row in the table shown below, followed by multiple rows of date and/or data values.
Format Rule #1: The very first row must contain the column labels (e.g., DATE-YMD, ABND=, BIOM=, TEMP=, ...).
Format Rule #2: The first column must be a date column (e.g., DATE-YMD, DATE-MDY, or DATE-DMY).
Format Rule #2a (temporary): The second column must be either an "ABND" or "BIOM" data type.
Formatting Hints, Tips, and Tricks:
The purpose of the "#" ignore option is to allow you to quickly "remove/restore" anomalous values from a data file without permanently removing them. If you remove the value instead, it will be harder to restore it in the future. This on/off toggle lets you play around with large/small values to see how they influence the analysis results.
... ... ... Data Format instructions continue after the table below ... ...
|# Comments||Any comment or text here||Any comment or text here||Any comment or text here||Any comment or text here|
|2005-11-07||# lost sample||Oct/29/2005||173||# -100.25 (??)||05_11_2005||19|
DATE columns and Date Formats:|
The current version of COPEPODITE has base time unit is "monthly means".
This means that if you provide weekly or daily data, it will be binned and averaged into a single monthly value for that month of that year.
(Monthly bins will soon be expanded to optional "weekly means"x, to accommodate the WG137 and WGPME phytoplankton data needs. At that point, you will be given an option to select either monthly or weekly bins in the COPEPODITE processing menu.)
It is quite common to have different sampling intervals (dates) for the plankton than for the other variables. You might have monthly or seasonal zooplankton date, weekly chlorophyll data, and perhaps daily temperature data. COPEPODITE will read all of these and correctly match up and synchronzie the data for you (currently to monthly bins).
In the example table above, the biomass data and abundance data and temperature data all have different sampling dates (and formats). The COPEPODITE software will bin them into monthly means and then synchronize them into matching month+year date sets. (This means the temperature data, although taken on different days, will sync with the corresponding biomass and abundance data for that month!).
Format Rule #3: Each column of data values is assigned to belong to the first date column found to its left. You can have a single date column with 15 data columns following it, you can have 15 paired "date + data" column pairs, or any mixture you desire. The general idea is to make your set up of the data file as easy as possible.
Format Rule #4: COPEPODITE currently only recognizes three general data formats:
Format Rule #5: Your data format must remain consistent within each individual date column (ie, do not switch from YMD to MDY or DMY within a single date column). You may have multiple different date format COLUMNS in the spreadsheet (like the table above).
DATA (variable) columns Types:|
All COPEPODITE data columns must be labeled with four character + "=" variable indicator (e.g., "BIOM=", "ABND=", ...). The text immediately following that indicator keyword can be whatever you desire and will be used to describe the variable in column (e.g., "BIOM= Total Wet Mass (mg/m3)", "BIOM= Total Dry Mass (mg/m3)"). This "text to the right of the keyword" will be used in all of the plots and figures showing the variable.
Please make that your variable text does not contain any commas (e.g., "Calanus finmarchicus, adults, , female"). These extra commas will corrupt the comma-separated-values data format and cause your data to fail the preview step. Also, at this time please do not include any Greek or mathematical symbols (e.g., the degrees symbol or the "u" ("mu" or micro) symbol), as they will cause the header text to get cut short (the rest of the description text will not be shown in the plots).
Format Rule #6: COPEPODITE currently only recognizes these Variable Indicators:
Format Rule #7: Your data values must NOT already be "log transformed".
Per the WG125/WGZE analysis method, all biological values will be log10 transformed during the processing steps.
If your data are already log transformed, and you can not easily reverse them, you can try using the "OTHR=" header to at least visualize the values, but the results will not be 100% identical to the WG125/WGZE method results.
Special Grouping Options:
This option is currently in testing mode. Listed are the "April 2011" grouping rules, which may change in a later update.
Currently the COPEPODITE "group plot" is focused on allowing a user to plot multiple years of taxa (ABND=) or nutrient variables (LOTH=) in a single plot.
This is done by identifying the group membership with a one or two digit number (e.g., the "ABND1=" column header in the example table earlier in this document indicates "Group 1").
Any taxa data associated with "ABND1=" will be plotted in a separate graph from "ABND2=" (e.g., so you could plot "copepods species" using ABND1= and "diatom species" using ABND2= ).
Currently, different variable types do not cross-group (e.g., "ABND1=" and "BIOM1=" are treated and plotted as completely different groups.)
Group plots are shown in both "log10" and "raw" value format (see examples below), because the results and usefulness of either plot depends on the data, the distribution of values, and what you are looking for within the data. Below are examples of the same data plotted in both "log10" and "raw" format.
This section is under construction. Please email Todd directly with any questions or problems (Todd.OBrien@noaa.gov).
Powered by NAUPLIUS