GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
21h
answered Understanding dates a plotting with ggplot2 in R
1d
comment How do I zoom in through ggplot2-autoplot with time series data
For dygraphs see: stackoverflow.com/questions/17329875/…
1d
answered How do I zoom in through ggplot2-autoplot with time series data
2d
comment Exponential fitting with R
If a is positive then the right hand side can never equal a negative y and if a is negative then the right hand side can never equal a positive y so this model seems inconsistent with data that has both positive and negative y values as in your data set. Furthermore, one cannot take the log of y since some components of y are negative. Suggest you try a different model if that is indeed your data.
Aug
26
awarded Nice Answer
Aug
26
comment R function does not returns values for date period
SQLite has no date type so when the data frame is sent to SQLite the dates are converted to numbers (no of days since epoch) but then the code in the question is trying to compare those number to character strings. The above answer converts eS and eD to numeric so it is all consistent. Another way to do this is:: query <- fn$identity("select HFRIEMNI from hedge where Date between $sD and $eD") Note that sqldf also supports the H2 database and it does have true dates so this type of problem would not exist if you use that. See the sqldf home page and help files for more info.
Aug
25
revised Function create with sqldf in R
wording
Aug
25
comment difference between timeseries as columns of a matrix in R
Questions to SO should provide sample input, e.g. the output of dput(myInput) or (dput(head(myInput)) if large), and the expected output.
Aug
24
revised Function create with sqldf in R
spacing
Aug
24
comment Unable to execute JDBC statement in sqldf in R
When you load sqldf it will automatically load tcltk. Do not detach it.
Aug
24
comment Function return values for period in R
What you posted is not a csv file.
Aug
24
revised Function create with sqldf in R
trailing } was missing
Aug
24
answered Function create with sqldf in R
Aug
24
comment Function return values for period in R
data.csv is not a csv file so it is not going to work right from the start. The SQL statement is select 1 from ... which is not likely what you want. Maybe other errors too.
Aug
22
revised Unable to execute JDBC statement in sqldf in R
formatting
Aug
22
answered Unable to execute JDBC statement in sqldf in R
Aug
21
revised Plot HH:MM:SS formatted data in R, when HH goes above 24
add image
Aug
20
comment Plot HH:MM:SS formatted data in R, when HH goes above 24
I have added some code for that at the end.
Aug
20
revised Plot HH:MM:SS formatted data in R, when HH goes above 24
add nicer axis
Aug
20
revised Plot HH:MM:SS formatted data in R, when HH goes above 24
added hours
1 2 3 4 5