R Data.frame Question

List overview All Threads
Download

newer

older

Workflow and Replication

biking

Michael Hankinson

3 Apr 2011 3 Apr '11

4:25 p.m.

Hello everyone, I'm trying to manipulate a data frame and I need your help. I working with Congressional committee assignments. Here is what the current data frame looks like: Name Year Committee Aandahl 1951 102 Aandahl 1951 146 Aandahl 1952 102 Aandahl 1952 146 Basically, each representative has their committee listed. If they are in more than one committee that year, they receive two rows (one for each committee). What I want is to butcher this data set into a string of binary values for each committee, each year. Kind of like: Year Name 102 103 104....145 146 147 1951 Aandahl 1 0 0 0 1 0 Any thoughts on how to pull this off? Thank you in advance. I hope you are frolicking among the baby deer on this beautiful Sunday (rather than inhaling the stale air of the CGIS-K Dungeon/Lab) Mikey H! _______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l

Attachments:

attachment.htm (text/html — 990 bytes)

Show replies by date

Rachel Crouch

3 Apr 3 Apr

4:47 p.m.

Hi Michael, I can't help you with R on this one, but it's relatively easy to do in Excel with a vlookup. Less elegant and slower probably, but I can show you how to do if nobody else comes up with a better answer. Rachel On Apr 3, 2011, at 4:25 PM, Michael Hankinson <mhankins(a)fas.harvard.edu> wrote:

...

_______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l -- gov2001 mailing list served by Harvard-MIT Data Center List Address: gov2001(a)lists.gking.harvard.edu Subscribe/Unsubscribe: http://lists.gking.harvard.edu/?info=gov2001

Brandon Stewart

9:35 p.m.

Hadley Wickham's plyr package is the generic answer for how to do this kind of data manipulation but it has a bit of a learning curve (although he has nice tutorials on his site). I'm not completely positive but I think you can get aggregate() to do this for you as well. Brandon On Sun, Apr 3, 2011 at 4:47 PM, Rachel Crouch <rcrouch(a)jd12.law.harvard.edu>wrote;wrote:

...

Hello everyone, I'm trying to manipulate a data frame and I need your help. I working

with Congressional committee assignments. Here is what the current data frame looks like:

Name Year Committee Aandahl 1951 102 Aandahl 1951 146 Aandahl 1952 102 Aandahl 1952 146 Basically, each representative has their committee listed. If they are

in more than one committee that year, they receive two rows (one for each committee).

What I want is to butcher this data set into a string of binary values

for each committee, each year. Kind of like:

Year Name 102 103 104....145 146 147 1951 Aandahl 1 0 0 0 1 0 Any thoughts on how to pull this off? Thank you in advance. I hope you are frolicking among the baby deer on

this beautiful Sunday (rather than inhaling the stale air of the CGIS-K Dungeon/Lab)

Mikey H! _______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l

_______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l

Maxwell Palmer

9:43 p.m.

The reshape package in R should be able to do this, but I have had some trouble with it. In stata, you can use the "reshape wide" function to do this pretty easily. I can send you some stata code or show you this week if you want to try that. Also, a pivot table in Excel might be the simplest solution, but you won't have replicable code from doing that. Max On Sun, Apr 3, 2011 at 9:35 PM, Brandon Stewart <brandonmstewart(a)gmail.com>wrote;wrote:

...

Hello everyone, I'm trying to manipulate a data frame and I need your help. I working

with Congressional committee assignments. Here is what the current data frame looks like:

Name Year Committee Aandahl 1951 102 Aandahl 1951 146 Aandahl 1952 102 Aandahl 1952 146 Basically, each representative has their committee listed. If they are

in more than one committee that year, they receive two rows (one for each committee).

What I want is to butcher this data set into a string of binary values

for each committee, each year. Kind of like:

Year Name 102 103 104....145 146 147 1951 Aandahl 1 0 0 0 1 0 Any thoughts on how to pull this off? Thank you in advance. I hope you are frolicking among the baby deer on

