Group Array from .csv | PHP

Question

I have this code and what i'm trying to do is , group the data coming from the .csv by Player , and then group by year and league , so for example , i will have faker -> 2021 -> lck->data ; ->2020->lck->data

and sometimes when a player has played more than one league in a year , faker->2021->lck->data | 2021->kespa->data

the problem is when i show the kills(image) , the year 2020 is adding the kills from 2021 plus kills from 2020. and what i want is 2020 show the kills from that league and that year and the same with 2021.

The result im Getting :

Faker => 2021 => kills [1,2,3] ; 2020 => kills [1,2,3,6,9,12];

The expected result is :
Faker => 2021 => kills [1,2,3] ; 2020 => kills [6,9,12]

how can i achieve that ?

Thats the csv

gameid,datacompleteness,url,league,year,split,playoffs,date,game,patch,playerid,side,position,player,team,champion .....

thats my code;

<?php
  
$csvFileData = file('./datalck.csv');
$dataMatch = [];

foreach ($csvFileData as $lines) {
    $data[] = str_getcsv($lines);
}
  

foreach ($dataMatch as $matchs) {
  // So here i'm grouping the array by player
 //[3] is the position for the league
 //[4] is the position for year
 //[13] is the position of player name ,
 //[23] The position of kills
    if ($matchs[13] != NULL and $matchs[13] != "") {

        $group[$matchs[13]][] = [
            'Player' => $matchs[13],
            "kills" => $matchs[23],
            'league' => $matchs[3],
            'year' => $matchs[4],


        ];
    }
}


foreach ($group as $players => $p) {


    $kills = [];       
    foreach ($p as $op) {

        $kills[] = $op['kills'];

        $group2[$op['Player']][$op['year']][$op['league']] = [
            "Player" => $op['Player'],
            "kills" => $kills,
            "league" => $op['league'],
            "year" => $op['year'],
        ];
    }
}

foreach ($group2 as $op2) {

    echo '<pre>';
    var_dump(($group2));
    echo '</pre>';
}

?>

Improve your Question and add a formated Example of the CSV-Data — Bernhard
– Bernhard, Commented Feb 18, 2021 at 23:21
As @Bernhard said, please include more information in your question and please instead of the image, use the code tags so others can replicate your coder easier. — Crimin4L
– Crimin4L, Commented Feb 19, 2021 at 1:10

Syscall · Accepted Answer · 2021-02-19 07:30:36Z

1

You are adding to $kills array, without taking care of the year. So, when you parse the year 2021, the $kills array already contains the 2020 data.

You could create an empty array the first time (each new year), and then, fill it.

foreach ($group as $players => $p)
{
    foreach ($p as $op)
    {
        // variables for readability
        $plyr = $op['Player'];
        $year = $op['year'];
        $leag = $op['league'];
        $kills = $op['kills'];

        // create the initial state
        if (!isset($group2[$plyr][$year][$leag])) 
        {
            $group2[$plyr][$year][$leag] = [
                "Player" => $plyr,
                "league" => $leag,
                "year" => $year,
                "kills" => [], // empty array
            ];
        }

        // add value to array for the player/year/league :
        $group2[$plyr][$year][$leag]['kills'][] = $kills;
    }
}

See a working demo.

edited Feb 19, 2021 at 7:30

answered Feb 19, 2021 at 7:04

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

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

1 Comment

Lucas Ln Over a year ago

Thanks for the help !

Collectives™ on Stack Overflow

Group Array from .csv | PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related