How do I get the sum of numbers for each column in a csv file separately. Then select the top 3 column and place them in a new list in order?

[GTIOS_WT]

Hi, TIMA2
Simply speaking I just want to find the column index of the top 12 in the 48 cloumn sum values in the CSV.
But the 48 column indexes are divided into 3 parts( A/B/C) .
LIST_A : [9,10,11,12,21,22,23,24,33,34,35,36,45,46,47,48] ---column index number
LIST_B : [5,6,7,8,17,18,19,20,29,30,31,32,41,42,43,44]
LIST_C : [1,2,3,4,13,14,15,16,25,26,27,28,37,38,39,40]
I need top 4 from LIST_A , LIST_B , LIST_C , then there are 12 column indexes in total.
Looking forward to hear from you soon.

Thanks~
Tommy

[patel]

It's not very clear for me, but if you want the top 4 values in a list you have to sort the list and keep the first 4 values.
Maybe it's better to solve one problem at a time

[GTIOS_WT]

Hi patel,
attachment : 1. csv file 2. flow chart
log.csv (54.3 KB)
flow chart.pdf (465.2 KB)
Hope the attachment helps to understand.
Best regards,
Tommy

[patel]

I don't understand step 2,3,4

[ABG]

Here are some blocks to get you part way through, with top 4 selection by group.
You can assemble the results to your taste...

sensor_group_log.aia (28.4 KB)

[GTIOS_WT]

B.rgds,
Tommy

[ABG]

My top 4 procedure had a bug in it for items close to my stopper, so I had to rewrite it, breaking it down into a sort routine and a top n clipper routine.

I added the final steps needed to pick out and sort the requested column numbers, as penance for my bug.
sensor_group_log.aia (30.9 KB)

[GTIOS_WT]

Correct ~ Marvelous ~ Many thanks for your kind help !
Best regards,
Tommy

[GTIOS_WT]

Dear ABG,
Please link with the last Q&A. (from ABG / Power User)

How do I get the sum of numbers for each column in a csv file separately. Then select the top 3 column and place them in a new list in order?

My top 4 procedure had a bug in it for items close to my stopper, so I had to rewrite it, breaking it down into a sort routine and a top n clipper routine. I added the final steps needed to pick out and sort the requested column numbers, as penance for my bug. sensor_group_log.aia (30.9 KB) [Capture] [Designer] [to first_n table n result] [to sortListAscending list result] [to sortDescending table byColumn result] [to top_n table n byColumn result (1)] [when logFile .…

Attachment : Last aia and my python sample

Best regards,
Tommy
python to AI2.pdf (294.4 KB)
sensor_group_log.aia (30.9 KB)

[GTIOS_WT]

Dear ABG,
Please link with the last Q&A. I still need your kind help.

How do I get the sum of numbers for each column in a csv file separately. Then select the top 3 column and place them in a new list in order?

My top 4 procedure had a bug in it for items close to my stopper, so I had to rewrite it, breaking it down into a sort routine and a top n clipper routine. I added the final steps needed to pick out and sort the requested column numbers, as penance for my bug. sensor_group_log.aia (30.9 KB) [Capture] [Designer] [to first_n table n result] [to sortListAscending list result] [to sortDescending table byColumn result] [to top_n table n byColumn result (1)] [when logFile .…

Attachment : Last aia and my python sample
Could you kind help me to rebuild a new.aia continued with last aia ?
Sorry,I’m not familiar with AI2. But I have to finish this AI2 program this week.
Best regards,
Tommy
python to AI2.pdf (294.4 KB)
sensor_group_log.aia (30.9 KB)

[RamNaresh]

Hello Gtios,

Definitely you will get solution or direction to find solution. I am sorry if my concern not correct/good, but in my opinion every Power Users are equally capable to solve the problem, yes offcourse some users are expert in one area and some in others. But it dont look good to mention or refer one user can solve this, as you have done in your post subject/title. Please remove section where you have mentioned - wish ABG can help.

No doubt ABG is very great and knowledgeable person.

Thanks

[ABG]

@GTIOS_WT

Please link with the last Q&A.

Done.

I made your request public to allow those with more time and Python extension experience to chip in.

[ABG]

@RamNaresh

No doubt ABG is very great and knowledgeable person.

You have me confused with this guy ...

[ABG]

I have finished my personal errands and done my rounds of easy to answer questions.

I double checked this thread and saw that I answered your original question.

I see you have posted a pdf and an .aia, but I do not see:

• What your project was supposed to do
• What you got working
• what does not work
• what you don't know how to implement
• what you tried.

[RamNaresh]

Thanks, your Honor -- I mean, your Excellency -- I mean, your Wizardry.

[RamNaresh]

@GTIOS_WT

my python sample

Here is you answer according to the python file and its output.

[GTIOS_WT]

Hi, rnareshu,
one more question.
Suppose I just want to fix 0x04 as byte0, because it is a fix header of a command.
Do I just need to change the value of key0 from 0 to 4 in command dictionary ?
Looking forward to hear from you soon and thanks for your support.
Best regards,
Tommy

[RamNaresh]

@GTIOS_WT

Do I just need to change the value of key0 from 0 to 4 in command dictionary ?

Yes, you just need to make this modification only, as