[Paraview] [EXT] Re: [EXTERNAL] Excel Pivot Table like functionality

[Dennis Conklin]

Cory,

I'm heading off on a month of vacation, but I'm looking at using the pivot table functionality in pandas within a Programmable filter.    I'm not sure when I will get time to get back into this!

Dennis

-----Original Message-----
From: Cory Quammen [mailto:cory.quammen at kitware.com] 
Sent: Friday, August 04, 2017 2:36 PM
To: Scott, W Alan <wascott at sandia.gov>
Cc: Dennis Conklin <dennis_conklin at goodyear.com>; Paraview (paraview at paraview.org) <paraview at paraview.org>
Subject: [EXT] Re: [Paraview] [EXTERNAL] Excel Pivot Table like functionality

 WARNING - External email; exercise caution.



Dennis,

That's a fairly complex operation that you describe. I'm afraid there isn't anything canned to do this in ParaView. It should be possible with a fairly impressive Programmable Filter, though.

Best regards,
Cory

On Mon, Jul 31, 2017 at 12:52 PM, Scott, W Alan <wascott at sandia.gov> wrote:
> Kitware – Ping?
>
>
>
> From: ParaView [mailto:paraview-bounces at paraview.org] On Behalf Of 
> Dennis Conklin
> Sent: Monday, July 24, 2017 2:34 PM
> To: Paraview (paraview at paraview.org) <paraview at paraview.org>
> Subject: [EXTERNAL] [Paraview] Excel Pivot Table like functionality
>
>
>
> All,
>
>
>
> So, I have a multi-block dataset (Exodus).   Within each block, I have sets
> of 360 elements which have a common index.   So, in Block 1, elements 0-359
> have a cell variable called N_RING, which is 1.    Elements 360-719, have
> N_RING=2, etc.
>
>
>
> What I really want is the ability to operate on these sets.   Imagine I have
> an element variable called Ying, which is different for each element 
> in the model.  I would like every element with N_RING=1 to have an 
> element variable of Ying_max assigned, which is the maximum value of Ying for any element
> with N_RING=1.    So, for example,  elements 0-359 would be assigned a value
> of Ying_max which is the maximum value of Ying in any of elements 0-359.
> Elements 360-719 would be assigned a value of Ying_max which is the maximum
> value for any element with N_RING=2.    I would ideally also like to get min
> and average.
>
>
>
> Is there any way to get max/min/average of a group consisting of a 
> cell variable index?  - and to assign the output as element variables 
> so I can color by?
>
>
>
> Thanks for any hints.
>
>
>
> Dennis
>
>
> _______________________________________________
> Powered by 
> https://na01.safelinks.protection.outlook.com/?url=www.kitware.com&dat
> a=01%7C01%7Cdennis_conklin%40goodyear.com%7Cd72609f7e8a64e94edb808d4db
> 679a10%7C939e896692854a9a9f040887efe8aae0%7C0&sdata=FcCoY8cIzamH%2Bcah
> p8rx2XTw%2BeOQkr1hcrbiar6eABk%3D&reserved=0
>
> Visit other Kitware open-source projects at
> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ki
> tware.com%2Fopensource%2Fopensource.html&data=01%7C01%7Cdennis_conklin
> %40goodyear.com%7Cd72609f7e8a64e94edb808d4db679a10%7C939e896692854a9a9
> f040887efe8aae0%7C0&sdata=rzMOj5ESh3oHjuW%2BHDedetSsbgzqMSexh0jpwvsPKR
> Q%3D&reserved=0
>
> Please keep messages on-topic and check the ParaView Wiki at:
> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fparavi
> ew.org%2FWiki%2FParaView&data=01%7C01%7Cdennis_conklin%40goodyear.com%
> 7Cd72609f7e8a64e94edb808d4db679a10%7C939e896692854a9a9f040887efe8aae0%
> 7C0&sdata=rAlabLkAZmggru4zAy1Iuk48lrUn0HTRO9wSVAp5ooU%3D&reserved=0
>
> Search the list archives at: 
> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmarkma
> il.org%2Fsearch%2F%3Fq%3DParaView&data=01%7C01%7Cdennis_conklin%40good
> year.com%7Cd72609f7e8a64e94edb808d4db679a10%7C939e896692854a9a9f040887
> efe8aae0%7C0&sdata=W95mxbW6LD2LVm%2BAoXRGA4gq2PFzHBY3h8pQhKkpr4Q%3D&re
> served=0
>
> Follow this link to subscribe/unsubscribe:
> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublic
> .kitware.com%2Fmailman%2Flistinfo%2Fparaview&data=01%7C01%7Cdennis_con
> klin%40goodyear.com%7Cd72609f7e8a64e94edb808d4db679a10%7C939e896692854
> a9a9f040887efe8aae0%7C0&sdata=IlNNte5Ru4gJgZfjWFYSaA5OwLgYRxMt7UbnZ3XC
> hWA%3D&reserved=0
>



--
Cory Quammen
Staff R&D Engineer
Kitware, Inc.