search for: peteoutside

List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to send select queries to the db, put the results in a data frame, and so forth. Today, dbDriver() threw an error: > dbDriver(MySQL) Error in function (classes, fdef, mtable) : unable to find an inherited method for

Hello List, I am working on creating periodograms from IP network traffic logs using the Fast Fourier Transform. The FFT requires all the data points to be evenly-spaced in the time domain (constant delta-T), so I have a step where I zero-pad the data. Lately I've been wondering if there is a faster way to do this. Here's what I've got: * data1 is a data frame consisting of

Greetings all, I'm working on a project trying to apply fourier analysis to timestamped router logs, using R to perform the analysis. The idea is to determine if any type of traffic (say, outgoing ICMP requests) has strong periodic features because it may indicate a compromise somewhere on the network. The FFT requires all data points to be evenly spaced, but the recorded events do not

Hello list, I have two data frames, X (48469,2) and Y (79771,5). X[,1] contains distinct values of Y[,2]. I want to match values in X[,1] and Y[,2], then take the corresponding value in [X,2] and place it in Y[,4]. So far I have been doing it like so: for(i in 1:48469) { y[which(x[i,1]==y[,3]),4]<-x[i,2] } But it chunks along so very slowly that I can't help but wonder if there's a

Greetings all, I am using Fourier analysis to search for periodicities in IP network traffic by generating periodograms and then visually examining them for large, distinct peaks. However, in many cases it is not readily apparent where there are periodicities. I have no experience with discrete maths so I've come up against a block here: How do I define what the "noise floor"

List, I am trying to apply some digital signal analysis methods to IPv4 networks. Specifically, I have had some success using the Fast Fourier Transform in R to find periodic events in IPv4 network traffic by producing periodograms. I store network traffic in a mysql database so I have been using RMySQL to generate a data frame of [timestamp,events] (the FFT is run on the vector of events).

Hello all, I have a population of 112 servers that are experiencing different levels of packet loss. I don't want to poll all 112 of them (the analytical tools must be manually run on each individually) so it seems best to sample among them; then I plan on using R to run comparisons of the data pulled from each one. I'm not clear on the most sound way to go about this and I don't

R List, I'm writing a tcl/tk gui tool to wrap around RMySQL for some co-workers. One function is to be able to add, modify, and remove entries to my.cnf, which is where RMySQL stores database connection information in the following format: [connection_name] # comment user = $username password = $password host = $hostname_or_ip database = $which_database_to_use I'm seeking advice as to

List, I just left an environment where I was running R and mysql on CENTOS. At the time of install, RMySQL was available on CRAN. Later installs on Ubuntu were possible because it was available as a package in the base repos. Now I'm in a new environment where I have no choice but to use Windows XP. I have just installed R 2.4.1 and MySQL 5.0.27. The installation instructions for getting

List, I am attempting to install RMySQL on a Kubuntu box. mysql and R were installed using the adept package manager: "apt-get install mysql-server" "apt-get install r-base" I can access mysql via the terminal and I can open R and perform various basic tasks. However, I cannot install the RMySQL package in R. I get the following error: * Installing *source*

Folks, I'm writing a gui wrapper around RODBC (having abandoned RMySQL) and some custom analysis scripts. I'm hoping that I could get some advice. All of my users will have access to a database server. I am going to limit their access to certain databases--a sizeable warehouse in a SAN, and then smaller storage that they can use for temp files and personal tables. I want to present