Assigning array keys based on the values of another array

Question

An optimisation question:

Currently I have entities stored in text files in the following format:

Attribute1,Attribute2,Attribute3
Value1-1,Value1-2,Value1-3
Value2-1,Value2-2,Value2-3
Value3-1,Value3-2,Value3-3

And convert it into a 2D array in the following format:

$array = array(array('Attribute1' => 'Value1-1',
                     'Attribute2', => 'Value1-2',
                     'Attribute3', => 'Value1-3'),
               array('Attribute1' => 'Value2-1',
                     'Attribute2', => 'Value2-2',
                     'Attribute3', => 'Value2-3'),
               array('Attribute1' => 'Value3-1',
                     'Attribute2', => 'Value3-2',
                     'Attribute3', => 'Value3-3'));

Using the following PHP code:

$lines = array();
$dump = normaliseNewLine($dump);
$dump = explode("\n", $dump);
$attributes = explode(',', array_shift($dump));

for($i = 0; $i < count($dump); $i++) {
    $tmp = explode(',', $dump[$i]);
    for ($j = 0; $j < count($tmp); $j++) {
        $lines[$i][$attributes[$j]] = $tmp[$j];
    }
}

I was wondering if there was a more efficient method of completing this task?

Community · Accepted Answer · 2023-11-17 20:24:57Z

4

PHP provides functions to parse CSV files and strings line-by-line.

$file = ...
$headers = fgetcsv($file);
$lines = array();
while (($line = fgetcsv($file)) !== false) {
    $lines[] = array_combine($headers, $line);
}

edited Nov 17, 2023 at 20:24

CommunityBot

1

answered Apr 11, 2014 at 2:17

David Harkness

8,8931 gold badge27 silver badges44 bronze badges

Add a comment |

MrLore · Accepted Answer · 2014-04-11 14:32:20Z

1

This version uses fewer lines, and is slightly quicker for me:

function($fileName)
{
    $handle = fopen($fileName, 'r');
    $attributes = fgetcsv($handle);
    for($i = 0; $line = fgetcsv($handle); $i++)
    {
        foreach($attributes as $k => $attribute)
        {
            $lines[$i][$attribute] = $line[$k];
        }
    }
    return $lines;
}

edited Apr 11, 2014 at 14:32

answered Apr 11, 2014 at 2:25

MrLore

1,3889 silver badges16 bronze badges

\$\begingroup\$ Just noticed that this code does not produce the correct output! \$\endgroup\$

Jacob Mulquin
– Jacob Mulquin

2014-04-11 05:34:30 +00:00
Commented Apr 11, 2014 at 5:34
\$\begingroup\$ @mulquin You're right- updated the answer. \$\endgroup\$

MrLore
– MrLore

2014-04-11 14:32:41 +00:00
Commented Apr 11, 2014 at 14:32

Add a comment |

Stack Exchange Network

Assigning array keys based on the values of another array

2 Answers 2

You must log in to answer this question.

Hot Network Questions

Assigning array keys based on the values of another array

2 Answers 2

You must log in to answer this question.

Related

Hot Network Questions