Java: Read a CSV File into an Array #49

[@alexlorenlee]

If you’re new to programming but want a career in tech, I HIGHLY RECOMMEND applying to one of Springboard’s online coding bootcamps (use code ALEXLEE for $1,000 off): bit.ly/3HX970h

[@cristobalsanchez3829]

System.out.println(“I love your videos”);

[@sakshi8574]

I'm an Engineer and graduated like a month ago. Not a single teacher in 4 years of my graduation taught me in such a good way ! Thank you Alex ❤️🇮🇳

[@jglee6721]

I think Alex mentioned that he didn't have a good teacher thus he started these videos to help others. Thank God he is a world class teacher and 196K subs at this point in time speaks louder than words.

[@paulhetherington3854]

Like a, month ago? Bull sht-- e(ng)ineer -- racist... EINEER -- not E(ng)lish

[@mannyokafor4609]

Fifth! my fav youtuber if I am honest you deserve much more subs man just keep going Java is gonna get much more popular! Please do a video on annotations!

[@martynbirdem189]

See this video I hope you will find it helpful. And you can subscribe also get the original code by mail. I have also get kzbin.info/www/bejne/o16QZZeahbKartE This is the channel link

[@shazzadurrahman9750]

1. How to skip the first row of headline 2. How to read the each row from csv file 3. How to write in csv file

[@seelyw.4818]

1. put this in your while: if (values[0].equals("NameOfFirstHeading")) { continue; } else { code wich parses the columns }

[@martynbirdem189]

See this video I hope you will find it helpful. And you can subscribe also get the original code by mail. I have also get kzbin.info/www/bejne/o16QZZeahbKartE This is the channel link

[@Rajdeep11082]

To write into a file, try (PrintWriter pw = new PrintWriter(new FileWriter(file))) { pw.write(“data to append) } catch (IOException e) { // Handle the exception }

[@Rajdeep11082]

It is not a good idea to read and write into the same file, it would be better to create a diff file for writing if you perform read operation simultaneously, and later if needed, files can be merged easily

[@Kurokage130]

Fourth! Alex you rock man this is exactly what I needed to analyze stock data! Are you a mind reader? =]

[@BrandonCastillo-eo1or]

Lol. Are you taking any Udemy course?

[@gabbishleegifted4752]

That’s a good point this would be sufficient for that

[@m4gg197]

4:34 BLESS YOU! The "wow" killed me 😂☕

[@sanuMani1998]

same here , I was laughing the whole video with that wowww . 😂😂😂😂😂😂😂

[@lesediseleke1416]

If I could I'd reference Alex only in assignments cause this is so helpful

[@morris4622]

hi alex i love your vids about java but can you pls make a game with the JFrame plss

[@luisvieira640]

MC Noob26 Great suggestion!

[@tiboomvds344]

I hope hé do it this Will be also good for gis vieus because that is much populier as a simpele turtorial

[@aayamrai1215]

kzbin.info/www/bejne/nYLFZJd7Yt5kiZY

[@aayamrai1215]

kzbin.info/www/bejne/nYLFZJd7Yt5kiZY

[@zimt_g2375]

here for the cute Asian guy with additional java knowledge

[@sheriffcrandy]

Gay

[@mngf749]

@@sheriffcrandy homophobic

[@williamtrillion992]

@@sheriffcrandy lmao

[@harpreetjanday1660]

hi alex

[@ap-pv7ug]

You no longer need separate catch statements to catch each individual error. You can just use a vertical pipe to separate types.

[@paulj19]

second

[@brianparsons5709]

Thank you for not only explaining yourself as you go, but also taking the time at the end to go back and explain the process line by line. You are a life saver!

[@martynbirdem189]

See this video I hope you will find it helpful. And you can subscribe also get the original code by mail. I have also get kzbin.info/www/bejne/o16QZZeahbKartE This is the channel link

[@yashsaxena7787]

what if the data already has commas in it? like the address. The what to do??

