Skip to main content
Solved

TXT file+statistics

  • March 27, 2018
  • 2 replies
  • 26 views

Forum|alt.badge.img

Hi,

I have a TXT file (point cloud) containing 2 columns col1=X and col2=Y.

I want to create groups every 1cm (according to X axis) and compute for each group Xmean, Ymean, Ymin and Ymax.

I think it is necessary to create a point cloud and then create slice of points (every 1cm) but I don't know how to do this.

Thank you for your help.

Best answer by todd_davis

Hi,

So you want to group x values based on the cm they fall into and then get Stats?

Read the text file as a csv with the relevant delimiter. Copy the value of the X value into a new attribute and then use attributerounder to convert that new value to the relevant number of decimal places. Then use the StatisticsCalculator with the group by being the attribute you rounded.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

todd_davis
Influencer
Forum|alt.badge.img+23
  • Influencer
  • Best Answer
  • March 27, 2018

Hi,

So you want to group x values based on the cm they fall into and then get Stats?

Read the text file as a csv with the relevant delimiter. Copy the value of the X value into a new attribute and then use attributerounder to convert that new value to the relevant number of decimal places. Then use the StatisticsCalculator with the group by being the attribute you rounded.


Forum|alt.badge.img
  • Author
  • March 28, 2018

Hi,

So you want to group x values based on the cm they fall into and then get Stats?

Read the text file as a csv with the relevant delimiter. Copy the value of the X value into a new attribute and then use attributerounder to convert that new value to the relevant number of decimal places. Then use the StatisticsCalculator with the group by being the attribute you rounded.

Hi @todd_davis,

 

It is a really good solution. Thank you very much !

 

Have a good day.