Hello, I need your help. I have a list, like this. For this I have to analyze a matrix In the example a 5.3 matrix. Pos Row Column x y State Counter Coding 1 1 1 10 10 1 32321 0000 2 2 1 20 10 1 32322 0000 3 3 1 30 10 1 32323 0000 4 4 1 40 10 0 32324 FFFF 5 5 1 50 10 1 32325 0000 6 1 2 10 110 1 32326 0000 7 2 2 20 110 1 32327 0000 8 3 2 30 110 1 32328 0000 9 4 2 40 110 1 32329 0000 10 5 2 50 110 1 32330 0000 11 1 3 10 210 1 32331 0000 12 2 3 20 210 1 32332 0000 13 3 3 30 210 0 32333 FFFF 14 4 3 40 210 1 32334 0000 15 5 3 50 210 1 32335 0000 The result should be 0000 0000 0000 0000 0000 0000 0000 0000 FFFF FFFF 0000 0000 0000 0000 0000 Now the hard part. I have to create a 3.5 matrix from the 5.3 matrix, I have to convert. 0000 0000 0000 FFFF 0000 0000 0000 0000 0000 0000 0000 0000 FFFF 0000 0000 Finally I have to write it in an xml element <Result bin1="0000 0000 0000" bin2="0000 0000 0000" bin3="0000 0000 FFFF" bin4="FFFF 0000 0000" bin5="0000 0000 0000" \> <ResultConvert bin1="0000 0000 0000 FFFF 0000" bin2="0000 0000 0000 0000 0000" bin3="0000 0000 0000 0000 0000" \> The questions How do I do it? Which objects are suitable? Datatable? Can someone show me? Thanks in advance.

You can just use a standard 2D array to represent your data (or rather, an array of arrays.) If your data is coming from a SQL table like in the first example then you'll need to convert that serial one-dimensional data into your 5x3 matrix. From there it's fairly straight forward. You just need to create a new 2D array with flipped row/column dimension sizes, then map over the data to the corresponding cell. In matrix terms this is called transposing. Here's a snippet to demonstrate: https://pastebin.com/yDJTmAKg (had to pastebin because of too many characters) Result: <?xml version="1.0" encoding="utf-16"?> <Result bin0="0000 0000 0000" bin1="0000 0000 0000" bin2="0000 0000 FFFF" bin3="FFFF 0000 0000" bin4="0000 0000 0000"> <ResultConvert bin0="0000 0000 0000 FFFF 0000" bin1="0000 0000 0000 0000 0000" bin2="0000 0000 FFFF 0000 0000" /> </Result>

Source-list - goal is a matrix - convert matrix - Find a good way

Accepted answer

P a u l 10,406 Reputation points

2022-02-12T14:54:38.903+00:00
You can just use a standard 2D array to represent your data (or rather, an array of arrays.) If your data is coming from a SQL table like in the first example then you'll need to convert that serial one-dimensional data into your 5x3 matrix.

From there it's fairly straight forward. You just need to create a new 2D array with flipped row/column dimension sizes, then map over the data to the corresponding cell. In matrix terms this is called transposing. Here's a snippet to demonstrate:
https://pastebin.com/yDJTmAKg

(had to pastebin because of too many characters)

Result:

<?xml version="1.0" encoding="utf-16"?> <Result bin0="0000 0000 0000" bin1="0000 0000 0000" bin2="0000 0000 FFFF" bin3="FFFF 0000 0000" bin4="0000 0000 0000"> <ResultConvert bin0="0000 0000 0000 FFFF 0000" bin1="0000 0000 0000 0000 0000" bin2="0000 0000 FFFF 0000 0000" /> </Result>
Please sign in to rate this answer.

1 person found this answer helpful.
Markus Freitag 3,786 Reputation points

2022-02-12T17:22:45.357+00:00

Thanks a lot for your help!

// 2. Chunk the data into groups of 5, which if your data is divisible by 5, as per your OP should produce a 5x3 matrix (2D array of arrays)
string[][] matrix = data.Chunk(5).ToArray();

// 3. Transpose the matrix into a new 3x5 matrix.

string[][] transposed = matrix.Transpose();

chunk, i didn't know that!

Can you show me how to get to the matrix, to the group. I have a one-dimensional list and need to create the matrix first! That would still be great.173719-new-sample.txt

And then save to a xml file like in the attachment. That would be the goal, would be nice for your help. Thank you very much.

P a u l 10,406 Reputation points

2022-02-13T00:46:16.233+00:00

Do you mean like this?: https://pastebin.com/4XEc2C9t

This example doesn't physically move the items, it just transposes their Column & Row properties. The result looks like this:

https://pastebin.com/hh9PK1Mz

Note that the elements themselves don't change position, but their "row" and "column" attributes are flipped in the transformed group.

Markus Freitag 3,786 Reputation points

2022-02-15T17:09:41.31+00:00

Hello,

@P a u l ,
https://www.tutorialsteacher.com/csharp/csharp-extension-method

