フィルターのクリア

How to pivot the table

3 ビュー (過去 30 日間)
Mekala balaji
Mekala balaji 2019 年 6 月 11 日
編集済み: Peter Perkins 2019 年 6 月 12 日
Hi,
I have below data,
ID Date cK_1 ck_k2 ck_4
Gat_pt01 2019-06-01 pass pass miss
HAY_2t_001 2019-06-01 undefined pass pass
VBA_jkl_78 2019-06-05 pass pass pass
HAY_2t_001 2019-06-05 pass miss pass
VBA_jkl_78 2019-06-06 pass pass pass
Gat_pt01 2019-06-06 pass pass miss
I want to pivote by ID & by date
My dessired output as below:
ID Date cK_1 ck_k2 ck_4
Pass Miss Undefined Pass Miss Undefined Pass Miss Undefined
Gat_pt01
01-06-2019 1 0 0 1 0 0 0 1 0
06-06-2019 1 0 0 1 0 0 0 1 0
HAY_2t_001
01-06-2019 0 0 1 1 0 0 1 0 0
05-06-2019 1 0 0 0 1 0 1 0 0
VBA_jkl_78
05-06-2019 1 0 0 1 0 0 1 0 0
06-06-2019 1 0 0 1 0 0 1 0 0

採用された回答

Peter Perkins
Peter Perkins 2019 年 6 月 12 日
編集済み: Peter Perkins 2019 年 6 月 12 日
At first glance, this seems like you could be using the unstack function, and it may be that you can. But you are a bit out of model for that, because the data type is changing. It's more like you are converting each of the categorical variables in a table into what statisticans would call dummy variables (and if you have the Statistics and Machine Learning Toolbox, you could use dummyvars). Here's something that might help get you started:
>> cK_1 = categorical(["p";"m";missing;"p";"p";"m"])
cK_1 =
6×1 categorical array
p
m
<undefined>
p
p
m
>> cK_1 = array2table([cK_1=="p" cK_1=="m" ismissing(cK_1)],'VariableNames',["pass" "miss" "undefined"])
cK_1 =
6×3 table
pass miss undefined
_____ _____ _________
true false false
false true false
false false true
true false false
true false false
false true false
>> ID = ["a";"b";"c";"b";"c";"a"];
>> Date = datetime(2019,6,[1;1;5;5;6;6]);
>> t = table(ID,Date,cK_1)
t =
6×3 table
ID Date cK_1
pass miss undefined
___ ___________ ___________________________
"a" 01-Jun-2019 true false false
"b" 01-Jun-2019 false true false
"c" 05-Jun-2019 false false true
"b" 05-Jun-2019 true false false
"c" 06-Jun-2019 true false false
"a" 06-Jun-2019 false true false

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeLogical についてさらに検索

製品


リリース

R2016a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by