Displaying 20 results from an estimated 2000 matches similar to: "Columns and rows"
2006 Feb 01
2
Write.table: change points to commas when object contains a row of characters
Dear Group! I asked write.table to change the decimal point from "." to
"," , but apparently it would only do so if the object to be written
does not contain any character elements. I would like to understand, why
this has to be so and - of course - find a solution for my matrix object
jjmat, that I tried to write out by
write.table(jjmat, file="jjmat.txt",
2012 Jul 24
5
First value in a row
Hi.
This is likely a trivial problem but have not found a solution.
Imagine the following dataframe:
Lat Lon x1 x2 x3
01 10 NA NA .1
01 11 NA .2 .3
01 12 .4 .5 .6
I want to generate another column that consist of the first value in
each row from columns x1 to x3. That is
NewColumn
.1
.2
.4
Any input greatly appreciated,
Thanks,
Camilo
Camilo Mora, Ph.D.
2012 Sep 01
5
R_closest date
Hi,
I have encountered an issue about finding a date closest to another date
So this is how the data frame looks like:
PT_ID IDX_DT OBS_DATE DAYS_DIFF OBS_VALUE CATEGORY
13 4549 2002-08-21 2002-08-20 -1 183 2
14 4549 2002-08-21 2002-11-14 85 91 1
15 4549 2002-08-21 2003-02-18 181 89 1
16 4549 2002-08-21 2003-05-15
2012 Mar 10
3
function input as variable name (deparse/quote/paste) ??
Hi all
Say I have a function:
myname=function(dat,x=5,y=6){
res<<-x+y-dat
}
for various input such as
myname(dat1)
myname(dat2)
myname(dat3)
myname(dat4)
myname(dat5)
how should I modify the 'res' line, to have new informative variable name
correspondingly, such as
dat1.res
dat2.res
dat3.res
dat4.res
dat5.res
stored in the workspace.
This is only an example of a complex
2013 Jan 05
3
Need help with time series data
Dear R users,
Could you share your knowledge on following problem:
Suppose we have dataframe:
ID TIME Data1 Data2 Data3
........... Data700
1. 2013-01-01 00:00:00 34 53 66
............ 55
2. 2013-01-01 00:00:01 333 4 5
............ 50
3. 2013-01-01 00:00:02 and so
2012 Jul 29
1
readRDS, In as.double.xts(fishReport$count) : NAs introduced by coercion
Hello,
I looked in the R-help but could not find an archive addressing the
following. I would like to convert a character to numeric after reading a
file with RDS extension. After using as.numeric, I checked if it is
numeric. It was not converted. Please help.
Here is my code
>Report <- readRDS(file="RDS/Report.RDS")
> Report[1:2,]
dive_id date
2012 Jul 14
2
Arrange two columns into a five variable dataframe
Hi,
I hope that folks can give me some simple approaches to taking the data set
below, which is accumulated in two columns called "long" and "group", then
arrange the data is the "long" column into a data frame containing five
variables: "Group 1", "Group 2", "Group 3", "Group 4", and "Group 5". I am
hoping for a few
2012 Jun 22
4
Search list of elements for a specific pattern
Hi,
I have a list of mutations, called "mutList", of the form:
> head(mutList)
Alu
1 AluJ
2 AluJ/F(R)AM
3 AluJ/FLAM
4 AluJ/FRAM
5 AluJ/monomer
6 AluJb
It contains about 500 elements and not all of them contain the
sequence "Alu". I tried using this code:
Alu<-mutList[which(grep("Alu",mutList)==1)]
But that simply returned
2011 Jul 02
5
How many times occurs
Hi all,
I have a data matrix likein "input.txt"
8 9 2 5 4 5 8 5 6 6
8 9 2 8 9 2 8 9 2 1
8 9 2 5 4 5 8 5 6 4
8 9 2 5 4 5 8 5 6 6
8 9 2 8 9 2 8 9 2 1
8 9 2 5 4 5 8 9 2 2
In this example will be an 6x10 matrix (or data frame)
I want to detect how many times in a row appears this combination 8 follewd
by 9 followed by 2, and create a new matrix with only this number of occurs
then
2013 Apr 08
3
Reshaping a table
Hello all,
I have data in the form of a table:
X Y1 Y2
0.1 3 2
0.2 2 1
And I would like to transform in the form:
X Y
0.1 Y1
0.1 Y1
0.1 Y1
0.1 Y2
0.1 Y2
0.2 Y1
0.2 Y1
0.2 Y2
Any ideas how?
Thanks in advance,
IOanna
[[alternative HTML version deleted]]
2012 Sep 24
3
List creation based on matrix
Hi guys,
It would be great if you could help me with this one...
I'm looking to create a script to convert a matrix of species abundance e.g:
<http://r.789695.n4.nabble.com/file/n4643978/species_matrix.jpg>
into two vectors e.g:
<http://r.789695.n4.nabble.com/file/n4643978/communitylist.jpg>
----------------
If you feel there is no easy answer to this and that it would be
2012 Jul 14
2
Help for Fisher's exact test
Hi, R-help,
I have a group of data from RNA-seq want to be analyzed by Fisher's
exact test in R. I want to compare the significant difference of about
30,0000 individuals in two different samples, and I have no idea how to use
R, so could you please give me some suggestions or the scripts for
Fisher's exact test? Thank you very much.
Best,
Guanfeng Wang
[[alternative HTML version
2012 Oct 26
3
regression analysis in R
Dear useRs,
i have vectors of about 27 descriptors, each having 703 elements. what i want to do is the following 1. i want to do regression analysis of these 27 vectors individually, against a dependent vector, say B, having same number of elements.2. i would like to know best 10 regression results, if i do regression analysis of dependent vector against the random combination of any 4
2012 Oct 19
4
Creating a new by variable in a dataframe
Hello,
I have a dataframe w/ 3 variables of interest: transaction,date(tdate) &
time(event_tim).
How could I create a 4th variable (last_trans) that would flag the last
transaction of the day for each day?
In SAS I use:
proc sort data=all6;
by tdate event_tim;
run;
/*Create last transaction flag per day*/
data all6;
set all6;
by tdate event_tim;
last_trans=last.tdate;
Thanks
2006 Sep 15
1
Table manipulation question
I have a table:
C1
RowName1 3
RowName2 2
and another table:
C2
RowName1 5.6
RowName1a 4.3
RowName2 NA
I want to join join the tables with matching rows:
C1 C2
RowName1 3 5.6
RowName2 2 NA
I'm thinking of something like:
2012 Oct 26
3
Delete row if two values in a matrix are equal
Hi all and thank you for your time.
I would like to delete rows from this matrix I call "var" if the character
in Ref_Allele is equal to the character in Var_Allele. I have attached a
before and after, to help my poor explanation. If someone could provide me
with some code, or some guidance I would really appreciate it.
Thank you again.
"Before"
> var
Ref_Pos Ref_Allele
2012 Dec 17
3
Merge more than 2 dataframe
Hello.
I have for example 4 or more dataframe which like such this example:
date value
2006-11 0.4577647
2006-12 NaN
2006-10 0.1577647
2006-11 0.3577647
2006-12 NaN
2007-01 NaN
2007-02 NaN
2007-03 0.2956429
2007-01 0.3677647
2007-02 NaN
They have the same length. I need merge by date undefined number of
dataframes. End result output will look like
2012 Oct 04
3
R combining vectors into a data frame but without a continuous common variable
Hello,
I have two different files which I'd like to combine to make one data frame
but I've no idea how to do it! The first file has two columns; one is the
date, the following is a binary code for debris flow events. Then my other
file has also two columns; the date and then precipitation data.
The thing is, is that the two date columns don't all contain the same dates.
The binary
2002 Nov 04
3
write table and dinnames
I would write in tab-text file a table like this one:
TAB colname1 TAB colname2 TAB TAB... colnameN
rowname1 # # #
rowname2 # # #
rownameM # # #
then I wrote something like:
mymatrix <- matrix(nrow=M,ncol=N,byrow=T)
rownames(mymatrix) <- chvector1
colnames(mymatrix) <- chvector2
2012 Jun 28
6
How can I make a list using aggregate function?
Hi friends,
I need to generate a list, that should contain the quantile value of one
column in a data frame. while I am compiling this one i am facing one bug,,
Really I cannot find out that where the problem has occurred? Could any one
help me to come out from this bug??
Here is the code,
data <- lapply(comb.data$zFE, function(x) aggregate(x,