In [2]:
import pandas as pd
import numpy as np
import pickle
root_directory = 'D:/github/w_vattenstatus/ekostat_calculator'#"../" #os.getcwd()
workspace_directory = root_directory + '/workspaces' 
resource_directory = root_directory + '/resources'
#alias = 'lena'
user_id = 'test_user' #kanske ska vara off_line user?
# workspace_alias = 'lena_indicator' # kustzonsmodellen_3daydata
workspace_alias = 'kustzonsmodellen_3daydata'

# ## Initiate EventHandler
print(root_directory)
paths = {'user_id': user_id, 
         'workspace_directory': root_directory + '/workspaces', 
         'resource_directory': root_directory + '/resources', 
         'log_directory': 'D:/github' + '/log', 
         'test_data_directory': 'D:/github' + '/test_data',
         'cache_directory': 'D:/github/w_vattenstatus/cache'}


D:/github/w_vattenstatus/ekostat_calculator

In [18]:
file_path = workspace_directory + '/78bd7584-5de1-45ca-9176-09a998a7e734/input_data/exports/all_data_raw.pkl'
print(file_path)


D:/github/w_vattenstatus/ekostat_calculator/workspaces/78bd7584-5de1-45ca-9176-09a998a7e734/input_data/exports/all_data_raw.pkl

In [19]:
with open(file_path, "rb") as fid:
    df = pickle.load(fid)

In [20]:
df.head()


Out[20]:
LONGI_DD DEPH RLABO WATER_DISTRICT STIME WADEP STATN MYEAR WATER_TYPE_AREA WATER_BODY_NAME ... CPHL_BTL NTRZ PHOS NTOT SECCHI PTOT NTRA origin_dtype origin_file_path DIN
0 0.0 kustzonsmodellen SE1 SE641250-211751 2011 23 - Bottenviken, yttre kustvatten S Bottenvikens kustvatten ... 0.004 0.022000000000000002 19.533 8.1 0.182 6.2379999999999995 physicalchemical physicalchemicalmodel_SE641250-211751.txt 6.42
1 0.25 kustzonsmodellen SE1 SE641250-211751 2011 23 - Bottenviken, yttre kustvatten S Bottenvikens kustvatten ... 0.004 0.022000000000000002 19.533 8.1 0.182 6.2379999999999995 physicalchemical physicalchemicalmodel_SE641250-211751.txt 6.42
2 0.75 kustzonsmodellen SE1 SE641250-211751 2011 23 - Bottenviken, yttre kustvatten S Bottenvikens kustvatten ... 0.004 0.022000000000000002 19.531 8.1 0.182 6.237 physicalchemical physicalchemicalmodel_SE641250-211751.txt 6.42
3 1.25 kustzonsmodellen SE1 SE641250-211751 2011 23 - Bottenviken, yttre kustvatten S Bottenvikens kustvatten ... 0.004 0.021 19.539 8.1 0.182 6.245 physicalchemical physicalchemicalmodel_SE641250-211751.txt 6.42
4 1.75 kustzonsmodellen SE1 SE641250-211751 2011 23 - Bottenviken, yttre kustvatten S Bottenvikens kustvatten ... 0.004 0.02 19.559 8.1 0.182 6.266 physicalchemical physicalchemicalmodel_SE641250-211751.txt 6.43

5 rows × 25 columns


In [6]:
p = paths['resource_directory']+'/default_workspaces/default_workspace/subsets/default_subset/step_2/settings/indicator_settings'

In [10]:
ntot_settings = pd.read_csv(p+'/indicator_ntot_winter.set', sep = '\t')

In [46]:
import numpy as np
d = {'ntot_winter': {}}
min_s = 2

for row in ntot_settings.rows:
    eq = row['ref_ref_value_limit_eq']
    d['ntot_winter'][eq] = {}
    max_s = row['ref_Salinity_max_int']
    S = np.linspace(min_s,max_s, (max_s-min_s)*10+1)
    for s in S:
        d['ntot_winter'][eq].setdefault(s, eval(eq))


---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-46-38e1d3b9abe5> in <module>()
      4 
      5 for row in ntot_settings:
----> 6     eq = row['ref_ref_value_limit_eq']
      7     d['ntot_winter'][eq] = {}
      8     max_s = row['ref_Salinity_max_int']

TypeError: string indices must be integers

In [75]:
for ix in ntot_settings.iterrows():
    print(ix)


