import numpy as np
import pandas as pd


def maranon_data():
    allometriy_dtf = pd.DataFrame(np.array([
        ['Prochlorococcus_sp', 'Cyano', 'D', 0.12, 0.035, 0.011, 0.021, 3.3, 6.37e-5, 0.019, 0.0017, 1.5, 0.45, 0.28,
         4.15e-1, np.nan],
        ['Synechococcus_sp', 'Cyano', 'D', 0.41, 0.094, 0.019, 0.039, 5.4, 4.06e-4, 0.035, 0.0043, 2.0, np.nan, 0.30,
         4.91e-1, 1.15e1],
        ['Ostreococcus_tauri', 'Chloro', 'v', 2.4, 0.67, 0.16, 0.31, 5.1, 4.72e-3, 0.035, 0.0020, 2.8, 0.62, 0.41,
         9.42e-1, np.nan],
        ['Nannochloropsis_gaditana', 'Other', 'h', 8.6, 1.8, 0.40, 0.74, 6.1, 2.25e-2, 0.074, 0.0055, 1.2, 0.57, 0.49,
         4.10e-1, 5.89e-1],
        ['Micromonas_pusilla', 'Chloro', 'v', 11, 2.5, 0.43, 0.77, 4.3, 9.67e-3, 0.074, 0.0073, 8.0, 0.59, 0.59, 1.30,
         np.nan],
        ['Pavlova_lutheri', 'Other', 'h', 45, 6.0, 0.55, 2.2, 9.8, 3.31e-2, 0.136, 0.0074, 1.0, 0.62, 0.70, 7.87e-1,
         1.73],
        ['Calcidiscus_leptoporus', 'Cocco', '^', 51, 5.4, 0.48, 2.2, 7.0, 6.79e-2, np.nan, 0.0034, np.nan, 0.67, 0.89,
         1.13, 1.69],
        ['Isochrysis_galbana', 'Other', 'h', 64, 4.3, 0.58, 1.4, 7.8, 4.11e-2, 0.101, 0.0067, 0.6, 0.68, 0.82, 1.01,
         2.49],
        ['Gephyrocapsa_oceanica', 'Cocco', '^', 82, 12, 1.8, 6.6, 6.7, 9.85e-2, 0.166, 0.0050, 1.2, 0.66, 0.85, 1.07,
         5.78],
        ['Phaeodactylum_tricornutum', 'Diatom', 'o', 93, 5.2, 0.31, 1.4, 7.2, 3.63e-2, 0.205, 0.0026, 0.3, 0.63, 1.06,
         1.14, 1.92],
        ['Emiliania_huxleyi', 'Cocco', '^', 158, 7.8, 0.68, 2.2, 10.0, 8.7e-2, 0.115, 0.0036, 0.3, 0.64, 0.92, 1.01,
         1.51],
        ['Skeletonema_costatum', 'Diatom', 'o', 242, 26, 2.9, 5.0, 9.4, 3.35e-1, 0.143, 0.0036, 0.1, np.nan, 0.85, 1.30,
         2.45],
        ['Thalassiosira_weissflogii', 'Diatom', 'o', 1163, 55, 6.4, 21, 8.4, 3.09e-1, 0.119, 0.0026, 0.3, 0.69, 0.54,
         4.85e-1, 8.34e-1],
        ['Melosira_nummuloides', 'Diatom', 'o', 2285, 269, 35, 115, 9.0, 4.52e0, np.nan, 0.0021, np.nan, 0.62, 0.56,
         8.04e-1, 1.09],
        ['Protoceratium_reticulatum', 'Dino', 's', 2383, 920, 116, 357, 7.4, 1.45e1, 0.052, 0.0042, 2.9, 0.61, 0.43,
         4.48e-1, 5.27e-1],
        ['Thalassiosira_rotula', 'Diatom', 'o', 2597, 195, 21, 88, 11.9, 1.12e0, 0.071, 0.0031, 0.5, 0.62, 0.60,
         3.24e-1, 4.34e-1],
        ['Alexandrium_minutum', 'Dino', 's', 5575, 1106, 73, 262, 8.6, 5.03e0, 0.027, 0.0067, 7.2, 0.60, 0.33, 2.23e-1,
         2.58e-1],
        ['Akashiwo_sanguinea', 'Dino', 's', 47349, 2555, 392, 1093, 6.6, 1.18e2, 0.047, 0.0082, 7.8, 0.50, 0.34,
         4.28e-1, 4.55e-1],
        ['Dytilum_brightwellii', 'Diatom', 'o', 75827, 3484, 275, 940, 6.1, 1.99e1, 0.052, 0.0034, 2.3, 0.60, 0.32,
         3.50e-1, 4.38e-1],
        ['Coscinodiscus_radiatus', 'Diatom', 'o', 81955, 3939, 773, 3387, 6.0, 1.96e2, 0.023, 0.0028, 1.2, 0.65, 0.35,
         3.41e-1, 3.61e-1],
        ['Alexandrium_tamarense', 'Dino', 's', 88836, 1452, 155, 683, 7.9, 1.31e1, 0.039, 0.0104, 4.2, 0.57, 0.24,
         3.08e-1, 3.63e-1],
        ['Coscinodiscus_wailesii', 'Diatom', 'o', 2498458, 85860, 10495, 48032, 8.0, 9.46e2, 0.054, 0.0053, 5.4, 0.71,
         0.25, 3.64e-1, 4.38e-1]]),
        columns=['Species', 'PFT', 'marker', 'Vcell', 'Ccell', 'QminN', 'QmaxN',
                 'CN', 'VmaxN', 'Pc', 'Rc', 'PER', 'FvFm', 'mumax', 'Wmumax', 'Wmuinf'])

    allometriy_dtf[
        ['Vcell', 'Ccell', 'QminN', 'QmaxN', 'CN', 'VmaxN', 'Pc', 'Rc', 'PER', 'FvFm', 'mumax', 'Wmumax', 'Wmuinf']] = \
        allometriy_dtf[['Vcell', 'Ccell', 'QminN', 'QmaxN', 'CN', 'VmaxN', 'Pc', 'Rc', 'PER', 'FvFm', 'mumax', 'Wmumax',
                        'Wmuinf']].astype('float')
    allometriy_dtf['Species'] = allometriy_dtf['Species'].astype('category')
    allometriy_dtf['PFT'] = allometriy_dtf['PFT'].astype('category')
    allometriy_dtf['marker'] = allometriy_dtf['marker'].astype('category')
    allometriy_dtf['muinf'] = (allometriy_dtf.mumax * allometriy_dtf.VmaxN * 24 / allometriy_dtf.QminN) / (
            (allometriy_dtf.VmaxN * 24 / allometriy_dtf.QminN) - allometriy_dtf.mumax)

    batchcultures_dtf = pd.DataFrame(
        np.array([['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 0.000, 13513404, 1.12, 3.67, 0.82, 0.35],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 0.757, 12697479, 1.28, 3.36, 1.31, 0.52],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 1.753, 14978382, 1.68, 3.33, 1.24, 0.46],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 2.781, 22165554, 2.30, 3.25, 1.23, 0.43],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 3.774, 29542085, 3.21, 3.16, 1.41, 0.50],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 4.757, 40843837, 5.05, 3.00, 1.48, 0.54],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 5.757, 50976447, 7.56, 2.85, 1.29, 0.43],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 6.753, 70016049, 11.52, 2.44, 1.72, 0.60],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 7.753, 64925531, 16.36, 1.78, 1.84, 0.64],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 8.750, 64334872, 19.73, 0.73, 2.08, 0.64],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 9.785, 60254070, 19.23, 0.62, 2.07, 0.66],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 10.771, 68369218, 19.11, 0.65, 2.33, 0.78],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 11.750, 68432440, 19.15, 0.67, 2.33, 0.76],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 0.000, 21643947, 10.34, 107.15, 1.46, 0.45],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 0.938, 23623513, 12.82, np.nan, 1.52, 0.50],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 1.951, 24674289, 17.06, 98.57, 2.24, 0.69],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 2.969, 19517330, 19.87, 92.00, 2.86, 0.77],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 3.927, 27322821, 28.48, 86.16, 3.30, 0.81],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 4.979, 31751384, 38.68, 63.35, 5.16, 0.97],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 5.979, 47503205, 57.23, 43.47, 6.58, 1.25],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 6.938, 79348390, 70.62, 16.28, 7.72, 1.49],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 7.958, np.nan, np.nan, 0.29, 8.81, 1.64],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 8.958, 111378885, 59.72, 0.13, 10.44, 1.86],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 9.958, np.nan, np.nan, 0.17, 10.24, 1.70],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 0.000, 461383, 1.82, 140.76, 0.70, 0.14],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 0.813, 574309, 2.27, 137.35, 0.82, 0.16],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 1.833, 1276064, 5.04, 133.95, 1.43, 0.38],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 2.750, 2131075, 8.42, 133.89, 1.78, 0.50],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 3.802, 2461786, 9.73, np.nan, 1.69, 0.39],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 4.729, 2744101, 10.85, 122.00, 2.09, 0.50],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 5.729, 2671506, 10.56, 115.16, 2.14, 0.61],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 6.740, 2526315, 9.98, 114.57, 2.07, 0.58],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 6.875, 2408550, 9.52, np.nan, np.nan, np.nan],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 6.958, 2432748, 9.62, np.nan, np.nan, np.nan],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 0.000, 720000, 18.47, 111.46, 2.07, 0.43],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 0.806, 610000, 20.76, 111.59, 2.24, 0.45],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 1.167, 1080000, 22.85, 105.31, np.nan,
                   np.nan],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 1.833, 1155000, 26.89, 93.94, 2.97, 0.67],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 2.146, 1315000, np.nan, np.nan, np.nan,
                   np.nan],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 2.813, 1520000, 33.39, 91.12, 4.37, 0.76],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 3.104, 1560000, np.nan, 82.90, np.nan,
                   np.nan],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 3.771, 2155000, 42.45, 76.12, 5.28, 0.87],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 0.000, 58620, 1.59, 143.39, 0.99, 0.21],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 0.813, 50018, 1.19, 125.03, 0.92, 0.18],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 1.833, 267666, 4.93, 122.34, 1.04, 0.31],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 2.750, 320201, 6.25, 121.00, 1.45, 0.44],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 3.802, 539411, 8.76, 117.70, 1.33, 0.43],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 4.729, 627976, 7.68, 116.11, 1.03, 0.35],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 5.750, 687407, 7.24, 111.08, 1.61, 0.51],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 6.000, 757056, 7.92, np.nan, np.nan, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 0.000, 220000, 10.93, 114.18, 2.37, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 0.771, 256667, 14.83, 96.89, 1.57, 0.41],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 1.073, 260000, 16.11, 83.21, 3.20, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 1.792, 390000, 48.71, 70.88, 2.86, 0.84],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 2.083, 533333, 74.85, 48.09, 3.54, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 2.792, 736667, 130.52, 19.33, 4.82, 0.99],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 3.125, 1040000, 160.29, 0.13, 10.14, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 3.760, 1546667, 177.66, 0.09, 10.35, 1.39],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 4.083, 1596667, np.nan, 0.17, 13.52, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 4.760, 2113333, 174.67, 0.04, 13.19, 1.30],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 5.083, 2386667, 173.28, 0.33, 16.18, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 5.781, 2570000, np.nan, 0.40, 19.54, 1.51],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 6.125, 2443333, 178.30, 0.53, 20.72, np.nan],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 6.771, 2263333, 166.58, 0.59, 20.48, 1.34],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 0.000, 200000, 3.38, 90.09, 1.76, 0.41],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 0.667, 165000, 4.93, 87.00, 1.88, 0.37],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 1.021, 225000, 7.88, 77.14, 2.37, 0.50],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 1.625, 505000, 14.50, 71.82, 2.75, 0.56],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 2.000, 485000, 17.01, 46.39, 4.34, 0.78],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 2.667, 1385000, 45.94, 23.61, 4.57, 0.76],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 2.979, 1010000, 67.62, 0.55, 7.41, 1.18],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 3.646, 2305000, 65.78, 0.43, 10.36, 1.29],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 3.979, 2235000, 63.99, 0.18, 10.23, 1.07],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 4.625, 2490000, 59.49, 0.24, 9.88, 1.03],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 0.000, 355000, 21.91, 41.31, 3.17, 0.42],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 1.000, 510000, 47.64, 7.45, 3.55, 0.71],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 1.938, 1095000, 83.53, 0.11, 4.73, 0.87],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 2.927, 1720000, 99.35, 0.11, 6.55, 1.00],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 3.313, 1350000, np.nan, 0.92, np.nan, np.nan],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 3.958, 1475000, 97.07, 0.16, 7.20, 0.99],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 4.292, 1175000, np.nan, 0.82, np.nan, np.nan],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 4.958, 1470000, 100.84, 0.10, 8.87, 1.07],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 0.000, 40000, 9.17, 102.83, 1.17, 0.27],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 0.729, 75000, 11.11, 90.45, 1.15, 0.24],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 1.063, 70000, 25.18, 82.37, 1.69, 0.32],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 1.708, 185000, 43.23, 69.48, 2.22, 0.45],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 2.063, 185000, 71.32, 47.27, 3.18, 0.59],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 2.708, 400000, 108.82, 20.65, 3.31, 0.77],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 3.042, 385000, 123.41, 0.28, 5.66, 1.04],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 3.708, 505000, 139.27, 0.24, 5.94, 1.05],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 4.083, 480000, np.nan, 0.12, 7.00, 1.17],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 4.792, 545000, 131.06, 0.37, 7.05, 1.17],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 5.083, 535000, 111.37, 0.45, 7.47, 1.14],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 5.729, 580000, 107.95, 0.35, 7.79, 1.06],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 6.083, 480000, 87.86, 1.05, 8.88, 1.34],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 6.885, 540000, 84.71, 0.11, 8.62, 1.28],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 0.000, 230000, 15.65, 110.51, 2.05, 0.38],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 0.785, 435000, 46.25, 59.72, 2.52, 0.61],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 1.146, 825000, np.nan, 39.85, np.nan,
                   np.nan],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 1.813, 1190000, 177.28, 0.37, 6.45, 1.42],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 2.125, 2090000, np.nan, 0.97, np.nan,
                   np.nan],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 2.792, 2535000, 137.92, 0.30, 13.62, 1.30],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 3.083, 3290000, np.nan, 0.43, np.nan,
                   np.nan],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 3.771, 4465000, 140.65, 0.41, 20.55, 1.40],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 3.931, 4155000, np.nan, np.nan, np.nan,
                   np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 0.000, 115000, 9.91, 100.43, 1.39, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 0.729, 150000, 12.35, 89.01, 1.34, 0.26],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 1.063, 255000, 21.15, 85.21, 2.48, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 1.708, 445000, 39.05, 65.36, 3.46, 0.55],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 2.063, 505000, 70.85, 40.27, 6.06, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 2.708, 930000, np.nan, 17.06, 7.16, 1.18],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 3.042, 1035000, 96.19, 0.19, 11.01, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 3.708, 1795000, np.nan, 0.46, 12.55, 1.30],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 4.083, 1570000, 114.96, 0.17, 6.75, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 4.792, 1730000, 115.04, 1.05, 14.71, 1.35],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 5.083, 1755000, np.nan, 0.58, 13.91, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 5.729, 1780000, np.nan, 0.27, 15.61, 1.32],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 6.083, 1635000, 101.41, 0.29, 18.09, np.nan],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 6.885, 1945000, 96.99, 0.15, 19.57, 1.55],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 0.000, 109120, 35.32, 186.21, 2.48, 0.31],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 0.896, 114740, 42.26, 159.07, 2.85, 0.44],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 1.875, 151280, 93.74, 121.94, 4.59, 0.75],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 2.882, 355600, 227.47, 21.30, 9.09, 1.36],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 3.875, 366360, 265.98, 1.92, 14.29, 1.48],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 4.875, 388980, 276.38, 1.46, 17.76, 1.51],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 5.875, 349500, 281.92, 2.43, 22.02, 1.51],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 0.000, 15000, 14.74, 119.38, 2.13, 0.31],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 0.333, 15000, np.nan, 106.89, np.nan,
                   np.nan],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 1.042, 30000, 14.98, np.nan, 2.68, 0.50],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 1.333, 50000, np.nan, 77.88, np.nan,
                   np.nan],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 1.979, 40000, 26.45, 60.82, 2.70, 0.50],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 2.333, 40000, np.nan, 44.74, np.nan,
                   np.nan],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 2.969, 40000, 56.10, 28.00, 4.42, 0.79],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 3.292, 70000, np.nan, 1.64, np.nan, np.nan],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 4.021, 140000, 149.64, 0.07, 7.55, 1.21],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 4.361, 85000, np.nan, 0.10, np.nan, np.nan],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 5.021, 150000, 122.00, 0.03, 9.01, 1.04],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 5.354, 110000, np.nan, 0.10, np.nan,
                   np.nan],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 6.042, 145000, 95.60, np.nan, 11.19, 0.93],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 0.000, 3750, 27.31, 112.27, 2.91, 0.43],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 0.333, 8100, np.nan, 94.48, np.nan, np.nan],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 1.042, 22200, 56.29, 56.88, 4.37, 0.77],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 1.333, 32550, np.nan, 39.59, np.nan, np.nan],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 1.979, 30600, 112.77, 0.61, 8.25, 1.59],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 2.333, 32250, np.nan, 0.03, np.nan, np.nan],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 2.969, 25950, 135.91, 0.20, 14.46, 1.72],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 3.292, 26900, np.nan, 0.16, np.nan, np.nan],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 4.021, 19300, 131.85, 0.15, 16.06, 1.62],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 4.361, 27500, np.nan, 0.15, np.nan, np.nan],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 5.021, 42100, 90.58, 0.15, 19.28, 1.65],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 5.333, 11500, np.nan, 0.15, np.nan, np.nan],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 6.063, 37250, 77.96, 0.15, 16.14, 1.35],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 0.000, 600, 5.41, 100.93, 1.67, 0.34],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 0.802, 1100, 6.42, 96.85, 2.20, 0.39],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 1.802, 1800, 8.52, 90.03, 2.28, 0.42],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 2.785, 2350, 12.06, 82.57, 2.39, 0.41],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 3.778, 2900, 17.46, np.nan, 3.30, 0.61],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 4.785, 4500, 24.06, 55.43, 4.06, 0.77],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 5.785, 6000, 30.23, 29.02, 4.85, 0.81],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 6.785, 6200, 39.89, 6.54, 6.18, 0.98],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 7.771, 9200, 47.21, 0.49, 8.12, 1.39],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 8.896, 7950, 39.60, 0.55, 10.19, 1.29],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 9.781, 9050, 33.34, 0.27, 11.29, 1.39],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 10.792, 9300, 30.90, 0.78, 10.56, 1.08],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 0.000, 10000, 24.53, 40.10, 5.31, 0.50],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 1.000, 10000, 73.52, 0.13, 6.01, 0.88],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 1.938, 50000, 105.15, 0.28, 9.75, 1.04],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 2.927, 35000, 110.69, 0.30, 10.62, 0.95],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 3.313, 20000, np.nan, 0.20, np.nan, np.nan],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 3.958, 20000, 77.03, 0.08, 13.27, 1.01],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 4.292, 35000, np.nan, 0.73, np.nan, np.nan],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 4.958, 35000, 68.60, 0.10, 16.58, 1.05],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 0.000, 1350, 3.21, 88.03, 1.54, 0.32],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 0.792, 1400, 4.45, np.nan, 1.47, 0.25],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 1.771, 1650, 5.32, 88.62, 1.84, 0.31],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 2.771, 1450, 6.96, 86.32, 2.29, 0.38],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 3.771, 1500, 7.24, np.nan, 2.38, 0.39],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 4.813, 1900, np.nan, 71.84, 2.40, 0.33],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 5.813, 2350, 7.95, 69.27, 2.90, 0.40],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 6.813, 2500, np.nan, 64.83, 3.58, 0.43],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 7.792, 3600, 9.79, 59.17, 3.65, 0.48],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 8.771, 4600, 11.06, 51.05, 4.08, 0.54],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 9.781, 4850, np.nan, 47.66, 4.64, 0.56],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 10.750, 5800, 13.57, 37.05, 6.26, 0.66],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 11.802, 7100, np.nan, 25.18, 5.92, 0.71],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 12.771, 6750, 18.04, 17.66, 6.44, 0.80],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 13.740, 8600, 19.19, 8.75, 7.08, 0.87],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 14.781, 12000, 17.30, 0.27, 7.06, 0.87],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 0.000, 400, 7.61, 90.31, 2.29, 0.37],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 0.802, 450, 10.15, 73.80, 2.85, 0.49],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 1.802, 850, 17.32, np.nan, 3.30, 0.66],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 2.785, 1350, 24.02, 51.58, 4.13, 0.92],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 3.778, 1400, 34.82, 25.66, 6.39, 1.32],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 4.785, 2450, 39.99, 17.06, 6.84, 1.24],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 5.785, 2600, 40.08, 0.42, 7.44, 1.34],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 6.785, 2750, 34.92, 0.25, 7.87, 1.35],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 7.771, 3100, 28.32, 0.29, 7.38, 1.50],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 8.896, 3400, 19.52, 0.27, 9.67, 1.42],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 9.781, 3750, 17.27, 0.28, 10.00, 1.56],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 10.792, 4150, 14.45, 0.25, 9.95, 1.63],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 0.000, 500, 12.54, 76.78, 1.99, 0.47],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 0.667, 550, 15.17, 74.04, 2.16, 0.49],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 1.021, 650, 19.36, 72.66, 2.19, 0.49],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 1.625, 650, 22.67, 68.96, 2.26, 0.51],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 2.000, 800, 26.09, 63.11, 2.24, 0.50],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 2.667, 1100, 32.67, 56.76, 2.91, 0.62],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 2.979, 1050, np.nan, 45.29, 3.53, 0.65],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 3.646, 1250, 45.38, 40.68, 3.57, np.nan],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 3.979, 1600, np.nan, 32.70, 3.52, 0.66],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 4.625, 1667, 69.09, 22.67, 2.88, np.nan],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 4.979, 2133, 82.04, 10.78, 2.79, 0.63],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 5.646, 2350, 105.28, 0.52, 3.87, 0.65],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 5.979, 2250, 110.81, 0.47, 4.35, 0.62],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 6.667, 2000, np.nan, 0.31, 4.16, 0.66],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 6.958, 2600, 114.36, 0.77, 3.95, 0.68],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 7.646, 3000, 114.56, 0.30, 4.37, 0.84],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 7.979, 2833, 98.94, 0.30, 5.15, 0.86],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 8.604, 3250, 100.60, np.nan, 4.96, 0.96],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 0.000, 94, 2.57, 104.80, 1.39, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 0.688, 88, 2.42, np.nan, 1.39, 0.30],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 1.063, 117, 3.21, 105.00, 1.46, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 1.677, 171, 4.69, np.nan, 1.79, 0.37],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 2.042, 220, 6.04, np.nan, 1.83, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 2.646, 309, 8.47, 104.05, 1.93, 0.35],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 3.042, 357, 9.79, np.nan, 2.02, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 3.646, 457, 12.54, 102.28, 2.49, 0.46],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 4.063, 382, np.nan, 93.59, 2.70, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 4.677, 748, 20.51, 85.06, 3.29, 0.63],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 5.042, 726, np.nan, 76.46, 3.56, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 5.656, 968, 26.52, 63.62, 3.88, 0.75],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 6.063, 1046, 28.68, 47.91, 4.66, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 6.635, 3160, np.nan, 45.88, 6.58, 1.32],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 7.771, 1548, 42.42, np.nan, np.nan, np.nan],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 9.85416666666424, np.nan, np.nan, np.nan,
                   np.nan,
                   np.nan],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 0.000, 450, 3.97, 89.75, 1.53, 0.25],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 0.792, 400, 3.89, 91.10, 1.67, 0.27],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 1.771, 500, 4.81, 84.05, 1.87, 0.31],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 2.771, 650, 6.20, 82.73, 1.96, 0.37],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 3.771, 750, np.nan, 78.48, 2.42, 0.39],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 4.813, 700, 8.07, 74.34, 2.38, 0.38],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 5.813, 1000, np.nan, 66.57, 3.04, 0.51],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 6.792, 1050, 12.26, 58.27, 3.22, np.nan],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 7.792, 2150, np.nan, 45.04, 4.14, 0.63],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 8.771, 2350, 18.75, 33.59, 4.26, 0.65],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 9.781, 2750, 21.18, 21.67, 4.26, 0.61],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 10.750, 3150, 31.11, 10.51, 5.54, 0.79],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 11.802, 5300, np.nan, 1.30, 6.48, 0.85],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 12.771, 5600, 37.68, 0.54, 6.96, 0.87],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 13.740, 5850, np.nan, 0.35, 7.62, 0.91],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 14.781, 6250, 34.29, 0.41, np.nan, 1.24],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 0.000, 16, 10.82, 97.24, 3.87, 0.45],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 0.615, 10, np.nan, 76.47, 3.93, 0.50],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 0.979, 16, 11.06, np.nan, 4.10, 0.57],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 1.583, 22, 15.17, 62.00, 4.55, 0.71],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 1.979, 47, 32.70, 43.72, 5.40, 0.86],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 2.583, 92, 63.74, 35.36, 5.96, 1.08],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 3.000, 98, np.nan, 1.40, 6.25, 1.09],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 3.615, 133, 91.84, 1.28, 8.73, 1.53],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 3.979, 142, 97.74, 1.76, 9.99, 1.49],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 4.594, 145, 100.01, 0.50, 10.09, 1.53],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 5.000, 137, 94.79, 0.39, 11.68, 1.55],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 5.573, np.nan, np.nan, 0.62, 12.02, 1.52],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 6.708, 158, np.nan, np.nan, np.nan, np.nan]]),
        columns=['Species', 'PFT', 'marker', 'hexcol', 'Time_d', 'Abun_cellmL',
                 'Chla_ugL', 'NO3_uM', 'POC_ugCmL', 'PON_ugNmL'])

    batchcultures_dtf[['Time_d', 'Abun_cellmL', 'Chla_ugL', 'NO3_uM', 'POC_ugCmL', 'PON_ugNmL']] = \
        batchcultures_dtf[['Time_d', 'Abun_cellmL', 'Chla_ugL', 'NO3_uM', 'POC_ugCmL', 'PON_ugNmL']].astype('float')
    batchcultures_dtf['Species'] = batchcultures_dtf['Species'].astype('category')
    batchcultures_dtf['PFT'] = batchcultures_dtf['PFT'].astype('category')
    batchcultures_dtf['marker'] = batchcultures_dtf['marker'].astype('category')
    batchcultures_dtf['hexcol'] = batchcultures_dtf['hexcol'].astype('category')

    sizecultures_dtf = pd.DataFrame(
        np.array([['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 0.000, 0.05],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 0.757, 0.06],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 1.753, 0.07],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 2.781, 0.06],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 3.774, 0.07],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 3.774, 0.07],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 4.757, 0.08],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 5.757, 0.11],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 6.753, 0.11],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 7.753, 0.12],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 8.750, 0.14],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 9.785, 0.15],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 10.771, 0.15],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 11.750, 0.15],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 13.753, 0.15],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 14.747, 0.17],
                  ['Prochlorococcus_sp', 'Cyano', 'D', '#5494aeff', 15.753, 0.18],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 0.000, 0.24],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 0.938, 0.27],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 1.951, 0.35],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 2.969, 0.51],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 3.927, 0.52],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 4.979, 0.61],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 5.979, 0.60],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 6.938, 0.45],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 7.958, 0.31],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 8.958, 0.27],
                  ['Synechococcus_sp', 'Cyano', 'D', '#5494aeff', 9.958, 0.37],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 0.000, 3.4],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 0.813, 2.7],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 1.833, 2.1],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 2.750, 2.4],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 3.802, 3.0],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 4.729, 3.3],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 5.729, 3.5],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 6.740, 2.7],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 6.875, 2.8],
                  ['Ostreococcus_tauri', 'Chloro', 'v', '#7cb950ff', 6.958, 2.6],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 0.806, 8.6],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 1.833, 8.3],
                  ['Nannochloropsis_gaditana', 'Other', 'h', '#ebeb6bff', 3.771, 11.8],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 0.000, 14.8],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 0.813, 13.0],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 1.833, 10.1],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 2.750, 10.7],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 3.802, 8.9],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 4.729, 6.7],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 5.750, 5.8],
                  ['Micromonas_pusilla', 'Chloro', 'v', '#7cb950ff', 6.000, 5.7],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 1.792, 45.4],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 3.760, 50.7],
                  ['Pavlova_lutheri', 'Other', 'h', '#ebeb6bff', 6.771, 44.7],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 1.625, 51.2],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 2.667, 78.3],
                  ['Calcidiscus_leptoporus', 'Cocco', '^', '#fdbf6fff', 4.625, 43.0],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 1.938, 64.1],
                  ['Isochrysis_galbana', 'Cocco', '^', '#fdbf6fff', 2.927, 50.1],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 1.708, 81.9],
                  ['Gephyrocapsa_oceanica', 'Cocco', '^', '#fdbf6fff', 5.729, 192.1],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 0.785, 93.2],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 1.813, 98.1],
                  ['Phaeodactylum_tricornutum', 'Diatom', 'o', '#e95c47ff', 3.771, 81.8],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 1.708, 157.6],
                  ['Emiliania_huxleyi', 'Cocco', '^', '#fdbf6fff', 5.729, 72.6],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 2.882, 241.6],
                  ['Skeletonema_costatum', 'Diatom', 'o', '#e95c47ff', 4.875, 192.0],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 1.979, 1162.8],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 4.021, 1135.6],
                  ['Thalassiosira_weissflogii', 'Diatom', 'o', '#e95c47ff', 6.042, 1110.0],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 1.979, 2285.2],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 4.021, 2899.8],
                  ['Melosira_nummuloides', 'Diatom', 'o', '#e95c47ff', 6.063, 2879.4],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 2.785, 2382.7],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 6.785, 2580.8],
                  ['Protoceratium_reticulatum', 'Dino', 's', '#9e0142ff', 9.781, 2675.4],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 1.938, 2597.2],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 2.927, 2598.8],
                  ['Thalassiosira_rotula', 'Diatom', 'o', '#e95c47ff', 3.958, 2904.0],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 2.771, 5574.6],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 8.771, 4474.9],
                  ['Alexandrium_minutum', 'Dino', 's', '#9e0142ff', 13.740, 3482.5],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 2.785, 47349.3],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 6.785, 53051.1],
                  ['Akashiwo_sanguinea', 'Dino', 's', '#9e0142ff', 9.781, 52295.7],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 1.625, 75827.0],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 2.667, 83409.9],
                  ['Dytilum_brightwellii', 'Diatom', 'o', '#e95c47ff', 8.604, 22574.1],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 2.646, 81955.4],
                  ['Coscinodiscus_radiatus', 'Diatom', 'o', '#e95c47ff', 5.656, 83340.8],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 2.771, 88835.7],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 8.771, 110968.6],
                  ['Alexandrium_tamarense', 'Dino', 's', '#9e0142ff', 13.740, 63486.3],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 1.583, 2498458.0],
                  ['Coscinodiscus_wailesii', 'Diatom', 'o', '#e95c47ff', 4.594, 2025597.8]
                  ]),
        columns=['Species', 'PFT', 'marker', 'hexcol', 'Time_d', 'Vcell'])
    sizecultures_dtf[['Time_d', 'Vcell']] = sizecultures_dtf[['Time_d', 'Vcell']].astype('float')
    sizecultures_dtf['Species'] = sizecultures_dtf['Species'].astype('category')
    sizecultures_dtf['PFT'] = sizecultures_dtf['PFT'].astype('category')
    sizecultures_dtf['marker'] = sizecultures_dtf['marker'].astype('category')
    sizecultures_dtf['hexcol'] = sizecultures_dtf['hexcol'].astype('category')

    allometriy_dtf.to_hdf('maranon_2013EcoLet_data.h5', key='allodtf', mode='w', format='table')
    batchcultures_dtf.to_hdf('maranon_2013EcoLet_data.h5', key='batchdtf', format='table')
    sizecultures_dtf.to_hdf('maranon_2013EcoLet_data.h5', key='sizedtf', format='table')


if __name__ == '__main__':
    maranon_data()