[@michaelsteele8402]

found my problem

[@axelpalomino2571]

don't think if this is relevant, but can you make a video about creating a java multiple choice quiz using buttons. I am working on a project similar to this and I need help. Let me know what you think.

[@axelpalomino2571]

Please!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@bjr816]

I can't wait for your course. You explain topics better than most people, move at constant pace, and provide great examples.

[@alexlorenlee]

Thanks :)

[@Kaname2907]

Hey Alex is there a way to put a sound track into a java gui program?

[@Aratussyitto]

You can use InputStream ! but just convert the files to .wav or .au

[@Kaname2907]

@@Aratussyitto I will try that! Thank you!

[@OzozGaming]

How would you separate a txt file into multiple txt files i.e. student2018.txt, student2019txt etc

[@driesyperman8119]

Go to window -> preferences -> Run/Debug -> Console -> disable "Limit console output" . Now you can see all the output.

[@christianw1490]

can you do the same tutorial for a 2 dimensiol array? Great video tho and very easy to understand

[@anr_plays]

Show how to make your slot machine.

[@jessechoe]

Again, The day I learn some topics in Java, you create the perfect video the eliminate my confusion. Thank You!

[@martynbirdem189]

See this video I hope you will find it helpful. And you can subscribe also get the original code by mail. I have also get kzbin.info/www/bejne/o16QZZeahbKartE This is the channel link

[@nityasridhar]

Wait so which part of this is the array? I'm confused

[@djuka8121]

This vid helped me a lot. Thank you Alex

[@itscarine8786]

hi, how do you sort arrays from the file? Let's say the length of the address from shortest to longest?

[@JapanTravelShorts]

I want to know that as well

[@morris4622]

first

[@youkeshgurung5280]

Bro, have you learned programming language by choosing IT course or you learn by yourself😀😀😀♥️♥️

[@renecabuhan1675]

He is a software engineer.

[@mineclashtv9709]

Why wouldn't you use the java.nio.file.Files class to read a file (from a Path object) as a String? It's a lot simpler and more readable this way. String[] values = Files.readString(Path.of("Path to file")).split(";"); (might throw an IOException) To get an array of single lines, you could either replace the split(";") with split(" "), get a List of all lines using Files.readAllLines(Path) or even a stream with Files.lines(path), though streams might be a little too advanced for beginners Iterating over the array is also easy: for(var value : values) System.out.println(value);

[@uppalaadarsh3261]

Can we ignore headers in file

[@DarKingHell]

te falto cerrar el archivo

[@dhrutipatel5264]

My code is exactly the same still doesn't work shows the problems like Variable 'line' initializer '""' is redundant and 'catch' branch identical to 'IOException' branch can u help?

[@kerimragimov5727]

You can not imagine how you helped me out with my CS lab. Thank you Alex:)

[@suchismitamohanty9010]

Hello Alex, I hope you are doing well.I wanna little guide from you..I have understood all the concepts of java but while I am trying for competitive coding I am unable to solve it..can you suggest how to be good at competitive coding

[@jurgencampos8505]

Just what i needed today! Thank you man!!

[@paulhetherington3854]

This isn't, the origin, EVrr of Java! Hence; illegally - get filesz! Under this Act: Loaned Land Act

[@itaybroder2037]

yo Alax can you pls make a vid on maps and hashmaps in java? I really need it and love your videos mate:)

[@renecabuhan1675]

He made it already

[@annalee9763]

thanks a lott these videos help, i am actually trying to make an app for parking since i forget to put parking . Can you help me make the app. this is how the app should work -> read the number see if it matches the number i put. -> read the timing till when the parking ticket lasts for and set alarms before the time provided . I cant find any KZbin channel that will help me in this problem, if you can please find the time to make a video on this. i would be very grateful thankyouuu soo much once again

[@salehashamim7803]

Plz reply me. I am printing output in excel and input file is properties file. But output is coming with double quotes which I don't need. How to fix it.

[@osamugaming1807]

