COPEPODITE Incoming Data Review

Fatal Format Issues:   none


    Mild Data Warnings (non-numeric values):   19    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.




HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2    [ABDT1= Bacteria (#/ml) via DAPI]      ( date set 1 )
    Column # 3    [ABDT1= Bacteria (#/ml) via DAPI]      ( date set 1 )
    Column # 4    [ABDT1= Bacteria (#/ml) via DAPI]      ( date set 1 )
    Column # 5    [OTHR= Bacteria Production via Leu-BP (ugC/l/d)]      ( date set 1 )
    Column # 6    [ABDT= Synechococcus (#/ml) via DAPI]      ( date set 1 )
    Column # 7     [ABDT= Phototrophic Nanoflagellates [PNF] (#/ml) via DAPI]      ( date set 1 )
    Column # 8     [ABDT2= Heterotrophic Nanoflagellates [HNF] (#/ml) via DAPI]      ( date set 1 )
    Column # 9    [ABDT2= HNF (#/ml) via DAPI]      ( date set 1 )
    Column # 10    [ABDT2= HNF (#/ml) via DAPI]      ( date set 1 )
    Column # 11    [ABDT= LNA (#/ml) via FC]      ( date set 1 )
    Column # 12    [ABDT= HNA (#/ml) via FC]      ( date set 1 )
    Column # 13    [ABDT= Bacteria (#/ml) via FC]      ( date set 1 )
    Column # 14    [ABDT= Bacteria (#/ml) via FC]      ( date set 1 )
    Column # 15    [OTHR= % HNA (#/ml) via FC]      ( date set 1 )
    Column # 16    [ABDT= Prochlorococcus (#/ml) via FC]      ( date set 1 )
    Column # 17    [ABDT= Synechococcus (#/ml) via FC]      ( date set 1 )
    Column # 18    [ABDT= Picoeukaryotes-1 (#/ml) via FC]      ( date set 1 )
    Column # 19    [ABDT= Peuk-2/Nano (#/ml) via FC]      ( date set 1 )
    Column # 20    [ABDT= Cryptos (#/ml) via FC]      ( date set 1 )

    Column # 21     [ DATE-DMY ]       Date Set = 2
    Column # 22    [TEMP= Temperature ( C )]      ( date set 2 )
    Column # 23    [OTHR= Secchi Depth (m)]      ( date set 2 )
    Column # 24    [PSAL= Salinity ()]      ( date set 2 )
    Column # 25    [CHLA= Chlorophyll (ug/m3)]      ( date set 2 )
    Column # 26    [LOTH= PO4 (um)]      ( date set 2 )
    Column # 27    [LOTH= NH4 (um)]      ( date set 2 )
    Column # 28    [LOTH= NO2 (um)]      ( date set 2 )
    Column # 29    [LOTH= NO3 (um)]      ( date set 2 )
    Column # 30    [LOTH= Silicate (um)]      ( date set 2 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Bacteria (#/ml) via DAPI ]
        Column # 3   [ ABDT1= Bacteria (#/ml) via DAPI ]
        Column # 4   [ ABDT1= Bacteria (#/ml) via DAPI ]
        Column # 6   [ ABDT= Synechococcus (#/ml) via DAPI ]
        Column # 7   [ ABDT= Phototrophic Nanoflagellates [PNF] (#/ml) via DAPI ]
        Column # 8   [ ABDT2= Heterotrophic Nanoflagellates [HNF] (#/ml) via DAPI ]
        Column # 9   [ ABDT2= HNF (#/ml) via DAPI ]
        Column # 10   [ ABDT2= HNF (#/ml) via DAPI ]
        Column # 11   [ ABDT= LNA (#/ml) via FC ]
        Column # 12   [ ABDT= HNA (#/ml) via FC ]
        Column # 13   [ ABDT= Bacteria (#/ml) via FC ]
        Column # 14   [ ABDT= Bacteria (#/ml) via FC ]
        Column # 16   [ ABDT= Prochlorococcus (#/ml) via FC ]
        Column # 17   [ ABDT= Synechococcus (#/ml) via FC ]
        Column # 18   [ ABDT= Picoeukaryotes-1 (#/ml) via FC ]
        Column # 19   [ ABDT= Peuk-2/Nano (#/ml) via FC ]
        Column # 20   [ ABDT= Cryptos (#/ml) via FC ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 26   [ LOTH= PO4 (um) ]
        Column # 27   [ LOTH= NH4 (um) ]
        Column # 28   [ LOTH= NO2 (um) ]
        Column # 29   [ LOTH= NO3 (um) ]
        Column # 30   [ LOTH= Silicate (um) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 5   [ OTHR= Bacteria Production via Leu-BP (ugC/l/d) ]
        Column # 15   [ OTHR= % HNA (#/ml) via FC ]
        Column # 23   [ OTHR= Secchi Depth (m) ]

    Temperatures Category
        Column # 22   [ TEMP= Temperature ( C ) ]

    Salinities Category
        Column # 24   [ PSAL= Salinity () ]

    Chlorophyll/Pigments Category
        Column # 25   [ CHLA= Chlorophyll (ug/m3) ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Bacteria (#/ml) via DAPI ]
        column # 3     [ ABDT1= Bacteria (#/ml) via DAPI ]
        column # 4     [ ABDT1= Bacteria (#/ml) via DAPI ]

    Category 8 Group # 2
        column # 8     [ ABDT2= Heterotrophic Nanoflagellates [HNF] (#/ml) via DAPI ]
        column # 9     [ ABDT2= HNF (#/ml) via DAPI ]
        column # 10     [ ABDT2= HNF (#/ml) via DAPI ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1992 2012
DATES in Column 21 no problems detected 1992 2012

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 1 31 1 12 1992 2012
21 DATE-DMY DATE-DMY yes 1 31 1 12 1992 2012



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Bacteria (#/ml) via DAPI ]
no problems detected 114 380996.656 1939619.38 114
( 100%)
114
( 100%)
Column 3 :
[ 05_ABDT1= Bacteria (#/ml) via DAPI ]
no problems detected 344 24000. 1870000. 344
( 100%)
344
( 100%)
Column 4 :
[ 06_ABDT1= Bacteria (#/ml) via DAPI ]
no problems detected 458 24000. 1939619.38 458
( 100%)
458
( 100%)
Column 5 :
[ 07_OTHR= Bacteria Production via Leu-BP (ugC/l/d) ]
no problems detected 132 0.0415927134 44.7144012 132
( 100%)
80
( 60%)
Column 6 :
[ 08_ABDT= Synechococcus (#/ml) via DAPI ]
no problems detected 134 705.549377 139987.406 134
( 100%)
134
( 100%)
Column 7 :
[ 09_ABDT= Phototrophic Nanoflagellates [PNF] (#/ml) via DAPI ]
no problems detected 136 753.122742 40049.1641 136
( 100%)
136
( 100%)
Column 8 :
[ 10_ABDT2= Heterotrophic Nanoflagellates [HNF] (#/ml) via DAPI ]
no problems detected 136 166.762894 4397.68896 136
( 100%)
136
( 100%)
Column 9 :
[ 11_ABDT2= HNF (#/ml) via DAPI ]
no problems detected 321 7. 2300. 321
( 100%)
321
( 100%)
Column 10 :
[ 12_ABDT2= HNF (#/ml) via DAPI ]
no problems detected 457 7. 4397.68896 457
( 100%)
457
( 100%)
Column 11 :
[ 13_ABDT= LNA (#/ml) via FC ]
no problems detected 148 64393.4062 783153.75 148
( 100%)
148
( 100%)
Column 12 :
[ 14_ABDT= HNA (#/ml) via FC ]
no problems detected 148 127078.172 1341173.88 148
( 100%)
148
( 100%)
Column 13 :
[ 15_ABDT= Bacteria (#/ml) via FC ]
no problems detected 149 194141.781 1980232.88 149
( 100%)
149
( 100%)
Column 14 :
[ 16_ABDT= Bacteria (#/ml) via FC ]
no problems detected 188 194141.781 7813282.5 188
( 100%)
188
( 100%)
Column 15 :
[ 17_OTHR= % HNA (#/ml) via FC ]
no problems detected 148 28.8012123 83.3658981 148
( 100%)
148
( 100%)
Column 16 :
[ 18_ABDT= Prochlorococcus (#/ml) via FC ]
no problems detected 190 19. 39447.6289 166
( 87%)
166
( 87%)
Column 17 :
[ 19_ABDT= Synechococcus (#/ml) via FC ]
no problems detected 190 671.530579 149705.516 190
( 100%)
190
( 100%)
Column 18 :
[ 20_ABDT= Picoeukaryotes-1 (#/ml) via FC ]
no problems detected 189 121.070641 27744.7969 189
( 100%)
189
( 100%)
Column 19 :
[ 21_ABDT= Peuk-2/Nano (#/ml) via FC ]
no problems detected 152 4.40087128 5825.53125 149
( 98%)
149
( 98%)
Column 20 :
[ 22_ABDT= Cryptos (#/ml) via FC ]
no problems detected 75 2.96740198 1426.66077 51
( 68%)
51
( 68%)
Column 22 :
[ 23_TEMP= Temperature ( C ) ]
no problems detected 948 11. 27. 948
( 100%)
948
( 100%)
Column 23 :
[ 24_OTHR= Secchi Depth (m) ]
no problems detected 155 3.5 24. 155
( 100%)
155
( 100%)
Column 24 :
[ 25_PSAL= Salinity () ]
no problems detected 157 35.0757904 39.0900002 157
( 100%)
157
( 100%)
Column 25 :
[ 26_CHLA= Chlorophyll (ug/m3) ]
no problems detected 478 0.00999999978 5.75 478
( 100%)
105
( 21%)
Column 26 :
[27_LOTH= PO4 (um) ]
There is/are 17 count WARNING(S)!

Some of your values are zero or "one".

Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

  • 156 0.0199999996 0.935000002 156
    ( 100%)
    0
    ( 0%)
    Column 27 :
    [ 28_LOTH= NH4 (um) ]
    no problems detected 173 0.0260000005 5.26999998 173
    ( 100%)
    54
    ( 31%)
    Column 28 :
    [29_LOTH= NO2 (um) ]
    There is/are 2 count WARNING(S)!

    Some of your values are zero or "one".

    Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

  • 171 0.00100000005 1.27999997 171
    ( 100%)
    2
    ( 1%)
    Column 29 :
    [ 30_LOTH= NO3 (um) ]
    no problems detected 173 0.0130000003 9.09697914 172
    ( 99%)
    72
    ( 41%)
    Column 30 :
    [ 31_LOTH= Silicate (um) ]
    no problems detected 173 0.0399999991 7.59000015 173
    ( 100%)
    99
    ( 57%)

    The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".