Re: [R] Convert list of data frames to one data frame

2018-07-01 Thread Ira Sharenow via R-help
} listFinal3 <- lapply( employees4List, myrename3 ) listFinal3 #> [[1]] #>  First1 Second1 #> 1    Al  Jones #> #> [[2]] #>  First1 Second1 First2 Second2 #> 1    Al2  Jones  Barb  Smith #> #> [[3]] #>  First1 Second1  First2 Second2 First3 Second3 #> 1    Al3  Jo

Re: [R] Convert list of data frames to one data frame

2018-06-30 Thread Ira Sharenow via R-help
Start              End John              Adams Thomas        Jefferson ", header = TRUE, as.is = TRUE ) DFL <- list( DF1, DF2 ) # DFNames is a set of unique identifiers DFL1 <- data_frame( .DFNames = sprintf( "DF%d", 1:2 )                   , data = DFL                   ) DFL2

Re: [R] Convert list of data frames to one data frame

2018-06-30 Thread Ira Sharenow via R-help
quot;Barb", "Carol"), second1 = c("Jones", > > "Smith", "Adams")), > > data.frame(first1 = ("Al"), second1 = "Jones")) > > > > employees4List = list( > > data.frame(first1 = ("Al"), sec

Re: [R] Convert list of data frames to one data frame

2018-06-29 Thread Ira Sharenow via R-help
Carol"), second3 = c("Jones", > "Smith", "Adams")), > data.frame(first4 = ("Al"), second4 = "Jones2")) > > ### > > dfbycol <- function(x) { >  x <- lapply(x, function(y)as.vector(t(as.matrix(y >  x <- lapply(x

[R] Convert list of data frames to one data frame

2018-06-29 Thread Ira Sharenow via R-help
I have a list of data frames which I would like to combine into one data frame doing something like rbind. I wish to combine in column order and not by names. However, there are issues. The number of columns is not the same for each data frame. This is an intermediate step to a problem and the

Re: [R] Connect to postgreSQL

2017-08-26 Thread Ira Sharenow via R-help
do know how to write SQL queries, having used SQL Server. On 8/26/2017 9:47 PM, John wrote: > On Sat, 26 Aug 2017 18:35:31 -0700 > Ira Sharenow via R-help <r-help@r-project.org> wrote: > > Can you access the postgres database through psql or some other route? > Also, do y

[R] Connect to postgreSQL

2017-08-26 Thread Ira Sharenow via R-help
I am using RStudio Version1.0.143 on a Windows 7 machine. R version 3.4.0 I am trying to connect to a postgreSQL database with the following command, but I receive an error message that says my password is incorrect. Since I saved my password in a file, I think I remember it. I searched for a