Reading each row from text file into an array of doubles or integer using C#

Question

Suppose I have a text file with data like below, I want to read first row and store the elements in one array. Read the second row and store in second array and so on. I will be making some manipulations on the array later on. Can you help me to do this in C#?

Input text file:

5,7,3,6,9,8,3,5,7

5,6,8,3,4,5

6,4,3,2,65,8,6,3,3,5,7,4

4,5,6,78,9,4,2,5,6

The Code I am trying out is:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace ReadFile
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        static void Main(string[] args)
        {
            TextReader tr = new StreamReader("Data.txt");
            // write a line of text to the file
            string word = tr.ReadLine();
            //now split this line into words
            string[] val = word.Split(new Char[] { ',' });
        }
    }

}

If I use the above technique, I can get the first line in array val. Is there a way to loop it for all the rows?

Its good to begin at some point! But what have you tried yet? Can you paste your code in the question. — Ozair Kafray
– Ozair Kafray, Commented Jul 17, 2012 at 6:48
Good i see that you have posted what you have tried, what you are expecting OR what is desired AND the problem. Now you will get good answers! — Ozair Kafray
– Ozair Kafray, Commented Jul 17, 2012 at 7:35
I am expecting to use each row data as a sample for analysis. Once I get an array for each row, I can use them for my analysis. — Next Door Engineer
– Next Door Engineer, Commented Jul 17, 2012 at 8:09
I am still working on it. I was trying out the method given by Phil Cartmell below, I am not able to pre determine the number of rows thus created, so I can use an array to work on the individual rows. — Next Door Engineer
– Next Door Engineer, Commented Jul 18, 2012 at 6:21

Giedrius · Accepted Answer · 2012-07-17 06:50:43Z

3

File.ReadAllLines will help you read all lines from file as string array.
String.Split will help you split line in pieces.
Int.Parse will help you transform string to int (double has similar method).

answered Jul 17, 2012 at 6:50

Giedrius

8,6106 gold badges57 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Felice Pollano · Accepted Answer · 2012-07-17 07:02:57Z

Ok, since you are a beginner my suggestions on what to focalize your attention. First of all, are your consumer always needing all the lines or can it stop at some point? If so, use a yield strategy to return the results one by one. You can use a StreamReader to read line one by one in any case, and use double.TryParse(...) or int.TryParse() after splitting the string by the separator. Keep an eye to the fact that separator can change, so use it with some kind of configurability, and in the case of double, ensure your code works even in machines with a different decimal point configured. If you are sure your csv alwais uses '.' as a decimal point separator, specify

double.TryParse("",System.Globalization.CultureInfo.InvariantCulture);

Ebad Masood · Accepted Answer · 2012-07-17 07:02:02Z

Something roughly like this would work:

StreamReader reader = new (File.OpenRead(@"YourFile.txt"));
List<string> LstIntegers = new List<string>();

            while (!reader.EndOfStream)
            {
                var line = reader.ReadLine();
                //values is actually a string array.
                var values = line.Split(',');
                //add the entire array fetched into string List
        LstIntegers.AddRange(values);   
            }
          // important to close the reader. You can also use using statement for reader. It 
          // will close the reader automatically when reading finishes.
            reader.Close();

   // You can then further manipulate it like below, you can also use int.Parse or int.TryParse:
   foreach (var v in LstIntegers)
   {
      // use int.TryParse if there is a chance that a non-int is read.
      int someNum = Convert.ToInt32(v);

   }

Phil · Accepted Answer · 2012-07-17 07:04:18Z

0

Try this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Xml;
using System.IO;
using System.Xml.Linq;
using System.Diagnostics;

namespace ConsoleApplication5
{
    class Program
    {
        static void Main(string[] args)
        {

            List<int[]> arrays = new List<int[]>();

            int counter = 0;
            string line;

            // Read the file
            System.IO.StreamReader file =
               new System.IO.StreamReader("c:\\temp\\test.txt");
            while ((line = file.ReadLine()) != null)
            {
                // split the line into a string array on , separator
                string[] splitLine = line.ToString().Split(',');

                // if our split isnt null and has a positive length
                if (splitLine != null && splitLine.Length > 0)
                {

                    // create a lineArray the same size as our new string[]
                    int[] lineArray = new int[splitLine.Length];

                    int posCounter = 0;

                    foreach (string splitValue in splitLine)
                    {
                        // loop through each value in the split, try and convert
                        // it into an int and push it into the array
                        try
                        {
                            lineArray[posCounter] = Int32.Parse(splitValue);
                        }
                        catch { }
                        posCounter++;
                    }

                    // if our lineArray has a positive length then at it to our
                    // list of arrays for processing later.
                    if (lineArray.Length > 0)
                    {
                        arrays.Add(lineArray);
                    }
                }
                counter++;
            }

            file.Close();

            // go through the List<int[]> and print to screen
            foreach (int[] row in arrays)
            {
                foreach (int rowCol in row)
                {
                    Console.Write(rowCol + ",");
                }
                Console.WriteLine();
            }

            // Suspend the screen.
            Console.ReadLine();
        }
    }
}

