COPEPODITE Incoming Data Review

Fatal Format Issues:   none


    Mild Data Warnings (non-numeric values):   7    [ 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-YMD ]       Date Set = 1
    Column # 2     [ABDT1= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3     [ABDT1= Total Zooplankton (#/m3)]      ( date set 1 )
    Column # 4     [ABDT2= Hydromedusae (#/m3)]      ( date set 1 )
    Column # 5     [ABDT2= Siphonophora (#/m3)]      ( date set 1 )
    Column # 6     [ABDT2= Ctenophora (#/m3)]      ( date set 1 )
    Column # 7     [ABDT3= Polychaeta larvae (#/m3)]      ( date set 1 )
    Column # 8     [ABDT3= Cirripedia larvae (#/m3)]      ( date set 1 )
    Column # 9     [ABDT4= Cladocera (#/m3)]      ( date set 1 )
    Column # 10     [ABDT4= Ostracoda (#/m3)]      ( date set 1 )
    Column # 11     [ABDT4= Mysidacea (#/m3)]      ( date set 1 )
    Column # 12     [ABDT4= Euphausiacea (#/m3)]      ( date set 1 )
    Column # 13     [ABDT4= Amphipoda (#/m3)]      ( date set 1 )
    Column # 14     [ABDT= Insecta larvae (#/m3)]      ( date set 1 )
    Column # 15     [ABDT4= Isopoda (#/m3)]      ( date set 1 )
    Column # 16     [ABDT4= Decapoda larvae (#/m3)]      ( date set 1 )
    Column # 17     [ABDT3= Molusca larvae (#/m3)]      ( date set 1 )
    Column # 18     [ABDT4= Chaetognatha (#/m3)]      ( date set 1 )
    Column # 19     [ABDT3= Echinodermata (#/m3)]      ( date set 1 )
    Column # 20     [ABDT2= Apendicularia (#/m3)]      ( date set 1 )
    Column # 21     [ABDT2= Thaliacea (#/m3)]      ( date set 1 )
    Column # 22     [ABDT2= Ascidiacea larvae (#/m3)]      ( date set 1 )
    Column # 23     [ABDT= Pisces eggs (#/m3)]      ( date set 1 )
    Column # 24     [ABDT= Pisces larvae (#/m3)]      ( date set 1 )

    Column # 25     [ DATE-YMD ]       Date Set = 2
    Column # 26     [TEMP= Temperature ( C ) at the surface]      ( date set 2 )
    Column # 27     [PSAL= Salinity () at the surface]      ( date set 2 )
    Column # 28     [CHLA= Chlorophyll (ug/l)]      ( date set 2 )
    Column # 29     [OTHR= Freshwater Inflow (m3/s)]      ( date set 2 )

    Column # 30     [ DATE-YMD ]       Date Set = 3
    Column # 31     [LOTH= Guadiana River Flow (m3/s)]      ( date set 3 )
    Column # 32     [OTHR= Average Daily Precipitation (mm/day)]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (#/m3) ]
        Column # 3   [ ABDT1= Total Zooplankton (#/m3) ]
        Column # 4   [ ABDT2= Hydromedusae (#/m3) ]
        Column # 5   [ ABDT2= Siphonophora (#/m3) ]
        Column # 6   [ ABDT2= Ctenophora (#/m3) ]
        Column # 7   [ ABDT3= Polychaeta larvae (#/m3) ]
        Column # 8   [ ABDT3= Cirripedia larvae (#/m3) ]
        Column # 9   [ ABDT4= Cladocera (#/m3) ]
        Column # 10   [ ABDT4= Ostracoda (#/m3) ]
        Column # 11   [ ABDT4= Mysidacea (#/m3) ]
        Column # 12   [ ABDT4= Euphausiacea (#/m3) ]
        Column # 13   [ ABDT4= Amphipoda (#/m3) ]
        Column # 14   [ ABDT= Insecta larvae (#/m3) ]
        Column # 15   [ ABDT4= Isopoda (#/m3) ]
        Column # 16   [ ABDT4= Decapoda larvae (#/m3) ]
        Column # 17   [ ABDT3= Molusca larvae (#/m3) ]
        Column # 18   [ ABDT4= Chaetognatha (#/m3) ]
        Column # 19   [ ABDT3= Echinodermata (#/m3) ]
        Column # 20   [ ABDT2= Apendicularia (#/m3) ]
        Column # 21   [ ABDT2= Thaliacea (#/m3) ]
        Column # 22   [ ABDT2= Ascidiacea larvae (#/m3) ]
        Column # 23   [ ABDT= Pisces eggs (#/m3) ]
        Column # 24   [ ABDT= Pisces larvae (#/m3) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 29   [ OTHR= Freshwater Inflow (m3/s) ]
        Column # 32   [ OTHR= Average Daily Precipitation (mm/day) ]

    Temperatures Category
        Column # 26   [ TEMP= Temperature ( C ) at the surface ]

    Salinities Category
        Column # 27   [ PSAL= Salinity () at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (#/m3) ]
        column # 3     [ ABDT1= Total Zooplankton (#/m3) ]

    Category 8 Group # 2
        column # 4     [ ABDT2= Hydromedusae (#/m3) ]
        column # 5     [ ABDT2= Siphonophora (#/m3) ]
        column # 6     [ ABDT2= Ctenophora (#/m3) ]
        column # 20     [ ABDT2= Apendicularia (#/m3) ]
        column # 21     [ ABDT2= Thaliacea (#/m3) ]
        column # 22     [ ABDT2= Ascidiacea larvae (#/m3) ]

    Category 8 Group # 3
        column # 7     [ ABDT3= Polychaeta larvae (#/m3) ]
        column # 8     [ ABDT3= Cirripedia larvae (#/m3) ]
        column # 17     [ ABDT3= Molusca larvae (#/m3) ]
        column # 19     [ ABDT3= Echinodermata (#/m3) ]

    Category 8 Group # 4
        column # 9     [ ABDT4= Cladocera (#/m3) ]
        column # 10     [ ABDT4= Ostracoda (#/m3) ]
        column # 11     [ ABDT4= Mysidacea (#/m3) ]
        column # 12     [ ABDT4= Euphausiacea (#/m3) ]
        column # 13     [ ABDT4= Amphipoda (#/m3) ]
        column # 15     [ ABDT4= Isopoda (#/m3) ]
        column # 16     [ ABDT4= Decapoda larvae (#/m3) ]
        column # 18     [ ABDT4= Chaetognatha (#/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1997 2021
