Loading a 3d pointset for classification

dimple · August 27, 2018, 4:47pm

Hi

I have a very large csv 3d lidar pointset for classification. I am finding it difficult to load it into a dataloader without errors. Can anyone pls help me in this?

I have two columns of the format

|labels|points|

|1 | 601120.23 4493773.37 12.44,601120.43 4493773.53 12.54,601121.12 4493773.54 12.61,601120.38 4493773.61 12.42,601121.75 4493773.69 13.02,601119.95 4493773.69 8.07,…
|0 | 604916.47 4494396.11 11.58,604916.02 4494396.13 11.84,604915.03 4494396.15 11.58,604915.87 4494396.19 11.44,604914.49 4494396.23 11.45,604917.41 4494396.35 …|

One issue am facing is pd.read_csv is reading the data as list but it is read as strings which has to be split by commas for eg:
[‘596287.12 4491565.09 5.6,596287.15 4491564.61 11.88,596287.16 4491564.18 12.05,596287.19 4491565.23 12,596287.22 4491565.89 5.52,596287.23 4491564.13 12.28,596287.36 4491565.49 12.45,596287.4 4491564.89 12.31,596287.45 4491564.28 12.02,596287.48 4491564.94 5.57,596287.51 4491564.71 11.94’]
How this is to be handled correctly.

ptrblck · August 27, 2018, 8:46pm

Could you post some lines of your .csv or are you really using horizontal bars to separate the label from the data?

ptrblck · August 28, 2018, 11:35am

Thanks for the code.
Could you also post a few rows of the data inside your .csv file?
This would make it easier to think about a way to properly load the data.

dimple · August 28, 2018, 11:51am

i cannot copy data of two rows here as it exceeds space limit. is attachment possible here? anyway i will paste here the first row here

