PHP/Mixpanel - mass users update (from csv file exported via JQL)

mixpanel.php

<?php

$mp = Mixpanel(MIXPANEL_KEY);

$path = '/path/to/user/list.csv';

$row = 1;
if (($handle = fopen($path, "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        // skip header line
        if ($row++ != 1) {
        
            // $data:
            // 0 - Mail
            // 1 - $distinct_id
            // 17 - Company Type  - string
            // 18 - Company Field - list

            $items = explode(',', $data[18]);

            $mp->people->set($data[1], [
                '$email' => $data[0],
                'Company Type' => $data[17],
                'Company Field' => $items
            ]);

        }
    }
    fclose($handle);
}

?>