If you are using Windows and it seems there's an Exception showing up in String path just change the \ backslash to / forward slash

[@Sinaiii]

my scanner is skipping the last line to read because i have a while loop with the following condition: sc.hasNextLine() help

[@StevenRafael268]

Thank you so much for this super useful video! this saved my butt with my assignment haha

[@johnmaravelis9568]

☕☕☕ Hey Alex, another great video thank you for helping us learning Java!! At some point you mentioned #RegEx, could you make a video explaining them?

[@martynbirdem189]

See this video I hope you will find it helpful. And you can subscribe also get the original code by mail. I have also get kzbin.info/www/bejne/o16QZZeahbKartE This is the channel link

[@davidhamilton9871]

dude why are you using your desktop directory instead of the IDE folder that can be packaged together; cant use this

[@ferfykins]

Excellent video, thanks Alex.

[@morris4622]

do you reply???

[@FabianVirgen-gz9yl]

You've taught me more than my college professor has... lol much love Alex

[@hypnos9336]

MAN I wish I had seen this tutorial about a month ago. I was trying to write a similar program and for the life of me couldn't figure it out

[@roneelkumar3269]

HI. Alex can you tell how can we sort this file by book id with insertion or any sort or anyone has any idea about this. Thanx.

[@ghostcavalry]

Thank you soo much it was exactly what I was looking for 2 days..

[@lauraaltavilla399]

public void EscribeEnTextoCSV(String nombreFichero, boolean anyadir, Alumne al) { File f; f = new File(nombreFichero); boolean encabezado = false; if (f.exists() && !anyadir) { f.delete(); encabezado = true; } if (!f.exists()) { encabezado = true; } //Escribir con buffer para hacerlo línea a línea FileWriter flujoSalida = null; BufferedWriter salida = null; try { flujoSalida = new FileWriter(f, anyadir); salida = new BufferedWriter(flujoSalida); if (encabezado) { salida.write("nom;apellido;edat"); salida.newLine(); } String nom = al.getNom(); salida.write(nom); salida.append(";"); String apellido = al.getApellido(); salida.write(apellido + ";"); int edat = al.getEdat(); salida.write(Integer.toString(edat)); salida.newLine();

[@loetonkukubane2424]

need help looping through a CSV file, checking and printing if it has duplicates or not.

[@sanjaymarathe3763]

are you an oracle certified java programmer? just asking :)

[@akshithachennupati7278]

could u please make a video on storing datasets into graphical neural networks using java

[@mattnsac]

Found it entertaining that I know damn near ever street in that list. Go SacTown!

[@latedeveloper7836]

Does anyone know how to skip the header row? I have different data types but can't figure out a simple way to ignore the header row (all strings, whereas my data has doubles). Any help much appreciated!

[@hemanthgowda3450]

How to print a partical line in csv file instead of printing evrything can you please send me the code

[@boshydbash9030]

making videos so simple gg alex lee liked vid

[@xow9450]

what if the array youre using is for a class and not a primitive type

[@magretrutendontokozoshone3366]

my first year lecturer, Alex Lee. thank you so much. this year has been tough :(

[@JuanitO_o]

any idea why the csv that i made in excel separates the data with this ; instead of commas?

[@johnbeesoo1634]

Hi how can I retrieve a specific data ,like for example a specific row and column?? the data being: car owner plateNo 1 a a1 2 b b1 3 c c2 I wanna retrieve only row 3 and column 3

[@nickingraz6727]

HOW DO I SELECT JUST ONE VALUE OF THE ARRAY AS A DOUBLE SOMEONE PLEASE HEEEELLLLLLPPPPPPPPP

[@Ms_Oszy]

thanks alot, what if file need to be fragments into m blocks ?

[@anonym0us__537]

Thank you so much...😊🙏 . Just one doubt , Is it possible to search for a particular value,like just one name like "Alex" and the program will print all the corresponding values which we need..?

[@adarmawan117]

I think you need to explain between Scanner and bufferedReader or anything else to get input,.

[@khoanguyenucang5534]

hello guys, i have a range of date for example 03/01/2020 to 03/05/2020 in third column , and now how can calculate data from a fourth column that are corresponding to the third column, thank you guys !

[@RaselAhmed-ix5ee]

please reply me its an urgent help by tonight i need to submit a program

[@celestiaharpster4273]

Thanks for your excellent videos, you explain things so clearly. I say this with kindness I promise, but my 3 year old loves curious george and I couldn't help but notice you bear a striking resemblance to the man with the yellow hat, I say halloween costume idea.

[@essaydnb]

why does it not read the titles of each column and instead start on line 2?

[@djneverblock7300]

I swear this video was so helpful to me. i was looking for a more efficient method of scanning these than using a normal scanner method. you explained it in a clear way and easy for me to understand. thanks for saving my weekend :)