|labels|points|
|---|---|
|1|601120.23 4493773.37 12.44,601120.43 4493773.53 12.54,601121.12 4493773.54 12.61,601120.38 4493773.61 12.42,601121.75 4493773.69 13.02,601119.95 4493773.69 8.07,601122.15 4493773.74 13.1,601122.31 4493773.76 13.2,601120.74 4493773.77 12.61,601123.25 4493773.8 13.52,601119.71 4493773.84 12.32,601121.97 4493773.87 13,601122.2 4493773.88 13.15,601124.01 4493773.88 13.62,601122.33 4493773.91 13.2,601120.94 4493773.92 12.61,601121.14 4493773.95 12.74,601123.01 4493773.99 13.32,601125.07 4493774.02 14.08,601120.06 4493774.02 12.44,601120.58 4493774.03 12.44,601123.98 4493774.1 13.63,601123.98 4493774.11 13.7,601121.85 4493774.18 12.94,601121.07 4493774.18 12.72,601122.88 4493774.19 13.37,601124.75 4493774.23 13.98,601119.89 4493774.24 5.31,601121.79 4493774.27 13,601124.67 4493774.27 13.88,601125.69 4493774.27 14.23,601121.92 4493774.29 13.07,601119.67 4493774.31 5.18,601124.8 4493774.33 13.95,601122.78 4493774.33 13.31,601123.76 4493774.35 13.52,601119.98 4493774.35 12.4,601120.69 4493774.36 12.67,601120.44 4493774.37 12.46,601123.45 4493774.38 13.47,601121.12 4493774.44 12.71,601120.05 4493774.51 12.34,601121.43 4493774.57 12.87,601120.13 4493774.59 12.43,601124.28 4493774.65 13.9,601121.53 4493774.66 12.99,601124.4 4493774.69 13.82,601123.67 4493774.7 13.61,601124.82 4493774.71 13.96,601126.4 4493774.72 14.55,601121.91 4493774.72 13.03,601126.25 4493774.76 14.36,601125.39 4493774.79 14.23,601123.25 4493774.8 13.35,601119.93 4493774.82 12.27,601124.38 4493774.85 13.91,601121.73 4493774.85 12.91,601122.89 4493774.88 13.29,601125.7 4493774.88 14.36,601123.36 4493774.92 13.58,601121.02 4493774.96 12.78,601122.77 4493774.96 13.24,601122.36 4493774.99 13.22,601121.11 4493775.04 12.79,601123.84 4493775.05 13.7,601123.73 4493775.05 13.65,601121.35 4493775.06 12.86,601124.01 4493775.06 13.73,601120.33 4493775.13 12.57,601126.14 4493775.15 14.55,601120.82 4493775.16 12.67,601126.3 4493775.17 14.47,601124.51 4493775.19 13.97,601125.09 4493775.22 14.1,601125.45 4493775.22 14.15,601126 4493775.23 14.36,601125.7 4493775.26 14.24,601122.74 4493775.26 13.21,601119.89 4493775.29 7.84,601124.02 4493775.29 13.76,601122.53 4493775.3 13.27,601119.74 4493775.32 12.36,601120.59 4493775.35 12.62,601122.96 4493775.36 13.43,601122.36 4493775.37 13.16,601120.71 4493775.41 12.64,601120.88 4493775.41 12.64,601121.9 4493775.43 13.1,601123.61 4493775.43 13.58,601123.44 4493775.43 13.65,601126.01 4493775.5 14.42,601120.83 4493775.51 12.73,601119.89 4493775.57 12.31,601124.97 4493775.58 14.13,601119.77 4493775.58 12.45,601123.96 4493775.65 13.8,601123.42 4493775.67 13.61,601124.57 4493775.67 13.92,601121.67 4493775.68 12.99,601125.49 4493775.69 14.22,601122.24 4493775.71 13.05,601122.93 4493775.73 13.45,601120.17 4493775.75 12.48,601125.14 4493775.77 14.07,601120.31 4493775.78 12.5,601123.22 4493775.79 13.49,601119.6 4493775.8 5.25,601121.91 4493775.81 13.07,601121.48 4493775.82 12.89,601123.01 4493775.83 13.47,601125.46 4493775.84 14.29,601121.8 4493775.87 12.99,601120.89 4493775.89 12.71,601126.07 4493775.93 14.55,601122.52 4493775.94 13.23,601119.85 4493775.96 12.41,601123.49 4493776.02 13.54,601125.61 4493776.08 14.34,601126.06 4493776.09 14.47,601119.83 4493776.09 12.63,601119.94 4493776.13 12.45,601120.58 4493776.13 12.67,601122.84 4493776.15 13.43,601126.06 4493776.15 14.46,601124.53 4493776.16 13.94,601124.96 4493776.16 14.03,601124.27 4493776.16 13.9,601121.73 4493776.17 12.94,601125.21 4493776.18 14.12,601122.59 4493776.22 13.29,601123.43 4493776.24 13.62,601126.04 4493776.25 14.49,601122.3 4493776.26 13.2,601124.58 4493776.27 13.91,601119.7 4493776.29 13.67,601119.51 4493776.29 13.5,601119.46 4493776.3 7.66,601119.85 4493776.3 13.56,601125.66 4493776.31 14.4,601126.25 4493776.31 14.47,601125.02 4493776.32 14.17,601122.34 4493776.33 13.24,601121.26 4493776.36 12.84,601120.6 4493776.38 13.63,601124.01 4493776.39 13.85,601121.24 4493776.4 13.01,601120.03 4493776.44 13.43,601125.69 4493776.44 14.39,601122.42 4493776.44 14.16,601123.01 4493776.46 13.49,601122.5 4493776.47 13.48,601121.99 4493776.52 13.14,601119.6 4493776.53 13.5,601120.96 4493776.59 12.87,601121.26 4493776.6 12.89,601124.47 4493776.61 13.94,601119.51 4493776.63 13.62,601119.82 4493776.64 13.61,601122.42 4493776.64 14.55,601123.18 4493776.64 13.71,601124.33 4493776.64 13.88,601121.06 4493776.67 13.99,601125.27 4493776.67 14.27,601121.43 4493776.67 14.14,601126.16 4493776.7 14.52,601122.13 4493776.75 14.46,601119.53 4493776.76 8.97,601125.35 4493776.76 14.4,601125.08 4493776.77 14.27,601124.01 4493776.78 13.72,601121.2 4493776.78 14.04,601119.46 4493776.81 8.14,601125.21 4493776.82 14.44,601124.03 4493776.84 13.84,601125.19 4493776.84 15.41,601121.08 4493776.89 13.96,601122.93 4493776.91 13.84,601122.24 4493776.91 14.46,601125.25 4493776.93 15.39,601121.76 4493776.96 14.31,601122.04 4493776.99 14.43,601123.21 4493776.99 14.74,601124.09 4493777 14.35,601120.7 4493777.03 14,601119.65 4493777.1 13.7,601120.35 4493777.1 13.83,601123.79 4493777.11 14.86,601121.73 4493777.12 14.34,601125.82 4493777.12 15.07,601124.03 4493777.14 15.05,601124.93 4493777.14 15.26,601120.51 4493777.16 13.78,601124.81 4493777.2 15.33,601122.06 4493777.23 14.38,601119.26 4493777.25 13.49,601124.91 4493777.26 15.38,601125.98 4493777.28 15.22,601119.25 4493777.29 8.24,601120.58 4493777.33 13.79,601120.35 4493777.34 13.81,601121.65 4493777.35 14.24,601123.76 4493777.37 14.87,601126.2 4493777.38 15,601125.07 4493777.41 15.38,601124.04 4493777.48 15.15,601121.35 4493777.48 14.24,601119.36 4493777.5 13.44,601124.44 4493777.55 15.25,601123.02 4493777.56 14.75,601123.26 4493777.59 14.76,601124.55 4493777.59 15.31,601126.42 4493777.6 15.05,601124.04 4493777.6 15.09,601122.94 4493777.61 14.78,601119.99 4493777.63 13.65,601121.19 4493777.63 14.1,601122 4493777.64 14.39,601121.29 4493777.68 14.16,601120.96 4493777.71 14.1,601120.96 4493777.75 14.02,601120.11 4493777.76 13.71,601119.94 4493777.79 13.76,601124.98 4493777.79 15.41,601126.02 4493777.81 15.07,601123.26 4493777.81 14.74,601120.95 4493777.85 14.06,601124.92 4493777.87 15.38,601122 4493777.87 14.31,601125.66 4493777.89 15.16,601124.04 4493777.92 15.08,601123.9 4493777.93 15.14,601124.18 4493777.93 15.19,601124.49 4493777.94 15.27,601122.97 4493777.94 14.72,601122.9 4493778 14.76,601123.4 4493778.03 14.87,601120.91 4493778.03 14,601125.94 4493778.06 15.19,601121.88 4493778.07 14.46,601119.45 4493778.08 9.69,601120.1 4493778.08 13.76,601122.7 4493778.09 14.53,601125.58 4493778.09 15.3,601124.69 4493778.09 15.21,601119.47 4493778.1 13.54,601123.79 4493778.1 15,601122.31 4493778.11 14.5,601120.87 4493778.14 14.11,601119.62 4493778.19 13.57,601120.59 4493778.19 14.04,601121.82 4493778.19 14.37,601121.2 4493778.2 14.15,601119.86 4493778.2 13.78,601125.67 4493778.21 15.13,601126.03 4493778.21 15.11,601125.74 4493778.24 15.2,601123.67 4493778.26 15.01,601124.54 4493778.27 15.33,601122.76 4493778.27 14.61,601123.82 4493778.27 15.03,601120.12 4493778.28 13.78,601120.1 4493778.31 13.78,601123.49 4493778.34 14.98,601119.36 4493778.36 9.45,601120.56 4493778.36 13.96,601122.43 4493778.41 14.67,601119.09 4493778.44 4.61,601119.12 4493778.47 13.42,601121.37 4493778.48 14.25,601119.35 4493778.49 6.2,601125.46 4493778.52 15.32,601120.32 4493778.56 13.91,601120.18 4493778.56 13.86,601123.81 4493778.56 14.96,601122.17 4493778.57 14.41,601122.7 4493778.58 14.62,601123.47 4493778.59 14.94,601123.32 4493778.6 14.94,601120.94 4493778.6 14.07,601125.6 4493778.62 15.25,601126.11 4493778.62 15,601119.27 4493778.63 13.58,601119.14 4493778.63 13.44,601120.21 4493778.69 13.86,601122.27 4493778.71 14.49,601120.71 4493778.72 13.98,601126.16 4493778.74 15.02,601124.74 4493778.75 15.42,601121.75 4493778.84 14.32,601119.82 4493778.91 13.78,601122.72 4493778.91 14.7,601123.12 4493778.92 14.85,601122.96 4493778.93 14.88,601125.75 4493778.97 15.08,601124.96 4493778.99 15.33,601119.85 4493779.02 13.75,601125.15 4493779.05 15.33,601121.64 4493779.05 14.25,601125.34 4493779.05 15.31,601119.86 4493779.05 13.73,601124.44 4493779.06 15.24,601125.81 4493779.08 15.07,601123.55 4493779.08 14.99,601121.77 4493779.15 14.32,601121.58 4493779.15 14.32,601125.49 4493779.2 15.25,601122.78 4493779.24 14.72,601119.44 4493779.26 13.64,601122.58 4493779.28 14.68,601119.86 4493779.28 13.77,601126.29 4493779.29 14.97,601125.39 4493779.32 15.18,601126.31 4493779.32 14.98,601125.91 4493779.34 15.04,601125.18 4493779.34 15.28,601119.51 4493779.34 13.65,601124.8 4493779.37 15.39,601124.13 4493779.4 15.25,601125.48 4493779.4 15.21,601123.77 4493779.45 15.08,601123.12 4493779.47 14.92,601124.69 4493779.47 15.35,601119.15 4493779.47 4.56,601124.41 4493779.48 15.12,601122.74 4493779.52 14.77,601121.1 4493779.53 14.12,601123.56 4493779.53 14.93,601122.1 4493779.54 14.59,601122.46 4493779.54 14.64,601122.44 4493779.55 14.64,601120.7 4493779.57 14.09,601119.1 4493779.58 13.62,601121.72 4493779.6 14.48,601121.28 4493779.6 14.19,601121.09 4493779.61 14.28,601122.22 4493779.62 14.57,601119.18 4493779.65 13.62,601125.05 4493779.66 15.32,601120.71 4493779.68 14.07,601120.1 4493779.68 13.84,601126.42 4493779.68 14.93,601120.47 4493779.69 13.97,601124.49 4493779.72 15.37,601125.13 4493779.73 15.23,601119.68 4493779.75 13.74,601119.07 4493779.75 13.54,601125.51 4493779.81 15.16,601121.5 4493779.82 14.32,601126.03 4493779.87 14.92,601124.38 4493779.87 15.3,601122.1 4493779.87 14.51,601122.48 4493779.88 14.62,601124.82 4493779.91 15.29,601124.18 4493779.93 15.13,601121.89 4493779.93 14.54,601123.32 4493779.94 14.95,601123.9 4493779.95 15.07,601119.06 4493779.98 5.34,601123.71 4493779.99 15.07,601124.69 4493780.01 15.4,601122.25 4493780.02 14.65,601120.56 4493780.02 13.95,601125.1 4493780.02 15.39,601119.62 4493780.02 13.75,601124.2 4493780.02 15.22,601120.79 4493780.04 14.05,601124.82 4493780.05 15.41,601123.31 4493780.05 14.9,601122.61 4493780.07 14.73,601121.18 4493780.09 14.31,601121.34 4493780.11 14.3,601121.52 4493780.15 14.39,601120.14 4493780.16 13.92,601121.78 4493780.17 14.47,601125.25 4493780.17 15.31,601120.43 4493780.23 14,601119.07 4493780.23 13.57,601119.62 4493780.24 13.67,601121.53 4493780.27 14.38,601126.07 4493780.29 15.04,601119.33 4493780.31 13.69,601123.68 4493780.37 14.98,601124.31 4493780.37 15.37,601124.46 4493780.38 15.38,601118.85 4493780.4 4.58,601123.37 4493780.43 14.94,601120.31 4493780.47 13.91,601120.04 4493780.49 13.8,601121.43 4493780.49 14.34,601123.31 4493780.5 14.95,601122.22 4493780.51 14.62,601120.46 4493780.54 14.03,601121.19 4493780.58 14.32,601126.18 4493780.64 14.96,601120.23 4493780.64 13.89,601124.25 4493780.69 15.29,601124.1 4493780.72 15.31,601126.2 4493780.74 14.96,601123.9 4493780.75 15.19,601121.12 4493780.78 14.29,601121.26 4493780.78 14.24,601123.18 4493780.82 14.83,601125.98 4493780.84 14.96,601122.24 4493780.84 14.57,601124.87 4493780.9 15.28,601126.27 4493780.9 14.95,601120.84 4493780.91 14.19,601122.82 4493780.92 14.77,601123.83 4493780.96 15.22,601123.96 4493780.98 15.21,601124.86 4493780.99 15.36,601123.07 4493781.01 14.88,601122.81 4493781.03 14.8,601123.72 4493781.07 15.15,601123.52 4493781.11 15.12,601125 4493781.14 15.3,601125.76 4493781.18 15.17,601125.76 4493781.21 14.95,601126.3 4493781.21 14.78,601124.63 4493781.24 15.36,601126.41 4493781.25 14.8,601125.83 4493781.25 15.02,601125.25 4493781.28 15.2,601125.85 4493781.31 15.08,601124.14 4493781.34 15.23,601126 4493781.51 14.94,601126.11 4493781.54 14.88,601126.5 4493775.34 14.52,601126.52 4493774.77 14.51,601126.54 4493774.21 14.51,601126.74 4493774.38 14.57,601126.82 4493775.38 14.68,601126.87 4493775.18 14.71,601127.04 4493775.43 14.76,601127.05 4493774.29 14.64,601127.2 4493775.07 14.84,601127.22 4493775.01 14.82,601127.28 4493774.79 14.81,601127.28 4493775.47 14.81,601127.4 4493774.65 14.87,601127.52 4493774.51 14.87,601127.6 4493774.65 14.89,601127.64 4493774.86 14.93,601127.73 4493774.38 15.04,601128.05 4493775.35 15.11,601128.27 4493775 15.21,601128.42 4493774.58 15.19,601128.49 4493774.63 15.23,601128.75 4493774.99 15.32,601128.96 4493775.51 15.31,601129.09 4493775.28 15.37,601129.13 4493775.11 15.36,601129.37 4493774.94 15.34,601129.41 4493775.48 15.21,601129.42 4493775.5 15.42,601129.47 4493775.05 15.34,601129.48 4493775.04 15.41,601129.61 4493775.47 15.22,601129.83 4493775.07 15.21,601129.98 4493775.1 15.13,601130.22 4493775.24 14.95,601130.34 4493774.75 14.96,601130.44 4493774.92 15.07,601130.53 4493774.89 14.95,601130.58 4493775.29 14.99,601131.28 4493775.26 14.74,601131.34 4493775.2 14.66,601131.71 4493774.94 14.6,601131.88 4493775.41 14.57,601132.4 4493775.16 14.45,601132.48 4493775.17 14.25,601132.55 4493775.18 14.28,601132.6 4493775.31 14.32,601133.38 4493775.37 14.05,601134.36 4493775.47 5.3,601134.65 4493775.39 5.19,601134.7 4493775.41 8.65,601134.88 4493775.4 13.55,601135.09 4493775.43 2.28,601126.45 4493781.22 14.7,601126.45 4493775.73 14.62,601126.47 4493777.78 14.97,601126.47 4493778.26 14.88,601126.48 4493775.55 14.66,601126.49 4493778.41 14.9,601126.55 4493778.36 14.95,601126.65 4493780.87 14.83,601126.66 4493779.75 14.87,601126.67 4493778.71 14.9,601126.68 4493780.28 14.87,601126.69 4493780.49 14.79,601126.7 4493775.99 14.72,601126.71 4493780.96 14.71,601126.79 4493777.4 14.93,601126.8 4493781.37 14.75,601126.82 4493778.15 14.86,601126.84 4493777.16 14.67,601126.87 4493777.85 14.76,601126.87 4493777.88 14.9,601126.88 4493778.05 14.98,601126.89 4493781.18 14.59,601126.91 4493777.36 14.82,601126.91 4493777.75 14.84,601126.96 4493780.57 14.69,601127.02 4493780.66 14.66,601127.04 4493779.3 14.72,601127.04 4493776.18 14.85,601127.04 4493776.44 14.82,601127.05 4493780.41 14.66,601127.06 4493781.73 14.6,601127.09 4493780.79 14.6,601127.11 4493777.76 14.85,601127.14 4493780.06 14.69,601127.16 4493779.83 14.73,601127.16 4493776.79 14.82,601127.19 4493777.73 14.76,601127.2 4493776.63 14.95,601127.22 4493779.83 14.6,601127.24 4493777.52 14.74,601127.29 4493777.32 14.91,601127.29 4493780.24 14.59,601127.29 4493779.44 14.63,601127.31 4493780.76 14.58,601127.33 4493780.35 14.59,601127.39 4493779.23 14.57,601127.4 4493775.81 14.87,601127.41 4493776.9 14.92,601127.41 4493776.65 14.85,601127.52 4493781.7 14.39,601127.53 4493778.48 14.64,601127.56 4493779.79 14.48,601127.58 4493779.65 14.6,601127.59 4493777.36 14.84,601127.6 4493781.16 14.4,601127.62 4493779.37 14.52,601127.62 4493779.92 14.49,601127.64 4493780.05 14.49,601127.72 4493777.08 15.04,601127.76 4493781.82 14.38,601127.77 4493777.52 15.01,601127.8 4493775.91 15.06,601127.8 4493778.83 14.54,601127.84 4493779.7 14.35,601127.91 4493776.45 15,601127.91 4493779.78 14.23,601127.95 4493779.59 14.38,601127.97 4493778.09 14.44,601127.98 4493776.14 15.02,601127.98 4493781.32 14.41,601127.99 4493781.14 14.29,601128.01 4493779.22 14.42,601128.01 4493780.84 14.34,601128.01 4493776.56 15.17,601128.04 4493777.8 14.6,601128.05 4493777.88 14.42,601128.06 4493776.12 15.14,601128.06 4493776.94 15.18,601128.1 4493777.69 15.24,601128.12 4493778.9 14.42,601128.15 4493781.74 14.23,601128.16 4493776.67 15.2,601128.18 4493779.27 14.26,601128.19 4493780.73 14.29,601128.23 4493780.35 14.34,601128.25 4493779.87 14.32,601128.25 4493775.59 15.12,601128.26 4493776.55 15.28,601128.27 4493779.44 14.28,601128.27 4493776.91 15.22,601128.31 4493779.25 14.32,601128.32 4493777.25 15.23,601128.35 4493781.91 14.07,601128.43 4493781.75 14.2,601128.43 4493775.98 15.15,601128.45 4493779.8 14.05,601128.46 4493778.8 14.31,601128.46 4493776.57 15.26,601128.48 4493779.37 14.31,601128.49 4493779.18 14.22,601128.5 4493778.91 14.33,601128.51 4493775.94 15.25,601128.54 4493775.64 15.16,601128.58 4493778.44 14.2,601128.59 4493779.13 14.2,601128.6 4493776.26 15.32,601128.63 4493781.28 14.12,601128.63 4493778.93 14.15,601128.71 4493781.72 14,601128.72 4493778.41 14.23,601128.73 4493781.66 13.95,601128.73 4493781.54 14.01,601128.74 4493781.69 14.06,601128.74 4493777.94 14.39,601128.76 4493781.1 14.06,601128.88 4493781.33 14.13,601128.88 4493776.18 15.4,601128.89 4493775.83 15.4,601128.91 4493778.37 14.17,601128.91 4493778.81 14.07,601128.93 4493777.44 15.4,601128.98 4493778.01 15.25,601128.99 4493779.64 14.03,601128.99 4493778.58 14.08,601128.99 4493780.72 14.08,601128.99 4493776.98 15.41,601129.03 4493775.85 15.38,601129.07 4493781.38 13.94,601129.1 4493777.69 15.28,601129.1 4493776.05 15.33,601129.11 4493780.82 14.02,601129.11 4493781.17 13.95,601129.12 4493781.11 13.9,601129.13 4493781.11 14.04,601129.16 4493777.62 15.32,601129.17 4493776.47 15.38,601129.23 4493779.74 14.05,601129.23 4493776.01 15.37,601129.24 4493778.49 14,601129.27 4493775.81 15.41,601129.29 4493779.23 13.89,601129.29 4493780.92 13.92,601129.32 4493780.68 13.84,601129.34 4493778.24 14.01,601129.38 4493776.5 15.29,601129.38 4493777.82 15.25,601129.38 4493780.14 13.94,601129.4 4493777.19 15.2,601129.42 4493781.04 13.85,601129.47 4493780.81 13.8,601129.47 4493778.78 13.98,601129.56 4493778.17 13.89,601129.58 4493780.36 13.82,601129.59 4493781.97 13.8,601129.61 4493779.13 13.84,601129.62 4493779.17 13.93,601129.65 4493779.75 13.75,601129.65 4493777.8 15.22,601129.72 4493777.82 15.11,601129.74 4493780.5 13.82,601129.76 4493780.7 13.69,601129.83 4493781 13.77,601129.85 4493780.45 13.68,601129.87 4493777.35 15.12,601129.87 4493778.2 13.87,601129.94 4493781.62 13.58,601129.94 4493781.04 13.69,601129.96 4493777.72 14.97,601129.96 4493776.85 15.18,601130.05 4493781.66 13.64,601130.07 4493780.04 13.69,601130.08 4493779.89 13.72,601130.08 4493777.37 15.02,601130.08 4493777.22 15.14,601130.1 4493775.79 15.01,601130.14 4493777.96 14.89,601130.14 4493780.34 13.65,601130.16 4493779.59 13.64,601130.16 4493777.68 14.9,601130.18 4493780.07 13.7,601130.19 4493776.01 15.03,601130.2 4493775.89 15.06,601130.23 4493780.07 13.58,601130.25 4493781.07 13.52,601130.27 4493777.58 14.9,601130.29 4493780.7 13.62,601130.31 4493777.37 14.89,601130.31 4493779.09 13.67,601130.32 4493777.66 14.84,601130.33 4493776.24 15.07,601130.34 4493782.2 13.48,601130.37 4493776.87 15.02,601130.42 4493779.2 13.53,601130.42 4493780.63 13.55,601130.49 4493779.99 13.53,601130.5 4493777.35 14.83,601130.53 4493777.16 14.82,601130.53 4493779.74 13.61,601130.54 4493776.44 14.86,601130.55 4493776.93 14.96,601130.55 4493778.13 13.74,601130.58 4493779.42 13.62,601130.61 4493779.7 13.44,601130.61 4493781.62 13.42,601130.62 4493779.65 13.56,601130.69 4493777.01 14.83,601130.72 4493779.09 13.45,601130.78 4493778.78 13.49,601130.8 4493777.18 14.86,601130.85 4493777.01 14.79,601130.85 4493780.65 13.41,601130.86 4493779.71 13.37,601130.86 4493779.64 13.45,601130.87 4493776.38 14.82,601130.98 4493777.82 14.77,601130.99 4493782.18 13.2,601131.01 4493776.49 14.8,601131.02 4493779.3 13.42,601131.04 4493776.21 14.78,601131.06 4493778.95 13.45,601131.06 4493776.64 14.73,601131.07 4493779.22 13.44,601131.09 4493781.99 13.3,601131.1 4493779.67 13.45,601131.13 4493781 13.22,601131.14 4493781.58 13.19,601131.19 4493776.68 14.64,601131.22 4493776.85 14.73,601131.23 4493779.27 13.32,601131.26 4493781.48 13.26,601131.29 4493775.95 14.69,601131.29 4493777.91 14.56,601131.31 4493775.75 14.61,601131.32 4493779.53 13.27,601131.34 4493778.7 13.38,601131.36 4493777.53 14.57,601131.36 4493781.97 13.23,601131.37 4493781.04 13.15,601131.37 4493775.9 14.67,601131.37 4493781.81 13.15,601131.39 4493781.96 13.17,601131.42 4493778.91 13.34,601131.44 4493782.16 13.11,601131.44 4493776.27 14.68,601131.46 4493776.05 14.66,601131.46 4493775.9 14.67,601131.51 4493778.79 13.29,601131.51 4493780.51 13.22,601131.52 4493777.61 14.49,601131.53 4493776.35 14.54,601131.54 4493780.58 13.12,601131.55 4493779.16 13.13,601131.57 4493781.53 13.12,601131.58 4493778.93 13.15,601131.59 4493777.74 14.58,601131.6 4493778.45 13.51,601131.66 4493777.12 14.46,601131.68 4493782.12 13.11,601131.69 4493776.39 14.52,601131.73 4493781.62 13.02,601131.73 4493781.46 12.97,601131.75 4493779.55 13.21,601131.79 4493775.92 14.48,601131.81 4493779.03 13.12,601131.82 4493781.54 13.12,601131.82 4493780.72 2.31,601131.82 4493778.52 13.22,601131.83 4493776.76 14.53,601131.89 4493776 14.51,601131.92 4493781.15 13.06,601131.93 4493775.6 14.56,601131.97 4493778.55 13.13,601132 4493778.58 13.12,601132.04 4493780.34 2.4,601132.07 4493779.67 12.99,601132.07 4493781.05 13,601132.07 4493775.79 14.47,601132.1 4493780.14 2.61,601132.1 4493781.27 12.97,601132.1 4493781.77 13,601132.13 4493781.08 12.96,601132.16 4493779.84 2.73,601132.16 4493775.56 14.37,601132.16 4493780.19 13.04,601132.2 4493777.61 14.36,601132.23 4493775.67 14.37,601132.25 4493778.22 14.3,601132.26 4493781.11 12.97,601132.29 4493780.94 12.93,601132.35 4493781.54 12.84,601132.35 4493777.84 14.31,601132.35 4493780.79 12.96,601132.4 4493775.9 14.36,601132.4 4493779.22 12.93,601132.44 4493780.94 12.83,601132.45 4493777.85 14.22,601132.45 4493776.65 14.3,601132.47 4493777.47 14.19,601132.47 4493779.47 12.94,601132.48 4493777.96 14.18,601132.49 4493781 12.82,601132.5 4493780.71 12.84,601132.52 4493775.71 14.23,601132.52 4493782.3 12.81,601132.53 4493782.11 12.8,601132.57 4493780.57 12.89,601132.57 4493778.04 13.93,601132.58 4493777.12 1.98,601132.59 4493779.83 12.95,601132.65 4493780.53 12.76,601132.65 4493778.27 14.09,601132.67 4493779.13 12.79,601132.7 4493775.69 14.25,601132.71 4493777.78 14.15,601132.72 4493780.67 12.86,601132.74 4493777.58 14.07,601132.77 4493781.32 12.79,601132.79 4493777.09 14.07,601132.8 4493780.58 12.76,601132.84 4493777.36 14.11,601132.84 4493778.86 12.88,601132.86 4493782.42 5.56,601132.87 4493776.33 14.1,601132.88 4493780.34 12.75,601132.88 4493782.47 12.7,601132.89 4493777.57 14.08,601132.9 4493777.3 14.08,601132.92 4493778.98 12.76,601133 4493782.47 5.47,601133 4493777.64 14.06,601133.01 4493782.49 6.56,601133.01 4493780.34 12.75,601133.05 4493780.1 12.69,601133.05 4493777.89 14.05,601133.07 4493780.04 9.13,601133.1 4493779.78 5.93,601133.13 4493781.51 12.64,601133.14 4493779.63 6.94,601133.14 4493776.34 14.08,601133.15 4493780.24 12.63,601133.16 4493780.24 12.7,601133.16 4493779.49 2.87,601133.16 4493779.35 3.49,601133.17 4493782.49 5.48,601133.17 4493777.34 14.03,601133.18 4493779.75 8.84,601133.2 4493779.84 8,601133.21 4493779.46 5.43,601133.24 4493779.56 4.86,601133.24 4493779.98 12.55,601133.25 4493779.37 12.75,601133.27 4493782.13 5.49,601133.29 4493779.64 12.54,601133.29 4493776.92 14.08,601133.3 4493782 5.51,601133.3 4493777.16 13.98,601133.32 4493779.03 5.14,601133.33 4493779.49 9.5,601133.34 4493776.88 13.99,601133.36 4493779.08 3.62,601133.37 4493779.72 9.58,601133.37 4493777.27 13.91,601133.38 4493780.54 12.64,601133.41 4493782.2 5.59,601133.43 4493778.73 3.38,601133.44 4493782.06 5.56,601133.46 4493779.02 2.9,601133.47 4493780.88 12.55,601133.49 4493779.23 6.15,601133.5 4493779.44 8.13,601133.5 4493778.41 13.62,601133.51 4493779.89 12.51,601133.52 4493775.85 13.88,601133.54 4493779.11 2.76,601133.54 4493775.95 14.03,601133.55 4493781.54 2.82,601133.57 4493777.42 13.83,601133.57 4493779.61 12.59,601133.61 4493777.79 13.85,601133.61 4493779.8 12.52,601133.62 4493779.58 12.52,601133.63 4493776.9 13.9,601133.65 4493779.58 12.53,601133.65 4493781.23 5.57,601133.66 4493779.41 12.53,601133.68 4493782.02 5.55,601133.7 4493776.76 13.84,601133.71 4493775.67 13.86,601133.71 4493781.62 3.17,601133.74 4493777.44 13.82,601133.75 4493776.9 13.77,601133.76 4493781.56 5.55,601133.77 4493778.66 3.23,601133.83 4493778.64 2.66,601133.86 4493776.39 13.9,601133.87 4493778.77 2.43,601133.87 4493778.6 12.56,601133.88 4493781.19 2.24,601133.9 4493780.27 5.55,601133.93 4493777.06 13.63,601133.96 4493777.54 13.69,601133.98 4493776.47 13.81,601134.04 4493776.27 13.7,601134.08 4493777.63 13.78,601134.09 4493776.46 13.8,601134.12 4493779.28 2.63,601134.13 4493776.35 13.76,601134.17 4493776.5 13.77,601134.2 4493778.61 2.37,601134.23 4493775.51 13.78,601134.24 4493775.79 5.35,601134.32 4493776.68 13.76,601134.36 4493775.9 13.72,601134.37 4493778.32 3.15,601134.41 4493778.45 13.45,601134.42 4493778.29 3.02,601134.45 4493778.1 3.32,601134.48 4493777.96 5.29,601134.5 4493778.44 9.78,601134.53 4493775.95 13.57,601134.54 4493776.14 13.55,601134.55 4493776.02 13.62,601134.56 4493777.68 3.39,601134.57 4493775.71 13.66,601134.61 4493775.79 13.59,601134.62 4493775.68 8.68,601134.65 4493778.44 8.71,601134.66 4493777.48 13.44,601134.68 4493777.37 13.45,601134.69 4493777.8 2.49,601134.7 4493775.77 10.74,601134.7 4493775.55 10.53,601134.72 4493777.97 2.49,601134.77 4493777.73 13.54,601134.78 4493777.93 5.19,601134.81 4493777.7 3.29,601134.85 4493776.38 2.24,601134.9 4493776.53 13.45,601134.91 4493775.77 13.39,601134.93 4493775.63 13.48,601134.95 4493775.54 13.47,601135.04 4493775.55 13.54|

