Use rowMeans:
rowMeans(iris[, regexpr("Sepal", colnames(iris)) > 0])
gives the means of each row of iris using only the columns
whose names contain "Sepal".
On 5/31/06, Guo Wei-Wei <[EMAIL PROTECTED]> wrote:
> Gabor and Peter,
>
> Thank you. Both of you give me excellent ways. I have a further p
Gabor and Peter,
Thank you. Both of you give me excellent ways. I have a further problem.
How can I get the common parts of column names as column names in a
new data.frame? For example, I combines data of XG1 and YG1 in
data.old and get a new column in data.new named G1. Can It be done
automatic
This is not restricted to single matches:
> colnames(iris)
[1] "Sepal.Length" "Sepal.Width" "Petal.Length" "Petal.Width" "Species"
> regexpr("Sepal", colnames(iris)) > 0
[1] TRUE TRUE FALSE FALSE FALSE
On 5/30/06, Guo Wei-Wei <[EMAIL PROTECTED]> wrote:
> Thank you. I made a mistake in my prev
Peter,
Thank you,
I made a mistake in my previous email. What I mean is:
data.new[,"G1"] <- (data.old[,"XG1"] + data.old[,"YG1"])/2
Does your way have effects on data? or only have effects on those column names?
I tried on my data and get a list of numbers. Can I rearrange the
order of columns
Thank you. I made a mistake in my previous email. What I mean is:
data.new[,"G1"] <- (data.old[,"XG1"] + data.old[,"YG1"])/2
data.old[, regexpr("G1", colnames(data.old)) > 0]
is a nice way, but there are about 100 "X*"s and "Y*"s. Can I do some
comparision on all those column names and get colum
Wei-wei
> I have a data.frame which has names as following.
> [1] "XG1" "YG1" "XEST" "YEST"
> [2] "XNOEMP1" "XNOEMP2" "YNOEMP1" "YNOEMP2"
> [3] "XBUS10" "XBUS10A" "XBUS10B" "XBUS10C"
> [4] "YBUS10" "YBUS10A" "YBUS10B" "YBUS10C"
> [5] "XOWNBUS" "XSELFEST" "YOWNBUS" "YSELFEST"
>
>
On 5/30/06, Guo Wei-Wei <[EMAIL PROTECTED]> wrote:
> Dear all,
>
> I have a data.frame which has names as following.
> [1] "XG1" "YG1" "XEST" "YEST"
> [2] "XNOEMP1" "XNOEMP2" "YNOEMP1" "YNOEMP2"
> [3] "XBUS10" "XBUS10A" "XBUS10B" "XBUS10C"
> [4] "YBUS10" "YBUS10A" "YBUS10B" "YBUS10C"
Dear all,
I have a data.frame which has names as following.
[1] "XG1" "YG1" "XEST" "YEST"
[2] "XNOEMP1" "XNOEMP2" "YNOEMP1" "YNOEMP2"
[3] "XBUS10" "XBUS10A" "XBUS10B" "XBUS10C"
[4] "YBUS10" "YBUS10A" "YBUS10B" "YBUS10C"
[5] "XOWNBUS" "XSELFEST" "YOWNBUS" "YSELFEST"
Those columns