edited Jul 17, 2012 at 7:04

answered Jul 17, 2012 at 6:53

Phil

2,3652 gold badges18 silver badges27 bronze badges

7 Comments

Next Door Engineer Over a year ago

How do you find length of each row array? Also when do the rows stop?

Phil Over a year ago

You can find the number of values in each row with splitLine.Length What do you mean by when the do rows stop?

Next Door Engineer Over a year ago

How can I find the total number of rows in the file? If I need to store the size of each row in another array, do I need another for loop or can I just assign it inside the while loop?

Next Door Engineer Over a year ago

Since we are appending the rows one after the other inside the while loop, we cannot find the number of rows prior to give the size of the new array to store row sizes. I would like to use say, row[1] as a sample for some calculations, then use the next row and so on, preferably in a for loop. I was thinking it can be done if the number of rows is known prior so we can use the for loop.

Phil Over a year ago

How about just picking random items from the arrays list

|

Ria · Accepted Answer · 2012-07-17 07:07:09Z

0

See this lines of code:

List<List<int>> numbers = new List<List<int>>();
foreach (string line in File.ReadAllLines(""))
{
    var list = new List<int>();
    foreach (string s in line.Split(new[]{',', ' '}, 
                                    StringSplitOptions.RemoveEmptyEntries))
    {
        int i;
        if(int.TryParse(s, out i))
        {
            list.Add(i);
        }
    }
    numbers.Add(list);
}

var specialNumber = numbers[3][4];        // gives line 3 number 4
var specialLine = numbers[2].ToArray();   //  gives an array of numbers of line 2

description: I used this useful Generic:

List: Represents a strongly typed list of objects that can be accessed by index

and these useful Classes:

File.ReadAllLines: Opens a text file, reads all lines of the file into a string array
String.Split : Returns a string array that contains the substrings in this instance that are delimited by elements of a specified string or Unicode character array.
Int.TryParse: Converts the string representation of a number to its 32-bit signed integer equivalent.

edited Jul 17, 2012 at 7:07

answered Jul 17, 2012 at 6:48

Ria

10.4k3 gold badges35 silver badges62 bronze badges

2 Comments

Frank Bollack Over a year ago

This will give one array for all lines, but the OP asked for one array per line.

David Mårtensson Over a year ago

This adds the numbers to the same array, each line should be in it's own array so you would need an list of int[].

Ozair Kafray · Accepted Answer · 2012-07-18 06:24:06Z

I have presented the following code in two sections, just to show you in steps.

SECTION 1

This code is just to show that you just needed to loop through all lines and store string numbers from each line in a List.

SECTION 1

static void Main(string[] args)
{
     List<string[]> allLines = new List<string[]>();

     TextReader tr = new StreamReader("Data.txt");
     string word = tr.ReadLine();

     // write a line of text to the file
     while ( word !=  null ) {

         //now split this line into words
         string[] vals = word.Split(new Char[] { ',' });

         //Add this line into allLines
         allLines.Add(vals);

         //Now read the next line
         word = tr.ReadLine();
     }
}

SECTION 2

This section will get you the results as int.

static void Main(string[] args)
{
     //A list of arrays of integers
     //A single array will have numbers from a single line
     List<int[]> allNumbers = new List<int[]>();

     TextReader tr = new StreamReader("Data.txt");
     string word = tr.ReadLine();

     // write a line of text to the file
     while ( word !=  null ) {

         //now split this line into words
         string[] vals = word.Split(new Char[] { ',' });
         int[] intVals = new int[vals.Length];

         for ( int i = 0; i < vals.Length; i++) {
             Int32.TryParse(vals[i], out intVals[i]);
         }

         //Add this array of integers into allNumbers
         allNumbers.Add(intVals);

         //Now read the next line
         word = tr.ReadLine();
     }
}

NOTE: I have not compiled or tested the code above.

Next Door Engineer · Accepted Answer · 2012-08-03 06:56:48Z

0

I figured it out. Thanks all for your time!

private void ReadFile()
    {
        var lines = File.ReadLines("Data.csv");
        var numbers = new List<List<double>>();
        var separators = new[] { ',', ' ' };
        /*System.Threading.Tasks.*/
        Parallel.ForEach(lines, line =>
        {
            var list = new List<double>();
            foreach (var s in line.Split(separators, StringSplitOptions.RemoveEmptyEntries))
            {
                double i;

                if (double.TryParse(s, out i))
                {
                    list.Add(i);
                }
            }

            lock (numbers)
            {
                numbers.Add(list);
            }
        });

answered Aug 3, 2012 at 6:56

Next Door Engineer

2,9164 gold badges22 silver badges33 bronze badges

Collectives™ on Stack Overflow

Reading each row from text file into an array of doubles or integer using C#

7 Answers 7

Comments

Comments

Comments

7 Comments

2 Comments

SECTION 1

SECTION 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

7 Comments

2 Comments

SECTION 1

SECTION 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related