dimple · August 28, 2018, 3:34pm

Please see the modified code below. I am not able to convert list of strings to tensor format before loading into data model. Please help me.

import pandas as pd
import numpy as np


import torch
import torch.nn as nn
from torch.autograd import Variable
from torchvision import transforms
from torch.utils.data.dataset import Dataset  

from cnn_3dmodel import CNNModel




class CustomDatasetFromCSV(Dataset):
    def __init__(self, csv_path, transform=None):
        
        self.data = pd.read_csv(csv_path)
        self.labels = np.asarray(self.data.iloc[:, 0])
        #self.points = np.asarray(self.data.iloc[:, 1])
        self.transform = transform
	
	
    def __getitem__(self, index):
        data_labels = self.labels[index]
        data_points = np.asarray(df.iloc[:, 1]) 
        mat = []
	for i in data_points:
 	  	 row = i.split(',')
   		 mat.append(row)
	print(mat)  
	point_t=torch.FloatTensor(mat)
	print(point_t)
        return (points_t, data_labels)
                

    def __len__(self):
        return len(self.data.index)


if __name__ == "__main__":

    #transformations = transforms.Compose([transforms.ToTensor()])

    #custom_b_from_csv = \
    	#CustomDatasetFromCSV('train.csv',transformations)

    b_dataset_loader = torch.utils.data.DataLoader(dataset= "train.csv",batch_size=10,shuffle=False)

    model = CNNModel()
    criterion = nn.CrossEntropyLoss()
    optimizer = torch.optim.SGD(model.parameters(), lr=0.01)

    for i, (points_t, data_labels) in enumerate(b_dataset_loader):
        points = Variable(points_t)
        labels = Variable(data_labels)
        # Clear gradients
        optimizer.zero_grad()
        # Forward pass
        outputs = model(points)
        # Calculate loss
        loss = criterion(outputs, labels)
        # Backward pass
        loss.backward()
        # Update weights
        optimizer.step()
	break

