回答編集履歴

1

回答を参考に見直しました

2022/04/28 11:53

投稿

cupnew1988
cupnew1988

スコア20

test CHANGED
@@ -1,3 +1,4 @@
1
+
1
2
  ```ここに言語を入力
2
3
  <入力>
3
4
  tbl = [
@@ -6,20 +7,27 @@
6
7
  { "date" => "2022/04/01 12:04:00", "X1" => "103", "X2" => "205", "X3" => "315" },
7
8
  { "date" => "2022/04/01 12:06:00", "X1" => "104", "X2" => "207", "X3" => "316" },
8
9
  { "date" => "2022/04/01 12:08:00", "X1" => "105", "X2" => "209", "X3" => "317" },
9
- ]
10
+ ]
10
11
 
11
- vals = []
12
+ vals = {}
13
+ tbl.each_with_index do |row, i|
14
+ keys = row.keys
12
- tbl.each do |row|
15
+ keys.each do |key|
16
+ if i == 0
17
+ vals[key] = [row[key]]
18
+ else
13
- vals.push( row.values )
19
+ vals[key].push(row[key])
20
+ end
21
+ end
14
22
  end
15
- x1 = vals.transpose[1]
16
- x2 = vals.transpose[2]
17
- p x1
18
- p x2
19
23
 
24
+ vals.each do |val|
25
+ p val
26
+ end
20
27
 
21
28
  <結果>
29
+ ["date", ["2022/04/01 12:00:00", "2022/04/01 12:02:00", "2022/04/01 12:04:00", "2022/04/01 12:06:00", "2022/04/01 12:08:00"]]
22
- ["101", "102", "103", "104", "105"]
30
+ ["X1", ["101", "102", "103", "104", "105"]]
23
- ["202", "204", "205", "207", "209"]
31
+ ["X2", ["202", "204", "205", "207", "209"]]
24
-
32
+ ["X3", ["313", "314", "315", "316", "317"]]
25
33
  ```