search for: datframes

Hi all I have a list of multiple datframes with the same column headers. The last column in each datframe contains a vector of "Interval" class after I have produced this column using "lubridate" package. I needed to convert my list of dataframes to be in a single dataframe for further analysis. I did this using the foll...

> On Apr 17, 2018, at 10:10 AM, Allaisone 1 <allaisone1 at hotmail.com> wrote: > > > Hi all > > I have a list of multiple datframes with the same column headers. The last column in each datframe contains a vector of "Interval" class after I have produced this column using "lubridate" package. I needed to convert my list of dataframes to be in a single dataframe for further analysis. I did this using the foll...

I am hoping for some advice regarding ordering a dataframe, by date. The dataframe is in the format below. $story $datepub story10 1 April 1999 story 90 1 March 2002 story 37 10 July 1985 I want to reorder the entire dataframe so the earliest story is first, and save the reordered dataframe. The command, 'class' (datepub) reveals $datepub is a factor variable. I tried

Hi I need some help getting results from multiple linear models into a dataframe. Let me explain the problem. I have a dataframe with ejection fraction results measured over a number of quartiles and grouped by base_study. My dataframe (800 different base_studies) looks like > afvtprelvefs basestudy quartile ef ef_std entropy CBP0908020 1 21.6 0.53 3.27

Hi, I'm writing for a little help. I have a dataframe with same NA value and I'd like to obtain the means of the value of a coloumn grouped by the levels of a factor coloumn of the datframe. I'm using the function "tapply" but I see that if only a NA value is present the result is NA. There is an option to have the correct result or I must use an other function? Thanks of

Dear r-help reader, I have some problems with the aggregate function. My datframe looks like >frame Day Time V1 V2 1 M 0 3 NA 2 M 0 4 NA 3 M 0 5 2 4 M 1 NA 4 5 M 1 10 6 6 T 0 4 45 7 T 1 4 3 8 T 1 3 2 9 T 1 6 1 I used the aggegate function to obtain the mean in V1 and V2 over the grouping variable Time and Day

Hi I have 3 dataframes, a,b,c with 0/1 values...i have to check a condition for dataframe a and b and then input the rows ids to datframe c . In the if condition, I AND the 2 rows of from a and b and then see if the result is equal to one of them. I have done this using a for loop, however, it takes a long time to execute with larger dataset..Can you help me do it using apply function so that i

hi all, I've got to import CSV-datasets (with variable-names in the first line) into data.frames. each is about 12MB (or more!) with 1823 columns and about 500 rows. the first 22 columns are in "character"-mode, the rest is "numeric". I run R 1.4.1 on a Windows 2000 system. First I tried read.table() which works fine for a low number of cases (say, 40). with all cases

Hi, I have managed to format my data into a single datframe consisting of two AsIs response and predictor dataframes in order to supply the plsr command of the pls package for principal components analysis. When I execute the command, however, I get this error: > fiber1 <- plsr(respmat ~ predmat, ncomp=1, data=inputmat,validation="LOO") Error in model.frame.default(formula =

I am still searching for a solution to what i think is a simple problem i am having with building a vector in a for loop. I have built a more understandable example so hopefully that will help..help you, help me, if you know what i mean. dev=400 #test location model TAZs to reference cands=c(101,105,109) #Create Object of length of cands candslength=length(cands) #TEST TAZ Vector

...ocal variable. My questions can thus be summarised as ff: 1). How do I call a custom function written in R, using the R ActiveX library. ? 2). How do I access a dataframe returned from a function call, using the R ActiveX library. ? 3). Can I / How do I pass arguments into a function (including datframes) using the R ActiveX library. ? Many Thanks PS: I am relatively new to R, and I suspect that my function is not loaded into R's memory space. When using R in the normal way (i.e. via GUI), I initially used the source() command to load the function script. However, I have saved it in th...

Hi Neha, Perhaps merge() from base or join from dplyr is what you are looking for. data. table could also be interesting. Hth Ulrik On Wed, 2 May 2018, 21:28 Neha Aggarwal, <aggarwalneha2000 at gmail.com> wrote: > Hi > > I have 3 dataframes, a,b,c with 0/1 values...i have to check a condition > for dataframe a and b and then input the rows ids to datframe c . In the if >

Hi friends, If someone can find out some time to go through my problem would be really grateful. I have a dataset(dataset1) as shown below:-- recmeanC1 recmeanC2 recmeanC3 recmeanC4 i1 i2 i3 i4 i5 i6 i7 i8 i9 i10 i11 1 NA 1 1.00 1.800000 NA 1 NA 1 1 NA 2 2 2 NA 2 2 2 2 1.00

hi, I have 2 files example 1 and example 2 and would like to know what is in example2 and not in example1 (attached) V1 contain data which could be in duplicated which I am using as identifiers I used setdiff(example2$V1,example1$V1) to find the identifiers which are specific to example2: [1] "rs2276598" "rs17253672" I am looking for a way to get an output with all

On Fri, 17 Aug 2001, Patrick Connolly wrote: > |> The data are stored in a MySQL table, and I can read them > |> into R with RMySQL obtaining a MySQLResultSet object (which I > |> suppose is a data frame ?) which looks like this: > > No, it doesn't have any column names. It would be a good idea to get > it into one since dataframes are very good ways of

Hello all R gurus, I have a following problem which I hope someone will help me to solve. I have a data.frame in form similar to below. > testframe<-data.frame("Name"=c("aa","aa","aa","aa","aa","bb","bb","bb","bb","bb"),"Value"=c(1,100,1,1,1,100,100,100,100,1))

i want to make survival plots for a coxph object using survfit function. mod.phm is an object of coxph class which calculated results using columns X and Y from the DataFrame. Both X and Y are categorical. I want survival plots which shows a single line for each of the categories of X i.e. '4' and 'C'. I am getting the following error: > attach(DataFrame) >

Dear All, I have a list of dataframes, each cell in every dataframe (after I have cleaned up the dataframes) is either real or NA but have class character (I think). I would like to know how to change the class of every cell without using a for-loop. I currently have this dataframes <- sapply(1: no.of.subs, function(k) apply(dataframes[[k]], 2, function(x) {

Pues este es el culpable... como soy nuevo en esto, disculpad si las estrategias de creación de datframes, etc. son poco ortodoxas. Y por cierto... esto del slicing con R es un poco... duro library(RPostgreSQL) library(reshape) #CARGA DE DATOS conn<-dbConnect("PostgreSQL",dbname="OFIDAT",user="antares") #consulta<-dbSendQuery(conn,"select codigo_buque,coalesc...

...o - Listas > Enviado el: martes, 03 de diciembre de 2013 14:18 > Para: r-help-es en r-project.org > Asunto: Re: [R-es] seleccionar columnas de un dataframe mediante > variables > > Pues este es el culpable... como soy nuevo en esto, disculpad si las > estrategias de creación de datframes, etc. son poco ortodoxas. Y por > cierto... esto del slicing con R es un poco... duro > > library(RPostgreSQL) > library(reshape) > #CARGA DE DATOS > conn<-dbConnect("PostgreSQL",dbname="OFIDAT",user="antares") > #consulta<-dbSendQuery(conn,&...