taskGNU Astronomy Utilities - Tasks: task #15570, Operator to group rows with...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

task #15570: Operator to group rows with special scaling

Submitter:  Mohammad Akhlaghi <makhlaghi>
Submitted:  Fri 06 Mar 2020 12:00:08 AM UTC
   
 
Should Start On:  Thu 05 Mar 2020 12:00:00 AM UTC Should be Finished on:  Thu 05 Mar 2020 12:00:00 AM UTC
Category:  Table Priority:  5 - Normal
Item Group:  Enhancement Status:  None
Privacy:  Public Assigned to:  None
Percent Complete:  0% Open/Closed:  Open
Effort:  0.00

Wed 29 Mar 2023 05:01:50 PM UTC, comment #3: 

Hi Li, thanks for your interest in this.

We don't have such a function yet in Gnuastro. But if you want to see how the Table program interprets the various row and column selection operations (see the Operation precedence page in the manual for the list of existing operations), see the code in 'bin/table/table.c'.

For the time being, you can use a simpler kind of grouping (for example log-scale). The Voronoi example may be a little too complex to start with ;-).

Mohammad Akhlaghi <makhlaghi>
Group administrator
Tue 28 Mar 2023 02:37:24 PM UTC, comment #2: 

Respect Mohammad,
It would be helpful if you could tell me where can the related code be found.
A brief suggestion, or any tips about the task would be really helpful sir :).
comment #1:

> I am currently working on this issues. I wonder whether the user have to provide seed point for 1d veronoi? Or we need to generate seed points randomly.

LI Junnan <junnan>
Tue 28 Mar 2023 02:30:58 PM UTC, comment #1: 

I am currently working on this issues. I wonder whether the user have to provide seed point for 1d veronoi? Or we need to generate seed points randomly.

LI Junnan <junnan>
Fri 06 Mar 2020 12:00:08 AM UTC, original submission:  

One useful operation with tables is to group rows based on some criteria/scale in each column.

For example, assume that we have an input table like this:


# Column 1: Radius.
# Column 2: Sum of pixels.
1    100
2    50
3    20
4    10
5    5
6    4
7    3.2
8    3
9    2.8
10   2.5


Now, assume that in some scaling, we want the rows in each column to be grouped. For example in a hypothetical log-scale (the groupings are just arbitrary here, for demonstration)


# Column 1: Radius.
# Column 2: Sum of pixels.
0     100
0.39  70    # Second column, addition of rows 2&3: 50+20
0.60  19    # Second column, addition of rows 4&5&6: 10+5+4
0.92   11.5  # Second column, addition of rows 7&8&9&10: 3.2+3+2.8+2.5


The user just has to specify the reference column, and particular scaling (maybe also a 1D Voronoi, or other scaling) and their desired columns, for example:


asttable table.fits --rescale=1,log --column=1,2


Mohammad Akhlaghi <makhlaghi>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by junnan (Posted a comment)
  • -email is unavailable- added by makhlaghi (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    No changes have been made to this item

    Back to the top

    Powered by Savane 3.13-d3ae.
    Corresponding source code