I'm getting a csv file in input, that is a example of the content:
TIME,Value
2010,77.77046
2010,60.32812
2010Q1,63.33447
2010Q2,61.29888
2010Q3,59.06448
2010Q4,57.62415
2011,60.75586
2011Q1,60.97929
2011Q2,61.36082
2011Q3,59.88779
2011Q4,60.79407
That is the code i use to take the csv, read the content and put it into an array.
if (($handle = fopen("csvExtractTor.csv", "r")) !== FALSE) {
# Set the parent multidimensional array key to 0.
$nn = 0;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
# Count the total keys in the row.
$c = count($data);
# Populate the multidimensional array.
for ($x=0;$x<$c;$x++)
{
$brim[$nn][$x] = $data[$x];
}
$nn++;
}
# Close the File.
fclose($handle);
};
What i need, is to take the values of each quarters, for example, 2010Q1, 2010Q2, 2010Q3, 2010Q4, sum it and divided / 4 for the medium and save the operation to a unique value in 2010, into the csv or in a variable. I've tried lots of solutions but none works good. I tried the method strpos(), i was able to read only a value per time, but after that i cannot do other things. Does anyone have an advise to solve my problem?
kind regards