similar to: Windows-Application can't handle .dbf- Files correctly

good morning This question is not a stats question per say but a data management and lattice plotting problem. I apologize now if I'm asking an inappropriate question to this gracious group. I'm need to bring in approximately 100 *.dbf files into R but I'm having difficultly understanding several examples I've tracked down regarding this procedure and could benefit from your

Dear UseRs, I did not have any answer to my previous message ("Is there a way to define "manually" columns width when using write.dbf function from the library foreign ?"), so I tried to modify write.dbf function to do what I want. Here is my modified version : write.dbfMODIF <- function (dataframe, file, factor2char = TRUE, max_nchar = 254, width = d) {

Hi, I'm having difficulty with getting a table to show with multiple rows and columns. Below is the commands that I've typed in and errors that I am getting. Thank you. Laura Table trying to enter: Diet: Binger-yes: Binger-No: Total: None 24 134 158 Healthy 9 52 61 Unhealthy 23 72 95 Dangerous 12 15 27 >

Otras variantes con y sin paquetes adicionales... > sapply(split(datIn$Gain, as.factor(datIn$Diet)), mean) d1 d2 d3 280 278 312 > by(datIn$Gain, datIn$Diet, mean) datIn$Diet: d1 [1] 280 -------------------------------------------------------------- datIn$Diet: d2 [1] 278 -------------------------------------------------------------- datIn$Diet: d3 [1] 312 > > library(dplyr) >

Me gusta la respuesta uqe has dado, pero si por ejemplo, alguno de los datos tiene datos faltantes, entonces devuelve NA. He probado con: sapply(split(datos$uno, as.factor(datos$dos)), mean(na.rm=TRUE)) pero da fallo. ¿Cómo se podría hacer para que devolviera además la media obviando los NA y que contara el numero de NA por categoria? > Date: Wed, 28 Oct 2015 00:13:45 +0100 > From: cof

Hello.. I am currently working on running random forest to make predictions. For that I have a bunch of .dbf files from shapefiiles. Earlier I was running random forest on those dbf files individually but now I have >1,000 such files and procesisng one by one is not an option. I started by trying to read multiple dbf files as: >setwd (..) >a=list.files() > for (x in

Estimados Cuando existia epicalc, había una manera muy fácil de determinar la media de una variable (en esta caso Gain) por grupos, en este caso (Diet). ?Como se puede hacer ahora? Diet Gain 1 d1 270 2 d1 300 3 d1 280 4 d1 280 5 d1 270 6 d2 290 7 d2 250 8 d2 280 9 d2 290 10 d2 280 11 d3 290 12 d3 340 13 d3 330 14 d3 300 15 d3 300

Hello Arnaud, You posted this question a long long time ago, however I found your answer so I decided to post it anyway in case somebody else have the same problem as you and me. You were actually very close in finding your solution. The function DoWritedbf is an internal function from the foreign package. To access it outside of the package just do: foreign:::DoWritedbf so in your line:

Hello, I'm newbie in R and I have a problem exporting a table with many columns to a dbf file. I found an error when I open the result DBF file on other software and also importing it on R again. Here a example snippet of the problem (on a GNU/Linux OS): http://pastebin.com/0SMJqqwb Is it a bug? Thank you, Nacho V [[alternative HTML version deleted]]

Dear all, This question may be too basic quesition for this list, but if someone has time to answer I will be happy. I have tried to find out, but haven't found a consice answer. As an example I use "Pinheiro, J. C. & Bates, D. M. 2000. Mixed-effects models in S and S-PLUS. Springer, New York." page 225, where rats are fed by 3 different diets over time, which body mass has

I have a heavy DATA saved in dbf format. What I want is to bring that data to R with SQL statements. Like: I want columns 1, 4, 5 and only when column 4 > 30. Sorry asking it here instead of keep searching in manuals, but it seems that there are too many ways of doing it. So what's the appropriate package that I need to work it, considering also that im dealing with lots of gigas so the

Hello This is Elaine. I am using package lattice to generate boxplots. Using Richard's code, the display was almost perfect except the outlier shape. Based on the following code, the outliers are vertical lines. However, I want the outliers to be empty circles. Please kindly help how to modify the code to change the outlier shapes. Thank you. code package (lattice) dataN <-

Hi there, This is summary and patch for a bug in read.dbf, demonstrating in Message-Id: <20050818150446.697835cb.stanimura-ngs at umin.ac.jp>. After consulting Rjpwiki, a cyber-community of R user in Japan, the cause was found, and the patch of solution was proposed. Overflowing occurs when we use read.dbf for reading a dbf file having a field of longer signed integer. For example, $

Hi - I need to export data to openoffice base, where one of the elements is a long character vector (>255 characters.) write.dbf exports it as varchar, truncating the data. Any idea how to do this? thanks, -eduardo

Hi I know that it is very easy to import data from a dbf file to R, by saving the data as csv, for instance. However, I have several hundreds of files to do that. So, I thought of using RODBC to read the dbf files and save it as data.frame. However, I cannot even start (this is my first time using such package): > library(RODBC) > bdades <- odbcConnect("prova.DBF") Warning

Hi, In the examples from the ReShape package there is a simple example of using melt followed by cast that produces a smallish amount of output about the chicks database. Here's the code: library(reshape) names(ChickWeight) <- tolower(names(ChickWeight)) chick_m <- melt(ChickWeight, id=2:4, na.rm=TRUE) DietResults <- cast(chick_m, diet + chick ~ time) DietResults My challenge

Hello. I am trying to acces to a software in a network, from a terminal. This terminal works on Windows, so I use Wine. I could execute the software, but some errors appear. It seams that it couldn't create in the right way the indexes in the data base (.dbf and cdx files). I think that the software was programed with Visual Fox Pro (but I am not sure) I will appreciate yours comments and

Hi, I have these BMIMS .dbf/.cdx/.fpt files. I have no longer BMIMS. I would like to transfers theses files to another visible format. I tried opening them with Monarch 4.0, but it does not give me a proper format. what do i do? thankx

Hi to everyone, Since last week I am trying to fix following problem: I have a DOS application, operating on DBF databases. I've set up a Samba 3.0.14a-2 server running as a PDC on Fedora Core 4 (in fact, Samba server was a part of FC4 distribution). I've set up a share and then I've moved all data for this application on to that share. The problem is that the application hangs

Hi List, I wanted to provide the solution that proved to fix this problem. On this particular server I observed we had consumed all memory resources and were using a decent sized swap file. After installing more RAM the problem & symptoms have disappeared. FINALLY I have happy users. L. Kipp From: wikked1@hotmail.com To: samba@lists.samba.org Subject: Fox Pro DBF open problems Date: