Solved

concatenate columns c#

Posted on 2011-02-27
10
274 Views
Last Modified: 2012-08-14
Hello i have a list of 1s and 0s List = [1,0,1,0,1,1]
1 means that set of columns is selected and 0 no.
each set of columns maybe differ from the other set since it has different number of columns.

So i want to concatenante all the selected sets together. It's not working I want them to be saved a new 2D array.
0
Comment
Question by:dadadude
  • 7
  • 3
10 Comments
 

Author Comment

by:dadadude
ID: 34992018
For more Information:
I have a :
List<String[,]> Features

Open in new window


And i added the sets to a list. So now i have a list of 2D arrays as u can see
and then
Int [] index = new int[11];
suppose index = {1,0,1,0,1}
String [,]sub; // is that the right way.
        for (int i = 0; i < index.Count; i++) {
            if (index[i] == 1)
            {
              
             ???????????? HOW CAN I APPEND THE SELECTED 2D ARRAYS TOGETHER???
                     
            }//end if

        }//end for

Open in new window

0
 
LVL 29

Expert Comment

by:anarki_jimbel
ID: 34993005
Can you explain more clearly what should happen? What you mean "APPEND THE SELECTED 2D ARRAYS"? For example, if index[1] = 1, what arrays you append?! Some examples?
0
 

Author Comment

by:dadadude
ID: 34993067
I'll post the code:
As u can see in the code, i already create a list.

Private List<String [,]> features = new List<String[,]>

Open in new window


so I am adding a 2D-Array to the List features.
the list length is 11.
so suppose that i have index = [1,0,0,0,0,0,0,0,0,0,1]

so i should create a new 2D-array with these Columns.
//1. Hauteur
        String[,] hauteur = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            hauteur[i, 0] = obs[i, 1];
        }
        features.Add(hauteur);
        //2. Largeur
        String[,] largeur = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            largeur[i, 0] = obs[i, 2];
        }
        features.Add(largeur);
        //3. excentricité
        String[,] excentricite = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            excentricite[i, 0] = obs[i, 3];
        }
        features.Add(excentricite);
        //4.densite globale
        String[,] densiteGlobale = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            densiteGlobale[i, 0] = obs[i, 4];
        }
        features.Add(densiteGlobale);
        //5. orientation
        String[,] orientation = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            orientation[i, 0] = obs[i, 5];
        }
        features.Add(orientation);

        //6.perimetre
        String[,] perimetre = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            perimetre[i, 0] = obs[i, 6];
        }
        features.Add(perimetre);
        //7. rapport Fitness
        String[,] rapportFitness = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            rapportFitness[i, 0] = obs[i, 7];
        }
        features.Add(rapportFitness);
        //8. compacite
        String[,] compacite = new String[obs.GetLength(0), 1];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            compacite[i, 0] = obs[i, 8];
        }
        features.Add(compacite);
        //9. densite
        String[,] densite = new String[obs.GetLength(0), 8];

        for (int i = 0; i < obs.GetLength(0); i++)
        {
            for (int j = 8; j < 16; j++)
            {

                densite[i, j - 8] = obs[i, j];

            }
        }
        features.Add(densite);

        //10.orientations contour
        String[,] contour = new String[obs.GetLength(0), 8];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            for (int j = 16; j < 24; j++)
            {

                contour[i, j - 16] = obs[i, j];
            }
        }
        features.Add(contour);
        //11. Zernike
        String[,] zernike = new String[obs.GetLength(0), 35];
        for (int i = 0; i < obs.GetLength(0); i++)
        {
            for (int j = 24; j < 59; j++)
            {

                zernike[i, j - 24] = obs[i, j];
            }
        }
        features.Add(zernike);

        List<String[,]> matrix = new List<String[,]>();
        
        for (int i = 0; i < index.Count; i++)
        {
            if (index[i] == 1)
            {
                matrix.Add(features[i]);

            }//end if

Open in new window

0
 

Author Comment

by:dadadude
ID: 34993078
I don't know if what i did is correct. I created a new List and added the selected Items to it.
is that right. it's in the end of the code.
0
 
LVL 29

Expert Comment

by:anarki_jimbel
ID: 34993344
Because code, it seems, not quite correct, I can't understand what you are trying to achieve.

For example, you last statement is strange:

// see code section - I can't paste it here...

Basically, you don't need a loop, you add just one element if i==1. So, effectively you run:

                matrix.Add(features[1]);

 And your matrix has just one element. matrix and features has same structure, datatype, they are lists of square arrays.
What matrix should represent?

Again, what do you mean by "concatenation"?

for (int i = 0; i < index.Count; i++)
        {
            if (index[i] == 1)
            {
                matrix.Add(features[i]);

            }//end if
        }

Open in new window

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:dadadude
ID: 34993407
HOPE THAT THIS PICTURE HELP!!!

Sans-titre.jpg
0
 

Author Comment

by:dadadude
ID: 34993412
AS you can see in the picture Index(0) = 1 SO I should take Features[0], and Index(2) = 1, so i should take features(2).
0
 

Author Comment

by:dadadude
ID: 34993424
Bottom Line i want TO Concatenate 2D-arrays by columns.
if matrix1 =
1 2 3 4
1 2 3 4
1 2 3 4

and matrix2 =

5  6 7 8 9
5 6 7 8 0
5 6 7 8 0

so matrix3 = Matrix1 + Matrix2:

1 2 3 4 5 6 7 8 9
1 2 3 4 5 6 7 8 0
1 2 3 4 5 6 7 8 0
0
 
LVL 29

Accepted Solution

by:
anarki_jimbel earned 500 total points
ID: 34993706
OK, here is a method to concatenate two rectangular arrays:

Input:
A_0_0   A_0_1   A_0_2  
A_1_0   A_1_1   A_1_2  
A_2_0   A_2_1   A_2_2  

and
B_0_0   B_0_1   B_0_2   B_0_3  
B_1_0   B_1_1   B_1_2   B_1_3  
B_2_0   B_2_1   B_2_2   B_2_3  

Output:

A_0_0   A_0_1   A_0_2   B_0_0   B_0_1   B_0_2   B_0_3  
A_1_0   A_1_1   A_1_2   B_1_0   B_1_1   B_1_2   B_1_3  
A_2_0   A_2_1   A_2_2   B_2_0   B_2_1   B_2_2   B_2_3  
private string[,] concatenate(string[,] ar1, string[,] ar2)
        {
            if (ar1.GetLength(0) != ar2.GetLength(0))
            {
                throw new ArgumentException("Arrays must have same number of rows");
            }
            int rows = ar1.GetLength(0);
            int cols1 = ar1.GetLength(1);
            int cols2 = ar2.GetLength(1);
            string[,] concatenatedArr = new string[rows, cols1 + cols2];
            for (int r = 0; r<rows;r++)
            {
                for (int c1 = 0; c1 < cols1; c1++)
                {
                    concatenatedArr[r, c1] = ar1[r, c1];
                }
                for (int c2 = 0; c2 < cols2; c2++)
                {
                    concatenatedArr[r, cols1+c2] = ar2[r, c2];
                }
            }

            return concatenatedArr;
        }
        private void initialiseArray(string[,] ar, string identifier)
        {
            // initialise
            for (int i = 0; i < 3; i++)
            {
                for (int j = 0; j < ar.GetLongLength(1); j++)
                {

                    ar[i, j] = identifier + "_" + i + "_" + j;
                }
            }
        }

Open in new window

0
 

Author Closing Comment

by:dadadude
ID: 34995260
not bad for an answer. it's ok
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now