check index of columns in key of an array and remove columns with value 0

Question

I have a php code that takes the matched rows of a csv file and puts them in an array. my csv file looks like this:

Company,Produkt,Sortiment name,31,32,33,34,35,36,37,38 //these are shoe sizes
Dockers,AD1234,Sort A,2,3,5,3,2,1,0,0  //and these numbers are how many pairs of shoes
Addidas,AB1234,Sort B,2,2,1,4,,0,0,4,3
Nike,AC1234,Sort C,0,2,0,1,4,0,4,3
Dockers,AE1234,Sort D,0,1,2,3,4,1,0,2

and my php code is

$csv = file_get_contents($_SERVER['DOCUMENT_ROOT'] . 'CsvTest/Sortiment.csv');

    $input = 'Company'; // column
    $value = 'Dockers'; // what value of that column

    $csv = array_map("str_getcsv", explode(PHP_EOL, $csv));
    $keys = array_shift($csv);
    $key = array_search($input, $keys);

    $sortiment_array = array();
    while ($line = array_shift($csv)) {
        if ($line[$key] == $value) {
            $line = implode(',', $line) . PHP_EOL;
            $sortiment_array[] = $line;
        }
    }

so var_dump($sortiment_array); will give me the following

array(2) {
  [0]=>
  string(39) "Dockers,AD1234,Sort A,2,3,5,3,2,1,0,0"
  [1]=>
  string(39) "Dockers,AE1234,Sort D,0,1,2,3,4,1,0,2"
}

What I would like to do is to have the 0 columns taken out from the array and so therefore I need to identify what pair of shoes was not 0 ? So I need the first row (which is the header for my case) to repeat itself for each key and take out the shoe size that had 0 pairs. basically my array should turn into something like:

array(2) {
  [0]=>array(2)
       ['shoe size']=> "Producer,Produkt,Sortiment name,31,32,33,34,35,36" // no 37,38 
       ['sortiment']=> "Dockers,AD1234,Sort A,2,3,5,3,2,1,"// no 0
  [1]=>array(2)
       ['shoe size']=> "Producer,Produkt,Sortiment name,32,33,34,35,36,38" // no 31, 37 
       ['sortiment']=> "Dockers,AE1234,Sort D,1,2,3,4,1,2" 
}

Basically in 'shoe size' sizes should be taken out where the matched row has 0 pairs for that size. I hope I can explain it. I tried my best. Any suggestions?

Don't Panic · Accepted Answer · 2022-02-28 16:48:55Z

2

If all the rows in the data are the same size, you can combine the keys and values for each line that matches, then filter that to remove the zeros.

while ($line = array_shift($csv)) {
    if ($line[$key] == $value) {

        // combine keys and values, and filter to remove zeros
        $filtered = array_filter(array_combine($keys, $line));

        // separate the resulting keys and values and add them to your output array
        $sortiment_array[] = [
            'shoe size' => implode(',', array_keys($filtered)),
            'sortiment' => implode(',', $filtered)
        ];
    }
}

edited Feb 28, 2022 at 16:48

answered Feb 28, 2022 at 16:23

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kmoser · Accepted Answer · 2022-02-28 17:00:59Z

<?php

$csv = file_get_contents($_SERVER['DOCUMENT_ROOT'] . 'CsvTest/Sortiment.csv');

$input = 'Company'; // column
$value = 'Dockers'; // what value of that column

$csv = array_map("str_getcsv", explode(PHP_EOL, $csv));

$keys = array_shift($csv);
$key = array_search($input, $keys);

$sortiment_array = array();
while ($line = array_shift($csv)) {
    if ($line[$key] == $value) {
        $lineStr = implode(',', $line) . PHP_EOL;

        $outputKeys = [];
        $outputLine = [];

        // Look through $line to find non-'0' elements and for each of them,
        // add the corresponding elements to $outputKeys and $outputLine:
        for( $i=0; $i < sizeof($keys); $i++ ) {
            if ( $line[$i] !== '0' ) { // No '0' in this slot so add this slot to $outputKeys and $outputLine:
                $outputKeys[] = $keys[$i];
                $outputLine[] = $line[$i];
            }
        }

        // Join $outputKeys and $outputLines back into a string:
        $sortiment_array[] = [
            join(',', $outputKeys),
            join(',', $outputLine)
        ];
    }
}
print_r($sortiment_array);

Lajos Arpad · Accepted Answer · 2022-02-28 17:21:05Z

0

You can implement the logic which does it for a pair of arrays, the first being the template (header row) and the second the csv row after the header.

function nonZeros($template, $row) {
    $output = [
        'shoe_size' => [],
        'sortiment' => []
    ];
    for ($index = 0; $index < count($row); $index++) {
        if ($row != 0) {
            $output['shoe_size'][]=$template[$index];
            $output['sortiment'][]=$row[$index]
        }
    }
    return $output;
}

and then you can loop the lines and call nonZeros, passing the corresponding arrays.

answered Feb 28, 2022 at 17:21

Lajos Arpad

80.5k42 gold badges124 silver badges235 bronze badges

Collectives™ on Stack Overflow

check index of columns in key of an array and remove columns with value 0

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related