R help - Apr 2013 - Data frame question

Hello,

I have 2 data frames:  activity and dates.  Activity contains a l variable
listing all activities:  activityA, activityB etc.
The dates contain all the valid business dates.  I need to combine the 2 so
that I get a single data frame activitydat that contains the activity name
along w/ evevry valid business dates such as

Name          dat
activity A   2013-02-01
activity A  2013-02-04
activity A  2013-02-05
etc


Any thought?  Thanks ahead for your help.



--
View this message in context:
http://r.789695.n4.nabble.com/Data-frame-question-tp4662967.html
Sent from the R help mailing list archive at Nabble.com.

That sounds like a job for merge().

If you provide an actual reproducible example using dput(), then you
will likely get some actual runnable code.

Sarah

On Mon, Apr 1, 2013 at 11:54 AM, ramoss <ramine.mossadegh at finra.org>
wrote:
> Hello,
>
> I have 2 data frames:  activity and dates.  Activity contains a l variable
> listing all activities:  activityA, activityB etc.
> The dates contain all the valid business dates.  I need to combine the 2 so
> that I get a single data frame activitydat that contains the activity name
> along w/ evevry valid business dates such as
>
> Name          dat
> activity A   2013-02-01
> activity A  2013-02-04
> activity A  2013-02-05
> etc
>
>
> Any thought?  Thanks ahead for your help.
>
>
>
--
Sarah Goslee
http://www.functionaldiversity.org

Hi,

Not sure if this is what you wanted:
activity<-
data.frame(Name=paste0("activity",LETTERS[1:5]),stringsAsFactors=FALSE)
dates1<-
data.frame(dat=as.Date(c("2013-02-01","2013-02-04","2013-02-05"),format="%Y-%m-%d"))
merge(dates1,activity)
#????????? dat????? Name
#1? 2013-02-01 activityA
#2? 2013-02-04 activityA
#3? 2013-02-05 activityA
#4? 2013-02-01 activityB
#5? 2013-02-04 activityB
#6? 2013-02-05 activityB
#7? 2013-02-01 activityC
#8? 2013-02-04 activityC
#9? 2013-02-05 activityC
#10 2013-02-01 activityD
#11 2013-02-04 activityD
#12 2013-02-05 activityD
#13 2013-02-01 activityE
#14 2013-02-04 activityE
#15 2013-02-05 activityE


#or
expand.grid(dat=dates1[,1],Name=activity[,1])
????????? dat????? Name
#1? 2013-02-01 activityA
#2? 2013-02-04 activityA
#3? 2013-02-05 activityA
#4? 2013-02-01 activityB
#5? 2013-02-04 activityB
#6? 2013-02-05 activityB
#7? 2013-02-01 activityC
#8? 2013-02-04 activityC
#9? 2013-02-05 activityC
#10 2013-02-01 activityD
#11 2013-02-04 activityD
#12 2013-02-05 activityD
#13 2013-02-01 activityE
#14 2013-02-04 activityE
#15 2013-02-05 activityE
A.K.



----- Original Message -----
From: ramoss <ramine.mossadegh at finra.org>
To: r-help at r-project.org
Cc: 
Sent: Monday, April 1, 2013 11:54 AM
Subject: [R] Data frame question

Hello,

I have 2 data frames:? activity and dates.? Activity contains a l variable
listing all activities:? activityA, activityB etc.
The dates contain all the valid business dates.? I need to combine the 2 so
that I get a single data frame activitydat that contains the activity name
along w/ evevry valid business dates such as

Name? ? ? ? ? dat
activity A?  2013-02-01
activity A? 2013-02-04
activity A? 2013-02-05
etc


Any thought?? Thanks ahead for your help.



--
View this message in context:
http://r.789695.n4.nabble.com/Data-frame-question-tp4662967.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.