How to pivot the table

5 visualizzazioni (ultimi 30 giorni)
Mekala balaji
Mekala balaji il 11 Giu 2019
Modificato: Peter Perkins il 12 Giu 2019
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

Risposta accettata

Peter Perkins
Peter Perkins il 12 Giu 2019
Modificato: Peter Perkins il 12 Giu 2019
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

Più risposte (0)

Prodotti


Release

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by