comp.lang.idl-pvwave archive: archive » Re: edit a large dataset

Home » Public Forums » archive » Re: edit a large dataset

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: edit a large dataset [message #56098 is a reply to message #56095]

Wed, 03 October 2007 09:40

Vince Hradil
Messages: 574
Registered: December 1999

Senior Member

On Oct 3, 9:48 am, queiny <quein...@yahoo.com> wrote:
> Hi, I have a large dataset (>1e7 records). One field of the record is
> a string 'landuse'. Now I want to add one more field based on the
> 'landuse', i.e., if it is 'forest', then add 'aa', if it is 'urban',
> then add 'bb', etc.. Since there are more than 20 different landuse,
> use 'if-then', or 'case' for each record will be quite inefficient.
>
> I am thinking of 'sort' the records based on 'landuse', and then use
> 'uniq' to locate the starting point and number of records for each
> 'landuse' type and add the new fields accordingly. But how could I go
> back to the original order afterward?
>
> a=sort(data_orig)
> data_sorted=data_orig(a)
> ;processing based on 'data_sorted'
>
> but how could I go back the order of 'data_orig'? Is there a inversion
> of 'sort'.
>
> Thanks,

a=sort(data_orig)
data_sorted=data_orig[a]
data_orig=data_sorted[sort(a)]

Cheers,
Vince

Report message to a moderator

[Message index]

		Re: edit a large dataset By: queiny on Wed, 03 October 2007 11:54
		Re: edit a large dataset By: queiny on Wed, 03 October 2007 11:43
		Re: edit a large dataset By: Jean H. on Wed, 03 October 2007 09:29
		Re: edit a large dataset By: Vince Hradil on Wed, 03 October 2007 09:45
		Re: edit a large dataset By: Vince Hradil on Wed, 03 October 2007 09:40
		Re: edit a large dataset By: Peter Clinch on Wed, 03 October 2007 07:58

Previous Topic:	Re: label x axis
Next Topic:	dynamic widget

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 11 15:05:35 PDT 2025

Total time taken to generate the page: 1.04340 seconds