daily pastebin goal
1%
SHARE
TWEET

Untitled

a guest Jan 22nd, 2019 94 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. library(RPostgreSQL)
  2. drv <- dbDriver("PostgreSQL")
  3. con <- dbConnect(drv, host="127.0.0.1",
  4. port=5432, dbname="postgres",user="postgres",
  5. password="shaggy")
  6. rs <- dbSendQuery(con,"select * from pmoy.data5min2010")
  7. data<-fetch(rs,n=-1)
  8.    
  9. data<-fetch(rs,n=-1)
  10.    
  11. det_id          time_stamp dayoftheweek idx_5min   speed    volume
  12. 3  401911 2010-08-11 05:00:00            3       60 63.7924  899.0000
  13. 4  400674 2010-08-11 05:00:00            3       60 63.6771 1311.0000
  14. 5  314853 2010-08-11 05:00:00            3       60 63.9762 1019.0000
  15. 6  400673 2010-08-11 05:00:00            3       60 64.4692  532.3333
  16. 7  401913 2010-08-11 05:00:00            3       60 64.1504  848.5000
  17. 8  401177 2010-08-11 05:00:00            3       60 64.2814 1259.0000
  18. 9  401914 2010-08-11 05:00:00            3       60 64.2291  771.5000
  19. 10 401178 2010-08-11 05:00:00            3       60 64.3218  679.0000
  20. 11 401362 2010-08-11 05:00:00            3       60 56.1178 1532.3333
  21. 12 401557 2010-08-11 05:00:00            3       60 55.7901 1721.3333
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top