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

2018-06-28 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] Convert list of data frames to one data frame

2018-06-29 Thread Ira Sharenow via R-help
arbara", "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 &g

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

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

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

2018-06-30 Thread Ira Sharenow via R-help
= c(NA, -1L)) DF2 <- read.table( text = "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 )      

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 Fir

[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 s

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 wrote: > > Can you access the postgres database through psql or some other route? > Also, do you require a password to acce