ptrblck · August 28, 2018, 4:15pm

You could try the following code to load your data:

data = pd.read_csv(
    './3d.csv',
    sep='\|', skiprows=2, engine='python', names=['labels', 'points',],
    usecols=[1, 2])

labels = torch.from_numpy(data['labels'].values)
points = data['points'].apply(lambda x: np.array([float(x_) for x_ in re.split(',|\s', x)]))
nb_samples = len(points)
points = torch.from_numpy(np.stack(points.values).reshape(nb_samples, -1, 3)).float()

dimple · August 28, 2018, 4:25pm

first line —data is not correct
points
0 NaN
1 NaN
2 NaN
3 NaN
4 NaN

when i executed it fully
Traceback (most recent call last):
File “classfn3dcsv1.py”, line 16, in
labels = torch.from_numpy(data[‘labels’].values)
File “/home/raman/miniconda2/lib/python2.7/site-packages/pandas/core/frame.py”, line 2688, in getitem
return self._getitem_column(key)
File “/home/raman/miniconda2/lib/python2.7/site-packages/pandas/core/frame.py”, line 2695, in _getitem_column
return self._get_item_cache(key)
File “/home/raman/miniconda2/lib/python2.7/site-packages/pandas/core/generic.py”, line 2489, in _get_item_cache
values = self._data.get(item)
File “/home/raman/miniconda2/lib/python2.7/site-packages/pandas/core/internals.py”, line 4115, in get
loc = self.items.get_loc(item)
File “/home/raman/miniconda2/lib/python2.7/site-packages/pandas/core/indexes/base.py”, line 3080, in get_loc
return self._engine.get_loc(self._maybe_cast_indexer(key))
File “pandas/_libs/index.pyx”, line 140, in pandas._libs.index.IndexEngine.get_loc
File “pandas/_libs/index.pyx”, line 162, in pandas._libs.index.IndexEngine.get_loc
File “pandas/_libs/hashtable_class_helper.pxi”, line 1492, in pandas._libs.hashtable.PyObjectHashTable.get_item
File “pandas/_libs/hashtable_class_helper.pxi”, line 1500, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: ‘labels’

ptrblck · August 28, 2018, 4:28pm

That’s strange as I’ve used your example and just copied the line a few times.
Could you try it with the example you’ve posted here and check if it works?

dimple · August 28, 2018, 4:35pm

i have taken this datas from the RoofN3D dataset which is publicly available. there i modified the roofn3d_buildings.csv file. could you pls check with this file

dimple · August 30, 2018, 7:01am

cud u pls try this. i have pasted rows seperately by cutting down some points in both rows

