航空旅客数

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

HTTP(`GET https://docs.machbase.com/assets/example/AirPassengers.csv`)
SCRIPT({
  var body = $.values[0].body.String()
  var lines = body.split('\n');
  // ヘッダーを除外
  // rownames, time, value
  const headers = lines[0].split(','); 
  for (let i = 1; i < lines.length-1; i++) {
    row = lines[i].split(',');
    ts = parseFloat(row[1]);
    value = parseFloat(row[2]);
    year = Math.floor(ts);
    month = Math.round(12 * (Math.round(ts*100)%100)/100) + 1;
    // 浮動小数点数で表した年を "year/month" に変換
    $.yield(`${year}/${month}`, value);
  }
})
CHART(
  chartOption({
    xAxis: { data: column(0) },
    yAxis: {},
    series: [
        {type:"line", name:"passengers", smooth:false, data:column(1)}
    ]
  })
)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

CSV (file("https://docs.machbase.com/assets/example/AirPassengers.csv"))

// ヘッダーを除外 : rownames,time,value
DROP(1) 
// rownamesカラムを除外
POPVALUE(0)

// 浮動小数点数で表した年を "year/month" に変換
MAPVALUE(0,
  strSprintf("%.f/%.f",
    floor(parseFloat(value(0))),
    1+round(12 * (mod(round(parseFloat(value(0))*100), 100)/100)) 
  )
)
// passengers
MAPVALUE(1, parseFloat(value(1)))

CHART(
  chartOption({
    xAxis: { data: column(0) },
    yAxis: {},
    series: [
        {type: "line", name: "passengers", smooth: false, data: column(1)}
    ]
  })
)