Combine Stacked Column with Unstacked Columns

["Bert Jacobs" <b.jacobs@pandora.be>]

Hi,

 

I’m looking to combine two dataframes

The first has two columns with info on

Period   Data ( = colnames)

W1         4

W2         5

W3         6

…

The second dataframe has one row with info on

                W1      W2      W3 ( = colnames)

DataBis     “A”       “B”       “C”

 

Now I would like to create a dataframe that looks like this,

but I can’t figure it out how to do it.

 

Period   Data     W1      W2      W3 ( = colnames)

 

W1         4        “A”         0         0    

W2         5         0          “B”       0

W3         6         0           0        “C”

 

Is there an easy way to create the above example?

 

Thx for replies

 

Bert

 

 

___________________________

 

Bert Jacobs

E-mail: B.Jacobs@pandora.be