DATES in Column 25 no problems detected 1997 2021
DATES in Column 30 no problems detected 1996 2010

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-YMD DATE-YMD yes 1997 2021 apr Sep 14 15
25 DATE-YMD DATE-YMD yes 1997 2021 apr Sep 14 15
30 DATE-YMD DATE-YMD yes 1996 2010 1 12 15 15



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepods (#/m3) ]
no problems detected 145 2.48920012 19668.0273 139
( 95 %)
139
( 95 %)
Column 3 :
[ 05_ABDT1= Total Zooplankton (#/m3) ]
no problems detected 145 9.28260040 22371.6230 144
( 99 %)
144
( 99 %)
Column 4 :
[ 06_ABDT2= Hydromedusae (#/m3) ]
no problems detected 145 1.26000000E-02 372.960388 92
( 63 %)
58
( 40 %)
Column 5 :
[ 07_ABDT2= Siphonophora (#/m3) ]
no problems detected 145 1.39999995E-03 124.320122 33
( 22 %)
22
( 15 %)
Column 6 :
[08_ABDT2= Ctenophora (#/m3) ]
There is/are 1 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")

  • 121 3.33000012E-02 0.235752448 7
    ( 5 %)
    0
    ( 0 %)
    Column 7 :
    [ 09_ABDT3= Polychaeta larvae (#/m3) ]
    no problems detected 145 1.13000004E-02 340.351807 77
    ( 53 %)
    56
    ( 38 %)
    Column 8 :
    [ 10_ABDT3= Cirripedia larvae (#/m3) ]
    no problems detected 145 4.99999989E-03 1513.80603 114
    ( 78 %)
    97
    ( 66 %)
    Column 9 :
    [ 11_ABDT4= Cladocera (#/m3) ]
    no problems detected 145 1.99999996E-02 7560.42383 126
    ( 86 %)
    117
    ( 80 %)
    Column 10 :
    [ 12_ABDT4= Ostracoda (#/m3) ]
    no problems detected 145 1.61000006E-02 51.3870010 25
    ( 17 %)
    16
    ( 11 %)
    Column 11 :
    [ 13_ABDT4= Mysidacea (#/m3) ]
    no problems detected 145 1.10999998E-02 11.8950005 23
    ( 15 %)
    10
    ( 6 %)
    Column 12 :
    [14_ABDT4= Euphausiacea (#/m3) ]
    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")

  • 121 0.285400003 7.45920753 3
    ( 2 %)
    2
    ( 1 %)
    Column 13 :
    [15_ABDT4= Amphipoda (#/m3) ]
    There is/are 1 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")

  • 145 7.79999979E-03 7.48728466 23
    ( 15 %)
    5
    ( 3 %)
    Column 14 :
    [16_ABDT= Insecta larvae (#/m3) ]
    There is/are 1 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")

  • 62 6.89999992E-03 0.129999995 9
    ( 14 %)
    0
    ( 0 %)
    Column 15 :
    [ 17_ABDT4= Isopoda (#/m3) ]
    no problems detected 145 3.80000006E-03 40.8723679 45
    ( 31 %)
    16
    ( 11 %)
    Column 16 :
    [ 18_ABDT4= Decapoda larvae (#/m3) ]
    no problems detected 145 5.66999987E-02 385.271790 125
    ( 86 %)
    102
    ( 70 %)
    Column 17 :
    [ 19_ABDT3= Molusca larvae (#/m3) ]
    no problems detected 145 6.89999992E-03 13292.4648 120
    ( 82 %)
    106
    ( 73 %)
    Column 18 :
    [ 20_ABDT4= Chaetognatha (#/m3) ]
    no problems detected 145 5.70000010E-03 1440.39868 103
    ( 71 %)
    79
    ( 54 %)
    Column 19 :
    [21_ABDT3= Echinodermata (#/m3) ]
    There is/are 1 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")

  • 121 2.39000004E-02 62.1600609 10
    ( 8 %)
    5
    ( 4 %)
    Column 20 :
    [ 22_ABDT2= Apendicularia (#/m3) ]
    no problems detected 145 6.89999992E-03 2797.20288 112
    ( 77 %)
    97
    ( 66 %)
    Column 21 :
    [ 23_ABDT2= Thaliacea (#/m3) ]
    no problems detected 145 1.24000004E-02 21.2361774 17
    ( 11 %)
    9
    ( 6 %)
    Column 22 :
    [24_ABDT2= Ascidiacea larvae (#/m3) ]
    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")

  • 62 0.474999994 0.474999994 1
    ( 1 %)
    0
    ( 0 %)
    Column 23 :
    [ 25_ABDT= Pisces eggs (#/m3) ]
    no problems detected 145 5.10000018E-03 132.523987 110
    ( 75 %)
    57
    ( 39 %)
    Column 24 :
    [ 26_ABDT= Pisces larvae (#/m3) ]
    no problems detected 143 1.14000002E-02 37.8647995 110
    ( 76 %)
    22
    ( 15 %)
    Column 26 :
    [27_TEMP= Temperature ( C ) at the surface ]
    There is/are 1 count WARNING(S)!
    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")

  • 136 10.3999996 25.5000000 136
    ( 100 %)
    136
    ( 100 %)
    Column 27 :
    [ 28_PSAL= Salinity () at the surface ]
    no problems detected 140 3.06999993 37.9799995 140
    ( 100 %)
    140
    ( 100 %)
    Column 28 :
    [29_CHLA= Chlorophyll (ug/l) ]
    There is/are 6 count WARNING(S)!
    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")

  • 52 0.119999997 10.5900002 52
    ( 100 %)
    39
    ( 75 %)
    Column 29 :
    [ 30_OTHR= Freshwater Inflow (m3/s) ]
    no problems detected 85 2.72000003 2411.94995 85
    ( 100 %)
    85
    ( 100 %)
    Column 31 :
    [ 31_LOTH= Guadiana River Flow (m3/s) ]
    no problems detected 156 0.980000019 1531.35999 156
    ( 100 %)
    155
    ( 99 %)
    Column 32 :
    [ 32_OTHR= Average Daily Precipitation (mm/day) ]
    no problems detected 158 9.99999978E-03 9.18999958 133
    ( 84 %)
    69
    ( 43 %)

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