搜索
搜索

使用PHP将CSV中数组的不同部分组合在一起？

Pooshonk 发表于 Dev
72
Pooshonk

我有一个来自CSV导入的数组，我想根据一个ID进行分组。

结构如下：

每行都是一个度量，并且注释添加到提交中。一个提交可以有多行。例如，如果有3个度量，那么标题提交数据将重复3次，并带有不同的注释/度量详细信息。

//this is the submission id
[1] => Array
        [0] => Array
            (
                [0] => 1
                [1] => Lot
                [2] => Lot Submission
                [3] => Lot Submission
                [4] => Lot Submission
                [5] => LNW North
                [6] => C Spencer Ltd
                [7] => Panel
                [8] => 1
                [9] => Buildings
                [10] => 2015/2016
                [11] => 2
                [12] => 1,2,3,4,5,6,7,8
                [13] => Testing notes
                [14] => KPI1 - Behavioural Safety
                [15] => PER1 - Health, Safety, and Wellbeing strategy
                [16] => Testing Comment 1
                [17] => Expected
            )

        [1] => Array
            (
                [0] => 1
                [1] => Lot
                [2] => Lot Submission
                [3] => Lot Submission
                [4] => Lot Submission
                [5] => LNW North
                [6] => C Spencer Ltd
                [7] => Panel
                [8] => 1
                [9] => Buildings
                [10] => 2015/2016
                [11] => 2
                [12] => 1,2,3,4,5,6,7,8
                [13] => Testing notes
                [14] => KPI1 - Behavioural Safety
                [15] => PMTEST - Test
                [16] => Testing 2
                [17] => Stretch
            )

        [2] => Array
            (
                [0] => 1
                [1] => Lot
                [2] => Lot Submission
                [3] => Lot Submission
                [4] => Lot Submission
                [5] => LNW North
                [6] => C Spencer Ltd
                [7] => Panel
                [8] => 1
                [9] => Buildings
                [10] => 2015/2016
                [11] => 2
                [12] => 1,2,3,4,5,6,7,8
                [13] => Testing notes
                [14] => KPI1 - Behavioural Safety
                [15] => JP001 - Jamie
                [16] => Testing 3
                [17] => Excellence
            )
[2] => Array
        [0] => Array
            (
                [0] => 2
                [1] => Lot
                [2] => Lot Submission
                [3] => Lot Submission
                [4] => Lot Submission
                [5] => LNW North
                [6] => C Spencer Ltd
                [7] => Panel
                [8] => 1
                [9] => Buildings
                [10] => 2015/2016
                [11] => 2
                [12] => 1,2,3,4,5,6,7,8
                [13] => Testing notes
                [14] => KPI1 - Behavioural Safety
                [15] => PER1 - Health, Safety, and Wellbeing strategy
                [16] => Testing Comment 1
                [17] => Expected
            )

        [1] => Array
            (
                [0] => 2
                [1] => Lot
                [2] => Lot Submission
                [3] => Lot Submission
                [4] => Lot Submission
                [5] => LNW North
                [6] => C Spencer Ltd
                [7] => Panel
                [8] => 1
                [9] => Buildings
                [10] => 2015/2016
                [11] => 2
                [12] => 1,2,3,4,5,6,7,8
                [13] => Testing notes
                [14] => KPI1 - Behavioural Safety
                [15] => PMTEST - Test
                [16] => Testing 2
                [17] => Stretch
            )

每个数组的第0-13部分相同，这是每个提交的标题信息。我想尝试将数组的第14-17部分添加到新数组中。下面是一个示例：

[1] => Array
    (
        [0] => 1
        [1] => Lot
        [2] => Lot Submission
        [3] => Lot Submission
        [4] => Lot Submission
        [5] => LNW North
        [6] => C Spencer Ltd
        [7] => Panel
        [8] => 1
        [9] => Buildings
        [10] => 2015/2016
        [11] => 2
        [12] => 1,2,3,4,5,6,7,8
        [13] => Testing notes
        ['measure'] = array(
            [0] = array(
                [14] => KPI1 - Behavioural Safety
                [15] => PER1 - Health, Safety, and Wellbeing strategy
                ['comments'] = array(
                    [16] => Testing Comment 1
                    [17] => Expected
                )
            ),
            [1] = array(
                [14] => KPI1 - Behavioural Safety
                [15] => PMTEST - Test
                ['comments'] = array(
                    [16] => Testing 2
                    [17] => Stretch
                )
            ),
            [2] = array(
                [14] => KPI1 - Behavioural Safety
                [15] => JP001 - Jamie
                ['comments'] = array(
                    [16] => Testing 3
                    [17] => Excellence
                )
            )
        )                   
    )

