File input and sorting into array for further organization

Question

I am designing a program that will take a file input, in the programs case, a census file that has 4 different inputs age, gender, marital status, and district.

My question's are

How exactly could I take the input and sort them into arrays, both integer (age and district) and string (marital status and gender) data types

How do I use them to count how many of each there are?

Any suggestions will help! I know how to read in the file and separate the info using input.Split(',') to separate whenever there is a comma, however, I am having trouble looping through so it doesn't repetitively loop unnecessarily.

Hari Prasad · Accepted Answer · 2016-04-01 04:02:39Z

1

You could do start doing something like this, this code uses Linq.

var records = File.ReadAllLines(filepath) // read all lines
    .Select(line=> line.Split(','))       //  Process each line one by one and split.
    .Select(s=> new                       // Convert to (anonymous)object with properties. 
    {
        Age = int.Parse(s[0]),
        Gender= s[1],
        MaritalStatus,= s[2],  
        Status= s[3],
        District = int.Parse(s[4]),  
    }).ToList();

Now you can access each record using

foreach(var record in records)
{
    // logic
    Console.WriteLine(record);
}

and Count using

int count = records.Count();

answered Apr 1, 2016 at 4:02

Hari Prasad

17k4 gold badges23 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

File input and sorting into array for further organization

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related