Message Boards Message Boards

0
|
10336 Views
|
3 Replies
|
1 Total Likes
View groups...
Share
Share this post:

How to erase column in a Map[Flatten[#] & command

Dear Mathematica Group,
I usually use the function
Map[Flatten[#] &, Table[{LxTptocompare[[i]], Flatten[Select[Tabletoplot, #[[1]] == LxTptocompare[[i, 1]] &]]}, {i, 1, Length}]]

But when there is no correspondence between LxTptocompare and Tabletoplot I have also the extra column of Tableplot and I would like to erase them.
Namely, I would like to delete all the rows for which Exists only LxTptocompare and not Tableplot.

I would be very grateful if you could suggest a command.

Thanks,
Maria
3 Replies
Hi,

If there are no matching lists in LpeakidGRB, Select will return an empty list, {}. Then the rows to delete are of the pattern {_, {}}. The following will do the job.

LpeakandLprompttotalsample =
Map[Flatten,
  DeleteCases[#, {_, {}}] &@
   Table[{LxTptocompare[[i]],
     Flatten[Select[
       LpeakidGRB, #[[1]] == LxTptocompare[[i, 1]] &]]}, {i, 1,
     Length[LxTptocompare]}]]

Youngjoo Chung
POSTED BY: Youngjoo Chung
Hello Peter,
thanks for your replay, I am providing the two tables, because if I use delete as
DeleteCases[LpeakandLprompttotalsample, {_, Null}]
This doesn't work, it still gives me all the not desidered values
  LpeakandLprompttotalsample =
   Map[Flatten[#] &,
    Table[{LxTptocompare[[i]],
      Flatten[Select[
        LpeakidGRB, #[[1]] == LxTptocompare[[i, 1]] &]]}, {i, 1,
      Length[LxTptocompare]}]]
  [/i]LxTptocompare={{"51221A", 0.115799, 0.111783, 49.8955, 0.0435632}, {60614, 2.31797,
    0.00812088, 47.4534, 0.0245526}, {"60912A", 1.63719, 0.156429,
    48.7877, 0.617642}, {"70714B", 1.33122, 0.0359068, 49.346,
   0.0342226}, {"70810A", 1.22518, 0.217759, 49.8507,
   0.315155}, {50315, 1.6108, 0.0282718, 49.9847, 0.0560419}, {50319,
   1.52767, 0.108061, 50.5923, 0.272284}, {50401, 0.114365, 0.0498865,
   51.4534, 0.0430669}, {50802, 0.939609, 0.0870742, 50.5276,
   0.0623248}, {"50820A", 1.22665, 0.0536676, 50.4357,
   0.105024}, {"50922C", -0.0392191, 0.568358, 50.2052,
   1.21084}, {"51109A", 1.55383, 0.0525303, 49.4997, 0.133991}, {60108,
    0.624621, 0.216299, 50.8198, 0.264716}, {60124, 1.1409, 0.18721,
   49.8365, 0.224045}, {60418, 1.62615, 0.0130834, 50.0158,
   0.0212885}, {60605, 0.938183, 0.178242, 50.0833, 0.256554}, {60729,
   2.30484, 0.0213541, 47.984, 0.125177}, {60814, 2.18737, 0.0119967,
   48.8089, 0.0375244}, {60906, 0.969616, 0.32865, 51.0168,
   0.553518}, {61121, 1.84383, 0.0134719, 49.084, 0.04436}, {71020,
   0.158828, 0.0421949, 50.4971, 0.0147986}, {80310, 0.853536,
   0.0420975, 51.0029, 0.046084}, {80430, 0.824035, 0.0269348, 50.1461,
    0.0350179}, {50318, 0.063633, 0.202394, 50.8731, 0.391049}, {50730,
    1.4694, 0.033756, 50.1188, 0.0702187}, {50814, 1.51951, 0.02138,
   50.377, 0.0606898}, {50908, 1.21773, 0.161225, 49.9889,
   0.267076}, {"51016B", 1.65188, 0.0274377, 49.0667,
   0.133556}, {60116, 1.04839, 0.0731413, 50.8029, 0.150007}, {60202,
   2.04429, 0.0196012, 49.4186, 0.043933}, {60210, 0.775845, 0.0249051,
    51.3028, 0.0254619}, {60522, 1.44609, 0.0632294, 49.5263,
   0.163715}, {60526, 1.1481, 0.0627243, 50.3443, 0.168751}, {60604,
   1.71281, 0.0920385, 49.8004, 0.268244}, {"60904B", 0.963007,
   0.0812827, 49.1721, 0.0864626}, {70110, 1.4904, 0.0201968, 49.6651,
   0.0443924}, {70518, 0.877609, 0.419547, 49.1241, 0.228951}, {70529,
   1.55614, 0.0610871, 49.772, 0.537234}, {71020, 0.369461, 0.11704,
   50.3892, 0.0527548}, {71031, 1.43976, 0.0212215, 51.2531,
   0.0466575}, {81008, 0.715098, 0.0439678, 50.0768,
   0.0280944}, {"60502A", 1.60852, 0.0302891, 49.0061,
   0.0818788}, {"60912A", 1.63719, 0.156429, 48.7877,
   0.617642}, {61006, 1.90094, 0.099385, 47.6393, 0.392737}, {70809,
   0.274033, 0.898059, 48.5906, 0.827831}, {"91208B", 1.09551,
   0.426541, 50.0279, 0.451501}, {90529, 1.78679, 0.170724, 49.6937,
   0.536812}, {90519, 1.63533, 0.0618788, 48.4299, 0.177115}, {90516,
   1.8194, 0.0220606, 50.1811, 0.0785749}, {90812, 1.7994, 0.0165121,
   49.5825, 0.0231879}, {90927, -0.11692, 0.205833, 50.986,
   0.239298}, {"91109A", 1.39347, 0.0854727, 49.6682,
   0.178801}, {"100901A", 2.04463, 0.107833, 48.8948,
   0.188421}, {"110106B", -0.221175, 0.19753, 50.2452,
   0.265625}, {"100816A", 1.13537, 0.0842606, 49.2601,
   0.0612545}, {"100724A", -0.030624, 0.506833, 49.9501,
   0.327612}, {91024, 1.35162, 0.0626152, 49.505,
   0.0874096}, {"110422A", 2.1713, 0.0390818, 50.0057,
   0.0642144}, {"110503A", 0.817481, 0.0948485, 50.6376,
   0.0622516}, {"110205A", 2.00226, 0.00570303, 50.5719,
   0.0461634}, {91020, 1.4469, 0.0256424, 49.8375, 0.0671697}, {90530,
   1.2736, 0.0505364, 49.4035, 0.0668971}, {90102, 0.0868471, 0.139116,
    50.383, 0.204222}, {"81203A", 1.71161, 0.038597, 49.5694,
   0.109194}, {81118, 1.34822, 0.0393455, 51.0864, 0.178124}, {81007,
   1.68492, 0.0398273, 49.1648, 0.108391}, {"80905B", 1.52988,
   0.0505636, 49.5728, 0.127969}, {80721, -0.728358, 0.109343, 51.6664,
    0.0743272}, {80707, 0.594392, 0.0728264, 50.4396,
   0.082465}, {80607, 1.41876, 0.0173212, 50.555, 0.023197}, {80325,
   1.78002, 0.0322667, 50.3217, 0.0619485}, {"80319C", 0.602288,
   0.0261091, 50.5501, 0.0248849}, {80210, 1.42278, 0.0834212, 50.3273,
    0.133445}, {"61110A", 2.0614, 0.0103242, 48.2757,
   0.0264903}, {61021, 1.18352, 0.0292333, 48.9066,
   0.037712}, {"100513A", 0.989904, 0.0479697, 50.7663,
   0.143722}, {"100425A", 1.38542, 0.019597, 50.6422,
   0.227084}, {"100418A", 1.23775, 0.0547303, 49.6178,
   0.153629}, {"100316B", 0.163632, 0.213489, 50.7625,
   0.321642}, {"100219A", 1.47087, 0.2515, 49.711, 0.869466}}[i]
 
 [/i]LpeakidGRB={{50126, 1.18605, 0.0310389, 51.1018, 0.0650107}, {50126, 1.03165,
   0.14269, 50.6644, 0.262743}, {50315, 1.02254, 0.0694012, 51.1642,
   0.144}, {50315, 0.97961, 0.0219211, 51.8727, 0.0295834}, {50315,
   0.823981, 0.0543613, 51.9173, 0.0664102}, {50315, 0.903987,
   0.0356498, 51.853, 0.111241}, {50319, 0.868964, 0.00753085, 52.3439,
    0.0327018}, {50401, 0.0478665, 0.0422881, 52.9108,
   0.0517783}, {50401, 0.0934546, 0.14383, 52.5457,
   0.220103}, {50401, -0.363183, 0.0273395, 53.0093,
   0.0660424}, {50401, 0.0728989, 0.0794423, 52.6543,
   0.0778794}, {50401, 0.140958, 0.221651, 52.3728, 0.272247}, {50401,
   0.0106139, 0.00422739, 53.3132, 0.0354358}, {50401, 0.420274,
   0.0202399, 52.9528, 0.00334604}, {"050416A", 0.670917, 0.0232722,
   51.2593, 0.113757}, {"050525A", -0.108682, 0.00357399, 52.1895,
   0.00557771}, {"050525A", -0.111496, 0.00840685, 52.3473,
   0.00834382}, {"050525A", 0.606373, 0.0102995, 51.4237,
   0.0144366}, {"050525A", 0.0285832, 0.00242516, 52.1227,
   0.00821748}, {"050525A", -0.283181, 0.0133858, 51.6945,
   0.0254616}, {"050525A", -0.277371, 0.021823, 51.8945,
   0.0219535}, {"050525A", 0.274014, 0.00333968, 51.7447,
   0.0336729}, {50724, 0.145694, 0.00451651, 50.3712, 0.12186}, {50724,
    1.43731, 0.0114207, 48.8835, 0.0215539}, {50724, 1.50308,
   0.0213429, 48.1724, 0.0412992}, {50724, 1.59505, 0.0197527, 47.7589,
    0.0432695}, {50724, 1.57091, 0.00118049, 47.3106,
   0.0841802}, {50724, 4.58712, 0.174494, 44.7504, 0.114918}, {50730,
   1.22819, 0.0194129, 51.6631, 0.0679528}, {50730, 0.174477,
   0.0712624, 52.0601, 0.102169}, {50730, 0.0625019, 0.155627, 52.0434,
   0.311406}, {50730, 0.943177, 0.0954616, 51.7351, 0.102843}, {50730,
   1.06098, 0.0761678, 51.3783, 0.0974763}, {50730, 0.506841,
  0.0780817, 50.9974, 0.202861}, {50730, 1.18059, 0.00729495, 50.7137,
   0.0650464}, {50730, 1.79702, 0.0454193, 49.4733,
  0.0626227}, {50801, -0.219495, 0.0136481, 51.7797,
  0.0723456}, {50801, 0.889326, 0.109191, 51.5454, 0.429208}, {50802,
  0.60746, 0.0243973, 51.8976, 0.0523708}, {50802, -0.0023654,
  0.0357548, 51.5418, 0.206579}, {50802, 1.07361, 0.0903158, 51.3797,
  0.410624}, {50802, 2.37969, 0.0842336, 48.5971, 0.146304}, {50814,
  0.468203, 0.0421263, 52.2949, 0.0708467}, {50814, 1.03239,
  0.0177081, 52.1169, 0.0461096}, {"050820A", 0.672008, 0.0193337,
  51.8415, 0.0327037}, {"050820A", 0.661455, 0.0622486, 51.6667,
  0.0760368}, {"050820A", 0.551548, 0.0803477, 51.7771,
  0.26221}, {"050820A", 0.63987, 0.0100852, 52.3325,
  0.0228591}, {"050820A", 1.26079, 0.0468652, 52.0054,
  0.04012}, {50908, 0.680785, 0.0189906, 51.9787,
  0.0716115}, {"050922C", 0.109781, 0.0323475, 52.1303,
  0.0753626}, {"050922C", -0.134615, 0.0104625, 52.921,
  0.0190706}, {"051016B", 0.660258, 0.0401528, 51.0982,
  0.242223}, {"051109A", 0.34101, 0.0441137, 52.3884,
  0.0603299}, {"051109A", 0.887008, 0.06333, 51.7046,
  0.162836}, {"051221A", -0.809085, 0.00381667, 52.1248,
  0.0230305}, {"051221A", -0.0233226, 0.0311633, 52.1424,
  0.0567125}, {"051221A", -0.335754, 0.0663478, 51.1496,
  0.208217}, {"051221A", 2.36851, 0.0626108, 47.702,
  0.124644}, {60108, 0.419911, 0.0220558, 51.6475, 0.0711162}, {60108,
   0.132648, 0.292947, 51.5731, 0.230002}, {60108, 0.529052,
  0.0785493, 51.5249, 0.286251}, {60115, 1.0262, 0.022781, 51.9001,
  0.0513571}, {60115, 0.552347, 0.0384628, 51.7434,
  0.0580431}, {60115, 0.402557, 0.0294027, 52.1182,
  0.0372155}, {60115, 1.69345, 0.102819, 49.0048, 0.16495}, {60116,
  0.79824, 0.0602217, 52.6539, 0.0703216}, {60116, -0.0959255,
  0.035232, 52.7631, 0.193908}, {60116, -0.208561, 0.0910285, 53.0439,
   0.262797}, {60124, 0.22022, 0.0350967, 51.6393, 0.0986621}, {60124,
   0.145464, 0.000321722, 52.017, 0.298706}, {60124, 0.142211,
  0.137202, 51.8279, 0.168837}, {60124, 2.21798, 0.184909, 48.9882,
  0.130121}, {60124, 1.80876, 0.125554, 49.5694, 0.240534}, {60124,
  1.61837, 0.0132372, 51.02, 0.0397251}, {60124, 1.41592, 0.0122914,
  50.4563, 0.029407}, {60124, 1.24504, 0.0220764, 50.9515,
  0.0476997}, {60124, 1.04335, 0.0202711, 51.5727, 0.0225893}, {60124,
   0.743235, 0.0176544, 51.4511, 0.0245489}, {60124, 0.94808,
  0.00888706, 52.1093, 0.0113855}, {60124, 0.415452, 0.00956236,
  52.2954, 0.00906228}, {60124, 1.2087, 0.0263645, 50.6642,
  0.0424739}, {60124, 0.944043, 0.00334852, 51.3805,
  0.0140117}, {60124, 1.55867, 0.0526116, 49.397, 0.0454506}, {60124,
  1.1946, 0.0364394, 49.859, 0.131766}, {60206, -0.0888609, 0.0104184,
   52.8609, 0.029703}, {60206, -0.224224, 0.262166, 52.343,
  0.217659}, {60210, 0.457325, 0.0978864, 52.1763, 0.0978432}, {60210,
   0.424743, 0.014215, 52.4523, 0.06586}, {60210, 0.849278, 0.0926882,
   52.4192, 0.0821006}, {60210, -0.0836609, 0.132619, 52.7446,
  0.144967}, {60210, 0.500199, 0.0886382, 52.3483, 0.144667}, {60210,
  0.561579, 0.0997426, 52.1579, 0.266077}, {60210, 0.243771,
  0.0328261, 52.7236, 0.062023}, {60210, 0.659063, 0.0671585, 51.5566,
   0.09036}, {60210, 0.842979, 0.0588134, 51.2912, 0.0968726}, {60210,
   1.19596, 0.0875271, 49.4681, 0.13727}, {60210, 0.938878, 0.0280268,
   51.2368, 0.0690703}, {60210, 0.653148, 0.01724, 51.3492,
  0.0501522}, {60210, 1.35276, 0.0548608, 49.5585, 0.0860729}, {60210,
   1.62196, 0.0391521, 49.0081, 0.0993556}, {60210, 1.56672, 0.026607,
   50.2131, 0.0343787}, {"060223A", 0.0737147, 0.0117439, 52.5866,
  0.0340045}, {"060223A", 0.0880778, 0.136708, 52.3035,
  0.330065}, {"060223A", 1.98787, 0.087639, 49.1469,
  0.186022}, {60418, 0.720498, 0.094534, 51.6464, 0.0391579}, {60418,
  0.833249, 0.015826, 51.9436, 0.0296683}, {60418, 0.576736,
  0.0798203, 51.5995, 0.100903}, {60418, 0.327068, 0.0951557, 51.5081,
   0.311733}, {60418, 0.591882, 0.0527125, 51.7224,
  0.13681}, {60418, -0.132048, 0.0683955, 52.265, 0.0554674}, {60418,
  0.819703, 0.069148, 51.5096, 0.242749}, {60418, 1.64491, 0.0353731,
  50.0131, 0.0606628}, {60418, 0.978297, 0.0142149, 50.8205,
  0.0306901}, {"060502A", 0.540271, 0.0358119, 51.5678,
  0.0745237}, {"060502A", 0.345745, 0.0476193, 51.8535,
  0.0884394}, {"060502A", 0.341188, 0.140815, 51.3839,
  0.267965}, {"060502A", 0.6424, 0.0581966, 51.4516,
  0.0853026}, {"060502A", 0.455224, 0.0720972, 51.7699,
  0.262704}, {"060502A", 0.771081, 0.0351791, 51.5342,
  0.117806}, {"060502A", 2.151, 0.122882, 47.8732, 0.147241}, {60522,
  0.570574, 0.0591809, 52.1159, 0.106424}, {60522, 0.138964, 0.171755,
   52.3445, 0.292076}, {60522, 0.639465, 0.0538655, 51.9537,
  0.0787973}, {60526, -0.146775, 0.014002, 52.3162,
  0.0588307}, {60526, 0.547364, 0.0396751, 51.9731, 0.119124}, {60526,
   0.380668, 0.0381711, 51.6296, 0.0445698}, {60526, 0.737657,
  0.0286115, 51.8302, 0.0344948}, {60526, 1.08058, 0.0309599, 51.2596,
   0.0596561}, {60526, 0.690136, 0.0261464, 51.6019,
  0.0737609}, {60526, 1.29632, 0.0377526, 50.1311, 0.0418611}, {60604,
   0.530705, 0.00445634, 51.5404, 0.0783698}, {60604, 0.516745,
  0.0145105, 51.5638, 0.243508}, {60604, 1.27241, 0.0122924, 50.4327,
  0.0218304}, {60604, 0.90848, 0.0653353, 50.042, 0.064654}, {60605,
  0.921293, 0.110859, 51.3063, 0.105333}, {60605, 0.66383, 0.0291854,
  51.9883, 0.0639553}, {60605, 0.593475, 0.152373, 51.5978,
  0.227303}, {"060607A", 0.662739, 0.00697093, 52.2878,
  0.0192996}, {"060607A", 0.894572, 0.0325699, 51.6069,
  0.0628166}, {"060607A", 0.64312, 0.0540508, 51.5523,
  0.152058}, {"060607A", 1.64793, 0.0683792, 49.7574,
  0.114592}, {"060607A", 1.22036, 0.010623, 50.874,
  0.0365164}, {60614, 0.577503, 0.0481313, 49.8911,
  0.0648748}, {60614, 0.365457, 0.0371632, 49.6837,
  0.080412}, {60614, -0.0347055, 0.00498866, 49.7064,
  0.0808622}, {60614, 1.08367, 0.0291955, 49.2876, 0.0633111}, {60614,
   0.541257, 0.0441096, 49.5197, 0.191696}, {60614, 0.609965,
  0.0447826, 49.3399, 0.125398}, {60614, 1.0754, 0.0420667, 49.3076,
  0.0203827}, {60614, 0.85907, 0.0230738, 49.43, 0.025045}, {60614,
  1.12813, 0.0125059, 49.5765, 0.0382997}, {60614, 0.956523,
  0.0324972, 49.4349, 0.0132201}, {60614, 1.34307, 0.0138618, 49.3636,
   0.0267047}, {60614, 1.03942, 0.0176965, 49.2153,
  0.0181916}, {60614, 0.815909, 0.0396634, 48.8939, 0.212148}, {60614,
   0.895171, 0.0214405, 49.0303, 0.0699899}, {60614, 0.57503,
  0.0522521, 48.9547, 0.157142}, {60614, 0.81667, 0.121248, 48.8458,
  0.109655}, {60614, 0.467397, 0.0602237, 48.7683, 0.138415}, {60614,
  0.341437, 0.0507779, 48.9383, 0.0709435}, {60614, 1.1095, 0.0367673,
   48.5865, 0.0335467}, {60614, 1.43904, 0.0374619, 48.3476,
  0.040066}, {60614, 1.40697, 0.0465774, 48.2978, 0.054522}, {60614,
  2.01384, 0.0170459, 47.7302, 0.0319545}, {60707, 1.00922, 0.0493426,
   51.5984, 0.0835223}, {60707, 0.431611, 0.0355205, 52.1623,
  0.055623}, {60707, 0.632135, 0.408686, 51.5611, 0.171091}, {60707,
  0.49595, 0.165346, 51.8259, 0.314397}, {60714, 0.511749, 0.034323,
  51.7043, 0.090623}, {60714, 0.5871, 0.065583, 51.8704,
  0.0947427}, {60714, 0.592838, 0.14622, 51.625, 0.427062}, {60714,
  0.316315, 0.0551421, 51.9207, 0.251751}, {60714, 0.508608,
  0.0221919, 51.9833, 0.027181}, {60714, 0.248232, 0.00704095,
  51.9062, 0.0248444}, {60714, -0.285441, 0.00802173, 52.672,
  0.148136}, {60714, 0.716673, 0.0530534, 51.1456, 0.116236}, {60714,
  0.847683, 0.023524, 50.7825, 0.0363827}, {60714, 0.789809,
  0.0109759, 50.4014, 0.0307525}, {60729, 0.746337, 0.0235671,
  50.3151, 0.427421}, {60729, 1.14686, 0.0327845, 50.4444,
  0.0693292}, {60729, 1.00224, 0.0452729, 50.2286, 0.155408}, {60729,
  1.02305, 0.022136, 50.4323, 0.0374593}, {60729, 1.29947, 0.0332029,
  49.8141, 0.0576343}, {60729, 1.84058, 0.0259493, 48.38,
  0.100899}, {60801, -0.690157, 0.0469766, 52.2834, 0.164744}, {60814,
   0.93747, 0.00520047, 51.3044, 0.0124513}, {60814, 0.719456,
  0.0110578, 51.5296, 0.0162379}, {60814, 1.16184, 0.00575588,
  51.2028, 0.0079616}, {60814, 1.28233, 0.0398384, 50.5066,
  0.0352448}, {60814, 2.10831, 0.0192139, 48.9469,
  0.0254129}, {"060904B", 0.494072, 0.00662175, 51.333,
  0.0424849}, {"060904B", 0.948629, 0.0695964, 50.4595,
  0.360469}, {"060904B", 1.28165, 0.00646523, 50.1556,
  0.032626}, {"060904B", 1.6489, 0.00635113, 49.7085,
  0.00933529}, {60906, 0.518806, 0.0159719, 52.3762,
  0.0307248}, {60906, -0.0838037, 0.169294, 52.2589,
  0.349263}, {60906, 0.202833, 0.0124233, 52.213, 0.222609}, {60906,
  3.84984, 0.0951305, 47.7015, 0.0547881}, {60908, 0.0708761,
  0.0209775, 51.8788, 0.050072}, {60908, 0.231464, 0.0296201, 52.0272,
   0.0426227}, {60908, 0.0116539, 0.0523335, 52.1588,
  0.0557529}, {60908, -0.00766008, 0.0306582, 52.1557,
  0.0597099}, {"060912A", 0.171323, 0.000598217, 51.9546,
  0.0122}, {"060912A", 0.928472, 0.10509, 50.9378, 0.227572}, {60926,
  0.238949, 0.0173548, 52.3905, 0.0464332}, {60926, 3.00845,
  0.0576412, 48.8753, 0.0867442}, {60927, -0.0895533, 0.0468203,
  53.1165, 0.047901}, {60927, -0.462671, 0.0921108, 52.8255,
  0.219325}, {60927, -0.057078, 0.0410129, 52.5081,
  0.0641991}, {60927, -1.33115, 0.256213, 52.4114, 0.113166}, {61006,
  0.359744, 0.0121905, 51.4605, 0.0143327}, {61006, 1.18448, 0.043012,
   49.7591, 0.147821}, {61021, 0.593566, 0.00887273, 50.7596,
  0.0234674}, {61021, 1.56108, 0.0407374, 49.27,
  0.0943772}, {"061110A", 1.36287, 0.0119183, 50.32,
  0.0325464}, {"061110A", 1.99192, 0.0129035, 48.3477,
  0.0291783}, {61121, 0.301346, 0.0396844, 51.7031, 0.029283}, {61121,
   0.600646, 0.0096731, 52.3152, 0.0110948}, {61121, 0.468036,
  0.0069299, 52.4878, 0.0114521}, {61121, 0.175503, 0.00702152,
  52.5074, 0.0118306}, {61121, -0.0727228, 0.0127069, 53.742,
  0.0405022}, {61121, 0.539234, 0.0922715, 51.058, 0.0873091}, {61121,
   0.989357, 0.0243641, 50.1872, 0.075101}, {"061222A", 0.579203,
  0.0251002, 51.542, 0.107894}, {"061222A", 0.228389, 0.0514028,
  52.0883, 0.041817}, {"061222A", 0.595362, 0.0116877, 51.7638,
  0.0271938}, {"061222A", 0.525808, 0.0253608, 51.8965,
  0.0333713}, {"061222A", 0.663189, 0.0304747, 51.7002,
  0.0813568}, {"061222A", -0.145577, 0.0547762, 52.7291,
  0.0686796}, {"061222A", 0.185374, 0.0260742, 52.3018,
  0.0401114}, {"061222A", 0.0212295, 0.0135473, 52.8097,
  0.0199783}, {"061222A", -0.0749743, 0.1157, 52.1759,
  0.117224}, {"061222A", 1.28635, 0.0394845, 49.9477,
  0.0332537}, {"061222B", 0.571338, 0.0171673, 52.3193,
  0.0403983}, {"061222B", 0.44584, 0.0384295, 52.5228,
  0.416108}, {"061222B", 0.567699, 0.118103, 52.3494,
  0.192875}, {"061222B", 1.87842, 0.0705772, 51.8905,
  0.0888352}, {70208, 0.901541, 0.0284928, 50.8238,
  0.0720124}, {70208, 0.893517, 0.0361887, 50.9824, 0.154968}, {70306,
   0.779638, 0.0641475, 51.2305, 0.10499}, {70306, 0.440943,
  0.0846711, 51.3424, 0.296614}, {70306, 0.823834, 0.032105, 51.2783,
  0.0596025}, {70306, 0.718189, 0.0232693, 51.6936, 0.028308}, {70306,
   0.689272, 0.0258005, 51.8301, 0.107998}, {70306, 1.07786,
  0.0327504, 51.0886, 0.0793789}, {70306, 1.26229, 0.0215009, 49.9074,
   0.0303829}, {70318, 1.20988, 0.00805984, 50.987,
  0.0839657}, {70318, 1.27221, 0.166426, 49.7542, 0.262567}, {70318,
  2.16368, 0.0343402, 48.6029, 0.0601926}, {"070419A", 1.54113,
  0.0261324, 50.4635, 0.0810991}, {"070419A", 1.30045, 0.11489,
  50.0415, 0.267951}, {"070419A", 1.54719, 0.0600307, 49.7293,
  0.115546}, {"070419A", 1.67132, 0.043598, 48.077, 0.193303}, {70506,
   0.536716, 0.0228555, 51.693, 0.0576371}, {70521, 1.05558,
  0.0312994, 50.3987, 0.130817}, {70521, 0.588095, 0.0109799, 50.8757,
   0.0473779}, {70521, 0.642064, 0.00886998, 51.2959,
  0.0252734}, {70521, 0.0366721, 0.0308099, 51.4079,
  0.0961973}, {70521, -0.0742799, 0.0363256, 51.5302,
  0.0571701}, {70521, 0.0928257, 0.00185408, 51.3092,
  0.0116557}, {70521, 0.226415, 0.0209798, 51.0753,
  0.0261653}, {70529, 0.16451, 0.0539939, 52.1603, 0.202182}, {70529,
  1.06578, 0.056994, 52.1558, 0.0919451}, {70529, 0.15186, 0.28168,
  51.6651, 0.138409}, {70529, 1.17428, 0.282654, 49.1856,
  0.371941}, {"070721B", 0.668486, 0.0128593, 52.7887,
  0.0376899}, {"070721B", 1.02947, 0.0602169, 50.7444,
  0.111531}, {"070721B", 0.801528, 0.0982643, 51.5962,
  0.0914482}, {"070721B", 0.321285, 0.010796, 52.6408,
  0.0458559}, {"070721B", 1.06712, 0.0571777, 50.7705,
  0.195539}, {"070721B", 1.69255, 0.153866, 50.342, 0.219555}, {70802,
   0.842556, 0.0388812, 51.3869, 0.116986}, {70809, 0.0380474,
  0.0237785, 49.6826, 0.144945}, {"070810A", 0.610768, 0.0216756,
  51.8866, 0.0332048}, {71020, -0.296922, 0.0138411, 52.9081,
  0.0218264}, {71020, -0.539525, 0.031278, 52.7579,
  0.0588398}, {71020, -0.662121, 0.0163706, 52.9883,
  0.0346658}, {71031, 0.937787, 0.0558742, 51.5549, 0.10243}, {71031,
  1.00636, 0.0266634, 51.2667, 0.0430456}, {71031, 1.3174, 0.0217073,
  50.8812, 0.0378124}, {71031, 1.57473, 0.0366246, 49.7693,
  0.0388104}, {71031, 1.42518, 0.0531695, 49.3036, 0.0570875}, {71031,
   2.07187, 0.0190637, 49.836, 0.0291938}, {71122, 1.54698, 0.0564633,
   50.27, 0.130678}, {71122, 0.854816, 0.262166, 49.9909,
  0.263312}, {80210, 0.876273, 0.0340373, 51.8837, 0.0786244}, {80210,
   0.748646, 0.0335402, 51.9933, 0.0355244}, {80210, 1.39732,
  0.0128282, 49.6184, 0.0502093}, {80310, 1.10858, 0.0527878, 51.5216,
   0.201895}, {80310, 0.183245, 0.0612704, 51.8211, 0.128992}, {80310,
   0.566248, 0.024781, 51.7849, 0.0435016}, {80310, 0.696587,
  0.0355171, 52.1, 0.207602}, {80310, 1.35237, 0.00794881, 50.4816,
  0.0253782}, {80310, 1.08545, 0.0314137, 50.8281, 0.047298}, {80310,
  1.17317, 0.0311276, 50.7955, 0.0557114}, {80310, 0.982175,
  0.0407125, 51.0007, 0.0615117}, {80310, 1.19312, 0.048504, 50.7458,
  0.083336}, {80310, 1.09432, 0.0332606, 50.6077, 0.0549358}, {80310,
  0.934331, 0.0420911, 50.8163, 0.0559881}, {80310, 1.0684, 0.0232451,
   50.415, 0.0345942}, {80310, 0.662898, 0.0154145, 50.5019,
  0.08149}, {80310, 1.19043, 0.0224005, 49.7834, 0.0259058}, {80310,
  1.77976, 0.0161807, 49.4587, 0.0191524}, {80310, 1.26426,
  0.00796771, 50.131, 0.0128881}, {"080319B", 0.44215, 0.00050619,
  52.617, 0.00856709}, {"080319B", 0.27773, 0.0172992, 53.1376,
  0.0125779}, {"080319B", 0.357524, 0.0105069, 53.2977,
  0.00876551}, {"080319B", 0.57704, 0.00400181, 52.5588,
  0.0131561}, {"080319B", 0.452299, 0.0116797, 52.6736,
  0.00654163}, {"080319B", 0.336178, 0.00776455, 53.2306,
  0.00948122}, {"080319B", 0.62615, 0.0110554, 52.7005,
  0.00684867}, {"080319B", 0.332954, 0.0101987, 53.1016,
  0.0062045}, {"080319B", 0.420406, 0.00753245, 52.9388,
  0.00787587}, {"080319B", 0.0544521, 0.0109314, 53.0651,
  0.0107255}, {"080319B", 0.115747, 0.00968423, 53.0765,
  0.00645948}, {"080319B", 0.173343, 0.0153777, 52.7831,
  0.0139192}, {"080319B", 0.153265, 0.0156205, 52.86,
  0.0199248}, {"080319B", 0.0647669, 0.00897457, 53.136,
  0.0243767}, {"080319B", 0.205101, 0.0042423, 52.8945,
  0.00507084}, {"080319B", 0.17895, 0.00471389, 53.0013,
  0.0105359}, {"080319B", -0.190743, 0.00373982, 52.8106,
  0.00659025}, {"080319C", 0.376539, 0.0230995, 52.456,
  0.0340128}, {"080319C", 0.461908, 0.0900893, 52.037,
  0.112575}, {"080319C", -0.0347677, 0.0649429, 51.9863,
  0.0754072}, {"080413A", 0.0252698, 0.00869198, 52.7563,
  0.0148312}, {"080413A", 0.37104, 0.0535197, 52.4242,
  0.1348}, {"080413A", 0.176843, 0.0167855, 52.4331,
  0.0235548}, {"080413A", 0.219109, 0.0524314, 52.0052,
  0.0480293}, {"080413A", 0.10673, 0.0259044, 52.2194,
  0.106169}, {"080413A", 1.79192, 0.0586251, 48.8257,
  0.0823964}, {"080413B", 0.124922, 0.00657546, 52.8062,
  0.0201788}, {80430, 0.822507, 0.0120495, 51.1174,
  0.0347497}, {"080603B", -0.0263151, 0.0123322, 52.6683,
  0.0202948}, {"080603B", 0.147455, 0., 52.5211,
  0.0079649}, {"080603B", -0.532197, 0.0312257, 52.3398,
  0.0701725}, {"080603B", 0.622282, 0.0273396, 51.9382,
  0.0347024}, {"080603B", 0.927972, 0.0789789, 51.2302,
  0.135427}, {"080603B", 0.136924, 0.028774, 52.0914,
  0.0415182}, {80604, 1.3761, 0.0208505, 50.7244, 0.0455571}, {80605,
  0.719049, 0.00910771, 52.1434, 0.02316}, {80605, 0.247858, 0.011283,
   52.4975, 0.0207629}, {80605, -0.276584, 0.0377593, 52.5822,
  0.020945}, {80605, 0.204814, 0.0164586, 52.7545,
  0.025781}, {80605, -0.14434, 0.00839216, 53.1253,
  0.00825454}, {80605, -0.949151, 0.137463, 52.93,
  0.0834705}, {80605, -0.152336, 0.040748, 52.238, 0.403212}, {80605,
  0.594837, 0.0977337, 51.9131, 0.157581}, {80605, 0.405297, 0.181325,
   51.8088, 0.163759}, {80607, 0.384922, 0.0192734, 53.0436,
  0.0345845}, {80607, 0.0507631, 0.00661781, 53.806,
  0.00787866}, {80607, -0.529553, 0.0119129, 53.6808,
  0.0224757}, {80607, 0.0446421, 0.0387927, 52.4738,
  0.0715314}, {80607, 0.346207, 0.0260895, 52.5665,
  0.0268521}, {80607, 0.471841, 0.0599252, 52.3415,
  0.0282045}, {80607, 0.428811, 0.0321542, 52.2754,
  0.0349252}, {80607, 0.661871, 0.019487, 52.1481, 0.029334}, {80607,
  0.203249, 0.0186757, 51.9754, 0.0362854}, {80607, 1.13108,
  0.0171966, 51.4095, 0.0356539}, {80707, 0.649494, 0.0116115,
  51.3093, 0.153943}, {80707, 0.585396, 0.0521667, 51.1397,
  0.118574}, {80721, 0.259289, 0.0163888, 52.8156, 0.0772751}, {80721,
   0.0242592, 0.0342994, 53.4652, 0.0507097}, {80721, -0.305809,
  0.0398217, 53.459, 0.143158}, {80721, 0.644062, 0.105464, 52.1496,
  0.316908}, {80804, 0.541791, 0.0169421, 52.3198, 0.0436334}, {80804,
   0.506927, 0.134666, 51.9972, 0.214399}, {80804, 0.680241, 0.192287,
   52.2559, 0.210602}, {80804, -0.281171, 0.159804, 52.5098,
  0.321676}, {80805, 1.13919, 0.0181028, 51.5226, 0.0273663}, {80805,
  0.570444, 0.0663083, 50.9845, 0.271099}, {80805, 0.27085,
  0.00147139, 51.5239, 0.184001}, {80805, 1.12574, 0.077406, 50.2385,
  0.0759043}, {80805, 1.38425, 0.0159323, 49.6281, 0.0243158}, {80810,
   0.801168, 0.0389149, 52.4437, 0.0571326}, {80810, 0.396093,
  0.0413047, 52.1836, 0.0504335}, {80810, 0.183859, 0.0834918, 52.264,
   0.0621278}, {80810, 0.102554, 0.0282074, 52.1748,
  0.0383065}, {80810, 0.100926, 0.0873976, 52.1205,
  0.0524299}, {80810, 0.384772, 0.0474509, 51.5946, 0.100935}, {80810,
   0.98587, 0.0356593, 51.0052, 0.0805921}, {80810, 0.398424,
  0.0192833, 51.9218, 0.0389033}, {80810, 1.14046, 0.030138, 50.3182,
  0.0617585}, {80810, 1.33966, 0.163959, 48.518,
  0.158041}, {"080905B", 0.701368, 0.0120798, 52.1137,
  0.0506038}, {"080905B", 0.963729, 0.0492185, 51.6202,
  0.059626}, {"080905B", 0.419583, 0.031759, 51.5454,
  0.0976946}, {80913, -0.115456, 0.0633532, 53.0117,
  0.108818}, {80913, -0.17914, 0.162382, 52.7307,
  0.291538}, {"080916A", 0.873666, 0.00529946, 51.2815,
  0.0220788}, {"080916A", 1.24049, 0.0128777, 50.7605,
  0.0357613}, {"080916A", 2.44344, 0.166472, 47.5668,
  0.238568}, {80928, 0.928706, 0.187172, 50.6178, 0.147673}, {80928,
  1.16438, 0.079715, 50.8616, 0.15941}, {80928, 1.29358, 0.0775447,
  50.8237, 0.224583}, {80928, 1.17684, 0.0176441, 50.7729,
  0.0367114}, {80928, 0.839149, 0.0210318, 51.6419,
  0.0235684}, {80928, 1.5107, 0.0243473, 50.8171, 0.0426256}, {80928,
  1.06934, 0.0238515, 50.5012, 0.0742773}, {81007, 1.03408, 0.0102848,
   51.8548, 0.0276605}, {81007, 2.26996, 0.414518, 47.6317,
  0.202995}, {81008, 0.81762, 0.0118377, 51.7923, 0.0336481}, {81008,
  0.595102, 0.0190061, 51.5572, 0.109098}, {81008, 0.988828,
  0.0417241, 51.2762, 0.071541}, {81008, 0.737396, 0.0280542, 51.3205,
   0.0339995}, {81008, 0.504984, 0.0198973, 51.4796,
  0.032397}, {81008, 0.550077, 0.0444027, 51.6565, 0.0582521}, {81008,
   0.864906, 0.0121581, 51.2006, 0.0225265}, {81008, 0.946915,
  0.0141412, 50.8192, 0.0357939}, {81008, 1.39534, 0.030415, 50.122,
  0.0407362}, {81008, 0.350856, 0.0169815, 50.871, 0.0903601}, {81008,
   1.10405, 0.0293892, 50.2482, 0.0387265}, {81008, 1.47014, 0.020094,
   49.7152, 0.0246151}, {81118, 0.518327, 0.0205453, 51.664,
  0.157102}, {81118, 0.745797, 0.0400495, 51.6755, 0.100353}, {81118,
  0.727518, 0.0430016, 52.2078, 0.255554}, {"081203A", 0.727686,
  0.00958956, 51.8849, 0.0203035}, {"081203A", 1.16572, 0.0262239,
  51.9688, 0.0314472}, {"081203A", 0.662885, 0.123436, 51.5642,
  0.4046}, {"081203A", 0.807578, 0.0199247, 52.067,
  0.0238953}, {"081203A", 1.96968, 0.0113294, 49.9878,
  0.0226894}, {"081203A", 1.13993, 0.03482, 50.3814,
  0.0388089}, {81222, 0.284264, 0.00414018, 52.9323,
  0.00680239}, {81222, 0.253555, 0.01293, 51.9406, 0.0694041}, {81230,
   0.608172, 0.0725093, 51.5724, 0.261419}, {81230, 0.714426,
  0.0549688, 51.34, 0.0743797}, {81230, 0.560496, 0.0448048, 51.7716,
  0.223049}, {81230, 0.985662, 0.0476269, 50.5486, 0.0970933}, {90102,
   0.577406, 0.0423527, 52.2216, 0.0814601}, {90102, 0.382619,
  0.0377564, 52.4134, 0.0859701}, {90102, 0.613573, 0.224601, 51.5624,
   0.0775963}, {90205, 0.379999, 0.0366711, 52.1682,
  0.0986786}, {"090418A", 0.792845, 0.0233795, 51.7812,
  0.0643417}, {"090418A", 0.666185, 0.0640762, 51.551,
  0.112534}, {"090418A", 0.634412, 0.01199, 51.6099,
  0.0344134}, {"090418A", 0.66729, 0.0123968, 51.5518,
  0.0752099}, {90423, -0.287637, 0.0411632, 52.9749,
  0.0802836}, {90423, -0.422782, 0.0281131, 53.214,
  0.0371143}, {90423, 0.344964, 0.0380106, 52.9259,
  0.0612116}, {90424, 0.254859, 0.00174521, 52.1698,
  0.00664965}, {90424, -0.0625172, 0.0156677, 51.8028,
  0.0164807}, {90424, -0.335376, 0.00858809, 52.203,
  0.0103601}, {90424, 0.44078, 0.094838, 50.9117, 0.109179}, {90424,
  0.843066, 0.0408965, 51.1967, 0.0831787}, {90424, 1.14422,
  0.0622687, 50.6657, 0.0193798}, {90426, -0.214763, 0.0211034,
  52.6903, 0.100137}, {"090429B", -0.441572, 0.0265523, 53.241,
  0.0509931}, {"090429B", -0.530504, 0.0263154, 53.2441,
  0.0787013}, {90510, -0.504375, 0.0141553, 52.9861,
  0.114656}, {90516, 0.548123, 0.0232115, 52.6586, 0.11463}, {90516,
  0.361374, 0.174816, 52.7293, 0.0851759}, {90516, 0.423599,
  0.0919481, 52.6117, 0.170746}, {90516, 0.21016, 0.0538049, 52.6509,
  0.101478}, {90516, 0.611786, 0.145584, 51.827, 0.107486}, {90516,
  0.605563, 0.0456675, 52.1313, 0.091856}, {90516, 0.963469,
  0.0326623, 51.6957, 0.0439488}, {90516, 0.46625, 0.014892, 51.3065,
  0.0452686}, {90516, 1.15502, 0.0205471, 51.5473, 0.0138865}, {90516,
   0.932981, 0.00513086, 51.3592, 0.016588}, {90516, 1.85607,
  0.0952791, 48.9018, 0.086377}, {90519, 0.778417, 0.0565136, 52.3291,
   0.0947031}, {90519, 0.889232, 0.0631256, 51.5651,
  0.144143}, {"090529A", 1.27896, 0.0346727, 52.3813,
  0.0572612}, {"090529A", 1.15796, 0.0481139, 53.1141,
  0.234518}, {90530, 0.509582, 0.0102415, 52.7701, 0.0416395}, {90530,
   0.65104, 0.0161504, 52.1809, 0.0974798}, {90618, 1.05125,
  0.0021989, 51.6885, 0.00759165}, {90618, 0.72887, 0.0135604,
  51.3571, 0.0227916}, {90618, 1.17832, 0.016922, 51.2802,
  0.0169565}, {90618, 0.798522, 0.00391267, 51.5918,
  0.0114946}, {90618, 0.896937, 0.00771452, 51.7826,
  0.0144657}, {90618, 0.839621, 0.0012583, 52.3375,
  0.00305671}, {90618, 0.747535, 0.0133394, 51.7743,
  0.0226183}, {90618, 0.327096, 0.00889136, 51.983, 0.019337}, {90618,
   0.530546, 0.0123764, 51.8023, 0.0196684}, {90618, 0.768463,
  0.0097375, 51.7643, 0.0166132}, {90618, 0.910908, 0.0047045,
  51.9862, 0.00818151}, {90618, 0.586195, 0.01121, 51.872,
  0.0158303}, {90618, 0.989072, 0.0086364, 51.7254,
  0.0120578}, {90618, 1.00525, 0.016897, 51.1485, 0.0475947}, {90618,
  1.03504, 0., 51.6591, 0.00261951}, {90618, 1.10502, 0.00278336,
  51.5742, 0.00372695}, {90618, 0.927326, 0.052485, 50.2671,
  0.0774956}, {"090715B", 0.598407, 0.0415765, 51.9411,
  0.0466309}, {"090715B", 0.4989, 0.0156081, 52.5778,
  0.0197698}, {"090715B", 0.0143463, 0.0320197, 52.4738,
  0.0328774}, {"090715B", 0.707121, 0.0336261, 51.7424,
  0.0540592}, {"090715B", 0.269454, 0.0760676, 51.9103,
  0.0779365}, {"090715B", 0.4596, 0.0880991, 51.7307,
  0.0778184}, {"090715B", 0.490664, 0.0441637, 52.1395,
  0.0424371}, {"090715B", 0.735678, 0.0535246, 51.4769,
  0.0794581}, {"090715B", 0.930822, 0.0422863, 50.8764,
  0.0770782}, {"090715B", 1.1855, 0.0511008, 50.1168,
  0.0596057}, {"090715B", 1.06365, 0.0403761, 50.6239,
  0.10124}, {"090715B", 1.02917, 0.0412129, 50.9226,
  0.058668}, {"090715B", 1.10039, 0.0383252, 50.7311,
  0.0554349}, {"090715B", 1.50783, 0.0452588, 49.8966,
  0.0398245}, {"090715B", 1.61485, 0.0163368, 49.7605,
  0.0646125}, {"090715B", 0.758854, 0.0190976, 51.6005,
  0.0342994}, {"090715B", 0.801158, 0.0140095, 51.3625,
  0.0250826}, {90812, 0.856812, 0.00747101, 52.1687,
  0.0199573}, {90812, 0.564462, 0.0851412, 51.8673, 0.153292}, {90812,
   0.139254, 0.0214227, 52.4054, 0.0317614}, {90812, 0.893942,
  0.019131, 51.5454, 0.0319788}, {90812, 1.65354, 0.0158007, 50.5064,
  0.0235791}, {90812, 1.60488, 0.0316158, 49.5782, 0.0242773}, {91018,
   0.378104, 0.005478, 52.1236, 0.0355425}, {91020, 0.631622,
  0.00689912, 52.1666, 0.0166544}, {91020, 0.644326, 0.0743283,
  51.2564, 0.178093}, {91020, 0.575045, 0.0985927, 50.4074,
  0.171375}, {91020, 1.47067, 0.0641288, 49.423, 0.0749521}, {91029,
  0.40552, 0.018683, 51.9065, 0.042529}, {91029, 0.391117, 0.0911254,
  51.6413, 0.0967328}, {91029, 0.423473, 0.114399, 51.6391,
  0.253457}, {91029, 0.452455, 0.0167957, 52.2087, 0.0237738}, {91029,
   0.0943812, 0.0304492, 51.9074, 0.142128}, {91029, 0.461725,
  0.0396996, 51.9176, 0.046239}, {91029, 0.313065, 0.0937136, 51.7266,
   0.312083}, {91029, 0.659042, 0.0328671, 51.7926,
  0.192847}, {"091109A", 0.761659, 0.0354177, 52.1084,
  0.0784276}, {"091208B", 0.615549, 0.0221803, 51.9082,
  0.124984}, {"091208B", 0.0482497, 0.0336255, 52.2364,
  0.0483138}, {"100219A", 1.08322, 0.058909, 51.7911,
  0.0859715}, {"100316B", 0.655768, 0.0504467, 51.3272,
  0.229782}, {"100418A", 0.765624, 0.0504267, 51.0087,
  0.0725341}, {"100418A", 0.631429, 0.0648843, 50.4779,
  0.194083}, {"100418A", 1.20129, 0.0205594, 50.5696,
  0.153261}, {"100425A", 0.326838, 0.0488946, 52.3805,
  0.347734}, {"100425A", 0.593888, 0.0538098, 53.0527,
  0.135166}, {"100425A", 0.417726, 0.0444488, 52.8126,
  0.0718143}, {"100425A", 0.18887, 0.15433, 51.4159,
  0.276135}, {"100425A", 1.71286, 0.0248558, 49.5062,
  0.0289513}, {"100513A", 0.342379, 0.0583189, 52.2553,
  0.108197}, {"100513A", 0.158019, 0.114638, 52.3617,
  0.206093}, {"100513A", 0.446065, 0.132976, 51.9462,
  0.211526}, {"100513A", 0.294008, 0.13704, 52.1844,
  0.230712}, {"100513A", 0.403166, 0.162672, 52.1201,
  0.169247}, {"100513A", 0.598118, 0.108355, 52.0352,
  0.262539}, {"100513A", 1.57501, 0.0619295, 49.7749,
  0.104159}, {"100621A", 1.2571, 0.00248549, 50.8431,
  0.0019841}, {"100621A", 1.02431, 0.00527812, 50.8295,
  0.0285042}, {"100621A", 0.898186, 0.0145592, 50.9195,
  0.023621}, {"100621A", 1.12759, 0., 51.2581,
  0.00248068}, {"100621A", 1.27708, 0.00833668, 51.676,
  0.0158609}, {"100621A", 1.12804, 0.02357, 51.3026,
  0.0872885}, {"100621A", 1.83067, 0.0247785, 49.7576,
  0.0487871}, {"100724A", -0.160232, 0.0380904, 52.0261,
  0.258741}, {"100814A", 0.538731, 0.00445234, 52.2532,
  0.0216216}, {"100814A", 0.929523, 0.0467202, 51.6463,
  0.0801113}, {"100814A", 0.226372, 0.284402, 51.4086,
  0.118099}, {"100814A", 0.525638, 0.0427085, 51.0249,
  0.090365}, {"100814A", 0.389739, 0.0540388, 51.0305,
  0.207925}, {"100814A", 0.714357, 0.298108, 50.6117,
  0.252791}, {"100814A", 0.708288, 0.019338, 51.4274,
  0.0335138}, {"100814A", 0.903215, 0.0548698, 51.2355,
  0.0501909}, {"100814A", 0.595603, 0.14235, 50.959,
  0.119146}, {"100814A", 1.27274, 0.0606866, 50.7207,
  0.0740681}, {"100814A", 1.25101, 0.0914535, 50.5441,
  0.154932}, {"100814A", 1.08907, 0.0767149, 50.6593,
  0.0703326}, {"100814A", 1.20588, 0.0886688, 50.5662,
  0.100255}, {"100814A", 1.49325, 0.046892, 50.2761,
  0.10557}, {"100814A", 0.650379, 0.0366328, 51.4635,
  0.0315801}, {"100814A", 1.26495, 0.0419014, 50.3119,
  0.0603519}, {"100814A", 1.71672, 0.0248069, 49.5113,
  0.0292686}, {"100816A", 0.0149803, 0.0119821, 51.9607,
  0.0676304}, {"100816A", 1.29213, 0.190569, 49.7502,
  0.262851}, {"100816A", 1.6848, 0.0880799, 48.5435,
  0.233746}, {"100901A", 1.19722, 0.0295508, 51.5073,
  0.127538}, {"100901A", 1.54911, 0.0425711, 50.3516,
  0.117141}, {"100901A", 2.34594, 0.0812129, 48.91,
  0.0847322}, {"100901A", 2.10943, 0.0421029, 50.0682,
  0.136868}, {"100901A", 1.44175, 0.0250404, 50.8471,
  0.039437}, {"100901A", 1.9619, 0.0617889, 48.4906,
  0.0793506}, {"100906A", 0.63389, 0.0131814, 53.0251,
  0.0185003}, {"100906A", 0.717242, 0.0553833, 52.3246,
  0.0691956}, {"100906A", 0.213407, 0.0147652, 52.981,
  0.0917204}, {"100906A", 0.828901, 0.0388256, 51.895,
  0.212486}, {"100906A", 0.590781, 0.132644, 51.7601,
  0.258493}, {"100906A", 0.64729, 0.168171, 51.9466,
  0.170753}, {"100906A", 0.873843, 0.038564, 51.9441,
  0.0783125}, {"100906A", 0.84396, 0.0698883, 51.8566,
  0.0808729}, {"100906A", 0.643559, 0.0265075, 52.2209,
  0.0301405}, {"100906A", 0.325834, 0.0289732, 52.4856,
  0.0245972}, {"100906A", 0.636556, 0.0755357, 52.008,
  0.056043}, {"100906A", 0.554371, 0.0256287, 52.3045,
  0.0344274}, {"100906A", 0.757245, 0.0448894, 51.9778,
  0.0733829}, {"100906A", 1.07446, 0.0300283, 51.6283,
  0.0538068}, {"101219A", -0.783164, 0.0702662, 52.9462,
  0.121627}, {"101219A", -0.782581, 0.0851697, 52.3652,
  0.217717}, {"101219A", 1.85231, 0.0955629, 48.9555,
  0.269649}, {"101219B", 1.5373, 0.0388152, 50.5488,
  0.0829157}, {"101219B", 2.30824, 0.0259355, 47.5919,
  0.0587824}, {"110106B", 0.570402, 0.0115613, 50.5435,
  0.0753306}, {"110106B", 1.00221, 0.0802855, 50.6171,
  0.109042}, {"110106B", 0.757977, 0.061137, 50.4917,
  0.293695}, {"110106B", 2.79859, 0.115573, 47.5933,
  0.177103}, {"110106B", 2.35211, 0.262166, 46.678,
  0.263407}, {"110205A", 1.10612, 0.0696069, 51.4405,
  0.0817031}, {"110205A", 0.924489, 0.161125, 51.2768,
  0.18391}, {"110205A", 0.910795, 0.0473976, 51.6836,
  0.0625216}, {"110205A", 0.256987, 0.368618, 51.4408,
  0.141103}, {"110205A", 0.89291, 0.0200059, 51.6409,
  0.0253451}, {"110205A", 0.656375, 0.0726434, 51.4127,
  0.0633761}, {"110205A", 1.02848, 0.0159569, 51.919,
  0.015557}, {"110205A", 0.745758, 0.0365899, 51.865,
  0.0345805}, {"110205A", 0.854365, 0.040425, 51.5598,
  0.0373446}, {"110205A", 0.736908, 0.0795586, 51.4728,
  0.0675482}, {"110205A", 1.12679, 0.0366882, 51.5866,
  0.031098}, {"110205A", 1.05091, 0.0141102, 52.0044,
  0.0119991}, {"110205A", 0.934144, 0.0725223, 51.1901,
  0.063395}, {"110205A", 1.08615, 0.0520845, 51.0979,
  0.0643372}, {"110205A", 1.72358, 0.0177861, 51.0445,
  0.0307198}, {"110205A", 2.79182, 0.0412975, 49.1724,
  0.0415045}, {"110205A", 1.46208, 0.0284457, 49.5396,
  0.0356727}, {"110213A", 0.47235, 0.0154803, 51.995,
  0.0397419}, {"110213A", 0.407834, 0.0627362, 52.3646,
  0.131239}, {"110213A", 0.54063, 0.255022, 52.0683,
  0.156909}, {"110213A", 0.167971, 0.2409, 51.6263,
  0.202509}, {"110213A", 0.455594, 0.0807546, 52.0743,
  0.262434}, {"110213A", 1.22566, 0.168652, 49.8674,
  0.262554}, {"110422A", 0.6675, 0.0121304, 52.4237,
  0.0265451}, {"110422A", 0.55086, 0.0206789, 52.6396,
  0.0290013}, {"110422A", 0.389775, 0.00529, 53.0417,
  0.0279398}, {"110422A", 0.211791, 0.00454651, 53.0909,
  0.0317064}, {"110422A", 0.360047, 0.0161387, 52.7772,
  0.0213484}, {"110422A", -0.0239745, 0.018498, 52.7422,
  0.0258724}, {"110422A", -0.141484, 0.0174522, 52.438,
  0.0266967}, {"110503A", 0.181516, 0.0104219, 53.0165, 0.0174921}}
Posted 11 years ago
I believe to understand that you have a list from which you would like to remove list elements containing a Null in a certain position.

DeleteCases with a suitable pattern should be able to help you there, e.g.:
In[1]:= list = {{a,}, {b, c}}

Out[1]= {{a, Null}, {b, c}}

In[2]:= DeleteCases[list, {_, Null}]

Out[2]= {{b, c}}

If this is not catching the essence of your question, then please provide sample data for LxTptocompare and Tabletoplot, so one can see your function in action.
POSTED BY: Peter Fleck
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract