12:14 p.m.
Dear gretl community,
I am using gretl and, recently, a number of issues came up when I was preparing a
cross-sectional dataset for analysis. Specifically:
(1) Within gretl, is it possible to change the ordering of variables, and keep i.e. save
this changed ordering? E.g. is it possible, in a dataset with 10 variables, to assign the
variable which currently has the ID no. 7 another ID, e.g. the ID no. 2? I am asking
because I often use gretl to "push" datasets into R, and it is convenient to
have them ordered as desired when they appear in R already.
(2) Within gretl, suppose a dataset contains observation labels e.g. company names. Is it
possible to remove all observation labels from the dataset so that there are none?
(3) Finally, I would like to standardize the regressors (not the dependent variable) in my
dataset, such that each regressor has mean 0 and standard deviation of 1. Is there a
"summary way" to do this e.g. by declaring the dataset to be a matrix, then
operating on this matrix using some matrix operators?
Could anyone provide an idea how to resolve these issues,
please? I'd appreciate this a lot.
Thank you very much.
Kind regards
Beek
1:15 p.m.
Dear gretl community,
I am using gretl
great! welcome!
(1) Within gretl, is it possible to change the ordering of
variables, and keep i.e. save this changed ordering?
Yes, through the
"Variable-> edit attribute" menu (or right-click on the
variable) and change the ID number.
(2) Within gretl, suppose a dataset contains observation labels e.g.
company names. Is it possible to remove all observation labels from the dataset so that
there are none?
Mmmm, can you try the "Data -> Observation markers"
menu? I know there's
a similar stuff to add/remove the variables labels (the "Data->
Variables labesl" menu) but never tried with observations'.
(3) Finally, I would like to standardize the regressors (not the
dependent variable) in my dataset, such that each regressor has mean 0 and standard
deviation of 1. Is there a "summary way" to do this e.g. by declaring the
dataset to be a matrix, then operating on this matrix using some matrix operators?
I
guess you could do this by using the "meanc" and "sdc" commands.
Could anyone provide an idea how to resolve these issues,
please? I'd appreciate this a lot.
Hope it helps,
Artur
1:30 p.m.
> (3) Finally, I would like to standardize the regressors (not the dependent variable)
in my dataset, such that each regressor has mean 0 and standard deviation of 1. Is there a
"summary way" to do this e.g. by declaring the dataset to be a matrix, then
operating on this matrix using some matrix operators?
I guess you could do this by using the "meanc" and "sdc" commands.
Or, better try the following script
<hansl>
open australia.gdt
matrix my_std_matrix = {}
loop foreach i PAU..IUS
mymean = mean($i)
mysd = sd($i)
my_std_series = ($i - mymean)/mysd
my_std_matrix = my_std_matrix ~ {my_std_series}
endloop
3:08 p.m.
Hi,
since hansl is a very userfriendly language u can even shorten the code
by using
my_std_matrix ~= {my_std_series}
Cheers
Am 16.04.2013 15:30, schrieb artur bala:
>
>> (3) Finally, I would like to standardize the regressors (not the dependent
variable) in my dataset, such that each regressor has mean 0 and standard deviation of 1.
Is there a "summary way" to do this e.g. by declaring the dataset to be a
matrix, then operating on this matrix using some matrix operators?
> I guess you could do this by using the "meanc" and "sdc"
commands.
Or, better try the following script
<hansl>
open australia.gdt
matrix my_std_matrix = {}
loop foreach i PAU..IUS
mymean = mean($i)
mysd = sd($i)
my_std_series = ($i - mymean)/mysd
my_std_matrix = my_std_matrix ~ {my_std_series}
endloop
_______________________________________________
Gretl-users mailing list
Gretl-users(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-users
1:26 p.m.
On Tue, 16 Apr 2013, Beek Pang wrote:
I am using gretl and, recently, a number of issues came up
when I was preparing a cross-sectional dataset for analysis.
Specifically:
(1) Within gretl, is it possible to change the ordering of
variables, and keep i.e. save this changed ordering? E.g. is
it possible, in a dataset with 10 variables, to assign the
variable which currently has the ID no. 7 another ID, e.g.
the ID no. 2?
In the GUI program, you can select a series in the main
window, right-click and select "Edit attributes" (or just
press "e"). In the dialog box that appears there's a control
for changing the ID number of the series; this will change
its position in the ordering. Alternatively you can use the
"store" command to save the dataset with a different ordering
of the variables, then re-open the data. The order in which
series are given to "store" is respected in the data save.
(2) Within gretl, suppose a dataset contains observation
labels e.g. company names. Is it possible to remove all
observation labels from the dataset so that there are none?
In the GUI: /Data/Observation markers and select "Remove the
markers". Via CLI: "markers --delete". Also see the --omit-obs
option to the "store" command.
(3) Finally, I would like to standardize the regressors (not
the dependent variable) in my dataset, such that each
regressor has mean 0 and standard deviation of 1. Is there a
"summary way" to do this e.g. by declaring the dataset to be
a matrix, then operating on this matrix using some matrix
operators?
Using a list and a loop is probably the easiest way. (In the
example below ENROLL is taken to be the dependent variable.)
<hansl>
open data4-10
list L = dataset - ENROLL
print L --byobs
loop foreach i L
$i = ($i - mean($i))/sd($i)
endloop
print L --byobs
</hansl>
But doing the transformation using a matrix is also possible
<hansl>
open data4-10
list L = dataset - ENROLL
matrix X = {L}
X = (X .- meanc(X)) ./ sdc(X)
loop foreach i L
$i = X[,i]
endloop
print L --byobs
</hansl>
Allin Cottrell
4299
days inactive
4299
days old
4 comments
4 participants
participants (4)
-
Allin Cottrell -
artur bala -
Beek Pang -
Pindar