6:56 a.m.
Could you also add another option under the "dataset" command, e.g.
"dataset deleteobs <parameter>", where e.g. "dataset deleteobs 3, 5,
11-22"
would delete observations 3, 5 and 11-22 from the data set (i.e. from all
variables in the data set) and "dataset deleteobs x>0" would delete all
observations where x>0 from the dataset.
Thanks in advance, and thanks for a great software.
Andreas
cottrell(a)wfu.edu @ INTERNET skrev 2007-10-03 21:20:11 :
On Wed, 3 Oct 2007, andreas.rosenblad(a)ltv.se wrote:
> I would appreciate a gretl command where the values of all >
variables in a data set is sorted in ascending or descending > order
by one of the variables, and one then can save the data > set with
the new sorted ordering.
OK, you now have an additional option under the recently-added
"dataset" command. You can say
dataset sortby <varname>
or
dataset dsortby <varname>
to use descending order. There's a corresponding new GUI menu item
/Data/Sort data...
Allin.
-- Allin Cottrell
Department of Economics
Wake Forest University, NC
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-devel
7:21 a.m.
On Thu, 4 Oct 2007, andreas.rosenblad(a)ltv.se wrote:
Could you also add another option under the "dataset"
command, e.g.
"dataset deleteobs <parameter>", where e.g. "dataset deleteobs 3, 5,
11-22"
would delete observations 3, 5 and 11-22 from the data set (i.e. from all
variables in the data set) and "dataset deleteobs x>0" would delete all
observations where x>0 from the dataset.
This is an excellent idea IMO. In fact, it would be nice to make this a
little more systematic. What I have in mind is a rough equivalent of
Stata's "drop" and "keep" commands.
How would you like something like the following?
dataset <subcommand> <argument>
where <subcommand> could be either "delete", "keep",
"deleteobs" or
"keepobs". The first two refer to variables (columns) and have a list as
the argument, the last two to observations (rows) and the argument follows
the same conventions we now use for the "smpl" command (with all the
caveats when applied to a time-series dataset).
By the way, this change would make obsolete the current "delete" command,
which is a bad thing in the short term because of backward compatibility
needs, but good in the long term because the less reserved words we have,
the better.
Comments?
Riccardo (Jack) Lucchetti
Dipartimento di Economia
Università Politecnica delle Marche
r.lucchetti(a)univpm.it
http://www.econ.univpm.it/lucchetti
8:07 a.m.
New subject: Regarding the dataset command (Was: Feature requestfor sorting of variables)
On Thursday 04 October 2007 08:56:23 andreas.rosenblad(a)ltv.se wrote:
Could you also add another option under the "dataset"
command, e.g.
"dataset deleteobs <parameter>", where e.g. "dataset deleteobs 3, 5,
11-22"
would delete observations 3, 5 and 11-22 from the data set (i.e. from all
variables in the data set) and "dataset deleteobs x>0" would delete all
observations where x>0 from the dataset.
I think the 'smpl' command maybe used in the form you need. For example,
to work with all observations except 3,5 and 11-22 you may use
smpl (obs<11 || obs>22) && obs!=3 && obs!=5 --restrict
--
Ignacio Diaz-Emparanza
DEPARTAMENTO DE ECONOMÍA APLICADA III (ECONOMETRÍA Y ESTADÍSTICA)
UPV/EHU
Avda. Lehendakari Aguirre, 83 | 48015 BILBAO
T.: +34 946013732 | F.: +34 946013754
www.et.bs.ehu.es
1:25 p.m.
On Thu, 4 Oct 2007, Riccardo (Jack) Lucchetti wrote:
How would you like something like the following?
dataset <subcommand> <argument>
where <subcommand> could be either "delete", "keep",
"deleteobs"
or "keepobs". The first two refer to variables (columns) and
have a list as the argument, the last two to observations (rows)
and the argument follows the same conventions we now use for the
"smpl" command (with all the caveats when applied to a
time-series dataset).
I quite like the "keep" idea (handy if you have a dataset
containing a lot of "junk"), and I also like the idea of moving
"delete" (for variables) into place under the "dataset" command.
The old "delete" command could be kept as an alias, at least for a
while.
As for deleteobs and keepobs, these seem to me somewhat
redundant given the smpl command and the ability to save the
dataset.
Allin.
2:14 p.m.
On Thu, 4 Oct 2007, Allin Cottrell wrote:
On Thu, 4 Oct 2007, Riccardo (Jack) Lucchetti wrote:
> How would you like something like the following?
>
> dataset <subcommand> <argument>
>
> where <subcommand> could be either "delete", "keep",
"deleteobs"
> or "keepobs". The first two refer to variables (columns) and
> have a list as the argument, the last two to observations (rows)
> and the argument follows the same conventions we now use for the
> "smpl" command (with all the caveats when applied to a
> time-series dataset).
I quite like the "keep" idea (handy if you have a dataset
containing a lot of "junk"), and I also like the idea of moving
"delete" (for variables) into place under the "dataset" command.
The old "delete" command could be kept as an alias, at least for a
while.
As for deleteobs and keepobs, these seem to me somewhat
redundant given the smpl command and the ability to save the
dataset.
Ok. Deal?
Riccardo (Jack) Lucchetti
Dipartimento di Economia
Università Politecnica delle Marche
r.lucchetti(a)univpm.it
http://www.econ.univpm.it/lucchetti
3:44 p.m.
On Thu, 4 Oct 2007, Riccardo (Jack) Lucchetti wrote:
On Thu, 4 Oct 2007, Allin Cottrell wrote:
> I quite like the "keep" idea (handy if you have a dataset
> containing a lot of "junk"), and I also like the idea of moving
> "delete" (for variables) into place under the "dataset"
command.
>
> The old "delete" command could be kept as an alias, at least for a
> while.
>
> As for deleteobs and keepobs, these seem to me somewhat
> redundant given the smpl command and the ability to save the
> dataset.
Ok. Deal?
In principle ;-) But adding list-parsing to the dataset command
is not trivial and might break things. And "delete" can also be
used for matrices. So I think I'll not attempt this right now;
probably after the next release.
Allin.
4:07 p.m.
On Thu, 4 Oct 2007, Allin Cottrell wrote:
>
> Ok. Deal?
In principle ;-) But adding list-parsing to the dataset command
is not trivial and might break things. And "delete" can also be
used for matrices. So I think I'll not attempt this right now;
probably after the next release.
Fine by me.
Riccardo (Jack) Lucchetti
Dipartimento di Economia
Università Politecnica delle Marche
r.lucchetti(a)univpm.it
http://www.econ.univpm.it/lucchetti
6050
days inactive
6050
days old
6 comments
4 participants
participants (4)
-
Allin Cottrell -
andreas.rosenblad＠ltv.se -
Ignacio Diaz-Emparanza -
Riccardo (Jack) Lucchetti