Hi
Isn't melt just what you want?
melt(mydt)
Petr
-Original Message-
From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
project.org] On Behalf Of Abraham Mathew
Sent: Tuesday, March 18, 2014 1:59 AM
To: r-help@r-project.org (r-help@r-project.org)
Subject: [R] Reshaping
I have the following data frame. Using the stringr package, I've attempted
to map the url's to some specific elements that are in each url. I then
used the reshape package to join two different data frames. The next step
is to transform the two columns in the mydt data frame (forester and
5
#Mary 4 0 0 0
A.K.
From: sylvain willart sylvain.will...@gmail.com
To: arun smartpink...@yahoo.com
Cc: R help r-help@r-project.org
Sent: Saturday, April 13, 2013 5:41 PM
Subject: Re: [R] Reshaping Data for bi-partite Network Analysis [SOLVED
Hello
I have a dataset of people spending time in places. But most people don't
hang out in all the places.
it looks like:
Input-data.frame(people=c(Marc,Marc,Joe,Joe,Joe,Mary),
+ place=c(school,home,home,sport,beach,school),
+ time=c(2,4,3,1,5,4))
Input
people
, 2013 5:03 PM
Subject: [R] Reshaping Data for bi-partite Network Analysis
Hello
I have a dataset of people spending time in places. But most people don't
hang out in all the places.
it looks like:
Input-data.frame(people=c(Marc,Marc,Joe,Joe,Joe,Mary),
+ place=c(school,home,home
Hello,
With the following the order of both rows and columns will be different
than the order of your example output, but the table is basically the same.
xtabs(time ~ people + place, data = Input)
Hope this helps,
Rui Barradas
Em 13-04-2013 22:03, sylvain willart escreveu:
Hello
I have
sylvain.will...@gmail.com
To: r-help r-help@r-project.org; sylvain willart
sylvain.will...@gmail.com
Sent: Saturday, April 13, 2013 5:03 PM
Subject: [R] Reshaping Data for bi-partite Network Analysis
Hello
I have a dataset of people spending time in places. But most people don't
hang out
Wonderful! thanks, Rui!
AC
On Tue, Jul 24, 2012 at 10:01 PM, Rui Barradas ruipbarra...@sapo.pt wrote:
Hello,
Try the following.
# We are going to use this twice
sl - split(long, long$id)
# Remove groups with only one row
l2 - lapply(sl, function(x) if(nrow(x) 1) x)
l2 -
Hi,
I am trying to reshape data from a long to wide format but have a specific
task that I cannot get to output properly.
# SAMPLE DATA;
id - c(1,2,2,3,3,3)
time -c(0,0,5, 0, 2, 10)
x - rnorm(length(id))
long - data.frame(id,time,x)
# To reshape, I would like to exclude 'id' values that have NO
Hello,
Try the following.
# We are going to use this twice
sl - split(long, long$id)
# Remove groups with only one row
l2 - lapply(sl, function(x) if(nrow(x) 1) x)
l2 - do.call(rbind, l2)
l2
# Create a new variable
l3 - lapply(sl, function(x) cbind(x, NEW_VARIABLE=seq_len(nrow(x
l3 -
On 2012-07-24 22:01, Rui Barradas wrote:
Hello,
Try the following.
# We are going to use this twice
sl - split(long, long$id)
# Remove groups with only one row
l2 - lapply(sl, function(x) if(nrow(x) 1) x)
l2 - do.call(rbind, l2)
l2
# Create a new variable
l3 - lapply(sl, function(x)
Hello All,
Tried some more Internet searches and came to the conclusion that one probably
does need to create a timevar before reshaping from long to wide. Below is
some code that creates the timevar and transposes the data.
connection - textConnection(
005 1 Gemcitabine
005 2 Erlotinib
006 1
Hello All,
I was wondering if it's possible to reshape data from long to wide in R without
using a timevar. I've pasted some sample data below along with some code. The
data are sorted by Subject and Drug. I want to transpose the Drug variable into
multiple columns in alphabetical order.
My
If I understand you right,
library(reshape2)
dcast(melt(TestData, id.var = Subject, measure.var = Drug), Subject ~ value)
Michael
On Tue, Mar 20, 2012 at 9:50 AM, Paul Miller pjmiller...@yahoo.com wrote:
Hello All,
I was wondering if it's possible to reshape data from long to wide in R
, Erlotinib. That's what I mean when I say
I want the columns in alphabetical order.
Thanks,
Paul
--- On Tue, 3/20/12, R. Michael Weylandt michael.weyla...@gmail.com wrote:
From: R. Michael Weylandt michael.weyla...@gmail.com
Subject: Re: [R] Reshaping data from long to wide without a timevar
On 09/08/2011 12:02 AM, dadrivr wrote:
Hi,
I'm trying to reshape my data set from wide to tall format for multilevel
modeling. Unfortunately, the function I typically use (make.univ from the
multilevel package) does not appear to work with unbalanced data frames,
which is what I'm dealing
I have the following data (see RawData using dput below)
How do I get it in the following 3 column format (CO2 measurements are the
elements of the original data frame). I'm sure the package reshape is where
I should look, but I haven't figured out how.
Thanks ahead of time
Month Year CO2
Hi,
I'm trying to reshape my data set from wide to tall format for multilevel
modeling. Unfortunately, the function I typically use (make.univ from the
multilevel package) does not appear to work with unbalanced data frames,
which is what I'm dealing with.
Below is an example of the columns of
look at the melt function in reshape, specifically ?melt.data.frame
require(reshape)
Raw.melt-melt(RawData,id.vars='Year',variable_name='Month')
there is an additional feature in the melt function for handling na values.
names(Raw.melt)[3]-'CO2'
head(Raw.melt)
Year MonthCO2
1 1958 J
The terminology (melt, cast, recast) just isn't intuitive to me; but I
understand how to use melt now.
Thanks!
Justin Haynes wrote:
look at the melt function in reshape, specifically ?melt.data.frame
require(reshape)
Raw.melt-melt(RawData,id.vars='Year',variable_name='Month')
there
Dear,
I have a data frame melted from a list of matrices (melt from reshape
package), then I impute some missing values and then want to tabulate
the data again to the array (or list, doesn't matter) of matrices form.
However when using xtabs function it orders my rows alphabetically and
Dnia 2011-06-15, o godz. 12:05:01
Jim Lemon j...@bitwrit.com.au napisał(a):
On 06/15/2011 06:46 PM, filip.biele...@rega.kuleuven.be wrote:
Dear,
I have a data frame melted from a list of matrices (melt from
reshape package), then I impute some missing values and then want
to tabulate
Hi Dennis,
Thanks for the answer, it works perfectly for two time intervals, but
if I add a third interval like this:
ID begin_t1end_t1 begin_t2end_t2
begin_t3end_t3
Thomas 11/03/0413/05/0604/02/07
$variable - NULL
dat.final - cast(m.dat, ... ~ begin.end)
Hope it helps,
Ista
--- On Mon, 7/19/10, Thomas Jensen thomas.jen...@eup.gess.ethz.ch wrote:
From: Thomas Jensen thomas.jen...@eup.gess.ethz.ch
Subject: [R] Reshaping data
To: R-help@r-project.org
Received: Monday, July 19, 2010, 6:48 PM
Dear All,
I have some data in the following shape:
ID begin_t1end_t1 begin_t2end_t2
Thomas 11/03/0413/05/0604/02/0716/05/08
... ... ... ...
Hi:
Here's one solution using function reshape() in the stats package (adapted
from an R-help solution by Thomas Lumley on Nov. 26, 2002):
d - read.table(textConnection(
+ ID begin_t1end_t1 begin_t2
end_t2
+ Thomas 11/03/0413/05/06
wrote:
From: Thomas Jensen thomas.jen...@eup.gess.ethz.ch
Subject: [R] Reshaping data
To: R-help@r-project.org
Received: Monday, July 19, 2010, 6:48 PM
Dear All,
I have some data in the following shape:
ID
begin_t1 end_t1
begin_t2 end_t2
Thomas
11/03
Thank you Dennis and Henrique for your help!
Both solutions work! I just need to find a way of removing the empty cells
from the final long dataframe since they are not NAs.
Maybe there is an easier way of doing this of the data is not treated as a
dataframe? The original data file that is
-Original Message-
From: r-help-boun...@r-project.org
[mailto:r-help-boun...@r-project.org] On Behalf Of Mia Bengtsson
Sent: Friday, May 21, 2010 3:39 AM
To: Dennis Murphy; Henrique Dallazuanna
Cc: r-help@r-project.org
Subject: Re: [R] reshaping data
Thank you Dennis
] On Behalf Of Mia Bengtsson
Sent: Friday, May 21, 2010 3:39 AM
To: Dennis Murphy; Henrique Dallazuanna
Cc: r-help@r-project.org
Subject: Re: [R] reshaping data
Thank you Dennis and Henrique for your help!
Both solutions work! I just need to find a way of removing
the empty cells from
Hello,
I am a relatively new R-user who has a lot to learn. I have a large dataset
that is in the following dataframe format:
red A B C
green D
blueE F
Where red, green and blue are species names and A, B and C are observations
(corresponding to DNA
Try this:
x_long - reshape(x, direction = 'long', varying = 2:4, sep = '', idvar =
'V1', timevar = 'V')
subset(x_long[order(x_long$V1),], V != )
On Thu, May 20, 2010 at 2:13 PM, Mia Bengtsson mia.bengts...@bio.uib.nowrote:
Hello,
I am a relatively new R-user who has a lot to learn. I have a
Hi All,
Can someone help me reshape following data:
Var1 Var2 Val
A X 1
A Y 2
A Z 3
B X 4
B Y 5
B Z 6
to some kind of matrix/tabular format (preferably as a matrix), may be like
Var1 X Y Z
A 1 2 3
B 4 5 6
Any help would be greatly appreciated,
Kim
[[alternative HTML version deleted]]
Try this:
xtabs(Val ~ Var1 + Var2, data = x)
On Wed, Mar 31, 2010 at 3:23 PM, Kim Jung Hwa kimhwamaill...@gmail.com wrote:
Hi All,
Can someone help me reshape following data:
Var1 Var2 Val
A X 1
A Y 2
A Z 3
B X 4
B Y 5
B Z 6
to some kind of matrix/tabular format (preferably as a
Hi Kim,
look at the reshape() command with direction=wide. Or at the reshape
package.
HTH,
Stephan
Kim Jung Hwa schrieb:
Hi All,
Can someone help me reshape following data:
Var1 Var2 Val
A X 1
A Y 2
A Z 3
B X 4
B Y 5
B Z 6
to some kind of matrix/tabular format (preferably as a matrix),
Thanks Henrique and Stephan for your reply!
Henrique, I'm planning to do some arthitmetic operations on tranformed
(matrix) data and then would like to convert it back to original format (as
a data frame)... is there an equivalent easy command for this too? Thanks,
On Wed, Mar 31, 2010 at 2:26
Actually, apart from melt() in reshape package.
On Wed, Mar 31, 2010 at 2:37 PM, Kim Jung Hwa kimhwamaill...@gmail.comwrote:
Thanks Henrique and Stephan for your reply!
Henrique, I'm planning to do some arthitmetic operations on tranformed
(matrix) data and then would like to convert it back
Try:
as.data.frame(with(x, tapply(Val, list(Var1, Var2), sum)))
On Wed, Mar 31, 2010 at 3:37 PM, Kim Jung Hwa kimhwamaill...@gmail.com wrote:
Thanks Henrique and Stephan for your reply!
Henrique, I'm planning to do some arthitmetic operations on tranformed
(matrix) data and then would like
On Mar 31, 2010, at 2:37 PM, Kim Jung Hwa wrote:
Thanks Henrique and Stephan for your reply!
Henrique, I'm planning to do some arthitmetic operations on tranformed
(matrix) data and then would like to convert it back to original
format (as
a data frame)... is there an equivalent easy
Dear all,
Lets say I have several data frames as follows:
set.seed(42)
dates - as.Date(c(2010-01-19, 2010-01-20))
times - c(09:30:00, 11:30:00, 13:30:00, 15:30:00)
shows - c(Red Dwarf, Being Human, Doctor Who)
df1 - data.frame(Date = dates[1], Time = times[1], Show = shows, Score = 1:3)
Try with tapply:
with(do.call(rbind, df.list), tapply(Score, list(Date, Time, Show), length))
On Wed, Jan 20, 2010 at 10:20 AM, Tony B tony.bre...@googlemail.com wrote:
Dear all,
Lets say I have several data frames as follows:
set.seed(42)
dates - as.Date(c(2010-01-19, 2010-01-20))
times
Thank you for taking the time to reply Henrique. Although your
solution does take away the zeroes and replaces them with NA's (which
i prefer), it unfortunately seems to reduce all of the other scores to
just '1':
x - with(do.call(rbind, df.list), tapply(Score, list(Date, Show, Time),
length))
You can use this instead:
with(do.call(rbind, df.list), tapply(Score, list(Date, Show, Time), invisible))
On Wed, Jan 20, 2010 at 3:02 PM, Tony B tony.bre...@googlemail.com wrote:
Thank you for taking the time to reply Henrique. Although your
solution does take away the zeroes and replaces
Hi all,
I have a dataframe that has one observation per case.
for example:
CaseStartyear Endyear
A 1979 1989
B 1950 1955
I would like to create a dataframe in which each case has
multiple observations corresponding to the start and end
Try this;
with(x, data.frame(Case = rep(Case, (Endyear - Startyear) + 1),
Year = unlist(mapply(seq, Startyear, Endyear
On Tue, Nov 24, 2009 at 4:14 PM, Joseph Magagnoli jcm...@gmail.com wrote:
Hi all,
I have a dataframe that has one observation per case.
for
Hi all,
I have a matrix of correlation values between all pairwise comparison in
an experiment. For example, I have 2 time points (1,2) each in
triplicate. Thus, I have the following matrix
1-1
1-2
1-3
2-1
2-2
2-3
1-1
NA
...
...
...
...
...
1-2
...
NA
...
...
...
...
Dear Chuck, John, Vikas, and useRs,
thank you very much for your great suggestions.
I received three replies providing different ways to reshape my original
data.frame (original question at the bottom). There are however some
discrepancies in their results (most likely because I didn't explain
Here is a very clumsy way to do it but I think it
works
fact1 - rep(level.1, length(mydat[,1]))
fact2 - rep(level.2, length(mydat[,1]))
lels - c(fact1,fact2)
nams - c(indiv, case.id, covar)
set1 - mydat[, c(1,2,3)] ; names(set1) - nams
set2 - mydat[,c(1, 4,5)] ; names(set2) - nams
newdata -
# 2. create one new row for each case in level.1 and level.2
# the new reshaped data.frame would should look like this:
# indiv factorcovar case.id
# A level.1 4.6141051
# A level.1 4.6141052
# A level.2 31.0644051
# A level.2 31.0644052
#
Dear all,
I'm having a few problems trying to reshape a data frame. I tried with
reshape{stats} and melt{reshape} but I was missing something. Any help is
very welcome. Please find details below:
#
# data in its original shape:
indiv - rep(c(A,B),c(10,10))
On 2/20/2008 1:14 PM, ahimsa campos-arceiz wrote:
Dear all,
I'm having a few problems trying to reshape a data frame. I tried with
reshape{stats} and melt{reshape} but I was missing something. Any help is
very welcome. Please find details below:
#
# data
51 matches
Mail list logo