Coding Gem #1.3: Parsing CSV Data as Lists in C#

[@kristhomas8295]

I cannot stress how good this was. You didn't leave anything out in my opinion, everything was explained beautifully. I came here with the intent to review something I thought I already knew, and left here learning a lot. Thanks!

[@jmoreno7554]

One of the best walk throughs Ive ever watched.

[@marcelobeani]

You are a very good teacher, congrats man. It really worked for me.

[@SharaPk]

You explained everything, I loved that, thank you :)

[@adamonjourney3726]

Thank you for this great tutorial. Again learned new things. Btw: in countries with comma-decimal numbers we have to use System.Globalization.CultureInfo.InvariantCulture to Convert DoubleNumbers... otherwise 49.0(string) will be converted to 490(!). exp.: double g = Convert.ToDouble(rawData[7], CultureInfo.InvariantCulture);

[@ParametricCamp]

You are absolutely right, I have ran into this issue before, thanks for bringing it up!

[@opafritzsche]

@@ParametricCamp YOU ARE BRILLANT! This is exactly what i am searching for.
*BUT* there is one Problem for me:
i need this, inside a C# Form ( UI Form for Windows ) is there something to find on your channel?
Also i have a *LOT* of data, 1 CSV String to be split = 71 special Colums.
Than i have a not know Amount of rows.
So i need 71 Lists with Special colum data
+ unknown amount of rows all contains 71 Lists.
Did you think this will be possible, or is this just **TO MUCH** to split ?

[@danielferrero211]

Gracias por el video, me fue muy útil a pesar de que no domino el ingles perfectamente.

[@bluefyr22]

this was amazingly helpful! thank you. I've been trying to figure out how to pull csv data into an array that i could then randomize and output different combinations.

[@AndreasDahl87]

Great tutorial for hobby programmer :D Thanks a lot!

[@jacobgandrup9865]

Thank you for this awesome and really helpful video, big thumps up!!

[@arfaouiarij8938]

Thank you for simplifying this ! However, I have a question : So if the csv file have more than one "table", meaning that more than one header. For example : Name , last name and underneath the data for those and then address and email and the corresponding data underneath. How do I do with that?

[@charudattabangal5123]

Thank you for this great video,but I have a question regarding scientific notation.
My csv file contains scientific notations, so is there any way to get rid of those?

[@anhquantrannguyen20]

Just want to say thank you for the lecture.
I tried to repeat the example with a random csv file I took from Autodesk Revit Mechanical/ Piping family (US - metric). I couldn't convert string list with decimal number (i.e 12.987) to double although I checked the csv carefully by inserting it as data into Excel for observing.
Finally, I have achieved it by using Double.Parse method with changing IFormatProvider formating to the "en-US". Things I have learned from Double.Parse method is I also can use Double.TryParse method to verify if there is an odd format in a row/ column list.

[@charliewhittaker1391]

Thanks for the tutorial dude! Do you know how to then sort these lists while keeping the data in the same columns?
Many thanks

[@arturoordonez-hernandez8750]

Using C#'s verbatim (@"") strings is similar to HTML's tags.

[@haskell3702]

What if the value contains the comma character?

[@leizedsanchez3521]

Excellent thanks!

[@yaduvamshi9]

How to print the data in another file rather than into console

[@jeptho]

Great video.
I have a csv where a row contains a customer number, a price and a item number. If the customer has multiple items with the same item number, it displays in the csv as a line for each item.
How would you sum the price for each customer, for each item.
Example:
Customernumber, 150.50, itemnumber1
Customernumber, 300, itemnumber2
Customernumber, 150.5, itemnumber1
The result should be customernumber, 301.0, itemnumber1
Customernumber, 300, itemnumber2
Hope it makes sense.
Thank you in advance 🤞🏼

[@capitanrdc99]

thank you so much!!

[@brehiner25]

As I can see, you are printing by column but how can I print a specific row?

[@adamonjourney3726]

Console.WriteLine(csvLines[i]) in a loop

[@hamzadamiel7224]

how do i read a row and then put it in a list that can allow me to access the individual elements in the row

[@adamonjourney3726]

Maybe you can use a jagged list like:
static void Main()
{
// Read the contents of the CSV file (as lines into array)
string[] rawLinesCSV = System.IO.File.ReadAllLines(@"C:\grades.csv");
// Count lines
var dataRows = rawLinesCSV.Count();
string[][] jaggedArray = new string[dataRows-1][]; // without headerRow
for (int i = 0; i < dataRows - 1; i++)
{
Console.WriteLine("i: " + i + " : rowData: " + rawLinesCSV[i + 1]);
jaggedArray[i] = rawLinesCSV[i + 1].Split(',');
}
for (int i = 0; i < jaggedArray.Length; i++)
{
for (int j = 0; j < jaggedArray[i].Length; j++)
{
System.Console.Write("jaggedArray[{0}][{1}]: ", i,j);
System.Console.WriteLine("{0}{1}", jaggedArray[i][j], j == (jaggedArray[i].Length - 1) ? "" : " ");
}
System.Console.WriteLine();
}
Console.ReadKey();
}
#####
Output:
jaggedArray[0][0]: Alfalfa
jaggedArray[0][1]: Aloysius
jaggedArray[0][2]: 123-45-6789
jaggedArray[0][3]: 40.0
jaggedArray[0][4]: 90.0
jaggedArray[0][5]: 100.0
jaggedArray[0][6]: 83.0
jaggedArray[0][7]: 49.0
jaggedArray[0][8]: D-
jaggedArray[1][0]: Alfred
jaggedArray[1][1]: University
jaggedArray[1][2]: 123-12-1234
jaggedArray[1][3]: 41.0
jaggedArray[1][4]: 97.0
jaggedArray[1][5]: 96.0
jaggedArray[1][6]: 97.0
jaggedArray[1][7]: 48.0
jaggedArray[1][8]: D+
and so on...

[@hugohuaman1487]

But how can I make a sum ? I mean if int the list of double there are the values 1 2 3 and I want to sum these 3 values how can I do that ?

[@adamonjourney3726]

declare a variable SUM outside a loop and count in loop like: SUM += columnWithNumbers[i];

[@serj-nf7ll]

Tnx MAN!

[@jeodezman32]

simple, pefrect.

[@josoeI]

Thank you so much

[@rubeushagrid4131]

Csv is easy. Tell us about xlx

[@aqilnoor2678]

Thank you, You made this easy to understand for me
ruclips.net/user/sgaming/emoji/7ff574f2/emoji_u1f44d.png