I'm not sure if "transpose" is the right term.
I'm trying to go from this
Date A B C
1/1/2000 1.25 1.0 .75
1/8/2000 .5 1.5 1.0
1/15/2000 1.0 .75 1.25
to this
Date Site Value
1/1/2000 A 1.25
1/8/2000 A .5
1/15/2000 A 1.0
1/1/2000 B 1.0
1/8/2000 B 1.5
1/15/2000 B .75
1/1/2000 C .75
1/8/2000 C 1.0
1/15/2000 C 1.25
using Pandas.
Any ideas?
