Displaying 20 results from an estimated 3000 matches similar to: "transform a df with a condition"
2011 Jan 17
2
How to still processing despite bug errors?
Hi, everybody.
I am working processing EEG data from 1000 pacients. I have a specific
syntax to perform the Spectral Analysis and a loop to analyse all subjects.
each subject data are in separate folders (P1, P2 P3...)
My question is: in some cases, some errors can appear in one subject. I want
to know if is possible to jump to the next subject and perform the same
syntax , exibiting an error
2009 Aug 12
4
paste first row string onto every string in column
Hi,
I am trying to edit a data frame such that the string in the first line is
appended onto the beginning of each element in the subsequent rows. The data
looks like this:
> df
V1 V2 V3 V4
1 DPA1* DPA1* DPB1* DPB1*
2 0103 0104 0401 0601
3 0103 0103 0301 0402
.
.
and what I want is this:
>dfnew
V1 V2 V3 V4
1 DPA1* DPA1* DPB1* DPB1*
2 DPA1*0103
2008 Jan 24
2
boxplot axis labelling
Hi,
i'm very new to R, so sorry for what i'm sure is a very basic question. I'm
producing a boxplot with the data below:
df3<-data.frame(
x=c(10,11,115,12,13,14,16,17,18,21,22,23,24,26,27,28,29,3,30,32,33,34,35,4,4
1,45,5,50,52,56,58,6,67,6738,68,7,8,9),
fq=c(8,11,1,2,4,4,2,2,6,3,4,2,2,1,1,1,4,51,3,1,1,1,1,35,1,1,19,2,1,1,1,14,1,
1,1,10,13,5),
2017 Nov 01
3
Adding Records to a Table in R
Dear R friends,
I am currently working with time series data, and I have a table(as data
frame) that has looks like this (TransitDate are in format = "%e-%B-%Y") :
TransitDate Transits CargoTons
1985-04-01 100 2500
1985-05-01 135 4500
1985-06-01 120 1750
1985-07-01 100 3750
1985-08-01 200
2010 Apr 21
2
Table to List Transformation Scenario
I have a series of tables, one for each environment indicating a date (row)
and a sample at each hour of the day (0 to 23)
Test1 Table:
Date,Hour1,Hour2,...Hour23
1/1/10,123,123,...,123
I would like to model this as a time series but how can I translate the
table into a list such that I can get:
1/1/10 00:00, 123
1/1/10 01:00, 123
1/1/10 02:00, 123
...
1/1/10 23:00, 123
Any suggestions on how
2002 Jun 14
1
data.frame - transform
Hi there,
I have a data.frame (pwt6) which I would like to transform:
country year gdp
MEX 1950 2
MEX 1951 5
BOL 1950 4
BOL 1951 12
ITA 1950 45
ITA 1951 2
This should be the result:
year MEX.gdp BOL.gdp ITA.gdp
1950 2 4 45
1951 5 12 2
Right now I have this code (better - no code):
country.label<-names(table(pwt6$country))
result<-data.frame(year=NULL)
for(i in country.label)
?
2017 Nov 01
0
Adding Records to a Table in R
Hi Paul,
#First I set up some sample data since I don't have a copy of your data
dtOrig <- as.Date( c("1985-04-01","1985-07-01","1985-12-01","1986-04-01"))
dfOrig <- data.frame( TransitDate=dtOrig, Transits=c(100,100,500,325),
CargoTons=c(1000,1080,3785,4200) )
#Generate the complete set of dates as a data frame
dfDates<- data.frame(
2011 Jun 14
1
Expand DF with all levels of a variable
Dear list,
I would like to expand a DF with all the missing levels of a variable.
a <- c(2,2,3,4,5,6,7,8,9)
a.cut <- cut(a, breaks=c(0,2,6,9,12), right=FALSE )
(x <- data.frame(a, a.cut))
# In 'x' the level "[0,2)" is "missing".
AddMissingLevel <- function(xdf) {
xfac <- factor( c("[0,2)", "[2,6)", "[6,9)",
2004 Dec 17
1
reshape and split
Dear R-users,
I am trying to reshape the DF "dat2" in the "long" format,
but can't figure out how to use the "split"-option:
> dat2
a.1995.z b.1995.z a.1996.z var
1 100.00000 100.00000 100.00000 Neue Anlagen insgesamt
2 40.09904 23.60890 40.88960 Neue Ausr??stungen
3 59.90096 76.39110 59.11040 Neue Bauten
This
2008 May 03
1
recode involving a count rule
Hello, R-helpers.
I have a data frame below called df. I want to add a variable c, based on
the following logic:
if df$a < 5 then the first two times this condition is met place a 1 in c,
the next two times this condition is met place a 2 in c and when the
condition is not met let c equal df$b. The result would look like, dfnew,
shown below.
a <- rep(c(3,5,7), 4)
b <- rep(c(NA,1,2),
2013 Apr 09
4
Converting matrix to data frame without losing an assigned dimname
Hello All,
Would like to be able to convert a matrix to a dataframe without losing an assigned dimname.
Here is an example that should illustrate what I'm talking about.
tableData <- state.x77[c(7, 38, 20, 46), c(7, 1, 8)]
names(dimnames(tableData)) <- c("State", "")
tableData
State Frost Population Area
Connecticut 139 3100 4862
2017 Nov 08
3
Adding Records to a Table in R
Dear Eric,
Hope you are doing great. I also tried the following:
#First I created the complete date sequence
TransitDateFrame <- data.frame(TransitDate=seq(as.Date(dataset1[1,1]),
as.Date(dataset1[nrow(dataset1),1]), by = "month"))
#Then I did the merging
dataset1NEW <- merge(TransitDateFrame, dataset1, by="TransitDate",
all.x=TRUE)
Now it has, as expected the
2010 Feb 17
3
Extending data frame with longer columns
Hi,
I am a beginner in R and have only read a few chapters in the R book,
I was not able to find a solution for this simple problem.
I have an empty data frame:
a=data.frame(name="test")
which I would like to extend in a for-loop (with data extracted from a
database). Ideally I would like to extend the data frame like this:
a["new_1"] = 1:10
a["new_1"] = 1:12
2009 Mar 02
2
ave and grouping
Dear list,
# I have a DF like this:
sleep$b <- c(rep(8,10), rep(9,10))
sleep$me <- with(sleep, ave(extra, group, FUN = mean))
sleep
# I would like to create a new variable
# holding the b-th value of group 1 and 2.
# This is not what I want, it takes always the '8' from group '1'
# and not the '9'
sleep$gr <- with(sleep, ave(extra, group, FUN = function(x)
2002 Sep 11
3
accolade
I've been using R for several months now, in fact it was my intro to "real"
computer programming. It used to frustrate me no end, but lately I've
noticed my reaction has changed. Nowadays its much more like "wow, is that
cool, or what?". So I guess I've gotten over the hump of the learning
curve.
Comparing what I now do with R to my previous hodge-podge of
2017 Nov 08
0
Adding Records to a Table in R
Hi
Instead of attachments copy directly result of dput(TransitDateFrame) and dput(dataset1) to your email. Or, if your data have more than about 20 rows you could copy only part of it.
dput(TransitDateFrame[,1:20])
dput(dataset1[,1:20])
Only with this approach we can evaluate your data in all aspects and provide correct answer.
Cheers
Petr
> -----Original Message-----
> From: R-help
2010 Aug 20
5
paired samples, matching rows, merge()
Hi everyone!
I'm matching two samples to create one sample that have
pairs of observations equal for the k1 variable. Merge()
doesn't work because I dont't want to recycle the values.
x <- data.frame(k1=c(1,1,2,3,3,5),
k2=c(20,21,22,23,24,25))
x
y <- data.frame(k1=c(1,1,2,2,3,4,5,5),
k2=c(10,11,12,13,14,15,16,17))
y
merge(x,y,by="k1")
k1 k2.x k2.y
1 1 20
2011 Feb 23
2
list multiplied by a factor / mapply
Dear list,
this works fine:
x <- split(iris, iris$Species)
x1 <- lapply(x, function(L) transform(L, g = L[,1:4] * 3))
but I would like to multiply each Species with another factor:
setosa by 2, versicolor by 3 and virginica by 4. I've tried mapply but
without success.
Any thoughts? Thanks for any idea!
Patrick
2005 Apr 21
2
Download advice please!
Sorry, but I'm just an ignorant Linux user!
I have a silly question.
Situation: Now that R 2.1.0 is out (Thank you, to all
concerned!) I'm about to go off and download it and
all the packages.
What this means in practice is trotting off to my "local"
(and brand new) Internet Cafe with some CDs, where I can
get the lot over a fast link and burn it onto a CD or two.
However,
2013 Jan 23
4
how to read a df like that and transform it?
Dear all
I have a data.frame like that :
father mother num_daughter daughter
291 3906 0 NULL
275 4219 0 NULL
273 4236 1 49410
281 4163 1 49408
274 4226 1 49406
295 3869 2 49403
49404
287 4113 0 NULL
295 3871 1 49401
292 3895 4 49396
49397
49398
49399
291 3900 3 49392
How to read it into R and transform it like that:
father mother num_daughter