As I said, thank you for your help.
Could you still answer shortly how I could implement this under .NET4.8?

Why is Tranpose not working?
https://csharp.hotexamples.com/examples/-/Expression/Expand/php-expression-expand-method-examples.html

namespace WindowsFormsAppMatrixBasic.Core { public static class ArrayExtensions { public static T[][] Transpose<T>(this T[][] source) { if (source.Length == 0 || source[0].Length == 0) { return Array.Empty<T[]>(); } int rows = source.Length; // I need something for int cols = source[0].Length; // ?? T[][] result = new T[cols][]; for (int i = 0; i < cols; i++) { result[i] = new T[rows]; for (int j = 0; j < rows; j++) { result[i][j] = source[j][i]; } } return result; } }

P a u l 10,406 Reputation points

2022-02-15T18:41:39.093+00:00

That's just because string[,] (2D string array) and string[][] (array of string arrays) are different types - they hold similar data in this scenario, but 2D arrays need to be uniform (i.e. same amount of columns per row), whereas an array of arrays can have any number of columns per row.

The way to fix this is to change all your string[,] to string[][].

Markus Freitag 3,786 Reputation points

2022-02-15T19:43:04.967+00:00

The way to fix this is to change all your string[,] to string[][].

Thanks! I will check it tomorrow.

How I can get the matrix from 1D list?
What analysis would you do there?

// Pos Row Col x y State Counter Coding // 1 1 1 10 10 1 32321 0000 // 2 2 1 20 10 1 32322 0000 // 3 3 1 30 10 1 32323 0000 // 4 4 1 40 10 0 32324 FFFF // 5 5 1 50 10 1 32325 0000 // 6 1 2 10 110 1 32326 0000 // 7 2 2 20 110 1 32327 0000 // 8 3 2 30 110 1 32328 0000 // 9 4 2 40 110 1 32329 0000 // 10 5 2 50 110 1 32330 0000 // 11 1 3 10 210 1 32331 0000 // 12 2 3 20 210 1 32332 0000 // 13 3 3 30 210 0 32333 FFFF // 14 4 3 40 210 1 32334 0000 // 15 5 3 50 210 1 32335 0000

In the example, it would transform a 5/3 matrix to 3/5

P a u l 10,406 Reputation points

2022-02-15T20:47:54.857+00:00

It's just the same as I posted in the pastebin example above with the .Chunk(5).ToArray(). If you're looking to transpose the entire entity (meaning the X, Y, Rows & Columns are all transposed in one go) and not just the Coding column then you can perform the same .Transpose() operation on a list of entities:
https://pastebin.com/KKEGgJxx

Markus Freitag 3,786 Reputation points

2022-02-16T17:18:08.263+00:00

Hello,

string[][] matrix2 = { new[] { "1", "1", "0000" }, new[] { "2", "1", "0000" }, new[] { "3", "1", "0000" }, new[] { "4", "1", "FFFF" }, new[] { "5", "1", "0000" }, new[] { "1", "2", "0000" }, new[] { "2", "2", "0000" }, new[] { "3", "2", "0000" }, new[] { "4", "2", "0000" }, new[] { "5", "2", "0000" }, new[] { "1", "3", "0000" }, new[] { "2", "3", "0000" }, new[] { "3", "3", "FFFF" }, new[] { "4", "3", "0000" }, new[] { "5", "3", "0000" } }; string[][] transposed = matrix2.Transpose(); // 3x5 matrix

OK it is works well. Thanks.

Markus Freitag 3,786 Reputation points

2022-02-16T17:19:21.987+00:00

Hello,

//string[][] matrix = new string(); //= data.Chunk(5).ToArray();

Chunk is missing in .Net4.8

I don't have this function because i have only .Net4.8. Do you know how is working?

What would I have to take if I have row, column maybe as int and an object.
Is that possible?

string[][] matrix2 = { new[] { "1", "1", object with more properties }, new[] { "2", "1", object with more properties }, new[] { "3", "1", object with more properties },

Or like this row as int, column as int object as item in a array?

P a u l 10,406 Reputation points

2022-02-16T18:51:04.883+00:00

You could add this polyfill if you're still on .NET Framework: https://pastebin.com/QH8Ahutv

Copied this from the dotnet runtime repo just fyi: https://github.com/dotnet/runtime/blob/ebba1d4acb7abea5ba15e1f7f69d1d1311465d16/src/libraries/System.Linq/src/System/Linq/Chunk.cs

If you want to switch to .NET (+Core) in the future you'll just want to delete the polyfill and use the one provided by the the framework.

If you want to represent your entities as string arrays rather than objects you can do that. It just means that once you convert your serial data into your matrix the type will be a string[][][]:
https://pastebin.com/YXY70UvL

If you had other types of data per row then you'd need to specify your initial data as object[][] and your matrix would become object[][][].

Markus Freitag 3,786 Reputation points

2022-02-17T17:34:15.28+00:00

Thank you!
Sign in to comment

Share via

Source-list - goal is a matrix - convert matrix - Find a good way

0 additional answers