|labels|points|
|---|---|
|1|601120.23 4493773.37 12.44,601120.43 4493773.53 12.54,601121.12 4493773.54 12.61,601120.38 4493773.61 12.42,601121.75 4493773.69 13.02,601119.95 4493773.69 8.07,601122.15 4493773.74 13.1,601122.31 4493773.76 13.2,601120.74 4493773.77 12.61,601123.25 4493773.8 13.52,601119.71 4493773.84 12.32,601121.97 4493773.87 13,601122.2 4493773.88 13.15,601124.01 4493773.88 13.62,601122.33 4493773.91 13.2,601120.94 4493773.92 12.61,601121.14 4493773.95 12.74,601123.01 4493773.99 13.32,601125.07 4493774.02 14.08,601120.06 4493774.02 12.44,601120.58 4493774.03 12.44,601123.98 4493774.1 13.63,601123.98 4493774.11 13.7,601121.85 4493774.18 12.94,601121.07 4493774.18 12.72,601122.88 4493774.19 13.37,601124.75 4493774.23 13.98,601119.89 4493774.24 5.31,601121.79 4493774.27 13,601124.67 4493774.27 13.88,601125.69 4493774.27 14.23,601121.92 4493774.29 13.07,601119.67 4493774.31 5.18,601124.8 4493774.33 13.95,601122.78 4493774.33 13.31,601123.76 4493774.35 13.52,601119.98 4493774.35 12.4,601120.69 4493774.36 12.67,601120.44 4493774.37 12.46,601123.45 4493774.38 13.47,601121.12 4493774.44 12.71,601120.05 4493774.51 12.34,601121.43 4493774.57 12.87,601120.13 4493774.59 12.43,601124.28 4493774.65 13.9,601121.53 4493774.66 12.99,601124.4 4493774.69 13.82,601123.67 4493774.7 13.61,601124.82 4493774.71 13.96,601126.4 4493774.72 14.55,601121.91 4493774.72 13.03,601126.25 4493774.76 14.36,601125.39 4493774.79 14.23,601123.25 4493774.8 13.35,601119.93 4493774.82 12.27,601124.38 4493774.85 13.91,601121.73 4493774.85 12.91,601122.89 4493774.88 13.29,601125.7 4493774.88 14.36,601123.36 4493774.92 13.58,601121.02 4493774.96 12.78,601122.77 4493774.96 13.24,601122.36 4493774.99 13.22,601121.11 4493775.04 12.79,601123.84 4493775.05 13.7,601123.73 4493775.05 13.65,601121.35 4493775.06 12.86,601124.01 4493775.06 13.73,601120.33 4493775.13 12.57,601126.14 4493775.15 14.55,601120.82 4493775.16 12.67,601126.3 4493775.17 14.47,601124.51 4493775.19 13.97,601125.09 4493775.22 14.1,601125.45 4493775.22 14.15,601126 4493775.23 14.36,601125.7 4493775.26 14.24,601122.74 4493775.26 13.21,601119.89 4493775.29 7.84,601124.02 4493775.29 13.76,601122.53 4493775.3 13.27,601119.74 4493775.32 12.36,601120.59 4493775.35 12.62,601122.96 4493775.36 13.43,601122.36 4493775.37 13.16,601120.71 4493775.41 12.64,601120.88 4493775.41 12.64,601121.9 4493775.43 13.1,601123.61 4493775.43 13.58,601123.44 4493775.43 13.65,601126.01 4493775.5 14.42,601120.83 4493775.51 12.73,601119.89 4493775.57 12.31,601124.97 4493775.58 14.13,601119.77 4493775.58 12.45,601123.96 4493775.65 13.8,601123.42 4493775.67 13.61,601124.57 4493775.67 13.92,601121.67 4493775.68 12.99,601125.49 4493775.69 14.22,601122.24 4493775.71 13.05,601122.93 4493775.73 13.45,601120.17 4493775.75 12.48,601125.14 4493775.77 14.07,601120.31 4493775.78 12.5,601123.22 4493775.79 13.49,601119.6 4493775.8 5.25,601121.91 4493775.81 13.07,601121.48 4493775.82 12.89,601123.01 4493775.83 13.47,601125.46 4493775.84 14.29,601121.8 4493775.87 12.99,601120.89 4493775.89 12.71,601126.07 4493775.93 14.55,601122.52 4493775.94 13.23,601119.85 4493775.96 12.41,601123.49 4493776.02 13.54,601125.61 4493776.08 14.34,601126.06 4493776.09 14.47,601119.83 4493776.09 12.63,601119.94 4493776.13 12.45,601120.58 4493776.13 12.67,601122.84 4493776.15 13.43,601126.06 4493776.15 14.46,601124.53 4493776.16 13.94,601124.96 4493776.16 14.03,601124.27 4493776.16 13.9,601121.73 4493776.17 12.94,601125.21 4493776.18 14.12,601122.59 4493776.22 13.29,601123.43 4493776.24 13.62,601126.04 4493776.25 14.49,601122.3 4493776.26 13.2,601124.58 4493776.27 13.91,601119.7 4493776.29 13.67,601119.51 4493776.29 13.5,601119.46 4493776.3 7.66,601119.85 4493776.3 13.56,601125.66 4493776.31 14.4,601126.25 4493776.31 14.47,601125.02 4493776.32 14.17,601122.34 4493776.33 13.24,601121.26 4493776.36 12.84,601120.6 4493776.38 13.63,601124.01 4493776.39 13.85,601121.24 4493776.4 13.01,601120.03 4493776.44 13.43,601125.69 4493776.44 14.39,601122.42 4493776.44 14.16,601123.01 4493776.46 13.49,601122.5 4493776.47 13.48,601121.99 4493776.52 13.14,601119.6 4493776.53 13.5,601120.96 4493776.59 12.87,601121.26 4493776.6 12.89,601124.47 4493776.61 13.94,601119.51 4493776.63 13.62,601119.82 4493776.64 13.61,601122.42 4493776.64 14.55,601123.18 4493776.64 13.71,601124.33 4493776.64 13.88,601121.06 4493776.67 13.99,601125.27 4493776.67 14.27,601121.43 4493776.67 14.14,601126.16 4493776.7 14.52,601122.13 4493776.75 14.46,601119.53 4493776.76 8.97,601125.35 4493776.76 14.4,601125.08 4493776.77 14.27,601124.01 4493776.78 13.72,601121.2 4493776.78 14.04,601119.46 4493776.81 8.14,601125.21 4493776.82 14.44,601124.03 4493776.84 13.84,601125.19 4493776.84 15.41,601121.08 4493776.89 13.96,601122.93 4493776.91 13.84,601122.24 4493776.91 14.46,601125.25 4493776.93 15.39,601121.76 4493776.96 14.31,601122.04 4493776.99 14.43,601123.21 4493776.99 14.74,601124.09 4493777 14.35,601120.7 4493777.03 14,601119.65 4493777.1 13.7,601120.35 4493777.1 13.83,601123.79 4493777.11 14.86,601121.73 4493777.12 14.34,601125.82 4493777.12 15.07,601124.03 4493777.14 15.05,601124.93 4493777.14 15.26,601120.51 4493777.16 13.78,601124.81 4493777.2 15.33,601122.06 4493777.23 14.38,601119.26 4493777.25 13.49,601124.91 4493777.26 15.38,601125.98 4493777.28 15.22,601119.25 4493777.29 8.24,601120.58 4493777.33 13.79,601120.35 4493777.34 13.81,601121.65 4493777.35 14.24,601123.76 4493777.37 14.87,601126.2 4493777.38 15,601125.07 4493777.41 15.38,601124.04 4493777.48 15.15,601121.35 4493777.48 14.24,601119.36 4493777.5 13.44,601124.44 4493777.55 15.25,601123.02 4493777.56 14.75,601123.26 4493777.59 14.76,601124.55 4493777.59 15.31,601126.42 4493777.6 15.05,601124.04 4493777.6 15.09,601122.94 4493777.61 14.78,601119.99 4493777.63 13.65,601121.19 4493777.63 14.1,601122 4493777.64 14.39,601121.29 4493777.68 14.16,601120.96 4493777.71 14.1,601120.96 4493777.75 14.02,601120.11 4493777.76 13.71,601119.94 4493777.79 13.76,601124.98 4493777.79 15.41,601126.02 4493777.81 15.07,601123.26 4493777.81 14.74,601120.95 4493777.85 14.06,601124.92 4493777.87 15.38,601122 4493777.87 14.31,601125.66 4493777.89 15.16,601124.04 4493777.92 15.08,601123.9 4493777.93 15.14,601124.18 4493777.93 15.19,601124.49 4493777.94 15.27,601122.97 4493777.94 14.72,601122.9 4493778 14.76,601123.4 4493778.03 14.87,601120.91 4493778.03 14,601125.94 4493778.06 15.19,601121.88 4493778.07 14.46,601119.45 4493778.08 9.69,601120.1 4493778.08 13.76,601122.7 4493778.09 14.53,601125.58 4493778.09 15.3,601124.69 4493778.09 15.21,601119.47 4493778.1 13.54,601123.79 4493778.1 15,601122.31 4493778.11 14.5,601120.87 4493778.14 14.11,601119.62 4493778.19 13.57,601120.59 4493778.19 14.04,601121.82 4493778.19 14.37,601121.2 4493778.2 14.15,601119.86 4493778.2 13.78,601125.67 4493778.21 15.13,601126.03 4493778.21 15.11,601125.74 4493778.24 15.2,601123.67 4493778.26 15.01,601124.54 4493778.27 15.33,601122.76 4493778.27 14.61,601123.82 4493778.27 15.03,601120.12 4493778.28 13.78,601120.1 4493778.31 13.78,601123.49 4493778.34 14.98,601119.36 4493778.36 9.45,601120.56 4493778.36 13.96,601122.43 4493778.41 14.67,601119.09 4493778.44 4.61,601119.12 4493778.47 13.42,601121.37 4493778.48 14.25,601119.35 4493778.49 6.2,601125.46 4493778.52 15.32,601120.32 4493778.56 13.91,601120.18 4493778.56 13.86,601123.81 4493778.56 14.96,601122.17 4493778.57 14.41,601122.7 4493778.58 14.62,601123.47 4493778.59 14.94,601123.32 4493778.6 14.94,601120.94 4493778.6 14.07,601125.6 4493778.62 15.25,601126.11 4493778.62 15,601119.27 4493778.63 13.58,601119.14 4493778.63 13.44,601120.21 4493778.69 13.86,601122.27 4493778.71 14.49,601120.71 4493778.72 13.98,601126.16 4493778.74 15.02,601124.74 4493778.75 15.42,601121.75 4493778.84 14.32,601119.82 4493778.91 13.78,601122.72 4493778.91 14.7,601123.12 4493778.92 14.85,601122.96 4493778.93 14.88,601125.75 4493778.97 15.08,601124.96 4493778.99 15.33,601119.85 4493779.02 13.75,601125.15 4493779.05 15.33,601121.64 4493779.05 14.25,601125.34 4493779.05 15.31,601119.86 4493779.05 13.73,601124.44 4493779.06 15.24,601125.81 4493779.08 15.07,601123.55 4493779.08 14.99,601121.77 4493779.15 14.32,601121.58 4493779.15 14.32,601125.49 4493779.2 15.25,601122.78 4493779.24 14.72,601119.44 4493779.26 13.64,601122.58 4493779.28 14.68,601119.86 4493779.28 13.77,601126.29 4493779.29 14.97,601125.39 4493779.32 15.18,601126.31 4493779.32 14.98,601125.91 4493779.34 15.04,601125.18 4493779.34 15.28,601119.51 4493779.34 13.65,601124.8 4493779.37 15.39,601124.13 4493779.4 15.25,601125.48 4493779.4 15.21,601123.77 4493779.45 15.08,601123.12 4493779.47 14.92,601124.69 4493779.47 15.35,601119.15 4493779.47 4.56,601124.41 4493779.48 15.12,601122.74 4493779.52 14.77,601121.1 4493779.53 14.12,601123.56 4493779.53 14.93,601122.1 4493779.54 14.59,601122.46 4493779.54 14.64,601122.44 4493779.55 14.64,601120.7 4493779.57 14.09,601119.1 4493779.58 13.62,601121.72 4493779.6 14.48,601121.28 4493779.6 14.19,601121.09 4493779.61 14.28,601122.22 4493779.62 14.57,601119.18 4493779.65 13.62,601125.05 4493779.66 15.32,601120.71 4493779.68 14.07,601120.1 4493779.68 13.84,601126.42 4493779.68 14.93,601120.47 4493779.69 13.97,601124.49 4493779.72 15.37,601125.13 4493779.73 15.23,601119.68 4493779.75 13.74,601119.07 4493779.75 13.54,601125.51 4493779.81 15.16,601121.5 4493779.82 14.32,601126.03 4493779.87 14.92,601124.38 4493779.87 15.3,601122.1 4493779.87 14.51,601122.48 4493779.88 14.62,601124.82 4493779.91 15.29,601124.18 4493779.93 15.13,601121.89 4493779.93 14.54,601123.32 4493779.94 14.95,601123.9 4493779.95 15.07,601119.06 4493779.98 5.34,601123.71 4493779.99 15.07,601124.69 4493780.01 15.4,601122.25 4493780.02 14.65,601120.56 4493780.02 13.95,601125.1 4493780.02 15.39,601119.62 4493780.02 13.75,601124.2 4493780.02 15.22,601120.79 4493780.04 14.05,601124.82 4493780.05 15.41,601123.31 4493780.05 14.9,601122.61 4493780.07 14.73,601121.18 4493780.09 14.31,601121.34 4493780.11 14.3,601121.52 4493780.15 14.39,601120.14 4493780.16 13.92,601121.78 4493780.17 14.47,601125.25 4493780.17 15.31,601120.43 4493780.23 14,601119.07 4493780.23 13.57,601119.62 4493780.24 13.67,601121.53 4493780.27 14.38,601126.07 4493780.29 15.04,601119.33 4493780.31 13.69,601123.68 4493780.37 14.98,601124.31 4493780.37 15.37,601124.46 4493780.38 15.38,601118.85 4493780.4 4.58,601123.37 4493780.43 14.94,601120.31 4493780.47 13.91,601120.04 4493780.49 13.8,601121.43 4493780.49 14.34,601123.31 4493780.5 14.95,601122.22 4493780.51 14.62,601120.46 4493780.54 14.03,601121.19 4493780.58 14.32,601126.18 4493780.64 14.96,601120.23 4493780.64 13.89,601124.25 4493780.69 15.29,601124.1 4493780.72 15.31,601126.2 4493780.74 14.96,601123.9 4493780.75 15.19,601121.12 4493780.78 14.29,601121.26 4493780.78 14.24,601123.18 4493780.82 14.83,601125.98 4493780.84 14.96,601122.24 4493780.84 14.57,601124.87 4493780.9 15.28,601126.27 4493780.9 14.95,601120.84 4493780.91 14.19,601122.82 4493780.92 14.77,601123.83 4493780.96 15.22,601123.96 4493780.98 15.21,601124.86 4493780.99 15.36,601123.07 4493781.01 14.88,601122.81 4493781.03 14.8,601123.72 4493781.07 15.15,601123.52 4493781.11 15.12,601125 4493781.14 15.3,601125.76 4493781.18 15.17,601125.76 4493781.21 14.95,601126.3 4493781.21 14.78,601124.63 4493781.24 15.36,601126.41 4493781.25 14.8,601125.83 4493781.25 15.02,601125.25 4493781.28 15.2,601125.85 4493781.31 15.08,601124.14 4493781.34 15.23,601126 4493781.51 14.94,601126.11 4493781.54 14.88,601126.5 4493775.34 14.52,601126.52 4493774.77 14.51,601126.54 4493774.21 14.51,601126.74 4493774.38 14.57,601126.82 4493775.38 14.68,601126.87 4493775.18 14.71,601127.04 4493775.43 14.76,601127.05 4493774.29 14.64,601127.2 4493775.07 14.84,601127.22 4493775.01 14.82,601127.28 4493774.79 14.81,601127.28 4493775.47 14.81,601127.4 4493774.65 14.87,601127.52 4493774.51 14.87,601127.6 4493774.65 14.89,601127.64 4493774.86 14.93,601127.73 4493774.38 15.04,601128.05 4493775.35 15.11,601128.27 4493775 15.21,601128.42 4493774.58 15.19,601128.49 4493774.63 15.23,601128.75 4493774.99 15.32,601128.96 4493775.51 15.31,601129.09 4493775.28 15.37,601129.13 4493775.11 15.36,601129.37 4493774.94 15.34,601129.41 4493775.48 15.21,601129.42 4493775.5 15.42,601129.47 4493775.05 15.34,601129.48 4493775.04 15.41,601129.61 4493775.47 15.22,601129.83 4493775.07 15.21,601129.98 4493775.1 15.13,601130.22 4493775.24 14.95,601130.34 4493774.75 14.96,601130.44 4493774.92 15.07,601130.53 4493774.89 14.95,601130.58 4493775.29 14.99,601131.28 4493775.26 14.74,601131.34 4493775.2 14.66,601131.71 4493774.94 14.6,601131.88 4493775.41 14.57,601132.4 4493775.16 14.45,601132.48 4493775.17 14.25,601132.55 4493775.18 14.28,601132.6 4493775.31 14.32,601133.38 4493775.37 14.05,601134.36 4493775.47 5.3,601134.65 4493775.39 5.19,601134.7 4493775.41 8.65,601134.88 4493775.4 13.55,601135.09 4493775.43 2.28,601126.45 4493781.22 14.7,601126.45 4493775.73 14.62,601126.47 4493777.78 14.97,601126.47 4493778.26 14.88,601126.48 4493775.55 14.66,601126.49 4493778.41 14.9,601126.55 4493778.36 14.95,601126.65 4493780.87 14.83,601126.66 4493779.75 14.87,601126.67 4493778.71 14.9,601126.68 4493780.28 14.87,601126.69 4493780.49 14.79,601126.7 4493775.99 14.72,601126.71 4493780.96 14.71,601126.79 4493777.4 14.93,601126.8 4493781.37 14.75,601126.82 4493778.15 14.86,601126.84 4493777.16 14.67,601126.87 4493777.85 14.76,601126.87 4493777.88 14.9,601126.88 4493778.05 14.98,601126.89 4493781.18 14.59,601126.91 4493777.36 14.82,601126.91 4493777.75 14.84,601126.96 4493780.57 14.69,601127.02 4493780.66 14.66,601127.04 4493779.3 14.72,601127.04 4493776.18 14.85,601127.04 4493776.44 14.82,601127.05 4493780.41 14.66,601127.06 4493781.73 14.6,601127.09 4493780.79 14.6,601127.11 4493777.76 14.85,601127.14 4493780.06 14.69,601127.16 4493779.83 14.73,601127.16 4493776.79 14.82,601127.19 4493777.73 14.76,601127.2 4493776.63 14.95,601127.22 4493779.83 14.6,601127.24 4493777.52 14.74,601127.29 4493777.32 14.91,601127.29 4493780.24 14.59,601127.29 4493779.44 14.63,601127.31 4493780.76 14.58,601127.33 4493780.35 14.59,601127.39 4493779.23 14.57,601127.4 4493775.81 14.87,601127.41 4493776.9 14.92,601127.41 4493776.65 14.85,601127.52 4493781.7 14.39,601127.53 4493778.48 14.64,601127.56 4493779.79 14.48,601127.58 4493779.65 14.6,601127.59 4493777.36 14.84,601127.6 4493781.16 14.4,601127.62 4493779.37 14.52,601127.62 4493779.92 14.49,601127.64 4493780.05 14.49,601127.72 4493777.08 15.04,601127.76 4493781.82 14.38,601127.77 4493777.52 15.01,601127.8 4493775.91 15.06,601127.8 4493778.83 14.54,601127.84 4493779.7 14.35,601127.91 4493776.45 15,601127.91 4493779.78 14.23,601127.95 4493779.59 14.38,601127.97 4493778.09 14.44,601127.98 4493776.14 15.02,601127.98 4493781.32 14.41,601127.99 4493781.14 14.29,601128.01 4493779.22 14.42,601128.01 4493780.84 14.34,601128.01 4493776.56 15.17,601128.04 4493777.8 14.6,601128.05 4493777.88 14.42,601128.06 4493776.12 15.14,601128.06 4493776.94 15.18,601128.1 4493777.69 15.24,601128.12 4493778.9 14.42,601128.15 4493781.74 14.23,601128.16 4493776.67 15.2,601128.18 4493779.27 14.26,601128.19 4493780.73 14.29,601128.23 4493780.35 14.34,601128.25 4493779.87 14.32,601128.25 4493775.59 15.12,601128.26 4493776.55 15.28,601128.27 4493779.44 14.28,601128.27 4493776.91 15.22,601128.31 4493779.25 14.32,601128.32 4493777.25 15.23,601128.35 4493781.91 14.07,601128.43 4493781.75 14.2,601128.43 4493775.98 15.15,601128.45 4493779.8 14.05,601128.46 4493778.8 14.31,601128.46 4493776.57 15.26,601128.48 4493779.37 14.31,601128.49 4493779.18 14.22,601128.5 4493778.91 14.33,601128.51 4493775.94 15.25,601128.54 4493775.64 15.16,601128.58 4493778.44 14.2,601128.59 4493779.13 14.2,601128.6 4493776.26 15.32,601128.63 4493781.28 14.12,601128.63 4493778.93 14.15,601128.71 4493781.72 14,601128.72 4493778.41 14.23,601128.73 4493781.66 13.95,601128.73 4493781.54 14.01,601128.74 4493781.69 14.06,601128.74 4493777.94 14.39,601128.76 4493781.1 14.06,601128.88 4493781.33 14.13,601128.88 4493776.18 15.4,601128.89 4493775.83 15.4,601128.91 4493778.37 14.17,601128.91 4493778.81 14.07,601128.93 4493777.44 15.4,601128.98 4493778.01 15.25,601128.99 4493779.64 14.03,601128.99 4493778.58 14.08,601128.99 4493780.72 14.08,601128.99 4493776.98 15.41,601129.03 4493775.85 15.38,601129.07 4493781.38 13.94,601129.1 4493777.69 15.28,601129.1 4493776.05 15.33,601129.11 4493780.82 14.02,601129.11 4493781.17 13.95,601129.12 4493781.11 13.9,601129.13 4493781.11 14.04,601129.16 4493777.62 15.32,601129.17 4493776.47 15.38,601129.23 4493779.74 14.05,601129.23 4493776.01 15.37,601129.24 4493778.49 14,601129.27 4493775.81 15.41,601129.29 4493779.23 13.89,601129.29 4493780.92 13.92,601129.32 4493780.68 13.84,601129.34 4493778.24 14.01,601129.38 4493776.5 15.29,601129.38 4493777.82 15.25,601129.38 4493780.14 13.94,601129.4 4493777.19 15.2,601129.42 4493781.04 13.85,601129.47 4493780.81 13.8,601129.47 4493778.78 13.98,601129.56 4493778.17 13.89,601129.58 4493780.36 13.82,601129.59 4493781.97 13.8,601129.61 4493779.13 13.84,601129.62 4493779.17 13.93,601129.65 4493779.75 13.75,601129.65 4493777.8 15.22,601129.72 4493777.82 15.11,601129.74 4493780.5 13.82,601129.76 4493780.7 13.69,601129.83 4493781 13.77,601129.85 4493780.45 13.68,601129.87 4493777.35 15.12,601129.87 4493778.2 13.87,601129.94 4493781.62 13.58,601129.94 4493781.04 13.69,601129.96 4493777.72 14.97,601129.96 4493776.85 15.18,601130.05 4493781.66 13.64,601130.07 4493780.04 13.69,601130.08 4493779.89 13.72,601130.08 4493777.37 15.02,601130.08 4493777.22 15.14,601130.1 4493775.79 15.01,601130.14 4493777.96 14.89,601130.14 4493780.34 13.65,601130.16 4493779.59 13.64,601130.16 4493777.68 14.9,601130.18 4493780.07 13.7,601130.19 4493776.01 15.03,601130.2 4493775.89 15.06,601130.23 4493780.07 13.58,601130.25 4493781.07 13.52,601130.27 4493777.58 14.9,601130.29 4493780.7 13.62,601130.31 4493777.37 14.89,601130.31 4493779.09 13.67,601130.32 4493777.66 14.84,601130.33 4493776.24 15.07,601130.34 4493782.2 13.48,601130.37 4493776.87 15.02,601130.42 4493779.2 13.53,601130.42 4493780.63 13.55,601130.49 4493779.99 13.53,601130.5 4493777.35 14.83,601130.53 4493777.16 14.82,601130.53 4493779.74 13.61,601130.54 4493776.44 14.86,601130.55 4493776.93 14.96,601130.55 4493778.13 13.74,601130.58 4493779.42 13.62,601130.61 4493779.7 13.44,601130.61 4493781.62 13.42,601130.62 4493779.65 13.56,601130.69 4493777.01 14.83,601130.72 4493779.09 13.45,601130.78 4493778.78 13.49,601130.8 4493777.18 14.86,601130.85 4493777.01 14.79,601130.85 4493780.65 13.41,601130.86 4493779.71 13.37,601130.86 4493779.64 13.45,601130.87 4493776.38 14.82,601130.98 4493777.82 14.77,601130.99 4493782.18 13.2,601131.01 4493776.49 14.8,601131.02 4493779.3 13.42,601131.04 4493776.21 14.78,601131.06 4493778.95 13.45,601131.06 4493776.64 14.73,601131.07 4493779.22 13.44,601131.09 4493781.99 13.3,601131.1 4493779.67 13.45,601131.13 4493781 13.22,601131.14 4493781.58 13.19,601131.19 4493776.68 14.64,601131.22 4493776.85 14.73,601131.23 4493779.27 13.32,601131.26 4493781.48 13.26,601131.29 4493775.95 14.69,601131.29 4493777.91 14.56,601131.31 4493775.75 14.61,601131.32 4493779.53 13.27,601131.34 4493778.7 13.38,601131.36 4493777.53 14.57,601131.36 4493781.97 13.23,601131.37 4493781.04 13.15,601131.37 4493775.9 14.67,601131.37 4493781.81 13.15,601131.39 4493781.96 13.17,601131.42 4493778.91 13.34,601131.44 4493782.16 13.11,601131.44 4493776.27 14.68,601131.46 4493776.05 14.66,601131.46 4493775.9 14.67,601131.51 4493778.79 13.29,601131.51 4493780.51 13.22,601131.52 4493777.61 14.49,601131.53 4493776.35 14.54,601131.54 4493780.58 13.12,601131.55 4493779.16 13.13,601131.57 4493781.53 13.12,601131.58 4493778.93 13.15,601131.59 4493777.74 14.58,601131.6 4493778.45 13.51,601131.66 4493777.12 14.46,601131.68 4493782.12 13.11,601131.69 4493776.39 14.52,601131.73 4493781.62 13.02,601131.73 4493781.46 12.97,601131.75 4493779.55 13.21,601131.79 4493775.92 14.48,601131.81 4493779.03 13.12,601131.82 4493781.54 13.12,601131.82 4493780.72 2.31,601131.82 4493778.52 13.22,601131.83 4493776.76 14.53,601131.89 4493776 14.51,601131.92 4493781.15 13.06,601131.93 4493775.6 14.56,601131.97 4493778.55 13.13,601132 4493778.58 13.12,601132.04 4493780.34 2.4,601132.07 4493779.67 12.99,601132.07 4493781.05 13,601132.07 4493775.79 14.47,601132.1 4493780.14 2.61,601132.1 4493781.27 12.97,601132.1 4493781.77 13,601132.13 4493781.08 12.96,601132.16 4493779.84 2.73,601132.16 4493775.56 14.37,601132.16 4493780.19 13.04,601132.2 4493777.61 14.36,601132.23 4493775.67 14.37,601132.25 4493778.22 14.3,601132.26 4493781.11 12.97,601132.29 4493780.94 12.93,601132.35 4493781.54 12.84,601132.35 4493777.84 14.31,601132.35 4493780.79 12.96,601132.4 4493775.9 14.36,601132.4 4493779.22 12.93,601132.44 4493780.94 12.83,601132.45 4493777.85 14.22,601132.45 4493776.65 14.3,601132.47 4493777.47 14.19,601132.47 4493779.47 12.94,601132.48 4493777.96 14.18,601132.49 4493781 12.82,601132.5 4493780.71 12.84,601132.52 4493775.71 14.23,601132.52 4493782.3 12.81,601132.53 4493782.11 12.8,601132.57 4493780.57 12.89,601132.57 4493778.04 13.93,601132.58 4493777.12 1.98,601132.59 4493779.83 12.95,601132.65 4493780.53 12.76,601132.65 4493778.27 14.09,601132.67 4493779.13 12.79,601132.7 4493775.69 14.25,601132.71 4493777.78 14.15,601132.72 4493780.67 12.86,601132.74 4493777.58 14.07,601132.77 4493781.32 12.79,601132.79 4493777.09 14.07,601132.8 4493780.58 12.76,601132.84 4493777.36 14.11,601132.84 4493778.86 12.88,601132.86 4493782.42 5.56,601132.87 4493776.33 14.1,601132.88 4493780.34 12.75,601132.88 4493782.47 12.7,601132.89 4493777.57 14.08,601132.9 4493777.3 14.08,601132.92 4493778.98 12.76,601133 4493782.47 5.47,601133 4493777.64 14.06,601133.01 4493782.49 6.56,601133.01 4493780.34 12.75,601133.05 4493780.1 12.69,601133.05 4493777.89 14.05,601133.07 4493780.04 9.13,601133.1 4493779.78 5.93,601133.13 4493781.51 12.64,601133.14 4493779.63 6.94,601133.14 4493776.34 14.08,601133.15 4493780.24 12.63,601133.16 4493780.24 12.7,601133.16 4493779.49 2.87,601133.16 4493779.35 3.49,601133.17 4493782.49 5.48,601133.17 4493777.34 14.03,601133.18 4493779.75 8.84,601133.2 4493779.84 8,601133.21 4493779.46 5.43,601133.24 4493779.56 4.86,601133.24 4493779.98 12.55,601133.25 4493779.37 12.75,601133.27 4493782.13 5.49,601133.29 4493779.64 12.54,601133.29 4493776.92 14.08,601133.3 4493782 5.51,601133.3 4493777.16 13.98,601133.32 4493779.03 5.14,601133.33 4493779.49 9.5,601133.34 4493776.88 13.99,601133.36 4493779.08 3.62,601133.37 4493779.72 9.58,601133.37 4493777.27 13.91,601133.38 4493780.54 12.64,601133.41 4493782.2 5.59,601133.43 4493778.73 3.38,601133.44 4493782.06 5.56,601133.46 4493779.02 2.9,601133.47 4493780.88 12.55,601133.49 4493779.23 6.15,601133.5 4493779.44 8.13,601133.5 4493778.41 13.62,601133.51 4493779.89 12.51,601133.52 4493775.85 13.88,601133.54 4493779.11 2.76,601133.54 4493775.95 14.03,601133.55 4493781.54 2.82,601133.57 4493777.42 13.83,601133.57 4493779.61 12.59,601133.61 4493777.79 13.85,601133.61 4493779.8 12.52,601133.62 4493779.58 12.52,601133.63 4493776.9 13.9,601133.65 4493779.58 12.53,601133.65 4493781.23 5.57,601133.66 4493779.41 12.53,601133.68 4493782.02 5.55,601133.7 4493776.76 13.84,601133.71 4493775.67 13.86,601133.71 4493781.62 3.17,601133.74 4493777.44 13.82,601133.75 4493776.9 13.77,601133.76 4493781.56 5.55,601133.77 4493778.66 3.23,601133.83 4493778.64 2.66

