date key values
0 2017-05-01 a 4.395979
1 2017-05-02 b 8.212326
2 2017-05-03 c 9.759327
3 2017-05-01 d 9.336916
4 2017-05-02 a 0.170616
5 2017-05-03 b 6.034662
6 2017-05-01 c 2.305592
7 2017-05-02 d 0.707555
8 2017-05-03 a 7.578554
-----
key a b c d
date
2017-05-01 4.395979 NaN 2.305592 9.336916
2017-05-02 0.170616 8.212326 NaN 0.707555
2017-05-03 7.578554 6.034662 9.759327 NaN
-----
values
date key
2017-05-01 a 1.0
c 1.0
d 1.0
2017-05-02 a 1.0
b 1.0
d 1.0
2017-05-03 a 1.0
b 1.0
c 1.0
-----
A B C
0 1 3 1.0
1 2 3 1.0
2 2 4 NaN
3 2 4 1.0
4 2 4 1.0
-----
B 3 4
A
1 1 0
2 1 3
-----频率表
B 3 4
A
1 0.2 0.0
2 0.2 0.6
-----归一化
B 3 4
A
1 1.0 NaN
2 1.0 2.0
-----求和
B 3 4 All
A
1 1.0 NaN 1.0
2 1.0 2.0 3.0
All 2.0 2.0 4.0
-----