this beautiful Sunday (rather than inhaling the stale air of the CGIS-K Dungeon/Lab)

Mikey H! _______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l

_______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l

Hankinson, Michael

10:05 p.m.

Dear Fellow Travelers on the Highway of 2000-and-Fun, Thanks for the tips. You are all fantastic. Just scored a touchdown with the reshape package! See you tomorrow with an R-induced smile on my face, MikeyH. ________________________________________ From: gov2001-l-bounces(a)lists.fas.harvard.edu [gov2001-l-bounces(a)lists.fas.harvard.edu] On Behalf Of Maxwell Palmer [mpalmer(a)fas.harvard.edu] Sent: Sunday, April 03, 2011 9:43 PM To: Class List for Gov 2001/E-2001 Subject: Re: [gov2001] R Data.frame Question The reshape package in R should be able to do this, but I have had some trouble with it. In stata, you can use the "reshape wide" function to do this pretty easily. I can send you some stata code or show you this week if you want to try that. Also, a pivot table in Excel might be the simplest solution, but you won't have replicable code from doing that. Max On Sun, Apr 3, 2011 at 9:35 PM, Brandon Stewart <brandonmstewart@gmail.com<mailto:brandonmstewart@gmail.com>> wrote: Hadley Wickham's plyr package is the generic answer for how to do this kind of data manipulation but it has a bit of a learning curve (although he has nice tutorials on his site). I'm not completely positive but I think you can get aggregate() to do this for you as well. Brandon On Sun, Apr 3, 2011 at 4:47 PM, Rachel Crouch <rcrouch@jd12.law.harvard.edu<mailto:rcrouch@jd12.law.harvard.edu>> wrote: Hi Michael, I can't help you with R on this one, but it's relatively easy to do in Excel with a vlookup. Less elegant and slower probably, but I can show you how to do if nobody else comes up with a better answer. Rachel On Apr 3, 2011, at 4:25 PM, Michael Hankinson <mhankins@fas.harvard.edu<mailto:mhankins@fas.harvard.edu>> wrote:

...

Hello everyone, I'm trying to manipulate a data frame and I need your help. I working with Congressional committee assignments. Here is what the current data frame looks like: Name Year Committee Aandahl 1951 102 Aandahl 1951 146 Aandahl 1952 102 Aandahl 1952 146 Basically, each representative has their committee listed. If they are in more than one committee that year, they receive two rows (one for each committee). What I want is to butcher this data set into a string of binary values for each committee, each year. Kind of like: Year Name 102 103 104....145 146 147 1951 Aandahl 1 0 0 0 1 0 Any thoughts on how to pull this off? Thank you in advance. I hope you are frolicking among the baby deer on this beautiful Sunday (rather than inhaling the stale air of the CGIS-K Dungeon/Lab) Mikey H! _______________________________________________ gov2001-l mailing list gov2001-l@lists.fas.harvard.edu<mailto:gov2001-l@lists.fas.harvard.edu> http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l

_______________________________________________ gov2001-l mailing list gov2001-l@lists.fas.harvard.edu<mailto:gov2001-l@lists.fas.harvard.edu> http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l _______________________________________________ gov2001-l mailing list gov2001-l@lists.fas.harvard.edu<mailto:gov2001-l@lists.fas.harvard.edu> http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l _______________________________________________ gov2001-l mailing list gov2001-l(a)lists.fas.harvard.edu http://lists.fas.harvard.edu/mailman/listinfo/gov2001-l -- gov2001 mailing list served by Harvard-MIT Data Center List Address: gov2001(a)lists.gking.harvard.edu Subscribe/Unsubscribe: http://lists.gking.harvard.edu/?info=gov2001

4793

days inactive

4794

days old

gov2001@lists.gking.harvard.edu

Manage subscription

4 comments

5 participants

tags (0)

participants (5)

Brandon Stewart
Hankinson, Michael
Maxwell Palmer
Michael Hankinson
Rachel Crouch