[@andreviniciusbezerradasilv9335]

thanks bro, your java content helped me a lot.

[@F1rstNameLastName]

I spent 3 hours trying to figure out how to do this because my uni lecturer is awful at explaining things and makes everything overly complicated, but then I bumped into this and figured it out within the first 9 minutes.

[@samsepiol7]

If I want to do the same thing but with 3 files, what do I do?

[@shadowwmoses3721]

Can someone help me like for example I want just the row where the address = 1260 BELL AVE

[@noone-hi6kq]

Not bad, man. I hate almost all youtubers but it is good

[@drcl7429]

Don't forget to do a close() on the bufferedreader. Best to put it in a Finally{} block following try-catch.

[@nicoleuruchima595]

THNAKS, you saved mi life.

[@atomrofl693]

Hey, where can I find the scanner version of this?

[@deinarudkova-schneider119]

OMG! you are just the best!!! :D Thank you!

[@ibrahimcowke]

He always says, Insha Allah. I think he is Muslim?

[@umiuo8894]

I can't take your java course because I don't wanna spend 15,000 INR

[@HammtariProductions]

Thank you, you are saving me from failing my computer science test 🙂

[@nuwaver91]

Thank you very much for this useful tutorial! Just one thing, I didn't catch why we need at 11: String line = "";

[@joeord4669]

hi how would you run queries on this like say i only wanted to see crimes that have been committed on a certain day for example?

[@mcfirstempire]

Merci !

[@CambrielMoore]

Hei Alex, how can you differenciate between a seperating comma and a comma which is used within a string of text? Like Story, #OfWords. foo, foofoo, 2 like i am working on a programm which lets you create quizzes on your own.. and i thought that csv files could be the thing how i store the quizzes :o

[@AayushBartaula]

Please make videos for binary file also

[@luttrell321]

What if I only wanted to read the first x number of lines of the file?

[@adolfjamesurian6510]

How do you insert data to txt file? Like to avoid making new object and deleting all the data inside the txt file? Can u make a tutorial

[@jetonkrasniqi8762]

You are doing a great job, keep it up.

[@hafpixels4172]

How come I didn't find your channel earlier 😕. I am amazed man♥️♥️.

[@hafpixels4172]

You got a new subscriber

[@eugenesmith9940]

Don't you need to close that reader (br)?

[@1914abw]

That move toward the end of your videos where you zoom out and show the entire code is so REFRESHING!!! Thanks a lot. Great job! Keep up the good work!

[@martynbirdem189]

See this video I hope you will find it helpful. And you can subscribe also get the original code by mail. I have also get kzbin.info/www/bejne/o16QZZeahbKartE This is the channel link

[@noahibarra3379]

what would the syntax look like for putting it into a 2d array char by char?

[@abizardhofar3294]

I want to read last row from the csv file and store in the array. How to do that? Can anyone help me out>

[@emmanueloloruntola7436]

How could I access this array in another class

[@arturopresa6552]

Thanks so much for you explain what I needed to understand!

[@twofacil]

I will like to do the same but instead of read the file vertically i will like to read it horizontally.