How convert csv to 2 arrays data and classes?

Question

0.00/5 (No votes)

See more:

, +

I want to do and-operation, my csv is
0,0,0
0,1,0
1,0,0
1,1,1

I want to get 2 arrays: input and output array
data (input)
0,0
0,1
1,0
1,1
classes (output)
0
0
0
1
I try this code:

What I have tried:

C#

double[][] input = new double[samples][];
double[][] output = new double[samples][];
public static void convertCSV()
        {
            StreamReader reader = new StreamReader("D:\\and.csv");
            samples = 0;
            
            try
            {
                string str = null;
                while((samples<50)&&((str=reader.ReadLine())!=null))
                {
                    string[] strs = str.Split(';');
                    if (strs.Length == 1)
                        strs = str.Split(',');
                    
                    //// parse tokens
                    tempData[samples, 0] = double.Parse(strs[0]);
                    tempData[samples, 1] = double.Parse(strs[1]);
                    tempClasses[samples] = int.Parse(strs[2]);

                    
                    samples++;
                  
                }
                data = new double[samples, 2];
                Array.Copy(tempData, 0, data, 0, samples * 2);
                classes = new int[samples];
                Array.Copy(tempClasses, 0, classes, 0, samples);

                
            }
            catch(Exception)
            {
                return;
            }
            finally
            {
                if (reader != null)
                    reader.Close();
            }
        }
        public static void SearchSolution()
        {
            // prepare learning data
            
            for (int i = 0; i < samples; i++)
            {
                input[i] = new double[2];
                output[i] = new double[1];

                //// set input
                input[i][0] = data[i, 0];
                input[i][1] = data[i, 1];

                //// set output
                output[i][0] = classes[i];

               
                }
            //}
        }

my code cant give my 2 arrays to use it in training, I want some help if possible, please

Posted 16-Feb-20 8:50am

Member 14129828

Updated 17-Feb-20 2:07am

CPallini

v2

Add a Solution

Comments

CHill60 17-Feb-20 4:12am

What happens when you run and debug your code?
This is a bad construct

catch(Exception)
            {
                return;
            }

because you will never know what error occurred.
You haven't declared tempData or tempClasses - could that be your problem?

Richard MacCutchan 17-Feb-20 6:56am

Your code does not appear to do anything apart from trying to read the numbers and moving them around from place to place. You initially read them into tempData, only to then copy them into data, so you can finally copy them from there to input and output. What exactly are you trying to achieve?

Member 14129828 17-Feb-20 7:43am

I want to separate the input from the output to use them in training by using
trainingSet = new BasicNeuralDataSet(input, output);

Richard MacCutchan 17-Feb-20 8:08am

See my Solution below.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2020-02-17T02:08:00

The following code will split your data into the two arrays you have declared:

C#

static int samples = 4;    // adjust this to the actual number to be processed

static double[,] input = new double[samples,2];
static double[] output = new double[samples];

public static void convertCSV()
{
    StreamReader reader = new StreamReader("D:\\and.csv");
    int index = 0;
    
    try
    {
        string str;
        while(index < samples && (str = reader.ReadLine()) != null)
        {
            string[] strs = str.Split(';');
            if (strs.Length == 1)
                strs = str.Split(',');
            
            // parse tokens
            input[index,0] = double.Parse(strs[0]);
            input[index,1] = double.Parse(strs[1]);
            output[index] = double.Parse(strs[2]);
            index++;
        }
    }
    catch(Exception e)
    {
        // do something here, do not ignore exceptions
        Console.WriteLine(e.Message);
    }
    finally
    {
        if (reader != null)
        reader.Close();
    }
}