1	604916.47 4494396.11 11.58,604916.02 4494396.13 11.84,604915.03 4494396.15 11.58,604915.87 4494396.19 11.44,604914.49 4494396.23 11.45,604917.41 4494396.35 11.48,604916.41 4494396.36 11.49,604915.42 4494396.37 11.61,604914.42 4494396.39 11.48,604914.5 4494396.41 11.53,604918.58 4494396.62 11.52,604918.04 4494396.68 11.42,604919.2 4494396.71 11.67,604918.24 4494396.71 11.65,604914.45 4494396.72 11.93,604917.31 4494396.73 11.43,604915.41 4494396.73 11.56,604916.37 4494396.74 11.28,604915.64 4494396.81 11.53,604917.91 4494396.87 11.73,604919.55 4494396.9 11.51,604918.57 4494396.9 11.67,604917.62 4494396.92 11.54,604916.65 4494396.92 11.73,604915.7 4494396.96 11.46,604914.74 4494396.97 11.48,604916.09 4494397.05 11.48,604918.52 4494397.08 11.91,604915.45 4494397.11 11.51,604916.01 4494397.13 11.45,604919.49 4494397.27 11.97,604917.62 4494397.59 11.61,604918.12 4494397.63 11.54,604914.82 4494397.65 11.82,604915.81 4494397.65 11.72,604916.79 4494397.65 11.67,604917.77 4494397.65 11.59,604918.75 4494397.65 11.47,604915.22 4494397.72 11.79,604919.56 4494397.74 11.56,604917.48 4494397.82 11.63,604918.57 4494397.98 11.8,604919.59 4494397.98 11.66,604915.03 4494397.98 12.01,604916.58 4494397.99 11.9,604917.58 4494397.99 11.78,604914.57 4494398 12.08,604915.57 4494398 11.98,604915.64 4494398.02 11.93,604915.55 4494398.08 11.96,604918.03 4494398.14 11.69,604919.06 4494398.23 11.75,604919.62 4494398.27 11.63,604918.66 4494398.27 11.75,604917.71 4494398.27 11.8,604916.76 4494398.27 11.91,604915.81 4494398.27 11.9,604914.86 4494398.27 12.04,604919.68 4494398.3 11.77,604917.21 4494398.49 11.98,604919.12 4494398.56 11.98,604918.17 4494398.57 12.05,604917.67 4494398.57 12.03,604917.21 4494398.58 12.1,604916.25 4494398.58 12.19,604915.29 4494398.59 12.29,604914.33 4494398.59 12.39,604914.81 4494398.6 12.31,604919.15 4494398.63 11.95,604917.06 4494398.68 12.22,604914.61 4494398.84 12.57,604915.2 4494398.98 12.49,604915.1 4494399.01 12.59,604919.42 4494399.08 12.11,604918.65 4494399.09 12.28,604917.59 4494399.09 12.31,604919.22 4494399.24 12.29,604914.41 4494399.25 12.72,604915.39 4494399.25 12.68,604916.38 4494399.25 12.59,604917.35 4494399.25 12.48,604918.34 4494399.26 12.35,604919.33 4494399.26 12.26,604916.81 4494399.35 12.56,604919.39 4494399.47 12.53,604918.39 4494399.48 12.62,604917.39 4494399.49 12.63,604916.39 4494399.5 12.65,604914.4 4494399.5 12.52,604917.21 4494399.51 12.61,604918.74 4494399.51 12.51,604915.39 4494399.52 12.6,604914.4 4494399.54 12.43,604916.65 4494399.54 12.65,604914.19 4494399.8 12.27,604919.25 4494399.89 12.59,604918.3 4494399.89 12.69,604917.35 4494399.89 12.73,604916.4 4494399.9 12.66,604915.45 4494399.91 12.56,604914.51 4494399.92 12.43,604918.24 4494399.96 12.63,604914.71 4494400.02 12.24,604918.98 4494400.04 12.65,604914.64 4494400.06 12.2,604913.69 4494400.07 6.63,604917.12 4494400.09 12.47,604919 4494400.1 12.53,604918.05 4494400.12 12.5,604917.1 4494400.14 12.36,604916.13 4494400.16 12.3,604915.19 4494400.19 12.18,604914.24 4494400.21 12.1,604918.77 4494400.21 12.5,604916.37 4494400.32 12.28,604918.31 4494400.45 12.34,604913.93 4494400.51 11.9,604916.22 4494400.55 12.07,604916.74 4494400.58 12.13,604913.75 4494400.82 11.63,604917.9 4494400.87 12.12,604918.87 4494400.87 12.21,604916.92 4494400.88 12.07,604915.94 4494400.89 11.93,604913.99 4494400.9 11.8,604914.96 4494400.9 11.85,604917.8 4494400.97 12.02,604914.21 4494401.11 11.68,604918.47 4494401.13 11.99,604916.61 4494401.2 11.82,604918.86 4494401.31 11.78,604918.29 4494401.31 11.86,604917.87 4494401.32 11.75,604915.9 4494401.33 11.64,604916.88 4494401.34 11.65,604915.88 4494401.35 11.68,604917.84 4494401.47 11.67,604918.83 4494401.58 11.87,604917.9 4494401.59 11.76,604919.73 4494397.64 11.63,604919.77 4494401.57 12.11,604919.84 4494401.27 12.05,604919.86 4494400.86 12.33,604919.87 4494398.12 11.55,604919.92 4494401.88 11.8,604919.92 4494401.35 12.02,604919.95 4494400.08 12.62,604919.98 4494396.83 11.42,604920.1 4494398.56 11.91,604920.14 4494397.27 11.91,604920.21 4494399.89 12.54,604920.28 4494401 12.15,604920.31 4494399.26 12.21,604920.33 4494397.11 11.48,604920.38 4494400.35 12.58,604920.41 4494399.47 12.42,604920.52 4494396.9 11.38,604920.58 4494398.26 11.68,604920.59 4494397.97 11.58,604920.67 4494401.24 12.11,604920.7 4494397.63 11.88,604920.71 4494400 12.67,604920.72 4494401.56 12.13,604920.74 4494401.32 12.02,604920.79 4494399.45 12.32,604920.84 4494400.85 12.39,604920.85 4494401.26 12,604920.89 4494401.87 11.78,604920.92 4494400.06 12.64,604921.06 4494398.56 11.74,604921.12 4494399.15 12.14,604921.16 4494399.89 12.46,604921.17 4494400.17 12.63,604921.19 4494398.59 11.72,604921.21 4494400.22 12.69,604921.29 4494399.26 12.04,604921.41 4494399.46 12.34,604921.45 4494396.85 11.8,604921.52 4494398.26 11.62,604921.54 4494398.28 11.61,604921.59 4494397.97 11.4,604921.61 4494399.21 12.04,604921.63 4494397.62 11.9,604921.63 4494402.21 11.81,604921.65 4494401.55 12.27,604921.66 4494399.29 12.07,604921.68 4494397.62 11.93,604921.7 4494401.84 13.12,604921.78 4494401.73 13.24,604921.8 4494400.84 12.63,604921.83 4494401.21 12.43,604921.88 4494400.05 12.61,604921.97 4494397.33 11.76,604922.02 4494398.55 11.65,604922.05 4494398.25 11.53,604922.09 4494401.23 12.21,604922.09 4494402.2 12.03,604922.11 4494399.89 12.35,604922.11 4494400.99 12.59,604922.12 4494398.35 11.59,604922.18 4494401.87 14.06,604922.27 4494399.26 12.05,604922.41 4494399.46 12.2,604922.49 4494398.27 11.38,604922.52 4494397.23 11.59,604922.53 4494400.07 12.58,604922.53 4494400.25 12.62,604922.57 4494401.15 12.34,604922.58 4494397.34 11.55,604922.59 4494397.96 11.44,604922.59 4494401.55 12.23,604922.62 4494401.08 12.33,604922.69 4494397.63 11.62,604922.78 4494400.83 12.69,604922.81 4494401.83 11.92,604922.83 4494400.05 12.56,604922.84 4494401.22 12.16,604922.93 4494399.39 12.03,604922.94 4494399.22 11.96,604922.98 4494398.54 11.65,604923.04 4494400.13 12.48,604923.06 4494399.89 12.29,604923.08 4494400.07 12.48,604923.27 4494399.26 12.01,604923.33 4494398.52 11.54,604923.36 4494398.34 11.57,604923.37 4494402.23 11.68,604923.43 4494399.46 12.1,604923.44 4494398.26 11.45,604923.48 4494399.19 11.88,604923.53 4494401.54 12.34,604923.53 4494399.13 11.87,604923.58 4494397.92 11.73,604923.67 4494397.64 11.47,604923.76 4494401.81 12.03,604923.76 4494397.6 11.46,604923.77 4494400.83 12.75,604923.79 4494397.42 11.57,604923.8 4494400.04 12.44,604923.83 4494401.19 12.34,604923.84 4494401.22 12.35,604923.93 4494398.21 11.6,604923.95 4494398.53 11.61,604923.97 4494402.18 11.81,604923.99 4494398.13 11.8,604924.02 4494399.89 12.21,604924.25 4494399.26 11.89,604924.26 4494401.83 12.05,604924.27 4494400.28 12.52,604924.37 4494398.24 11.89,604924.42 4494401.15 12.5,604924.43 4494399.45 12,604924.47 4494401.53 12.54,604924.48 4494402.61 11.7,604924.55 4494402.38 11.72,604924.58 4494397.91 11.62,604924.67 4494399.42 11.9,604924.73 4494401.78 12.17,604924.76 4494400.83 12.67,604924.76 4494400.75 12.69,604924.77 4494400.04 12.36,604924.83 4494401.18 12.4,604924.84 4494400.22 12.45,604924.92 4494398.54 11.34,604924.97 4494399.89 12.09,604925.03 4494401.27 12.5,604925.07 4494398.54 11.42,604925.19 4494399.81 12.11,604925.23 4494399.26 11.79,604925.26 4494399.36 11.94,604925.33 4494398.25 11.63,604925.4 4494401.52 12.49,604925.45 4494399.45 11.87,604925.46 4494402.6 11.81,604925.48 4494400.28 12.4,604925.49 4494397.62 11.4,604925.54 4494402.53 11.74,604925.59 4494397.91 11.47,604925.63 4494397.63 11.58,604925.63 4494398.87 11.53,604925.68 4494398.48 11.49,604925.68 4494402.68 11.74,604925.69 4494401.76 12.28,604925.74 4494400.03 12.23,604925.74 4494400.82 12.66,604925.82 4494401.15 12.54,604925.87 4494398.51 11.47,604925.92 4494399.89 12.03,604925.94 4494399.34 11.79,604926 4494401.52 12.39,604926.09 4494397.88 11.46,604926.11 4494402.83 11.67,604926.11 4494402.15 12.02,604926.12 4494401.67 12.36,604926.23 4494399.26 11.72,604926.29 4494398.25 11.56,604926.34 4494401.51 12.63,604926.43 4494400.59 12.5,604926.44 4494402.59 11.98,604926.45 4494399.44 11.82,604926.55 4494400.7 12.59,604926.58 4494401.73 12.39,604926.61 4494397.9 11.47,604926.61 4494401.07 12.68,604926.62 4494397.62 11.73,604926.64 4494402.84 11.67,604926.65 4494401.74 12.34,604926.69 4494400.03 12.15,604926.73 4494400.82 12.65,604926.81 4494401.13 12.68,604926.83 4494399.73 11.92,604926.84 4494398.5 11.5,604926.88 4494399.89 11.97,604926.96 4494399.85 11.96

