D&C GLug - Home Page

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

Re: [LUG] csv file editor

 

On Sun, Nov 21, 2010 at 11:20:08AM +0000, Philip Whateley wrote:
> 
> In order to get the data into R/Mondrian/gGobbi etc I need to enter it
> manually. This could be scripted I guess but the script would be complex
> as I need to enter some data by row (for example data points at
> particular factor levels) and some data by columns (for example blocks
> of factors). The main problems for me are a) needing to edit data
> afterwards (adding new columns, etc) and b) ensuring that the data
> entered by row lines up with the correct factors entered earlier by
> column. Certainly using an office package would be easier and more
> efficient than using a script as far as I can see, although a dedicated
> csv / tab delimited data editor would be even better.
> 
In looking at this it sounds like you should be keeping your data in a
database: not a spreadsheet. Once in a database then can add new "columns"
easily enough to subset of the data and merge back into the main database.

Then link R to the database


-- 
Henry
Photocopies or faxes of my signature are not binding. 
This email has been signed with an electronic signature in accordance with 
subsection 7(3) of the Electronic Communications Act 2000.
Digital Key Signature: GPG RSA 0xFB447AA1 
Sun Nov 21 12:46:52 GMT 2010

Attachment: signature.asc
Description: Digital signature

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