Merge and transpose 3 arrays of data

Question

There are three single dimensional arrays that needs to be saved in csv

$arr1=array(1,2,3);
$arr2=array('a','b','c');
$arr3=array('x','y','z');

I need to save the above arrays in the csv like the following example-

1,a,x
2,b,y
3,c,z

I have tried the following code but its not saving in that format

$handle = fopen('file.csv', 'w');
$data=array($arr1,$arr2,$arr3);
foreach ($data as $line) {
    fputcsv($handle, $line);
}
fclose($handle);

Output

1,2,3
a,b,c
x,y,z

What exactly are you getting instead? – deceze Feb 27 '14 at 08:35 — deceze, Feb 27 '14 at 08:35

score 2 · Answer 1 · answered Feb 27 '14 at 08:39

2

foreach ($arr1 as $key => $value) {
    fputcsv($handle, array($value, $arr2[$key], $arr3[$key]));
}

answered Feb 27 '14 at 08:39

deceze

510,633
85
743
889

score 2 · Accepted Answer · answered Feb 27 '14 at 08:56

Transpose the data before writing to the CSV

$data = array($arr1,$arr2,$arr3);
$transposedData = call_user_func_array(
    'array_map',
    array_merge(
        array(NULL),
        $data
    )
);

$handle = fopen('file.csv', 'w');

foreach ($transposedData  as $line) {
    fputcsv($handle, $line);
}
fclose($handle);

ReeCube · Answer 3 · 2014-02-27T08:52:53.937

0

<?php
   $arr1=array(1,2,3);
   $arr2=array('a','b','c');
   $arr3=array('x','y','z');

   $output = '';

   $data=array($arr1,$arr2,$arr3);
   $size=count($data[0]);
   //all arrays must have the same size! and $data must contain at least one item

   for ($i = 0; $i < $size; $i++) {
      foreach ($data as $arr) {
         $output .= $arr[$i] . ';';
      }
      $output .= "\n";
   }

   file_put_contents($output);
?>

Expected output:


    1;a;x;
    2;b;y;
    3;c;z;

edited Feb 27 '14 at 08:52

answered Feb 27 '14 at 08:38

ReeCube

2,545
17
23

You need to strip the trailing delimiter from each row before adding the \n. CSV rows are terminated by a newline, not a delimiter+newline. – The Blue Dog Feb 27 '14 at 08:43

score 0 · Answer 4 · answered Feb 27 '14 at 08:46

try like below:-

$arr1=array(1,2,3);
$arr2=array('a','b','c');
$arr3=array('x','y','z');
$handle = fopen('file.csv', 'w');
for($i=0; $i<count($arr1); $i++) {
  $data=array($arr1[$i],$arr2[$i],$arr3[$i]);
  fputcsv($handle, $data);
}
fclose($handle);

output

1   a   x
2   b   y
3   c   z

score 0 · Answer 5 · answered Feb 27 '14 at 08:48

Try this,Just take the transpose of the array before fputcsv

  <?php
 $arr1=array(1,2,3);
 $arr2=array('a','b','c');
 $arr3=array('x','y','z');
 $data=array($arr1,$arr2,$arr3);
 $rows = count($data);
 $cols = count($data[0]);
 $ridx = 0;
 $cidx = 0;

 $out = array();

 foreach($data as $rowidx => $row){
 foreach($row as $colidx => $val){
    $out[$ridx][$cidx] = $val;
    $ridx++;
    if($ridx >= $rows){
        $cidx++;
        $ridx = 0;
    }
}
}


$handle = fopen('file.csv', 'w');

 foreach ($out as $line) {
   fputcsv($handle, $line);
}
fclose($handle);
 ?>

Output

 1,a,x
 2,b,y
 3,c,z

Merge and transpose 3 arrays of data

5 Answers5