Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #11671

Re: Transforming/expanding a list

From Andrzej Kozlowski <akozlowski@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Transforming/expanding a list
Date 2012-09-08 07:47 +0000
Message-ID <k2et76$km1$1@smc.vnet.net> (permalink)
References <20120906081415.0241D684C@smc.vnet.net>
Organization Time-Warner Telecom

Show all headers | View raw


On 6 Sep 2012, at 10:14, Mark Coleman <markspcoleman@gmail.com> wrote:

> I'm working on some Mathematica code that will help transform a large set of lists drawn from my company's legacy database systems. A typical row of the raw data looks like
>
> {x1,NULL,NULL,x2,NULL,NULL,NULL,NULL,x3,NULL,NULL,x4,x5,NULL} ...
>
> The lists are sequences of real numbers, separating some some number of Strings which for convenicence sake we call "NULL" (as opposed to a proper Mathematica Null). The goal is to create a new list where each NULL is replaced by the real number that most recently proceeds it (note that any number of NULLs may occur before or after any real values). I would like the code to return
>
> {x1,x1,x1,x2,x2,x2,x2,x2,x3,x3,x3,x4,x5,x5}
>
>
> Thanks
>
> Mark
>

How about something like this:

h[ls_] :=
 Module[{u, g}, g[l_] /; VectorQ[l, NumberQ] := (u = Last[l];);
  g[l_] /; Last[l] == NULL := l /. NULL -> u;
  DeleteCases[Flatten[Map[g, Split[ls]]], Null]]

for example:

ls = {1, NULL, NULL, 2, NULL, NULL, NULL, NULL, 3, NULL, NULL, 4, 5,
  NULL}

h[ls]

{1,1,2,2,2,2,3,3,5}


The way the code is written, it is essential that your x's are numbers, although one could easily change it to make it work with symbols.

Andrzej Kozlowski

Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread


Thread

Re: Transforming/expanding a list Andrzej Kozlowski <akozlowski@gmail.com> - 2012-09-08 07:47 +0000

csiph-web