Re: [R] Getting an unexpected extra row when merging two dataframes

2017-03-30 Thread jim holtman
ql connection to read in the table. > > That being said, how can I do to fix tve issue? > > Best regards, > > Paul > > > > Mensaje original ---- > Asunto: Re: [R] Getting an unexpected extra row when merging two dataframes > De: jim holtman > Para

Re: [R] Getting an unexpected extra row when merging two dataframes

2017-03-29 Thread jim holtman
first of all when you read the data in you get 379 rows of data since you did not say 'header = TRUE' in the read.table. Here is what the first 6 lines of you data are: > dataset1 <- read.table('/users/jh52822/downloads/containertestdata.txt') > > str(dataset1) 'data.frame': 379 obs. of 2 vari

[R] Getting an unexpected extra row when merging two dataframes

2017-03-29 Thread Paul Bernal
Hello everyone, Hope you are all doing great. So I have two datasets: -dataset1Frame: which contains the historical number of transits from october 1st, 1985 up to march 1, 2017. It has two columns, one called TransitDate and the other called Transits. dataset1Frame is a table comming from an SQL