Buongiorno a tutti e buona domenica,
ho un file csv di che ha questa struttura
codice:
IG9,0.023633,51.631727,0.0 0.024642,51.632611,0.0 0.026397,51.638204,0.0 0.027491,51.637731,0.0 0.038207,51.635136,0.0 0.038709,51.635339,0.0 0.043396,51.633841,0.0 0.043655,51.633553,0.0 0.045378,51.633136,0.0 0.047472,51.63188,0.0 0.047482,51.631879,0.0 0.047931,51.631934,0.0 0.048539,51.631949,0.0 0.049134,51.632217,0.0 0.050401,51.633209,0.0 0.051427,51.633683,0.0 0.051443,51.633678,0.0 0.052416,51.633508,0.0 0.053974,51.632924,0.0 0.054718,51.632936,0.0 0.055062,51.63279,0.0 0.055272,51.632612,0.0 0.055636,51.632517,0.0 0.056932,51.632518,0.0 0.057558,51.631861,0.0 0.058124,51.631777,0.0 0.06076,51.630517,0.0 0.06241,51.629506,0.0 0.061111,51.628459,0.0 0.059938,51.626983,0.0 0.059778,51.626829,0.0 0.059272,51.625341,0.0 0.059933,51.62344,0.0 0.057541,51.621512,0.0 0.057314,51.620929,0.0 0.056399,51.620235,0.0 0.055092,51.618719,0.0 0.055059,51.618676,0.0 0.054057,51.616795,0.0 0.054073,51.61672,0.0 0.054172,51.613696,0.0 0.053324,51.613397,0.0 0.0509,51.611435,0.0 0.045623,51.613428,0.0 0.045545,51.613418,0.0 0.044298,51.613923,0.0 0.044451,51.61445,0.0 0.044018,51.615025,0.0 0.043515,51.615105,0.0 0.04296,51.61534,0.0 0.042112,51.615244,0.0 0.041544,51.616492,0.0 0.041175,51.616415,0.0 0.040014,51.616945,0.0 0.040328,51.61751,0.0 0.036832,51.617915,0.0 0.036709,51.618004,0.0 0.03619,51.618563,0.0 0.036513,51.619895,0.0 0.038,51.620961,0.0 0.037862,51.621119,0.0 0.036942,51.62186,0.0 0.034865,51.622142,0.0 0.03262,51.62198,0.0 0.031588,51.6215,0.0 0.031357,51.621585,0.0 0.028898,51.621785,0.0 0.028768,51.621786,0.0 0.028722,51.621895,0.0 0.028267,51.622136,0.0 0.025869,51.622601,0.0 0.025785,51.622575,0.0 0.024725,51.622952,0.0 0.024526,51.623195,0.0 0.024236,51.623252,0.0 0.024464,51.624298,0.0 0.024172,51.624538,0.0 0.024303,51.625312,0.0 0.022791,51.626329,0.0 0.022899,51.627024,0.0 0.02394,51.628358,0.0 0.023849,51.629083,0.0 0.023884,51.629379,0.0 0.023732,51.629805,0.0 0.023625,51.631591,0.0 0.023633,51.631727,0.0
IG7,0.133392,51.620263,0.0 0.141052,51.622444,0.0 0.142648,51.622494,0.0 0.15399,51.619266,0.0 0.149496,51.613868,0.0 0.149633,51.613263,0.0 0.150332,51.609393,0.0 0.150304,51.60854,0.0 0.147843,51.604713,0.0 0.146933,51.604317,0.0 0.141163,51.604658,0.0 0.130681,51.59762,0.0 0.12904,51.598798,0.0 0.129363,51.603141,0.0 0.129911,51.606526,0.0 0.130127,51.606724,0.0 0.127508,51.609345,0.0 0.128839,51.614315,0.0 0.130084,51.615554,0.0 0.129606,51.616447,0.0 0.127334,51.616414,0.0 0.125166,51.615235,0.0 0.122306,51.612971,0.0 0.121744,51.612882,0.0 0.120857,51.612191,0.0 0.120805,51.612182,0.0 0.120693,51.612123,0.0 0.120262,51.611636,0.0 0.118895,51.611536,0.0 0.118842,51.611554,0.0 0.118364,51.61204,0.0 0.117262,51.611975,0.0 0.116604,51.611231,0.0 0.11757,51.610816,0.0 0.117568,51.610749,0.0 0.116793,51.61026,0.0 0.117134,51.60975,0.0 0.117134,51.609708,0.0 0.116197,51.608872,0.0 0.115541,51.609248,0.0 0.115453,51.609233,0.0 0.113588,51.608493,0.0 0.113626,51.608337,0.0 0.113352,51.607501,0.0 0.113358,51.607488,0.0 0.112526,51.607104,0.0 0.111888,51.607173,0.0 0.111208,51.60736,0.0 0.111012,51.607528,0.0 0.109795,51.607287,0.0 0.109816,51.607225,0.0 0.109198,51.606322,0.0 0.109114,51.606311,0.0 0.108073,51.606882,0.0 0.10785,51.606928,0.0 0.107406,51.607178,0.0 0.107266,51.607175,0.0 0.106631,51.606859,0.0 0.106439,51.606883,0.0 0.1051,51.607278,0.0 0.105054,51.607451,0.0 0.104436,51.607666,0.0 0.10416,51.60765,0.0 0.10307,51.608748,0.0 0.102952,51.608799,0.0 0.102962,51.607654,0.0 0.101847,51.607277,0.0 0.101761,51.607286,0.0 0.101594,51.607434,0.0 0.101345,51.607963,0.0 0.101114,51.608057,0.0 0.100415,51.608061,0.0 0.099856,51.608328,0.0 0.098919,51.607699,0.0 0.098453,51.60823,0.0 0.097921,51.608246,0.0 0.097292,51.60883,0.0 0.095682,51.609291,0.0 0.094988,51.608853,0.0 0.094788,51.608692,0.0 0.094884,51.60815,0.0 0.095165,51.60769,0.0 0.095175,51.60758,0.0 0.094898,51.60691,0.0 0.094802,51.606799,0.0 0.09471,51.606235,0.0 0.095066,51.605508,0.0 0.094904,51.605217,0.0 0.09268,51.605048,0.0 0.092532,51.604968,0.0 0.09253,51.604957,0.0 0.092136,51.60442,0.0 0.090577,51.604342,0.0 0.090487,51.604325,0.0 0.089901,51.603536,0.0 0.089714,51.603581,0.0 0.088856,51.604002,0.0 0.088291,51.604124,0.0 0.08775,51.604382,0.0 0.087732,51.604408,0.0 0.087721,51.604449,0.0 0.087933,51.60506,0.0 0.087655,51.605311,0.0 0.086846,51.605249,0.0 0.086394,51.605438,0.0 0.086323,51.605755,0.0 0.085714,51.605824,0.0 0.085246,51.606026,0.0 0.085059,51.606421,0.0 0.084927,51.606535,0.0 0.084058,51.6064,0.0 0.083456,51.606574,0.0 0.082977,51.606457,0.0 0.081126,51.60693,0.0 0.081119,51.606935,0.0 0.081072,51.606942,0.0 0.080859,51.607018,0.0 0.080635,51.60701,0.0 0.079324,51.606496,0.0 0.078679,51.606475,0.0 0.078582,51.606099,0.0 0.078041,51.605592,0.0 0.076631,51.605585,0.0 0.076628,51.605327,0.0 0.07642,51.60474,0.0 0.075862,51.604364,0.0 0.075036,51.604131,0.0 0.07408,51.604647,0.0 0.073315,51.604619,0.0 0.072942,51.604652,0.0 0.072489,51.604563,0.0 0.071954,51.604622,0.0 0.070729,51.605963,0.0 0.070387,51.605927,0.0 0.069587,51.605552,0.0 0.069276,51.60525,0.0 0.068727,51.605121,0.0 0.066535,51.604863,0.0 0.065592,51.605291,0.0 0.065242,51.605348,0.0 0.065235,51.605389,0.0 0.064545,51.60662,0.0 0.064918,51.607582,0.0 0.066343,51.607471,0.0 0.067147,51.607738,0.0 0.067205,51.607999,0.0 0.070302,51.608547,0.0 0.068998,51.60944,0.0 0.068102,51.609579,0.0 0.066457,51.609042,0.0 0.065758,51.609217,0.0 0.065177,51.610092,0.0 0.065372,51.611144,0.0 0.065325,51.611225,0.0 0.061234,51.613517,0.0 0.059205,51.612978,0.0 0.056822,51.613163,0.0 0.054172,51.613696,0.0 0.054073,51.61672,0.0 0.054057,51.616795,0.0 0.055059,51.618676,0.0 0.055092,51.618719,0.0 0.056399,51.620235,0.0 0.057314,51.620929,0.0 0.057541,51.621512,0.0 0.059933,51.62344,0.0 0.059272,51.625341,0.0 0.059778,51.626829,0.0 0.059938,51.626983,0.0 0.061111,51.628459,0.0 0.06241,51.629506,0.0 0.064692,51.630377,0.0 0.065297,51.631903,0.0 0.06582,51.632354,0.0 0.065946,51.632434,0.0 0.067701,51.633413,0.0 0.07173,51.635237,0.0 0.071764,51.635243,0.0 0.073371,51.635275,0.0 0.077514,51.634636,0.0 0.079078,51.635732,0.0 0.081883,51.637216,0.0 0.083346,51.637307,0.0 0.087477,51.637954,0.0 0.088755,51.63809,0.0 0.090467,51.641465,0.0 0.092564,51.642295,0.0 0.0996,51.644141,0.0 0.099516,51.646012,0.0 0.099957,51.64785,0.0 0.100771,51.648953,0.0 0.111265,51.644928,0.0 0.112333,51.644286,0.0 0.114469,51.641717,0.0 0.114129,51.640123,0.0 0.122745,51.636939,0.0 0.123167,51.632268,0.0 0.122831,51.630424,0.0 0.122385,51.629978,0.0 0.124109,51.628334,0.0 0.125391,51.626856,0.0 0.133392,51.620263,0.0
Ho iniziato a parsarlo in questo modo:
Codice PHP:
    $file = file('miofile.csv');
    foreach($file as $line)
    {
        $row = explode(",", $line, 2);
        echo "<b>" .$row[0]. "</b>"; // questo è il primo valore che mi serve
        
        // itero su secondo array
        $arr = $row[1];
        //foreach 
Con questo script riesco a prelevare correttamente la stringa alfanumerica all'inizio di ogni riga e farmi restituire un altro array associato a questa stringa che ha dei valori che si ripetono ogni 3 volte.
Cercavo un modo efficiente per iterare questo secondo array in modo da evitare di dover usare degli indici multipli. In pratica questo secondo array ha dei valori che si ripetono ogni 3 volte, quindi vorrei appunto iterare su $arr[0] - $arr[1] - $arr[3] che sono questi 3 campi che mi interessano e che si ripetono appunto più volte.

Conoscete un modo per fare ciò correttamente?
Il risultato che vorrei ottenere è una tabella SQL di questo tipo

IG9 0.023633 51.631727 0.0
IG9 0.024642 51.632611 0.0
IG9 0.026397 51.638204 0.0
IG9 ecc ecc ecc
...
...
...

Potremmo sfruttare forse lo spazio che c'è dopo ogni "triade" per capire che è lì che iniziano altri 3 valori appunto.
Voi cosa suggerite?