similar to: Separating columns, and sorting by rows

This is the very last thing I need to make everything work properly. My query: sqlQuery(conn, "select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from mo_rains where stn_num=023000") Is there a way to may the stn_num in the query variable, ie make it so that whenever my script is run, the user must choose and input the station number? Cheers. -- View this message in context:

Hi, Given a date, how do I get the last date of that month? I have data in the form YYYYMM, that I've read as a date using > x$Date <- as.Date(ISOdate(substr(x$YearEnd,1,4),substr(x$YearEnd,5,6),1)) But this gives the first day of the month. To get the last day of the month, I tried > as.Date(as.yearmon(x$Date,frac=0)) But I don't get the last day of the month here. (Tried

Dear R experts, I have a dataframe imported from a csv file (with read.csv). Here is an example: yyyymm<- c("19860228", "19860331","19860430","19860531") id<-c("10000","10000","10000","10000") re<- c("C","0.25", "0.98", "1.34") mret<-data.frame(yyyymm, id, re)

I need to merge three datasets and don't know how. If I were using SQL, I would use df3, look up the characteristics of each date in df1 and the value for each observation in df2. df1 - unique list of Dates and characteristics of those dates Date, YYYYMM, YYYYWW, DOW df2 - the raw data Date, Place, Value df3 - all posibile combinations of Date + Place (via

Dear R experts, For quite some time I have been trying to solve a mistery of reading a seemingly trouble-free text file. The data is temperature reconstruction arranged as a huge grid, preceded by seven "header lines" (which you see better if file is opened in Firefox or Chrome). This is the data (gridded temperature reconstruction)

Hello all. I am a novice Ruby on Rails programmer, starting my first project using a legacy Oracle 10 database. Using ''reverse_scaffold'' I have created the models/controllers/views for my existing Oracle tables. All seems to work well, using /model/index, /model/show for most of my tables, *except* when one of the tables contains a Oracle ''date'' column, for

I''m just looking into how to connect to Oracle using Rails. I''ve got everything connecting and working as it should. I have a Users table in Oracle: create_table "users", :force => true do |t| t.column "username", :string t.column "created_on", :datetime t.column "email", :string t.column "note", :text

Hi, after some experience with Rails on MySQL databases I gave it a try on one of our larger Oracle database. I was facing a problem when Rails tried to detect the columns for a model/table. The appropriate statement ran about 1 min which led to a timeout. Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t helped, he said the only remaining chance is to use a

netfilter and lartc members I just thought it''s time I contribute. I created this little script to help me while setting up iptables rules for firewalling, shaping or both. I hope this helps someone. Called tableview.sh, inspired by Table Mountain, Cape Town, ZA :) --- SOF ---- #!/bin/sh # ____ # /\/ \/\ # /__________\ # # Simple loop for keeping track of what is happening in

I have a vector that contains month and year in the format YYYYMM (e.g.“200701”, “200702”) I wish to do to things: 1. I need to convert to a date that is the last calendar day of each month. 2. I need to convert this to a date that is the last U.S. stock-exchange trading day of each month. Any advice is appreciated, mymonths <- c(200701, 200702)

http://bugzilla.netfilter.org/show_bug.cgi?id=631 Summary: Unable to zero packet and byte count for policy. Product: iptables Version: 1.3.5 Platform: i386 OS/Version: RedHat Linux Status: NEW Severity: enhancement Priority: P1 Component: iptables AssignedTo: netfilter-buglog at lists.netfilter.org

Hola a todos, Tengo un problema con RStudio y la conexión a una base de datos. Desde la terminal no tengo problemas para ejecutar, por ejemplo: library(RODBC) channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd = "MiContrasena") datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \ , M.STODNR \ ... ... ...") pero desde

I am trying to determine the root of an issue I am having. How can I watch traffic destined to a specific port on my CentOS 5.1 box to see if its even hitting it? It would be udp traffic. Thanks! jlc -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080520/d5066957/attachment-0005.html>

Hello, my current network setup looks like the following: dom2-eth0 (172.30.1.22) netmask /24 | | xen-br1 (no ip) | dom1-eth0 (172.30.1.21) netmask /24 dom1-eth1 (172.30.0.21) netmask /24 | | xen-br10 (172.30.0.1) netmask /24 | dom0 | | xen-br0 (normal IP) | eth0 (same IP as xen-br0) |

Folks, This question is somewhat related to a previous posting of mine. I just can't seem to create a generic solution. Here is a function that I found searching around the internet: splitIt <- function(x, n) {split(x, sort(rank(x) %% n))} I use it like so: > splitIt(1:12, 2) $`0` [1] 1 2 3 4 5 6 $`1` [1] 7 8 9 10 11 12 Or > splitIt(1:12, 4) $`0` [1] 1 2 3 $`1` [1] 4 5 6

FYI, looks like support for Racoon is ending. Does anyone have any experience with the version in ipsec-tools ? ---Mike >Racoon users, > >This is the announcement that the kame project will quit providing >a key management daemon, the racoon, and that "ipsec-tools" will become >the formal team to release the racoon. >The final release of the racoon in the

Hi, please Cc: all replies, I'm not subscribed I seem to have troubles with my Linux bridge (2.6.8-rc2), which is apparently not bridging UDP fragments (NFS) when passing packets through iptables, but I do not see in the iptables stats where the packets are dropped. Policies for INPUT, FORWARD, OUTPUT are all "ACCEPT", and I grepped for all REJECT and DROP rules in iptables -nvL,

Hi?guys. There is a wierd problem with iptables recently, hopes somebody can help me. I have installed Centos 7.2.1511 on a bare metal Dell server these days, disabled firewalld and enabled iptables.services, and setup a group of very simple rules, as the following: # iptables-save # Generated by iptables-save v1.4.21 on Tue Apr 23 09:15:14 2019 *filter :INPUT ACCEPT [0:0] :FORWARD ACCEPT

Hi, anyone can help me? I have 2 model : Error and Error Detail Error: Error_name, tot_errors Error Detail: Error_name , details for error e.g. Error = Error_type1 | 5 Error Detail = 5 lines with Error_name=Error_type1 I want to show this: --------------------------------------------------------------------- Error_type1 | 5 | Show Error Detail Link

No, no estoy usando Rstudio Server El 1 de abril de 2014, 9:07, Carlos J. Gil Bellosta <cgb@datanalytics.com>escribió: > Una pregunta... no estarás utilizando RStudio server, ¿verdad? > > En tal caso, lo que tienes que hacer es configurar > /etc/rstudio/rstudio.conf tal como indica en > > http://www.rstudio.com/ide/docs/server/configuration > > En particular,