search for: usercount

...group of machines"? I'm not quite sure how to scale the data frame and analysis to summarize multiple hosts, though. I'm still getting a feel for using R. Here is a snippet of data for one host. the user_count column is generated from the users column using my custom function "usercount()". the samples are taken roughly once per minute and only unique samples are recorded. (i.e. use na.locf() to uncompress the data). Samples may occur twice in the same minute and are rarely aligned on the same time. Here is the original data before I turn t into a zoo series and run na.l...

...to copy a data.frame of 44 columns to a table of 45 columns (the 45th is an autoincremental column). With the following commands, colnames(df)<- a vector with the names of the 44 columns ch<-odbcDriverConnect(connection="SERVER=localhost;DRIVER=MySQL ODBC 5.1 Driver;DATABASE=my_db;UID=usercount;PWD=my_pwd;case=tolower") sqlSave(ch,my_df, "my_table", append = TRUE, rownames = FALSE, fast=FALSE) odbcClose(ch) I got the following message (in french, sorry): Erreur dans dimnames(x) <- dn : la longueur de 'dimnames' [2] n'est pas ?gale ? l'?tendue du tablea...