search for: cargotons

Displaying 6 results from an estimated 6 matches for "cargotons".

2017 Nov 01
3
Adding Records to a Table in R
Dear R friends, I am currently working with time series data, and I have a table(as data frame) that has looks like this (TransitDate are in format = "%e-%B-%Y") : TransitDate Transits CargoTons 1985-04-01 100 2500 1985-05-01 135 4500 1985-06-01 120 1750 1985-07-01 100 3750 1985-08-01 200 1250 The problem is, that there are several periods that don?t exist in the table, so it has the following behavi...
2017 Nov 01
0
Adding Records to a Table in R
Hi Paul, #First I set up some sample data since I don't have a copy of your data dtOrig <- as.Date( c("1985-04-01","1985-07-01","1985-12-01","1986-04-01")) dfOrig <- data.frame( TransitDate=dtOrig, Transits=c(100,100,500,325), CargoTons=c(1000,1080,3785,4200) ) #Generate the complete set of dates as a data frame dfDates<- data.frame( TransitDate=seq(from=as.Date("1985-04-01"),by="1 month",length=13) ) # do the merge adding the "missing" rows (where NA will appear) dfNew <- merge(dfDates, dfOr...
2017 Jun 19
3
How to Transform a Factor Variable into a Date
Dear all, Hope you are doing great. I have a .csv file that I read into R, the .csv file consistss of two fields (TransitDate and CargoTons). The TransitDate I formatted from Excel in the fashion mmm-yy (e.g.: Apr-2013). However R does not recognize the field TransitDate as a date field. Here is the code: library(lubridate) Dataset <- read.table("U:/NEWCargoData.csv", header=TRUE, sep=",", na.strings="NA...
2017 Nov 08
3
Adding Records to a Table in R
...Paul, > > #First I set up some sample data since I don't have a copy of your data > dtOrig <- as.Date( c("1985-04-01","1985-07-01","1985-12-01","1986-04-01")) > dfOrig <- data.frame( TransitDate=dtOrig, Transits=c(100,100,500,325), > CargoTons=c(1000,1080,3785,4200) ) > > #Generate the complete set of dates as a data frame > dfDates<- data.frame( TransitDate=seq(from=as.Date("1985-04-01"),by="1 > month",length=13) ) > > # do the merge adding the "missing" rows (where NA will appear) >...
2017 Nov 08
0
Adding Records to a Table in R
...set up some sample data since I don't have a copy of your > > data dtOrig <- as.Date( > > c("1985-04-01","1985-07-01","1985-12-01","1986-04-01")) > > dfOrig <- data.frame( TransitDate=dtOrig, Transits=c(100,100,500,325), > > CargoTons=c(1000,1080,3785,4200) ) > > > > #Generate the complete set of dates as a data frame > > dfDates<- data.frame( TransitDate=seq(from=as.Date("1985-04-01"),by="1 > > month",length=13) ) > > > > # do the merge adding the "missing" ro...
2017 Jun 19
0
How to Transform a Factor Variable into a Date
...mon(my.factor) ## gets around the factor-vs-character issue On Mon, Jun 19, 2017 at 3:07 PM, Paul Bernal <paulbernal07 at gmail.com> wrote: > Dear all, > > Hope you are doing great. I have a .csv file that I read into R, the .csv > file consistss of two fields (TransitDate and CargoTons). > > The TransitDate I formatted from Excel in the fashion mmm-yy (e.g.: > Apr-2013). However R does not recognize the field TransitDate as a date > field. > > Here is the code: > > library(lubridate) > > Dataset <- read.table("U:/NEWCargoData.csv", heade...