Clear Filters
Clear Filters

Info

This question is closed. Reopen it to edit or answer.

How to "filter" table to get the velocity of each y value but for a constant x value.

1 view (last 30 days)
I have 3970*5 matrix, first two columns are the x and y co ordinate and 3rd and 4th columns are the velocities(u,v) and the last column is the reference values. so i want to get the velocity of each y value but for a constant x value.
here are the values
2.608640, -59.998718, 0.000000, -0.000000, -2
5.217280, -59.998718, 0.000000, -0.000000, -2
7.825920, -59.998718, 0.000000, -0.000000, -2
10.434560, -59.998718, 0.000000, -0.000000, -2
13.043200, -59.998718, 0.000000, -0.000000, -2
15.651840, -59.998718, 0.000000, -0.000000, -2
18.260479, -59.998718, 0.000000, -0.000000, -2
20.869120, -59.998718, 0.000000, -0.000000, -2
23.477760, -59.998718, 0.003616, 0.734599, -1
26.086399, -59.998718, -0.000368, -0.261640, -1
28.695040, -59.998718, 0.480840, -0.002615, 4
31.303680, -59.998718, 0.481024, -0.002567, 4
33.912319, -59.998718, 0.480833, -0.002617, 4
36.520958, -59.998718, 0.481393, -0.002481, 4
39.129601, -59.998718, 0.479846, -0.003585, 1
41.738239, -59.998718, 0.484383, -0.001601, 1
44.346878, -59.998718, 0.481393, -0.002481, 4
46.955521, -59.998718, 0.358732, -0.021099, 4
49.564159, -59.998718, 0.271537, -0.033754, 4
52.172798, -59.998718, 0.185408, -0.046586, 4
54.781441, -59.998718, 0.240822, -0.037954, 4
57.390079, -59.998718, 0.355452, -0.023215, 4
59.998718, -59.998718, 0.443450, -0.007304, 4
62.607361, -59.998718, 0.502313, 0.004802, 4
65.215996, -59.998718, 0.498475, -0.034632, 1
67.824638, -59.998718, 0.505472, 0.002438, 4
70.433281, -59.998718, 0.479858, -0.012436, 1
73.041916, -59.998718, 0.500051, -0.000200, 4
75.650558, -59.998718, 0.496937, -0.003819, 4
78.259201, -59.998718, 0.497665, -0.003134, 4
80.867836, -59.998718, 0.495890, -0.003868, 4
83.476479, -59.998718, 0.495281, -0.004077, 4
86.085121, -59.998718, 0.494966, -0.004246, 4
88.693756, -59.998718, 0.494875, -0.004257, 4
91.302399, -59.998718, 0.000000, -0.000000, -2
93.911041, -59.998718, 0.000000, -0.000000, -2
96.519676, -59.998718, 0.000000, -0.000000, -2
99.128319, -59.998718, 0.000000, -0.000000, -2
101.736961, -59.998718, 0.000000, -0.000000, -2
104.345596, -59.998718, 0.000000, -0.000000, -2
106.954239, -59.998718, 0.000000, -0.000000, -2
109.562881, -59.998718, 0.000000, -0.000000, -2
112.171516, -59.998718, 0.000000, -0.000000, -2
114.780159, -59.998718, 0.000000, -0.000000, -2
117.388802, -59.998718, 0.000000, -0.000000, -2
119.997437, -59.998718, 0.000000, -0.000000, -2
122.606079, -59.998718, 0.000000, -0.000000, -2
125.214722, -59.998718, 0.000000, -0.000000, -2
127.823357, -59.998718, 0.000000, -0.000000, -2
130.431992, -59.998718, 0.000000, -0.000000, -2
133.040634, -59.998718, 0.000000, -0.000000, -2
135.649277, -59.998718, 0.000000, -0.000000, -2
138.257919, -59.998718, 0.000000, -0.000000, -2
140.866562, -59.998718, 0.000000, -0.000000, -2
143.475204, -59.998718, 0.000000, -0.000000, -2
146.083832, -59.998718, 0.000000, -0.000000, -2
148.692474, -59.998718, 0.000000, -0.000000, -2
151.301117, -59.998718, 0.000000, -0.000000, -2
153.909760, -59.998718, 0.000000, -0.000000, -2
156.518402, -59.998718, 0.000000, -0.000000, -2
159.127045, -59.998718, 0.000000, -0.000000, -2
161.735672, -59.998718, 0.000000, -0.000000, -2
164.344315, -59.998718, 0.000000, -0.000000, -2
2.608640, -62.607361, 0.000000, -0.000000, -2
5.217280, -62.607361, 0.000000, -0.000000, -2
7.825920, -62.607361, 0.000000, -0.000000, -2
10.434560, -62.607361, 0.000000, -0.000000, -2
13.043200, -62.607361, 0.000000, -0.000000, -2
15.651840, -62.607361, 0.000000, -0.000000, -2
18.260479, -62.607361, 0.000000, -0.000000, -2
20.869120, -62.607361, 0.000000, -0.000000, -2
23.477760, -62.607361, 0.004142, -0.613949, -1
26.086399, -62.607361, 0.480995, -0.002577, 4
28.695040, -62.607361, 0.480875, -0.002600, 4
31.303680, -62.607361, 0.481063, -0.002557, 4
33.912319, -62.607361, 0.481045, -0.002582, 4
36.520958, -62.607361, 0.481393, -0.002481, 4
39.129601, -62.607361, 0.481280, -0.002079, 1
41.738239, -62.607361, 0.480062, -0.002661, 1
44.346878, -62.607361, 0.481393, -0.002481, 4
46.955521, -62.607361, 0.331897, -0.025178, 4
49.564159, -62.607361, 0.241395, -0.038431, 4
52.172798, -62.607361, 0.000463, -0.112176, 1
54.781441, -62.607361, 0.237983, -0.038043, 4
57.390079, -62.607361, 0.354199, -0.023792, 4
59.998718, -62.607361, 0.469409, -0.003253, 4
62.607361, -62.607361, 0.521618, -0.029295, 1
65.215996, -62.607361, 0.512406, 0.020451, 1
67.824638, -62.607361, 0.477946, -0.001967, 1
70.433281, -62.607361, 0.485241, -0.005500, 1
73.041916, -62.607361, 0.498681, -0.000436, 4
75.650558, -62.607361, 0.498972, -0.002314, 4
78.259201, -62.607361, 0.498411, -0.002185, 4
80.867836, -62.607361, 0.496181, -0.003384, 4
83.476479, -62.607361, 0.495687, -0.003831, 4
86.085121, -62.607361, 0.495231, -0.004075, 4
88.693756, -62.607361, 0.495051, -0.004170, 4
91.302399, -62.607361, 0.000000, -0.000000, -2
93.911041, -62.607361, 0.000000, -0.000000, -2
96.519676, -62.607361, 0.000000, -0.000000, -2
99.128319, -62.607361, 0.000000, -0.000000, -2
101.736961, -62.607361, 0.000000, -0.000000, -2
104.345596, -62.607361, 0.000000, -0.000000, -2
106.954239, -62.607361, 0.000000, -0.000000, -2
109.562881, -62.607361, 0.000000, -0.000000, -2
112.171516, -62.607361, 0.000000, -0.000000, -2
114.780159, -62.607361, 0.000000, -0.000000, -2
117.388802, -62.607361, 0.000000, -0.000000, -2
119.997437, -62.607361, 0.000000, -0.000000, -2
122.606079, -62.607361, 0.000000, -0.000000, -2
125.214722, -62.607361, 0.000000, -0.000000, -2
127.823357, -62.607361, 0.000000, -0.000000, -2
130.431992, -62.607361, 0.000000, -0.000000, -2
133.040634, -62.607361, 0.000000, -0.000000, -2
135.649277, -62.607361, 0.000000, -0.000000, -2
138.257919, -62.607361, 0.000000, -0.000000, -2
140.866562, -62.607361, 0.000000, -0.000000, -2
143.475204, -62.607361, 0.000000, -0.000000, -2
146.083832, -62.607361, 0.000000, -0.000000, -2
148.692474, -62.607361, 0.000000, -0.000000, -2
151.301117, -62.607361, 0.000000, -0.000000, -2
153.909760, -62.607361, 0.000000, -0.000000, -2
156.518402, -62.607361, 0.000000, -0.000000, -2
159.127045, -62.607361, 0.000000, -0.000000, -2
161.735672, -62.607361, 0.000000, -0.000000, -2
164.344315, -62.607361, 0.000000, -0.000000, -2
2.608640, -65.215996, 0.000000, -0.000000, -2
5.217280, -65.215996, 0.000000, -0.000000, -2
7.825920, -65.215996, 0.000000, -0.000000, -2
10.434560, -65.215996, 0.000000, -0.000000, -2
13.043200, -65.215996, 0.000000, -0.000000, -2
15.651840, -65.215996, 0.000000, -0.000000, -2
18.260479, -65.215996, 0.000000, -0.000000, -2
20.869120, -65.215996, 0.000000, -0.000000, -2
23.477760, -65.215996, 0.480903, -0.002597, 4
26.086399, -65.215996, 0.480950, -0.002586, 4
28.695040, -65.215996, 0.480948, -0.002589, 4
31.303680, -65.215996, 0.481063, -0.002561, 4
33.912319, -65.215996, 0.481028, -0.002591, 4
36.520958, -65.215996, 0.481393, -0.002481, 4
39.129601, -65.215996, 0.481393, -0.002481, 4
41.738239, -65.215996, 0.481393, -0.002481, 4
44.346878, -65.215996, 0.418627, -0.011855, 4
46.955521, -65.215996, 0.310209, -0.028105, 4
49.564159, -65.215996, 0.240826, -0.038366, 4
52.172798, -65.215996, 0.002330, -0.036585, 1
54.781441, -65.215996, 0.303323, -0.028746, 4
57.390079, -65.215996, 0.367591, -0.021406, 4
59.998718, -65.215996, 0.455546, -0.003601, 4
62.607361, -65.215996, 0.521209, 0.017471, 1
65.215996, -65.215996, 0.508178, 0.050332, 1
67.824638, -65.215996, 0.519963, 0.022021, 1
70.433281, -65.215996, 0.513278, -0.001427, 1
73.041916, -65.215996, 0.522023, 0.001795, 1
75.650558, -65.215996, 0.500667, -0.001677, 4
78.259201, -65.215996, 0.499504, -0.000809, 4
80.867836, -65.215996, 0.496802, -0.002722, 4
83.476479, -65.215996, 0.496295, -0.003397, 4
86.085121, -65.215996, 0.495626, -0.003803, 4
88.693756, -65.215996, 0.495376, -0.003982, 4
91.302399, -65.215996, 0.495187, -0.004089, 4
93.911041, -65.215996, 0.000000, -0.000000, -2
96.519676, -65.215996, 0.000000, -0.000000, -2
99.128319, -65.215996, 0.000000, -0.000000, -2
101.736961, -65.215996, 0.000000, -0.000000, -2
104.345596, -65.215996, 0.000000, -0.000000, -2
106.954239, -65.215996, 0.000000, -0.000000, -2
109.562881, -65.215996, 0.000000, -0.000000, -2
112.171516, -65.215996, 0.000000, -0.000000, -2
114.780159, -65.215996, 0.000000, -0.000000, -2
117.388802, -65.215996, 0.000000, -0.000000, -2
119.997437, -65.215996, 0.000000, -0.000000, -2
122.606079, -65.215996, 0.000000, -0.000000, -2
125.214722, -65.215996, 0.000000, -0.000000, -2
127.823357, -65.215996, 0.000000, -0.000000, -2
130.431992, -65.215996, 0.000000, -0.000000, -2
133.040634, -65.215996, 0.000000, -0.000000, -2
135.649277, -65.215996, 0.000000, -0.000000, -2
138.257919, -65.215996, 0.000000, -0.000000, -2
140.866562, -65.215996, 0.000000, -0.000000, -2
143.475204, -65.215996, 0.000000, -0.000000, -2
146.083832, -65.215996, 0.000000, -0.000000, -2
148.692474, -65.215996, 0.000000, -0.000000, -2
151.301117, -65.215996, 0.000000, -0.000000, -2
153.909760, -65.215996, 0.000000, -0.000000, -2
156.518402, -65.215996, 0.000000, -0.000000, -2
159.127045, -65.215996, 0.000000, -0.000000, -2
161.735672, -65.215996, 0.000000, -0.000000, -2
164.344315, -65.215996, 0.000000, -0.000000, -2
here for one value of x we have 3 values of y and which contains 3 different value of u and v values. please tell me how to do filter so that i can get the values
  2 Comments
Matt J
Matt J on 30 May 2016
You mean you want to combine/average rows with repeated y-values somehow? If so, show us an example of those rows and what they look like combined.
Image Analyst
Image Analyst on 30 May 2016
Edited: Image Analyst on 30 May 2016
How about grpstats()?
Or what do you mean for a constant x value? Like you want the velocity for x=59.998718 or for x=135.649277 or for some other constant x value?

Answers (0)

This question is closed.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!