[2] => Array
    (
        [0] => 2
        [1] => Lot
        [2] => Lot Submission
        [3] => Lot Submission
        [4] => Lot Submission
        [5] => LNW North
        [6] => C Spencer Ltd
        [7] => Panel
        [8] => 1
        [9] => Buildings
        [10] => 2015/2016
        [11] => 2
        [12] => 1,2,3,4,5,6,7,8
        [13] => Testing notes
        ['measure'] = array(
            [0] = array(
                [14] => KPI1 - Behavioural Safety
                [15] => PER1 - Health, Safety, and Wellbeing strategy
                ['comments'] = array(
                    [16] => Testing Comment 1
                    [17] => Expected
                )
            ),
            [1] = array(
                [14] => KPI1 - Behavioural Safety
                [15] => PMTEST - Test
                ['comments'] = array(
                    [16] => Testing 2
                    [17] => Stretch
                )
            )
        )                   
    )

我很沮丧，但不知道从哪里开始。我可以创建一个新数组并将数据推送到[0] => 1该数组吗，具体取决于（数组的）提交ID ？

里格斯愚蠢

这将产生所需的数据转换。对您先前的问题进行了少量补充。

<?php
$original =
array(
       array(
             array(
                0 => '1',1 => 'Lot',2 => 'Lot Submission',3 => 'Lot Submission',4 => 'Lot Submission',
                5 => 'LNW North',6 => 'C Spencer Ltd',
                7 => 'Panel',8 => '1',9 => 'Buildings',10 => '2015/2016',
                11 => '2',12 => '1,2,3,4,5,6,7,8',13 => 'Testing notes',14 => 'KPI1 - Behavioural Safety',
                15 => 'PER1 - Health, Safety, and Wellbeing strategy',16 => 'Testing Comment 1',17 => 'Expected'
                ),
            array(
                0 => '1',1 => 'Lot',2 => 'Lot Submission',3 => 'Lot Submission',4 => 'Lot Submission',
                5 => 'LNW North',6 => 'C Spencer Ltd',7 => 'Panel',8 => '1',9 => 'Buildings',10 => '2015/2016',
                11 => '2',12 => '1,2,3,4,5,6,7,8',13 => 'Testing notes',14 => 'KPI1 - Behavioural Safety',
                15 => 'PMTEST - Test',16 => 'Testing 2',17 => 'Stretch'
                ),
            array(
                0 => '1',1 => 'Lot',2 => 'Lot Submission',3 => 'Lot Submission',4 => 'Lot Submission',
                5 => 'LNW North',6 => 'C Spencer Ltd',7 => 'Panel',8 => '1',9 => 'Buildings',10 => '2015/2016',
                11 => '2',12 => '1,2,3,4,5,6,7,8',13 => 'Testing notes',14 => 'KPI1 - Behavioural Safety',
                15 => 'JP001 - Jamie',16 => 'Testing 3',17 => 'Excellence'
                )
            ),
        array(
            array(
                0 => '2',1 => 'Lot',2 => 'Lot Submission',3 => 'Lot Submission',4 => 'Lot Submission',
                5 => 'LNW North',6 => 'C Spencer Ltd',7 => 'Panel',8 => '1',9 => 'Buildings',10 => '2015/2016',
                11 => '2',12 => '1,2,3,4,5,6,7,8',13 => 'Testing notes',14 => 'KPI1 - Behavioural Safety',
                15 => 'PER1 - Health, Safety, and Wellbeing strategy',16 => 'Testing Comment 1',17 => 'Expected'
                ),
            array(
                0 => '2',1 => 'Lot',2 => 'Lot Submission',3 => 'Lot Submission',4 => 'Lot Submission',
                5 => 'LNW North',6 => 'C Spencer Ltd',7 => 'Panel',8 => '1',9 => 'Buildings',10 => '2015/2016',
                11 => '2',12 => '1,2,3,4,5,6,7,8',13 => 'Testing notes',14 => 'KPI1 - Behavioural Safety',
                15 => 'PMTEST - Test',16 => 'Testing 2',17 => 'Stretch'
                )
        )
);

$new = array();

foreach ( $original as $idx => $old ) {

    foreach ( $old as $occ => $val ) {

        // move over the first 14 from first row
        if ( $occ == 0 ) {
           for( $i=0; $i<14; $i++ ) {
                $new[$idx][] = $old[$occ][$i];
            }
            // setup the new measure array
            $new[$idx]['measure'] = array();
        }

        $t = array();
        for ( $i=14; $i < 16; $i++ ) {
            $t[] = $old[$occ][$i];
        }
        $new[$idx]['measure'][] = $t;

        $t = array();
        for ( $i=16; $i < count($old[$occ]); $i++ ) {
            $t[] = $old[$occ][$i];
        }
        $new[$idx]['measure'][$occ]['comments'] = $t;
    }
}

print_r($new);

