|
I have 2 datasets. One is quite big and goes weekly, the other goes
yearly. First one looks like this:
Date Weekday Teamname
9/10/1995 7 ARI
10/1/1995 7 ARI
10/15/1995 7 ARI
10/29/1995 7 ARI
11/12/1995 7 ARI
11/26/1995 7 ARI
11/30/1995 4 ARI
12/25/1995 1 ARI
9/8/1996 7 ARI
9/29/1996 7 ARI
10/20/1996 7 ARI
10/27/1996 7 ARI
11/17/1996 7 ARI
11/24/1996 7 ARI
12/8/1996 7 ARI
12/15/1996 7 ARI
9/7/1997 7 ARI
10/5/1997 7 ARI
10/12/1997 7 ARI
10/26/1997 7 ARI
11/2/1997 7 ARI
11/21/1997 5 ARI
11/30/1997 7 ARI
12/7/1997 7 ARI
9/20/1998 7 ARI
10/4/1998 7 ARI
10/11/1998 7 ARI
11/8/1998 7 ARI
11/15/1998 7 ARI
12/6/1998 7 ARI
12/20/1998 7 ARI
12/27/1998 7 ARI
9/27/1999 1 ARI
10/10/1999 7 ARI
10/17/1999 7 ARI
10/31/1999 7 ARI
11/14/1999 7 ARI
11/21/1999 7 ARI
12/5/1999 7 ARI
12/19/1999 7 ARI
9/10/2000 7 ARI
9/24/2000 7 ARI
10/8/2000 7 ARI
10/15/2000 7 ARI
10/29/2000 7 ARI
11/5/2000 7 ARI
11/26/2000 7 ARI
12/17/2000 7 ARI
9/23/2001 7 ARI
9/30/2001 7 ARI
10/21/2001 7 ARI
11/4/2001 7 ARI
11/11/2001 7 ARI
11/18/2001 7 ARI
12/9/2001 7 ARI
12/23/2001 7 ARI
9/22/2002 7 ARI
9/29/2002 7 ARI
10/20/2002 7 ARI
11/3/2002 7 ARI
11/10/2002 7 ARI
11/24/2002 7 ARI
12/8/2002 7 ARI
12/21/2002 6 ARI
9/14/2003 7 ARI
9/21/2003 7 ARI
10/12/2003 7 ARI
10/26/2003 7 ARI
11/2/2003 7 ARI
11/23/2003 7 ARI
12/14/2003 7 ARI
12/28/2003 7 ARI
9/19/2004 7 ARI
10/3/2004 7 ARI
10/24/2004 7 ARI
11/14/2004 7 ARI
11/28/2004 7 ARI
12/12/2004 7 ARI
12/19/2004 7 ARI
1/2/2005 7 ARI
9/18/2005 7 ARI
10/2/2005 7 ARI
10/9/2005 7 ARI
10/23/2005 7 ARI
11/6/2005 7 ARI
11/27/2005 7 ARI
12/11/2005 7 ARI
12/24/2005 6 ARI
9/10/2006 7 ARI
9/24/2006 7 ARI
10/8/2006 7 ARI
10/16/2006 1 ARI
11/12/2006 7 ARI
12/10/2006 7 ARI
12/17/2006 7 ARI
11/19/2006 7 ARI
9/16/2007 7 ARI
9/30/2007 7 ARI
10/14/2007 7 ARI
11/11/2007 7 ARI
11/25/2007 7 ARI
12/2/2007 7 ARI
12/23/2007 7 ARI
12/30/2007 7 ARI
9/11/1994 7 ATL
9/18/1994 7 ATL
10/9/1994 7 ATL
10/16/1994 7 ATL
11/6/1994 7 ATL
11/27/1994 7 ATL
12/11/1994 7 ATL
12/24/1994 6 ATL
9/3/1995 7 ATL
9/24/1995 7 ATL
10/1/1995 7 ATL
10/29/1995 7 ATL
11/5/1995 7 ATL
11/19/1995 7 ATL
12/10/1995 7 ATL
12/24/1995 7 ATL
9/8/1996 7 ATL
9/22/1996 7 ATL
10/13/1996 7 ATL
10/27/1996 7 ATL
11/3/1996 7 ATL
11/17/1996 7 ATL
12/2/1996 1 ATL
12/15/1996 7 ATL
9/7/1997 7 ATL
9/14/1997 7 ATL
9/28/1997 7 ATL
10/19/1997 7 ATL
11/2/1997 7 ATL
11/9/1997 7 ATL
11/23/1997 7 ATL
12/14/1997 7 ATL
9/13/1998 7 ATL
10/4/1998 7 ATL
10/18/1998 7 ATL
11/1/1998 7 ATL
11/15/1998 7 ATL
11/22/1998 7 ATL
12/6/1998 7 ATL
12/27/1998 7 ATL
9/12/1999 7 ATL
10/3/1999 7 ATL
10/17/1999 7 ATL
10/31/1999 7 ATL
11/7/1999 7 ATL
12/5/1999 7 ATL
12/26/1999 7 ATL
12/31/1999 5 ATL
9/3/2000 7 ATL
9/24/2000 7 ATL
10/8/2000 7 ATL
10/22/2000 7 ATL
10/29/2000 7 ATL
11/5/2000 7 ATL
12/3/2000 7 ATL
12/24/2000 7 ATL
9/23/2001 7 ATL
10/7/2001 7 ATL
10/14/2001 7 ATL
11/4/2001 7 ATL
11/11/2001 7 ATL
12/2/2001 7 ATL
12/9/2001 7 ATL
12/23/2001 7 ATL
9/15/2002 7 ATL
9/22/2002 7 ATL
10/6/2002 7 ATL
10/20/2002 7 ATL
11/3/2002 7 ATL
11/17/2002 7 ATL
12/15/2002 7 ATL
12/22/2002 7 ATL
9/14/2003 7 ATL
9/21/2003 7 ATL
10/5/2003 7 ATL
10/19/2003 7 ATL
11/2/2003 7 ATL
11/23/2003 7 ATL
12/7/2003 7 ATL
12/28/2003 7 ATL
9/19/2004 7 ATL
9/26/2004 7 ATL
10/10/2004 7 ATL
10/17/2004 7 ATL
11/14/2004 7 ATL
11/28/2004 7 ATL
12/12/2004 7 ATL
12/18/2004 6 ATL
9/12/2005 1 ATL
10/2/2005 7 ATL
10/9/2005 7 ATL
10/24/2005 1 ATL
11/13/2005 7 ATL
12/12/2005 1 ATL
11/20/2005 7 ATL
1/1/2006 7 ATL
9/17/2006 7 ATL
10/1/2006 7 ATL
10/15/2006 7 ATL
10/22/2006 7 ATL
11/12/2006 7 ATL
11/26/2006 7 ATL
12/16/2006 6 ATL
12/24/2006 7 ATL
9/23/2007 7 ATL
9/30/2007 7 ATL
10/15/2007 1 ATL
11/4/2007 7 ATL
11/18/2007 7 ATL
11/22/2007 4 ATL
12/10/2007 1 ATL
12/30/2007 7 ATL
It of course follows the same pattern with the other teams making it a
panel data. I have ticket prices for every team for every year. The ticket
prices are same within a year and looks like this:
Teamname p1995 p1996 p1997 p1998 p1999 p2000 p2001 p2002
ARI 31.970 35.490 39.650 39.650 40.100 39.650 37.600 33.680
ATL 32.230 31.490 31.490 32.150 40.100 40.420 39.140 29.780
I didn't include the other years.
I need to create a price column for the first dataset and put all these
prices respectively. Clearly for every week in 1995 the price for ARI will
be 31.970 and price for ATL will be 32.230 so on so forth. I don't know
how to merge and then extend a dataset at the same time, do you guys have
any idea?
Bill
| 
