根據表中值的數量對列進行分組我有這張表,其中包含三列(dut、vcc、result)(例如):
dut | vcc | result |
1 | 1.1 | pass
2 | 1.1 | pass
3 | 1.1 | pass
4 | 1.1 | pass
1 | 1.2 | pass
2 | 1.2 | fail
3 | 1.2 | pass
4 | 1.2 | pass
1 | 1.3 | pass
2 | 1.3 | fail
3 | 1.3 | fail
4 | 1.3 | fail
我想按 vcc 分組通過的次數所以有這個表:
vcc | number |
1.1 | 4
1.2 | 3
1.3 | 1
從第一張桌子移動到另一張桌子的最簡單方法是什麼?
數據表腳本