ptrblck · August 30, 2018, 11:53am

The rows look differently, as the first one has separators |, while the second uses white spaces to separate the data?

InnovArul · August 30, 2018, 1:18pm

Just to augment @ptrblck’s effort, here is my try:

labels,points
1,"604916.47 4494396.11 11.58,604916.02 4494396.13 11.84,604915.03 4494396.15 11.58,604915.87 4494396.19 11.44,604914.49 4494396.23 11.45,604917.41 4494396.35 11.48,604916.41 4494396.36 11.49,604915.42 4494396.37 11.61,604914.42 4494396.39 11.48,604914.5 4494396.41 11.53,604918.58 4494396.62 11.52,604918.04 4494396.68 11.42,604919.2 4494396.71 11.67,604918.24 4494396.71 11.65,604914.45 4494396.72 11.93,604917.31 4494396.73 11.43,604915.41 4494396.73 11.56,604916.37 4494396.74 11.28,604915.64 4494396.81 11.53,604917.91 4494396.87 11.73,604919.55 4494396.9 11.51,604918.57 4494396.9 11.67,604917.62 4494396.92 11.54,604916.65 4494396.92 11.73,604915.7 4494396.96 11.46,604914.74 4494396.97 11.48,604916.09 4494397.05 11.48,604918.52 4494397.08 11.91,604915.45 4494397.11 11.51,604916.01 4494397.13 11.45,604919.49 4494397.27 11.97,604917.62 4494397.59 11.61,604918.12 4494397.63 11.54,604914.82 4494397.65 11.82,604915.81 4494397.65 11.72,604916.79 4494397.65 11.67,604917.77 4494397.65 11.59,604918.75 4494397.65 11.47,604915.22 4494397.72 11.79,604919.56 4494397.74 11.56,604917.48 4494397.82 11.63,604918.57 4494397.98 11.8,604919.59 4494397.98 11.66,604915.03 4494397.98 12.01,604916.58 4494397.99 11.9,604917.58 4494397.99 11.78,604914.57 4494398 12.08,604915.57 4494398 11.98,604915.64 4494398.02 11.93,604915.55 4494398.08 11.96,604918.03 4494398.14 11.69,604919.06 4494398.23 11.75,604919.62 4494398.27 11.63,604918.66 4494398.27 11.75,604917.71 4494398.27 11.8,604916.76 4494398.27 11.91,604915.81 4494398.27 11.9,604914.86 4494398.27 12.04,604919.68 4494398.3 11.77,604917.21 4494398.49 11.98,604919.12 4494398.56 11.98,604918.17 4494398.57 12.05,604917.67 4494398.57 12.03,604917.21 4494398.58 12.1,604916.25 4494398.58 12.19,604915.29 4494398.59 12.29,604914.33 4494398.59 12.39,604914.81 4494398.6 12.31,604919.15 4494398.63 11.95,604917.06 4494398.68 12.22,604914.61 4494398.84 12.57,604915.2 4494398.98 12.49,604915.1 4494399.01 12.59,604919.42 4494399.08 12.11,604918.65 4494399.09 12.28,604917.59 4494399.09 12.31,604919.22 4494399.24 12.29,604914.41 4494399.25 12.72,604915.39 4494399.25 12.68,604916.38 4494399.25 12.59,604917.35 4494399.25 12.48,604918.34 4494399.26 12.35,604919.33 4494399.26 12.26,604916.81 4494399.35 12.56,604919.39 4494399.47 12.53,604918.39 4494399.48 12.62,604917.39 4494399.49 12.63,604916.39 4494399.5 12.65,604914.4 4494399.5 12.52,604917.21 4494399.51 12.61,604918.74 4494399.51 12.51,604915.39 4494399.52 12.6,604914.4 4494399.54 12.43,604916.65 4494399.54 12.65,604914.19 4494399.8 12.27,604919.25 4494399.89 12.59,604918.3 4494399.89 12.69,604917.35 4494399.89 12.73,604916.4 4494399.9 12.66,604915.45 4494399.91 12.56,604914.51 4494399.92 12.43,604918.24 4494399.96 12.63,604914.71 4494400.02 12.24,604918.98 4494400.04 12.65,604914.64 4494400.06 12.2,604913.69 4494400.07 6.63,604917.12 4494400.09 12.47,604919 4494400.1 12.53,604918.05 4494400.12 12.5,604917.1 4494400.14 12.36,604916.13 4494400.16 12.3,604915.19 4494400.19 12.18,604914.24 4494400.21 12.1,604918.77 4494400.21 12.5,604916.37 4494400.32 12.28,604918.31 4494400.45 12.34,604913.93 4494400.51 11.9,604916.22 4494400.55 12.07,604916.74 4494400.58 12.13,604913.75 4494400.82 11.63,604917.9 4494400.87 12.12,604918.87 4494400.87 12.21,604916.92 4494400.88 12.07,604915.94 4494400.89 11.93,604913.99 4494400.9 11.8,604914.96 4494400.9 11.85,604917.8 4494400.97 12.02,604914.21 4494401.11 11.68,604918.47 4494401.13 11.99,604916.61 4494401.2 11.82,604918.86 4494401.31 11.78,604918.29 4494401.31 11.86,604917.87 4494401.32 11.75,604915.9 4494401.33 11.64,604916.88 4494401.34 11.65,604915.88 4494401.35 11.68,604917.84 4494401.47 11.67,604918.83 4494401.58 11.87,604917.9 4494401.59 11.76,604919.73 4494397.64 11.63,604919.77 4494401.57 12.11,604919.84 4494401.27 12.05,604919.86 4494400.86 12.33,604919.87 4494398.12 11.55,604919.92 4494401.88 11.8,604919.92 4494401.35 12.02,604919.95 4494400.08 12.62,604919.98 4494396.83 11.42,604920.1 4494398.56 11.91,604920.14 4494397.27 11.91,604920.21 4494399.89 12.54,604920.28 4494401 12.15,604920.31 4494399.26 12.21,604920.33 4494397.11 11.48,604920.38 4494400.35 12.58,604920.41 4494399.47 12.42,604920.52 4494396.9 11.38,604920.58 4494398.26 11.68,604920.59 4494397.97 11.58,604920.67 4494401.24 12.11,604920.7 4494397.63 11.88,604920.71 4494400 12.67,604920.72 4494401.56 12.13,604920.74 4494401.32 12.02,604920.79 4494399.45 12.32,604920.84 4494400.85 12.39,604920.85 4494401.26 12,604920.89 4494401.87 11.78,604920.92 4494400.06 12.64,604921.06 4494398.56 11.74,604921.12 4494399.15 12.14,604921.16 4494399.89 12.46,604921.17 4494400.17 12.63,604921.19 4494398.59 11.72,604921.21 4494400.22 12.69,604921.29 4494399.26 12.04,604921.41 4494399.46 12.34,604921.45 4494396.85 11.8,604921.52 4494398.26 11.62,604921.54 4494398.28 11.61,604921.59 4494397.97 11.4,604921.61 4494399.21 12.04,604921.63 4494397.62 11.9,604921.63 4494402.21 11.81,604921.65 4494401.55 12.27,604921.66 4494399.29 12.07,604921.68 4494397.62 11.93,604921.7 4494401.84 13.12,604921.78 4494401.73 13.24,604921.8 4494400.84 12.63,604921.83 4494401.21 12.43,604921.88 4494400.05 12.61,604921.97 4494397.33 11.76,604922.02 4494398.55 11.65,604922.05 4494398.25 11.53,604922.09 4494401.23 12.21,604922.09 4494402.2 12.03,604922.11 4494399.89 12.35,604922.11 4494400.99 12.59,604922.12 4494398.35 11.59,604922.18 4494401.87 14.06,604922.27 4494399.26 12.05,604922.41 4494399.46 12.2,604922.49 4494398.27 11.38,604922.52 4494397.23 11.59,604922.53 4494400.07 12.58,604922.53 4494400.25 12.62,604922.57 4494401.15 12.34,604922.58 4494397.34 11.55,604922.59 4494397.96 11.44,604922.59 4494401.55 12.23,604922.62 4494401.08 12.33,604922.69 4494397.63 11.62,604922.78 4494400.83 12.69,604922.81 4494401.83 11.92,604922.83 4494400.05 12.56,604922.84 4494401.22 12.16,604922.93 4494399.39 12.03,604922.94 4494399.22 11.96,604922.98 4494398.54 11.65,604923.04 4494400.13 12.48,604923.06 4494399.89 12.29,604923.08 4494400.07 12.48,604923.27 4494399.26 12.01,604923.33 4494398.52 11.54,604923.36 4494398.34 11.57,604923.37 4494402.23 11.68,604923.43 4494399.46 12.1,604923.44 4494398.26 11.45,604923.48 4494399.19 11.88,604923.53 4494401.54 12.34,604923.53 4494399.13 11.87,604923.58 4494397.92 11.73,604923.67 4494397.64 11.47,604923.76 4494401.81 12.03,604923.76 4494397.6 11.46,604923.77 4494400.83 12.75,604923.79 4494397.42 11.57,604923.8 4494400.04 12.44,604923.83 4494401.19 12.34,604923.84 4494401.22 12.35,604923.93 4494398.21 11.6,604923.95 4494398.53 11.61,604923.97 4494402.18 11.81,604923.99 4494398.13 11.8,604924.02 4494399.89 12.21,604924.25 4494399.26 11.89,604924.26 4494401.83 12.05,604924.27 4494400.28 12.52,604924.37 4494398.24 11.89,604924.42 4494401.15 12.5,604924.43 4494399.45 12,604924.47 4494401.53 12.54,604924.48 4494402.61 11.7,604924.55 4494402.38 11.72,604924.58 4494397.91 11.62,604924.67 4494399.42 11.9,604924.73 4494401.78 12.17,604924.76 4494400.83 12.67,604924.76 4494400.75 12.69,604924.77 4494400.04 12.36,604924.83 4494401.18 12.4,604924.84 4494400.22 12.45,604924.92 4494398.54 11.34,604924.97 4494399.89 12.09,604925.03 4494401.27 12.5,604925.07 4494398.54 11.42,604925.19 4494399.81 12.11,604925.23 4494399.26 11.79,604925.26 4494399.36 11.94,604925.33 4494398.25 11.63,604925.4 4494401.52 12.49,604925.45 4494399.45 11.87,604925.46 4494402.6 11.81,604925.48 4494400.28 12.4,604925.49 4494397.62 11.4,604925.54 4494402.53 11.74,604925.59 4494397.91 11.47,604925.63 4494397.63 11.58,604925.63 4494398.87 11.53,604925.68 4494398.48 11.49,604925.68 4494402.68 11.74,604925.69 4494401.76 12.28,604925.74 4494400.03 12.23,604925.74 4494400.82 12.66,604925.82 4494401.15 12.54,604925.87 4494398.51 11.47,604925.92 4494399.89 12.03,604925.94 4494399.34 11.79,604926 4494401.52 12.39,604926.09 4494397.88 11.46,604926.11 4494402.83 11.67,604926.11 4494402.15 12.02,604926.12 4494401.67 12.36,604926.23 4494399.26 11.72,604926.29 4494398.25 11.56,604926.34 4494401.51 12.63,604926.43 4494400.59 12.5,604926.44 4494402.59 11.98,604926.45 4494399.44 11.82,604926.55 4494400.7 12.59,604926.58 4494401.73 12.39,604926.61 4494397.9 11.47,604926.61 4494401.07 12.68,604926.62 4494397.62 11.73,604926.64 4494402.84 11.67,604926.65 4494401.74 12.34,604926.69 4494400.03 12.15,604926.73 4494400.82 12.65,604926.81 4494401.13 12.68,604926.83 4494399.73 11.92,604926.84 4494398.5 11.5,604926.88 4494399.89 11.97,604926.96 4494399.85 11.96"

import pandas as pd
import numpy as np
import torch, re

data = pd.read_csv(
    './train.csv',
    sep=',', skiprows=1, engine='python', names=['labels', 'points',],
    usecols=[0,1])

print(data)
labels = torch.from_numpy(data['labels'].values)
points = data['points'].apply(lambda x: torch.from_numpy(
                                            np.array([float(x_) for x_ in re.split(',|\s', x)]).reshape(-1, 3)))

for pt in points:
    print(pt.shape)

dimple · August 31, 2018, 6:51am

sorry, the second was also with sep | …mistake in the copy paste

dimple · September 3, 2018, 4:26pm

Hi,
Now iam facing this error

ValueError: only one element tensors can be converted to Python scalars

import pandas as pd
import numpy as np
import torch,re
import torch.nn as nn
from torch.autograd import Variable
from torchvision.transforms import transforms
from torch.utils.data.dataset import Dataset
import torch.optim as optim
from torch.utils.data import DataLoader
import torch.utils.data as data_utils
#import torchvision.transforms as transforms
from ast import literal_eval
from nn_3d import NeuralNet

input_size = 921
hidden_size = 100
num_classes = 3
num_epochs = 5
batch_size = 1
learning_rate = 0.01

def points_to_tensor(data):
#data = torch.tensor([[float(j) for j in i.split(’ ‘)] for i in data.split(’,’)])
data1 = data.apply(lambda x: torch.from_numpy(np.array([float(x_) for x_ in re.split(’,|\s’, x)]).reshape(-1, 3)))
data2 = torch.FloatTensor(data1)
print(data2)
print("--------------------------------------")
print(len(data2))
return data2

def labels_to_tensor(label):
label1 = torch.FloatTensor(label)
return label1

class BDatasetFromCSV(Dataset):

def __init__(self, csv_path,transforms):
  
    self.data = pd.read_csv(csv_path)
    data_labels = self.data.iloc[:, 0]
    data_points = self.data.iloc[:, 1]
    self.points = points_to_tensor(data_points)
    self.labels = labels_to_tensor(data_labels)
    #self.transforms = transform


def __getitem__(self, index):
  
    d_labels = self.labels[index]
    d_points = self.points[index]
    return (d_points, d_labels)
            

def __len__(self):
  
    return len(self.data.index)

if name == “main”:
transformations = transforms.Compose([transforms.ToTensor()])

#Load the training set
custom_b_from_csv = BDatasetFromCSV('train.csv',transformations)

#Create a loader for the training set
	b_dataset_loader = torch.utils.data.DataLoader(dataset= custom_b_from_csv,batch_size=1,shuffle=False) 

	print(b_dataset_loader)
	#print("--------------------------------------")
model = NeuralNet(input_size, hidden_size, num_classes)
#print(model)
criterion = nn.CrossEntropyLoss()
optimizer = torch.optim.SGD(model.parameters(), lr=0.01)

for i, (d_labels,d_points) in enumerate(b_dataset_loader):
	#points,labels = data
    	dpoints = Variable(points)
    	#dlabels = Variable(labels)
    	# Clear gradients
    	optimizer.zero_grad()
    	# Forward pass
    	outputs = model(dpoints)
    	# Calculate loss
    	loss = criterion(outputs, d_labels)
    	# Backward pass
    	loss.backward()
    	# Update weights
    	optimizer.step()
	break