D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] csv file editor

 

On Sat, 2010-11-20 at 11:15 +0000, tom wrote: 
> On 19/11/10 14:22, Philip Whateley wrote:
> > Anyone know of a good editor for delimited text data files (csv, tab
> > delimited etc.)
> >
> > I need it for directly creating data files for R. I can export from a
> > spreadsheet but that is cumbersome.
> >
> > I am aware that CSVed - which would be exactly what I am looking for -
> > will run under Wine, and I think there is a mode for emacs (although
> > only beta), but I'm looking for something native Linux (unlike CSVed)
> > and easy to learn (unlike emacs)
> >
> > I have looked at google-refine, but that won't create files, although it
> > looks very good for correcting data errors.
> >
> > I am happy with either gui or command line.
> >
> > Many thanks
> >
> > Phil
> >
> >
> >    
> Can I inquire as to how the data is generated?
> Tom te tom te tom
> 
The data is either marketing data from small surveys, or industrial
process control data. In either case the data is collected manually and
entered from paper reports.

There is no option to collect the data electronically at source.

The marketing data is a mixture of numeric, categorical and ordinal
categorical data. The process control data is mainly numeric. I also
analyse data from designed experiments, but that is usually small enough
and static enough to enter directly into a data frame in R. Categorical
data I usually analyse using a mixture of R and Mondrian.

Phil


-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq