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.quam...@kitware.com] Sent: Friday, August 04, 2017 2:36 PM To: Scott, W Alan <wasc...@sandia.gov> Cc: Dennis Conklin <dennis_conk...@goodyear.com>; Paraview (paraview@paraview.org) <paraview@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 <wasc...@sandia.gov> wrote: > Kitware – Ping? > > > > From: ParaView [mailto:paraview-boun...@paraview.org] On Behalf Of > Dennis Conklin > Sent: Monday, July 24, 2017 2:34 PM > To: Paraview (paraview@paraview.org) <paraview@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. _______________________________________________ Powered by www.kitware.com Visit other Kitware open-source projects at http://www.kitware.com/opensource/opensource.html Please keep messages on-topic and check the ParaView Wiki at: http://paraview.org/Wiki/ParaView Search the list archives at: http://markmail.org/search/?q=ParaView Follow this link to subscribe/unsubscribe: http://public.kitware.com/mailman/listinfo/paraview