(0, Type_Area_number                              1
Type_Area_suffix                              n
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                  12;1;2;3
ref_ref_value_limit_eq            -0.150*s+23.1
ref_HG_value_limit_eq             -0.170*s+26.2
ref_GM_value_limit_eq             -0.190*s+29.2
ref_MP_value_limit_eq             -0.250*s+38.4
ref_PB_value_limit_eq             -0.349*s+53.6
ref_HG_EQR_limit_float                     0.88
ref_GM_EQR_limit_float                     0.79
ref_MP_EQR_limit_float                      0.6
ref_PB_EQR_limit_float                     0.43
ref_Salinity_max_int                         27
Name: 0, dtype: object)
(1, Type_Area_number                              1
Type_Area_suffix                              s
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                  12;1;2;3
ref_ref_value_limit_eq            -0.659*s+30.2
ref_HG_value_limit_eq             -0.749*s+34.3
ref_GM_value_limit_eq             -0.834*s+38.2
ref_MP_value_limit_eq             -1.098*s+50.3
ref_PB_value_limit_eq             -1.533*s+70.2
ref_HG_EQR_limit_float                     0.88
ref_GM_EQR_limit_float                     0.79
ref_MP_EQR_limit_float                      0.6
ref_PB_EQR_limit_float                     0.43
ref_Salinity_max_int                         20
Name: 1, dtype: object)
(2, Type_Area_number                              2
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                  12;1;2;3
ref_ref_value_limit_eq            -0.150*s+23.1
ref_HG_value_limit_eq             -0.170*s+26.2
ref_GM_value_limit_eq             -0.190*s+29.2
ref_MP_value_limit_eq             -0.250*s+38.4
ref_PB_value_limit_eq             -0.349*s+53.6
ref_HG_EQR_limit_float                     0.88
ref_GM_EQR_limit_float                     0.79
ref_MP_EQR_limit_float                      0.6
ref_PB_EQR_limit_float                     0.43
ref_Salinity_max_int                         27
Name: 2, dtype: object)
(3, Type_Area_number                              3
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                  12;1;2;3
ref_ref_value_limit_eq            -0.150*s+23.1
ref_HG_value_limit_eq             -0.170*s+26.2
ref_GM_value_limit_eq             -0.190*s+29.2
ref_MP_value_limit_eq             -0.250*s+38.4
ref_PB_value_limit_eq             -0.349*s+53.6
ref_HG_EQR_limit_float                     0.88
ref_GM_EQR_limit_float                     0.79
ref_MP_EQR_limit_float                      0.6
ref_PB_EQR_limit_float                     0.43
ref_Salinity_max_int                         27
Name: 3, dtype: object)
(4, Type_Area_number                              4
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                  12;1;2;3
ref_ref_value_limit_eq            -0.659*s+30.2
ref_HG_value_limit_eq             -0.749*s+34.3
ref_GM_value_limit_eq             -0.834*s+38.2
ref_MP_value_limit_eq             -1.098*s+50.3
ref_PB_value_limit_eq             -1.533*s+70.2
ref_HG_EQR_limit_float                     0.88
ref_GM_EQR_limit_float                     0.79
ref_MP_EQR_limit_float                      0.6
ref_PB_EQR_limit_float                     0.43
ref_Salinity_max_int                         20
Name: 4, dtype: object)
(5, Type_Area_number                             5
Type_Area_suffix                           NaN
VISS_EU_CD                         unspecified
filter_DEPH_INTERVAL_int                  0-10
tolerance_MIN_NR_YEARS_int                   3
tolerance_MIN_NR_VALUES_int                  3
tolerance_TIME_DELTA_TOLERANCE               3
tolerance_POS_RADIUS_TOLERANCE             0.1
tolerance_DEPH_TOLERANCE_int                 5
filter_MONTH_LIST_int                 12;1;2;3
ref_ref_value_limit_eq            0.000*s+17.0
ref_HG_value_limit_eq             0.000*s+19.1
ref_GM_value_limit_eq             0.000*s+22.1
ref_MP_value_limit_eq             0.000*s+27.9
ref_PB_value_limit_eq             0.000*s+39.5
ref_HG_EQR_limit_float                    0.89
ref_GM_EQR_limit_float                    0.77
ref_MP_EQR_limit_float                    0.61
ref_PB_EQR_limit_float                    0.43
ref_Salinity_max_int                        20
Name: 5, dtype: object)
(6, Type_Area_number                             6
Type_Area_suffix                           NaN
VISS_EU_CD                         unspecified
filter_DEPH_INTERVAL_int                  0-10
tolerance_MIN_NR_YEARS_int                   3
tolerance_MIN_NR_VALUES_int                  3
tolerance_TIME_DELTA_TOLERANCE               3
tolerance_POS_RADIUS_TOLERANCE             0.1
tolerance_DEPH_TOLERANCE_int                 5
filter_MONTH_LIST_int                 12;1;2;3
ref_ref_value_limit_eq            0.000*s+17.0
ref_HG_value_limit_eq             0.000*s+19.1
ref_GM_value_limit_eq             0.000*s+22.1
ref_MP_value_limit_eq             0.000*s+27.9
ref_PB_value_limit_eq             0.000*s+39.5
ref_HG_EQR_limit_float                    0.89
ref_GM_EQR_limit_float                    0.77
ref_MP_EQR_limit_float                    0.61
ref_PB_EQR_limit_float                    0.43
ref_Salinity_max_int                        20
Name: 6, dtype: object)
(7, Type_Area_number                                7
Type_Area_suffix                              NaN
VISS_EU_CD                            unspecified
filter_DEPH_INTERVAL_int                     0-10
tolerance_MIN_NR_YEARS_int                      3
tolerance_MIN_NR_VALUES_int                     3
tolerance_TIME_DELTA_TOLERANCE                  3
tolerance_POS_RADIUS_TOLERANCE                0.1
tolerance_DEPH_TOLERANCE_int                    5
filter_MONTH_LIST_int                      12;1;2
ref_ref_value_limit_eq              -6.516*s+62.6
ref_HG_value_limit_eq               -7.160*s+68.8
ref_GM_value_limit_eq               -7.757*s+74.5
ref_MP_value_limit_eq               -9.725*s+93.4
ref_PB_value_limit_eq             -13.031*s+125.2
ref_HG_EQR_limit_float                       0.91
ref_GM_EQR_limit_float                       0.84
ref_MP_EQR_limit_float                       0.67
ref_PB_EQR_limit_float                        0.5
ref_Salinity_max_int                            7
Name: 7, dtype: object)
(8, Type_Area_number                                8
Type_Area_suffix                              NaN
VISS_EU_CD                            unspecified
filter_DEPH_INTERVAL_int                     0-10
tolerance_MIN_NR_YEARS_int                      3
tolerance_MIN_NR_VALUES_int                     3
tolerance_TIME_DELTA_TOLERANCE                  3
tolerance_POS_RADIUS_TOLERANCE                0.1
tolerance_DEPH_TOLERANCE_int                    5
filter_MONTH_LIST_int                      12;1;2
ref_ref_value_limit_eq              -5.337*s+54.4
ref_HG_value_limit_eq               -5.865*s+59.7
ref_GM_value_limit_eq               -6.354*s+64.7
ref_MP_value_limit_eq               -7.966*s+81.1
ref_PB_value_limit_eq             -10.674*s+108.7
ref_HG_EQR_limit_float                       0.91
ref_GM_EQR_limit_float                       0.84
ref_MP_EQR_limit_float                       0.67
ref_PB_EQR_limit_float                        0.5
ref_Salinity_max_int                            7
Name: 8, dtype: object)
(9, Type_Area_number                                9
Type_Area_suffix                              NaN
VISS_EU_CD                            unspecified
filter_DEPH_INTERVAL_int                     0-10
tolerance_MIN_NR_YEARS_int                      3
tolerance_MIN_NR_VALUES_int                     3
tolerance_TIME_DELTA_TOLERANCE                  3
tolerance_POS_RADIUS_TOLERANCE                0.1
tolerance_DEPH_TOLERANCE_int                    5
filter_MONTH_LIST_int                      12;1;2
ref_ref_value_limit_eq              -5.337*s+54.4
ref_HG_value_limit_eq               -5.865*s+59.7
ref_GM_value_limit_eq               -6.354*s+64.7
ref_MP_value_limit_eq               -7.966*s+81.1
ref_PB_value_limit_eq             -10.674*s+108.7
ref_HG_EQR_limit_float                       0.91
ref_GM_EQR_limit_float                       0.84
ref_MP_EQR_limit_float                       0.67
ref_PB_EQR_limit_float                        0.5
ref_Salinity_max_int                            7
Name: 9, dtype: object)
(10, Type_Area_number                            10
Type_Area_suffix                           NaN
VISS_EU_CD                         unspecified
filter_DEPH_INTERVAL_int                  0-10
tolerance_MIN_NR_YEARS_int                   3
tolerance_MIN_NR_VALUES_int                  3
tolerance_TIME_DELTA_TOLERANCE               3
tolerance_POS_RADIUS_TOLERANCE             0.1
tolerance_DEPH_TOLERANCE_int                 5
filter_MONTH_LIST_int                   12;1;2
ref_ref_value_limit_eq            0.000*s+17.0
ref_HG_value_limit_eq                 0*s+19.1
ref_GM_value_limit_eq                 0*s+20.0
ref_MP_value_limit_eq                 0*s+26.2
ref_PB_value_limit_eq                 0*s+34.0
ref_HG_EQR_limit_float                    0.89
ref_GM_EQR_limit_float                    0.85
ref_MP_EQR_limit_float                    0.65
ref_PB_EQR_limit_float                     0.5
ref_Salinity_max_int                         7
Name: 10, dtype: object)
(11, Type_Area_number                            11
Type_Area_suffix                           NaN
VISS_EU_CD                         unspecified
filter_DEPH_INTERVAL_int                  0-10
tolerance_MIN_NR_YEARS_int                   3
tolerance_MIN_NR_VALUES_int                  3
tolerance_TIME_DELTA_TOLERANCE               3
tolerance_POS_RADIUS_TOLERANCE             0.1
tolerance_DEPH_TOLERANCE_int                 5
filter_MONTH_LIST_int                   12;1;2
ref_ref_value_limit_eq            0.000*s+17.0
ref_HG_value_limit_eq                 0*s+19.1
ref_GM_value_limit_eq                 0*s+20.0
ref_MP_value_limit_eq                 0*s+26.2
ref_PB_value_limit_eq                 0*s+34.0
ref_HG_EQR_limit_float                    0.89
ref_GM_EQR_limit_float                    0.85
ref_MP_EQR_limit_float                    0.65
ref_PB_EQR_limit_float                     0.5
ref_Salinity_max_int                         7
Name: 11, dtype: object)
(12, Type_Area_number                             12
Type_Area_suffix                              s
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                    12;1;2
ref_ref_value_limit_eq            -4.555*s+44.3
ref_HG_value_limit_eq             -5.005*s+48.7
ref_GM_value_limit_eq             -5.488*s+53.4
ref_MP_value_limit_eq             -6.902*s+67.2
ref_PB_value_limit_eq             -9.110*s+88.7
ref_HG_EQR_limit_float                     0.91
ref_GM_EQR_limit_float                     0.83
ref_MP_EQR_limit_float                     0.66
ref_PB_EQR_limit_float                      0.5
ref_Salinity_max_int                          6
Name: 12, dtype: object)
(13, Type_Area_number                             12
Type_Area_suffix                              n
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                    12;1;2
ref_ref_value_limit_eq            -2.942*s+34.6
ref_HG_value_limit_eq             -3.163*s+37.3
ref_GM_value_limit_eq             -3.461*s+40.8
ref_MP_value_limit_eq             -4.326*s+51.0
ref_PB_value_limit_eq             -5.768*s+67.9
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          6
Name: 13, dtype: object)
(14, Type_Area_number                             13
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                    12;1;2
ref_ref_value_limit_eq            -4.555*s+44.3
ref_HG_value_limit_eq             -5.005*s+48.7
ref_GM_value_limit_eq             -5.488*s+53.4
ref_MP_value_limit_eq             -6.902*s+67.2
ref_PB_value_limit_eq             -9.110*s+88.7
ref_HG_EQR_limit_float                     0.91
ref_GM_EQR_limit_float                     0.83
ref_MP_EQR_limit_float                     0.66
ref_PB_EQR_limit_float                      0.5
ref_Salinity_max_int                          6
Name: 14, dtype: object)
(15, Type_Area_number                             14
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                    12;1;2
ref_ref_value_limit_eq            -4.555*s+44.3
ref_HG_value_limit_eq             -5.005*s+48.7
ref_GM_value_limit_eq             -5.488*s+53.4
ref_MP_value_limit_eq             -6.902*s+67.2
ref_PB_value_limit_eq             -9.110*s+88.7
ref_HG_EQR_limit_float                     0.91
ref_GM_EQR_limit_float                     0.83
ref_MP_EQR_limit_float                     0.66
ref_PB_EQR_limit_float                      0.5
ref_Salinity_max_int                          6
Name: 15, dtype: object)
(16, Type_Area_number                             15
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                    12;1;2
ref_ref_value_limit_eq            -2.942*s+34.6
ref_HG_value_limit_eq             -3.163*s+37.3
ref_GM_value_limit_eq             -3.461*s+40.8
ref_MP_value_limit_eq             -4.326*s+51.0
ref_PB_value_limit_eq             -5.768*s+67.9
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          6
Name: 16, dtype: object)
(17, Type_Area_number                             16
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                 11;12;1;2
ref_ref_value_limit_eq            -2.264*s+29.3
ref_HG_value_limit_eq             -2.434*s+31.5
ref_GM_value_limit_eq             -2.664*s+34.5
ref_MP_value_limit_eq             -3.329*s+43.1
ref_PB_value_limit_eq             -4.439*s+57.5
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          5
Name: 17, dtype: object)
(18, Type_Area_number                             17
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                 11;12;1;2
ref_ref_value_limit_eq            -2.264*s+29.3
ref_HG_value_limit_eq             -2.434*s+31.5
ref_GM_value_limit_eq             -2.664*s+34.5
ref_MP_value_limit_eq             -3.329*s+43.1
ref_PB_value_limit_eq             -4.439*s+57.5
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          5
Name: 18, dtype: object)
(19, Type_Area_number                            18
Type_Area_suffix                           NaN
VISS_EU_CD                         unspecified
filter_DEPH_INTERVAL_int                  0-10
tolerance_MIN_NR_YEARS_int                   3
tolerance_MIN_NR_VALUES_int                  3
tolerance_TIME_DELTA_TOLERANCE               3
tolerance_POS_RADIUS_TOLERANCE             0.1
tolerance_DEPH_TOLERANCE_int                 5
filter_MONTH_LIST_int                11;12;1;2
ref_ref_value_limit_eq            0.040*s+17.8
ref_HG_value_limit_eq             0.044*s+19.6
ref_GM_value_limit_eq             0.048*s+21.4
ref_MP_value_limit_eq             0.061*s+27.0
ref_PB_value_limit_eq             0.080*s+35.6
ref_HG_EQR_limit_float                    0.91
ref_GM_EQR_limit_float                    0.83
ref_MP_EQR_limit_float                    0.66
ref_PB_EQR_limit_float                     0.5
ref_Salinity_max_int                         5
Name: 19, dtype: object)
(20, Type_Area_number                            19
Type_Area_suffix                           NaN
VISS_EU_CD                         unspecified
filter_DEPH_INTERVAL_int                  0-10
tolerance_MIN_NR_YEARS_int                   3
tolerance_MIN_NR_VALUES_int                  3
tolerance_TIME_DELTA_TOLERANCE               3
tolerance_POS_RADIUS_TOLERANCE             0.1
tolerance_DEPH_TOLERANCE_int                 5
filter_MONTH_LIST_int                11;12;1;2
ref_ref_value_limit_eq            0.040*s+17.8
ref_HG_value_limit_eq             0.044*s+19.6
ref_GM_value_limit_eq             0.048*s+21.4
ref_MP_value_limit_eq             0.061*s+27.0
ref_PB_value_limit_eq             0.080*s+35.6
ref_HG_EQR_limit_float                    0.91
ref_GM_EQR_limit_float                    0.83
ref_MP_EQR_limit_float                    0.66
ref_PB_EQR_limit_float                     0.5
ref_Salinity_max_int                         5
Name: 20, dtype: object)
(21, Type_Area_number                             20
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                 11;12;1;2
ref_ref_value_limit_eq            -0.170*s+18.9
ref_HG_value_limit_eq             -0.187*s+20.7
ref_GM_value_limit_eq             -0.205*s+22.7
ref_MP_value_limit_eq             -0.254*s+28.1
ref_PB_value_limit_eq             -0.340*s+37.7
ref_HG_EQR_limit_float                     0.91
ref_GM_EQR_limit_float                     0.83
ref_MP_EQR_limit_float                     0.67
ref_PB_EQR_limit_float                      0.5
ref_Salinity_max_int                          5
Name: 21, dtype: object)
(22, Type_Area_number                             21
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                 11;12;1;2
ref_ref_value_limit_eq            -0.170*s+18.9
ref_HG_value_limit_eq             -0.187*s+20.7
ref_GM_value_limit_eq             -0.205*s+22.7
ref_MP_value_limit_eq             -0.254*s+28.1
ref_PB_value_limit_eq             -0.340*s+37.7
ref_HG_EQR_limit_float                     0.91
ref_GM_EQR_limit_float                     0.83
ref_MP_EQR_limit_float                     0.67
ref_PB_EQR_limit_float                      0.5
ref_Salinity_max_int                          5
Name: 22, dtype: object)
(23, Type_Area_number                             22
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                 11;12;1;2
ref_ref_value_limit_eq            -0.590*s+19.8
ref_HG_value_limit_eq             -0.634*s+21.3
ref_GM_value_limit_eq             -0.694*s+23.3
ref_MP_value_limit_eq             -0.868*s+29.1
ref_PB_value_limit_eq             -1.157*s+38.8
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          3
Name: 23, dtype: object)
(24, Type_Area_number                             23
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                 11;12;1;2
ref_ref_value_limit_eq            -0.590*s+19.8
ref_HG_value_limit_eq             -0.634*s+21.3
ref_GM_value_limit_eq             -0.694*s+23.3
ref_MP_value_limit_eq             -0.868*s+29.1
ref_PB_value_limit_eq             -1.157*s+38.8
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          3
Name: 24, dtype: object)
(25, Type_Area_number                             24
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                    12;1;2
ref_ref_value_limit_eq            -2.942*s+34.6
ref_HG_value_limit_eq             -3.163*s+37.3
ref_GM_value_limit_eq             -3.461*s+40.8
ref_MP_value_limit_eq             -4.326*s+51.0
ref_PB_value_limit_eq             -5.768*s+67.9
ref_HG_EQR_limit_float                     0.93
ref_GM_EQR_limit_float                     0.85
ref_MP_EQR_limit_float                     0.68
ref_PB_EQR_limit_float                     0.51
ref_Salinity_max_int                          6
Name: 25, dtype: object)
(26, Type_Area_number                             25
Type_Area_suffix                            NaN
VISS_EU_CD                          unspecified
filter_DEPH_INTERVAL_int                   0-10
tolerance_MIN_NR_YEARS_int                    3
tolerance_MIN_NR_VALUES_int                   3
tolerance_TIME_DELTA_TOLERANCE                3
tolerance_POS_RADIUS_TOLERANCE              0.1
tolerance_DEPH_TOLERANCE_int                  5
filter_MONTH_LIST_int                  12;1;2;3
ref_ref_value_limit_eq            -0.659*s+30.2
ref_HG_value_limit_eq             -0.749*s+34.3
ref_GM_value_limit_eq             -0.834*s+38.2
ref_MP_value_limit_eq             -1.098*s+50.3
ref_PB_value_limit_eq             -1.533*s+70.2
ref_HG_EQR_limit_float                     0.88
ref_GM_EQR_limit_float                     0.79
ref_MP_EQR_limit_float                      0.6
ref_PB_EQR_limit_float                     0.43
ref_Salinity_max_int                         20
Name: 26, dtype: object)

In [78]:
ix


Out[78]:
(26, Type_Area_number                             25
 Type_Area_suffix                            NaN
 VISS_EU_CD                          unspecified
 filter_DEPH_INTERVAL_int                   0-10
 tolerance_MIN_NR_YEARS_int                    3
 tolerance_MIN_NR_VALUES_int                   3
 tolerance_TIME_DELTA_TOLERANCE                3
 tolerance_POS_RADIUS_TOLERANCE              0.1
 tolerance_DEPH_TOLERANCE_int                  5
 filter_MONTH_LIST_int                  12;1;2;3
 ref_ref_value_limit_eq            -0.659*s+30.2
 ref_HG_value_limit_eq             -0.749*s+34.3
 ref_GM_value_limit_eq             -0.834*s+38.2
 ref_MP_value_limit_eq             -1.098*s+50.3
 ref_PB_value_limit_eq             -1.533*s+70.2
 ref_HG_EQR_limit_float                     0.88
 ref_GM_EQR_limit_float                     0.79
 ref_MP_EQR_limit_float                      0.6
 ref_PB_EQR_limit_float                     0.43
 ref_Salinity_max_int                         20
 Name: 26, dtype: object)

In [ ]: