CSV to Associative Array

Question

I've seen numerous examples on how to take a CSV file and then create an associative array with the headers as the keys.

For example:

Brand,Model,Part,Test
Honda,Civic,123,244
Honda,Civic,135,434
Toyota,Supra,511,664

Where it would create an Array such as Array[$num][$key] where $key would be Brand, Model, Part, Test.

So If I wanted to access the test value "434" I would have to loop every index in the array and then ignore any Brands that were not honda, and any models that were not Civic

What I need to do is access the value most directly, instead of running through a for loop going through each $num index. I want to be able to access the value test "434" with:

Array['Honda']['Civic']['135']

or control a for statement with looping through every model Honda has... something like

foreach $model in Array['Honda']

At the very least I need to be able to go through every model given a known Brand and access all the relative info for each.

Edit:

Just to confirm I was setting this up an example. My actually data has headers like:

brand model part price shipping description footnote

Of which I need to access all the information tied to the part (price, shipping,desc, footnote)

Example(s) how to do that with SplFileInfo

hakre
– hakre

2013-01-21 10:00:52 +00:00
Commented Jan 21, 2013 at 10:00 — hakre
– hakre, Commented Jan 21, 2013 at 10:00

Daerik · Accepted Answer · 2018-10-30 12:22:50Z

149

Too many long solutions. I've always found this to be the simplest:

<?php
    /* Map Rows and Loop Through Them */
    $rows   = array_map('str_getcsv', file('file.csv'));
    $header = array_shift($rows);
    $csv    = array();
    foreach($rows as $row) {
        $csv[] = array_combine($header, $row);
    }
?>

edited Oct 30, 2018 at 12:22

answered Jan 30, 2017 at 17:50

Daerik

4,2933 gold badges23 silver badges34 bronze badges

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

11 Comments

Alex Over a year ago

marvelous code, it works great with comma separated csv. But what if it is a semicolon separated csv? I don't find the way to do the same with a semicolon separated csv.

Daerik Over a year ago

@Alex, besides arguing semantics on the acronym CSV being Comma Separated Values, you are able to set the delimiter of the str_getcsv function. I hope this helps!

marcovtwout Over a year ago

If you want to pass a parameter (like the delimiter) to str_getcsv, use this: $rows = array_map(function($row) { return str_getcsv($row, ';'); }, file('file.csv'));

Daerik Over a year ago

@marcovtwout, keep in mind that you can pass additional arguments as the third parameter of array_map().

AngryUbuntuNerd Over a year ago

this solution is potentially very memory hungry, as it creates an array containing the whole of the CSV file, instead of reading single lines into memory

|

Dylan Valade · Accepted Answer · 2016-01-08 15:16:38Z

73

run over the csv file line by line, and insert to array like:

$array = $fields = array(); $i = 0;
$handle = @fopen("file.csv", "r");
if ($handle) {
    while (($row = fgetcsv($handle, 4096)) !== false) {
        if (empty($fields)) {
            $fields = $row;
            continue;
        }
        foreach ($row as $k=>$value) {
            $array[$i][$fields[$k]] = $value;
        }
        $i++;
    }
    if (!feof($handle)) {
        echo "Error: unexpected fgets() fail\n";
    }
    fclose($handle);
}

edited Jan 8, 2016 at 15:16

Dylan Valade

5,6056 gold badges44 silver badges57 bronze badges

answered Jan 26, 2011 at 6:39

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

3 Comments

Craig Hooghiem Over a year ago

If you were to change $array[$i][$k] = $value; to $array[$i][$fields[$k]] = $value; you would get the header as the key.

DWils Over a year ago

I was just about to say the same as @CraigHooghiem before I saw his comment. With $fields[$k], the above answer works as expected.

jerrygarciuh Over a year ago

If whitespace around header row values is a concern you can clean with $fields = array_map('trim', $row);

mario · Accepted Answer · 2011-01-26 06:46:29Z

22

To create an associative list array use something like:

$keys = fgetcsv($f);
while (!feof($f)) {
    $array[] = array_combine($keys, fgetcsv($f));
}

And to traverse and filter by specific attributes write a function like:

function find($find) {
    foreach ($array as $row) {
         if (array_intersect_assoc($row, $find) == $find) {
             $result[] = $row;
         }
    }
}

Where you would invoke it with $find = array(Brand=>Honda, Model=>Civic, Part=>135) to filter out the searched models. The other positional array structure seems not very workable, unless you only want to access the "Test" attribute.

answered Jan 26, 2011 at 6:46

mario

146k20 gold badges243 silver badges293 bronze badges

Comments

Tom Carnell · Accepted Answer · 2012-01-14 11:52:20Z

6

Try this simple algorithm:

        $assocData = array();

        if( ($handle = fopen( $importedCSVFile, "r")) !== FALSE) {
            $rowCounter = 0;
            while (($rowData = fgetcsv($handle, 0, ",")) !== FALSE) {
                if( 0 === $rowCounter) {
                    $headerRecord = $rowData;
                } else {
                    foreach( $rowData as $key => $value) {
                        $assocData[ $rowCounter - 1][ $headerRecord[ $key] ] = $value;  
                    }
                }
                $rowCounter++;
            }
            fclose($handle);
        }

        var_dump( $assocData);

answered Jan 14, 2012 at 11:52

Tom Carnell

5958 silver badges14 bronze badges

1 Comment

mickmackusa Over a year ago

This answer is missing its educational explanation.

mickmackusa · Accepted Answer · 2018-10-29 11:25:19Z

3

Using fgetcsv() seems the most direct and sensible tool for the job.

csv.csv contents:

Brand,Model,Part,Test
Honda,Civic,123,244
Honda,Civic,135,434
Toyota,Supra,511,664

Code:

$assoc_array = [];
if (($handle = fopen("csv.csv", "r")) !== false) {                 // open for reading
    if (($data = fgetcsv($handle, 1000, ",")) !== false) {         // extract header data
        $keys = $data;                                             // save as keys
    }
    while (($data = fgetcsv($handle, 1000, ",")) !== false) {      // loop remaining rows of data
        $assoc_array[] = array_combine($keys, $data);              // push associative subarrays
    }
    fclose($handle);                                               // close when done
}
echo "<pre>";
    var_export($assoc_array);                                      // print to screen
echo "</pre>";

Output:

array (
  0 => 
  array (
    'Brand' => 'Honda',
    'Model' => 'Civic',
    'Part' => '123',
    'Test' => '244',
  ),
  1 => 
  array (
    'Brand' => 'Honda',
    'Model' => 'Civic',
    'Part' => '135',
    'Test' => '434',
  ),
  2 => 
  array (
    'Brand' => 'Toyota',
    'Model' => 'Supra',
    'Part' => '511',
    'Test' => '664',
  ),
)

Resource: http://php.net/manual/en/function.fgetcsv.php

edited Oct 29, 2018 at 11:25

answered Oct 29, 2018 at 11:19

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

1 Comment

Richard Over a year ago

Tip: if you use a zero (0) instead of 1000 here: fgetcsv($handle, 0, ","), then there is no character limit per line. Good for if you aren't sure just how many characters might be per line.

Stranger · Accepted Answer · 2016-11-11 07:07:46Z

Here is a solutions that will work by specifying a local file or URL. You can also switch the association on and off. Hopefully this helps.

class CSVData{
    public $file;
    public $data;
    public $fp;
    public $caption=true;
    public function CSVData($file=''){
        if ($file!='') getData($file);
    }
    function getData($file){
        if (strpos($file, 'tp://')!==false){
            copy ($file, '/tmp/csvdata.csv');
            if ($this->fp=fopen('/tmp/csvdata.csv', 'r')!==FALSE){
                $this->readCSV();
                unlink('tmp/csvdata.csv');
            }
        } else {
            $this->fp=fopen($file, 'r');
            $this->readCSV();
        }
        fclose($this->fp);
    }
    private function readCSV(){
        if ($this->caption==true){
            if (($captions=fgetcsv($this->fp, 1000, ","))==false) return false;
        }
        $row=0;
        while (($data = fgetcsv($this->fp, 1000, ",")) !== FALSE) {
            for ($c=0; $c < count($data); $c++) {
                $this->data[$row][$c]=$data[$c];
                if ($this->caption==true){
                    $this->data[$row][$captions[$c]]=$data[$c];
                }
            }
            $row++;
        }
    }
}

Try this usage:

$o=new CSVData();
$o->getData('/home/site/datafile.csv');
$data=$o->data;
print_r($data);

Kadament · Accepted Answer · 2021-09-08 21:50:59Z

1

Here is my solution, similar to others stated but uses a while loop with fgetcsv, and uses a counter and array_combine to set the first row as the keys.

    $rownum = 0;
    while (($row = fgetcsv($openedFile, 1000, ',')) !== FALSE) {
        if ($rownum > 0) {
            $row = array_combine($importarray[0], $row);
        }
        array_push($importarray, $row);
        $rownum++;
    }
    array_shift($importarray);

answered Sep 8, 2021 at 21:50

Kadament

1301 silver badge8 bronze badges

Collectives™ on Stack Overflow

CSV to Associative Array

7 Answers 7

11 Comments

3 Comments

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

11 Comments

3 Comments

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related