8:13 p.m.
Hello,
I need a function the tests if variable is in an array (sorry for the poor wording of this
sentence). What I mean by this is a function that compares each element of an array to a
variable and returns 0 if no elements of the array are equal and the position in the array
of the first instance of equality. So here are my question:
1. Dose such a function exist? (I haven't found one, but I thought I should ask)
2. If not, coding it up is no problem, but I need a way to check the data type of
variable. Is there such a command?
3. Is there a way, other than using a bundle, to pass a variable of unknown data type to a
function?
Thanks,
Logan
8:18 p.m.
Do you mean something like:
# Replace NANs in matrix by zeros
M = isnan(M) ? 0 : M
# Replace zeros in matrix OUT by 999
M = OUT ? OUT : 999
# Check for conditions and replace zero by 1 if the condition v .< x is
met (x and v are both matrices)
mtmp = {}
mtmp = (v .< x)
Artur
On 25.11.2014 21:13, Logan Kelly wrote:
Hello,
I need a function the tests if variable is in an array (sorry for the
poor wording of this sentence). What I mean by this is a function that
compares each element of an array to a variable and returns 0 if no
elements of the array are equal and the position in the array of the
first instance of equality. So here are my question:
1. Dose such a function exist? (I haven’t found one, but I thought I
should ask)
2. If not, coding it up is no problem, but I need a way to check the
data type of variable. Is there such a command?
3. Is there a way, other than using a bundle, to pass a variable of
unknown data type to a function?
Thanks,
Logan
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-devel
8:35 p.m.
I don't think so. But let me give an example.
Let's say x is an array of strings and y is a string, I would like to have the
function return zero if x doesn't contains an element equal to y and the position in
the array if an element equals y.
This is easy if you know the data type ahead of time, but it would be neet if the function
could check that for itself. that way one function works for all data types that can be
stored in an array.
Artur,
What you are suggesting is fine for a matrix, but I was thinking about other data types?
Logan
Sent from my T-Mobile 4G LTE Device
-------- Original message --------
From: "Artur T." <artur.tarassow(a)googlemail.com>
Date:11/25/2014 2:18 PM (GMT-06:00)
To: gretl-devel(a)lists.wfu.edu
Cc:
Subject: Re: [Gretl-devel] is there an inarray function?
Do you mean something like:
# Replace NANs in matrix by zeros
M = isnan(M) ? 0 : M
# Replace zeros in matrix OUT by 999
M = OUT ? OUT : 999
# Check for conditions and replace zero by 1 if the condition v .< x is met (x and v
are both matrices)
mtmp = {}
mtmp = (v .< x)
Artur
On 25.11.2014 21:13, Logan Kelly wrote:
Hello,
I need a function the tests if variable is in an array (sorry for the poor wording of this
sentence). What I mean by this is a function that compares each element of an array to a
variable and returns 0 if no elements of the array are equal and the position in the array
of the first instance of equality. So here are my question:
1. Dose such a function exist? (I haven’t found one, but I thought I should ask)
2. If not, coding it up is no problem, but I need a way to check the data type of
variable. Is there such a command?
3. Is there a way, other than using a bundle, to pass a variable of unknown data type to a
function?
Thanks,
Logan
_______________________________________________
Gretl-devel mailing list
Gretl-devel@lists.wfu.edu<mailto:Gretl-devel@lists.wfu.edu>
http://lists.wfu.edu/mailman/listinfo/gretl-devel
9:28 p.m.
On Tue, 25 Nov 2014, Logan Kelly wrote:
I need a function the tests if variable is in an array (sorry for
the poor wording of this sentence). What I mean by this is a
function that compares each element of an array to a variable and
returns 0 if no elements of the array are equal and the position
in the array of the first instance of equality. So here are my
question:
1. Dose such a function exist? (I haven't found one, but I
thought I should ask)
No.
2. If not, coding it up is no problem, but I need a way to check
the data type of variable. Is there such a command?
Well, there's actually a "hidden" function typeof(), which returns
the same code numbers as inbundle(). I started documenting it after
reading your posting but on second thoughts I'm not sure we really
want to do that in its present state. Returning a "magic" integer
code is not very nice at all: if we need such a function we'd be
better off defining symbolic constants SCALAR, SERIES, MATRIX and so
on. Then you could do
if typeof(foo) == SERIES
...
endif
where you'd now have to do
if typestr(typeof(foo)) == "series"
...
endif
Documenting the latter would be giving a hostage to backward
compatibility. Moreover, I'm not sure that going very far in this
direction ("introspection") is something we want to do with hansl,
though I'm open to discussion of the point.
3. Is there a way, other than using a bundle, to pass a variable
of unknown data type to a function?
No. All arguments to user-defined functions must be of a definite,
specified type (though they may be optional).
More generally, could you give us an idea of why you need this sort
of thing? I suspect there may be another way of doing whatever it is
you're trying to do.
Allin
4:06 p.m.
Allin,
Sorry for the delay in my response. Thanksgiving, family and all that :-)
Generally, I want to create an array of strings form a text file, but I want to check for
duplicates. That is easy enough to do, but I got to thinking it might be nice to have a
function that could work with all array types (so I decided to give it a try). However, I
don't think that it can be done with hansl. A separate function for each data type
would be needed because to make a single function for all types the function would not
know the data types of the arguments ahead of time.
More generally, I am working on a project that can turn a gretl data set into a flat
file.
Thanks,
Logan
-----Original Message-----
From: gretl-devel-bounces(a)lists.wfu.edu [mailto:gretl-devel-
bounces(a)lists.wfu.edu] On Behalf Of Allin Cottrell
Sent: Wednesday, November 26, 2014 3:29 PM
To: Gretl development
Subject: Re: [Gretl-devel] is there an inarray function?
On Tue, 25 Nov 2014, Logan Kelly wrote:
> I need a function the tests if variable is in an array (sorry for the
> poor wording of this sentence). What I mean by this is a function that
> compares each element of an array to a variable and returns 0 if no
> elements of the array are equal and the position in the array of the
> first instance of equality. So here are my
> question:
>
> 1. Dose such a function exist? (I haven't found one, but I
> thought I should ask)
No.
> 2. If not, coding it up is no problem, but I need a way to check
> the data type of variable. Is there such a command?
Well, there's actually a "hidden" function typeof(), which returns the
same
code numbers as inbundle(). I started documenting it after reading your
posting but on second thoughts I'm not sure we really want to do that in its
present state. Returning a "magic" integer code is not very nice at all: if we
need such a function we'd be better off defining symbolic constants SCALAR,
SERIES, MATRIX and so on. Then you could do
if typeof(foo) == SERIES
...
endif
where you'd now have to do
if typestr(typeof(foo)) == "series"
...
endif
Documenting the latter would be giving a hostage to backward compatibility.
Moreover, I'm not sure that going very far in this direction
("introspection") is
something we want to do with hansl, though I'm open to discussion of the
point.
> 3. Is there a way, other than using a bundle, to pass a variable
> of unknown data type to a function?
No. All arguments to user-defined functions must be of a definite, specified
type (though they may be optional).
More generally, could you give us an idea of why you need this sort of thing?
I suspect there may be another way of doing whatever it is you're trying to
do.
Allin
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-devel
4:23 p.m.
Yes, I am going to output to a csv file, but it is time series data that is trying very
hard to be panel. I am working with regional data (at the State and County level) for a
web visualization, so I have, say, the unemployment rate for each country and each state
in my region that I need to stack (see example below). It is not too difficult, but I want
to be able to redefine the data set using a definition file that can be edited in excel
(so a student assistant can work with it).
Date State County UR
2005:01 WI DUNN 5% #value is just made up
2005:02 WI DUNN 6% #value is just made up
2005:01 MN WASH 3% #value is just made up
2005:02 MN WASH 4% #value is just made up
Cheers,
Logan
-----Original Message-----
From: gretl-devel-bounces(a)lists.wfu.edu [mailto:gretl-devel-
bounces(a)lists.wfu.edu] On Behalf Of Sven Schreiber
Sent: Monday, December 01, 2014 10:10 AM
To: gretl-devel(a)lists.wfu.edu
Subject: Re: [Gretl-devel] is there an inarray function?
Am 01.12.2014 um 17:06 schrieb Logan Kelly:
> More generally, I am working on a project that can turn a gretl data set into
a flat file.
>
You mean flatter than a csv file?
-sven
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-devel
4:27 p.m.
Am 01.12.2014 um 17:23 schrieb Logan Kelly:
Yes, I am going to output to a csv file, but it is time series data
that is trying very hard to be panel. I am working with regional data (at the State and
County level) for a web visualization, so I have, say, the unemployment rate for each
country and each state in my region that I need to stack (see example below). It is not
too difficult, but I want to be able to redefine the data set using a definition file that
can be edited in excel (so a student assistant can work with it).
Date State County UR
2005:01 WI DUNN 5% #value is just made up
2005:02 WI DUNN 6% #value is just made up
2005:01 MN WASH 3% #value is just made up
2005:02 MN WASH 4% #value is just made up
can you give an example or even better the pattern how your variables
are named?
-s
4:49 p.m.
Sven,
I hope this is what you are asking for.
Variable names:
UR in Dunn Co WI: WIDUNN3URN
UR in Washington Co WI: MNWASH5URN
Here is the function I have written to flatten the dataset (please do not look too closely
I have not made it very pretty yet):
function void flatten(string filename, lists inlsts, strings incats, strings invars)
#Needs error checking--VERY FRAGLE
/*
Summary: Creates a flat file from a panel of time series
Discription: Stacks time series variables by category arranging variables in
columns and adds a category variable.
Example:
*/
series isobasic = $obsdate
series y, m, d
isoconv(isobasic, &y, &m, &d)
matrix date = {y}~{m}~{d}
scalar T = rows(date)
scalar C = nelem(incats)
scalar N = nelem(invars)
strings dates = array(T)
loop i = 1..rows(date) --quiet
dates[i] = sprintf("%d-%02d-%02d",date[i,1],date[i,2],date[i,3])
endloop
matrix stack
loop i = 1..nelem(inlsts) --quiet
stack ~= vec({inlsts[i]})
endloop
matrix date =
mshape({isobasic},rows(stack),1)~mshape({y},rows(stack),1)~mshape({m},rows(stack),1)~mshape({d},rows(stack),1)
string obrow, dtrow tprow
loop n = 1..N --quiet
tprow = tprow ~ "," ~ sprintf("%s", invars[n])
endloop
outfile "(a)filename.csv" --write
printf "%s,%s,%s,%s,%s,%s%s\n", "date", "category",
"isobasic","year","month","day",tprow
loop c = 1..C --quiet
loop t = 1..T --quiet
scalar indx = c * t
loop k = 1..N --quiet
obrow = obrow ~ "," ~ sprintf("%f", stack[indx,k])
endloop
loop k = 1..4 --quiet
dtrow = dtrow ~ "," ~ sprintf("%d", date[indx,k])
endloop
printf "%s,%s%s%s\n", dates[t], incats[c], dtrow, obrow
dtrow = ""
obrow = ""
endloop
endloop
outfile --close
end function
-----Original Message-----
From: gretl-devel-bounces(a)lists.wfu.edu [mailto:gretl-devel-
bounces(a)lists.wfu.edu] On Behalf Of Sven Schreiber
Sent: Monday, December 01, 2014 10:28 AM
To: gretl-devel(a)lists.wfu.edu
Subject: Re: [Gretl-devel] is there an inarray function?
Am 01.12.2014 um 17:23 schrieb Logan Kelly:
> Yes, I am going to output to a csv file, but it is time series data that is trying
very hard to be panel. I am working with regional data (at the State and
County level) for a web visualization, so I have, say, the unemployment rate
for each country and each state in my region that I need to stack (see
example below). It is not too difficult, but I want to be able to redefine the
data set using a definition file that can be edited in excel (so a student
assistant can work with it).
>
>
> Date State County UR
> 2005:01 WI DUNN 5% #value is just made up
> 2005:02 WI DUNN 6% #value is just made up
> 2005:01 MN WASH 3% #value is just made up
> 2005:02 MN WASH 4% #value is just made up
>
>
can you give an example or even better the pattern how your variables are
named?
-s
_______________________________________________
Gretl-devel mailing list
Gretl-devel(a)lists.wfu.edu
http://lists.wfu.edu/mailman/listinfo/gretl-devel
10:15 p.m.
Am 01.12.2014 um 17:49 schrieb Logan Kelly:
Sven,
I hope this is what you are asking for.
Variable names:
UR in Dunn Co WI: WIDUNN3URN UR in Washington Co WI: MNWASH5URN
I hope the second isn't really in "WI" but rather in "MN"
(Minnesota?),
otherwise the pattern wouldn't be helpful. And the number in there is
also funny.
Here is the function I have written to flatten the dataset (please do
not look too closely I have not made it very pretty yet):
Initially I was also thinking about "outfile" and "printf" and so
forth.
Now I've tackled a slightly different problem (sorry) that I've been
thinking about myself, namely how to convert "time series that are
trying to be a panel", as you said, into a proper panel. And by using
"store" and "join" I was able to avoid handcrafted temp files. So the
result is not a flat file, but a panel workfile. Nevertheless maybe it
gives you some alternative ideas, and I think it should be easier to
create a flat file from there, because now you also have an actual
string series with the country names in there.
@Allin: I was surprised I had to specify --tconv-fmt="%YQ%q" for gretl's
own exported csv file, I got an error without it.
cheers,
sven
3428
days inactive
3434
days old
9 comments
4 participants
participants (4)
-
Allin Cottrell -
Artur T. -
Logan Kelly -
Sven Schreiber