Displaying 2 results from an estimated 2 matches for "sale_month".
Did you mean:
late_month
2010 Jul 15
1
How do I combine lists of data.frames into a single data frame?
...time,"exp")
rv$year = df$sale_year[1]
rv$sample = df$sale_week[1]
rv$granularity = "week"
rv
}
funmonth <- function(df)
if (length(df$elapsed_time) > 5) {
rv = fitdist(df$elapsed_time,"exp")
rv$year = df$sale_year[1]
rv$sample = df$sale_month[1]
rv$granularity = "month"
rv
}
It is basically the data.frame created by fitdist extended to include the
variables used to distinguish one sample from another.
I have the following statement that gets me a set of IDs from my db:
ids <- dbGetQuery(con, "SELECT DISTIN...
2010 Jul 21
0
One problem with RMySQL and a query that returns an empty recordset
...over a few hundred
values for m_id (see the SQL below). Because of the above error, I never
see about two thirds of the results that ought to be produced.
At the time that the error occurs, x contains the following SQL query:
SELECT m_id,sale_date,YEAR(sale_date) AS sale_year,MONTH(sale_date) AS
sale_month,return_type,0.0001 + DATEDIFF(return_date,sale_date) AS
elapsed_time FROM `merchants2`.`risk_input` WHERE m_id = 361 AND return_type
= 1 AND DATEDIFF(return_date,sale_date) IS NOT NULL;
If I execute this SQL, I find the resultset is empty. So assigning the
value returned by dbGetQuery to moreinfo...