Re: [Gretl-users] Data editing questions
On Mon, 16 Aug 2010, Data Analytics Corp. wrote:
I have two questions about editing data:
1. How do I delete observations? If I have 100 observations and I
want to delete, say, the last 10, how do I do this?
Truncate the sample range and save the data.
smpl ; -10
store shorter.gdt
open shorter.gdt
2. When I imported some data from Excel, the first column in the
spreadsheet had labels, say country names. In Gretl, these labels
appear as observation labels instead on 1, 2, 3 ... I'd like to
edit these labels in Gretl, perhaps to fix a misspelling or if I
add an observation to the dataset to change the observation number
to a more descriptive word or to just change the labels from
numbers to words for all the observations. How can I do this?
Go to the entry "Observation markers..." under the main-window
Data menu. If the dataset has markers you have the option of
saving them to a plain text file, which you can then edit. Once
you have the markers as you want them, go back to the "Observation
markers..." item, remove the existing markers, then add the
modified ones. Notice that you must preserve the plain text
quality of the markers file. (A Word doc, for example, is not
going to be any use.)
Allin Cottrell