哪个产生

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => Lot
            [2] => Lot Submission
            [3] => Lot Submission
            [4] => Lot Submission
            [5] => LNW North
            [6] => C Spencer Ltd
            [7] => Panel
            [8] => 1
            [9] => Buildings
            [10] => 2015/2016
            [11] => 2
            [12] => 1,2,3,4,5,6,7,8
            [13] => Testing notes
            [measure] => Array
                (
                    [0] => Array
                        (
                            [0] => KPI1 - Behavioural Safety
                            [1] => PER1 - Health, Safety, and Wellbeing strategy
                            [comments] => Array
                                (
                                    [0] => Testing Comment 1
                                    [1] => Expected
                                )
                        )
                    [1] => Array
                        (
                            [0] => KPI1 - Behavioural Safety
                            [1] => PMTEST - Test
                            [comments] => Array
                                (
                                    [0] => Testing 2
                                    [1] => Stretch
                                )
                        )
                    [2] => Array
                        (
                            [0] => KPI1 - Behavioural Safety
                            [1] => JP001 - Jamie
                            [comments] => Array
                                (
                                    [0] => Testing 3
                                    [1] => Excellence
                                )
                        )
                )
        )

    [1] => Array
        (
            [0] => 2
            [1] => Lot
            [2] => Lot Submission
            [3] => Lot Submission
            [4] => Lot Submission
            [5] => LNW North
            [6] => C Spencer Ltd
            [7] => Panel
            [8] => 1
            [9] => Buildings
            [10] => 2015/2016
            [11] => 2
            [12] => 1,2,3,4,5,6,7,8
            [13] => Testing notes
            [measure] => Array
                (
                    [0] => Array
                        (
                            [0] => KPI1 - Behavioural Safety
                            [1] => PER1 - Health, Safety, and Wellbeing strategy
                            [comments] => Array
                                (
                                    [0] => Testing Comment 1
                                    [1] => Expected
                                )
                        )
                    [1] => Array
                        (
                            [0] => KPI1 - Behavioural Safety
                            [1] => PMTEST - Test
                            [comments] => Array
                                (
                                    [0] => Testing 2
                                    [1] => Stretch
                                )
                        )
                )
        )
)

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

将数组元素组合在一起

将多个对象数组与不同的键组合在一起

将多个数组与 identica 键和不同的值组合在一起

将列表与列表中不同长度的列表组合在一起

使用Python将列表中的重复JSON键值对组合在一起

使用 SQL 将后续行中的反向对组合在一起

如何将2个Foreach循环与不同的数组结果组合在一起？

如何将向量与列表中的公共成分组合在一起？

将数组数组转换为组合在一起的对象数组

将SQL查询组合在一起

将正确的值组合在一起

将数据聚合/组合在一起

你能把不同的字符串函数组合在一起吗？

将两个不同的表组合在一起进行查询

在Stata中，如何将多个具有不同轴的coefplot组合在一起？

如何使用覆盖挂载将多个目录与不同的子目录组合在一起？

将数组的每个元素与其后面的元素组合在一起

获取将数组和常量组合在一起的哈希

将连续的整数组合在一起

FPDF，FPDI-如何使用PHP将单独的文件与唯一的文本组合在一起？

将数组混合在一起

如何将两个用于名称和值的数组组合在一起以在php中并排对齐

如何将Scala中的每个n元素组合在一起？

将MySQL查询中的类似条目组合在一起

将列表中的元素组合在一起形成新列表

将python中的值组合在一起

如何将 Python 中的值组合在一起？

在Python中，如何将多个轴组合在一起？

将嵌套对象中的值与公共属性组合在一起

TOP 榜单

  1. 1

    蓝屏死机没有修复解决方案

  2. 2

    计算数据帧中每行的NA

  3. 3

    UITableView的项目向下滚动后更改颜色，然后快速备份

  4. 4

    Node.js中未捕获的异常错误，发生调用

  5. 5

    在 Python 2.7 中。如何从文件中读取特定文本并分配给变量

  6. 6

    Linux的官方Adobe Flash存储库是否已过时？

  7. 7

    验证REST API参数

  8. 8

    ggplot：对齐多个分面图-所有大小不同的分面

  9. 9

    Mac OS X更新后的GRUB 2问题

  10. 10

    通过 Git 在运行 Jenkins 作业时获取 ClassNotFoundException

  11. 11

    带有错误“ where”条件的查询如何返回结果？

  12. 12

    用日期数据透视表和日期顺序查询

  13. 13

    VB.net将2条特定行导出到DataGridView

  14. 14

    如何从视图一次更新多行（ASP.NET - Core）

  15. 15

    Java Eclipse中的错误13，如何解决？

  16. 16

    尝试反复更改屏幕上按钮的位置 - kotlin android studio

  17. 17

    离子动态工具栏背景色

  18. 18

    应用发明者仅从列表中选择一个随机项一次

  19. 19

    当我尝试下载 StanfordNLP en 模型时，出现错误

  20. 20

    python中的boto3文件上传

  21. 21

    在同一Pushwoosh应用程序上Pushwoosh多个捆绑ID

热门标签

归档