How to set CSV title row?

[ux-engineer]

Hi,

I have timeseries data like:

[ [ 1417646511,4 ], [ 1417648041,3 ], [ 1417649181,1 ], ...

This exports as CSV without title row – how to add the title row?

0,1
1417646511,4
1417648041,3
1417649181,1

[Jaspaul]

Hi @envision,

To do what you would like to do you would have to used named arrays.

Example,

[ 
  [ 'timestamp' => 1417646511, 'value' => 4 ], 
  [ 'timestamp' => 1417648041, 'value' => 3 ], 
  [ 'timestamp' => 1417649181, 'value' => 1 ], 
  ...

Should output (approx)

timestamp,value
1417646511,4
1417648041,3
1417649181,1

[ux-engineer]

This did it:

$data       = substr_replace($data, '["timestamp","value"],', 1, 0);
$formatter  = Formatter::make($data, Formatter::JSON);
$csv        = $formatter->toCsv();
$csv        = ltrim($csv, "0,1 \r\n");