I've just interviewed for an amazing Python job, and if I get it I swear I will owe you so much. Everyone says this already but they're right, your videos are fantastic, thank you for all your time and effort!

I gotta say: it's so rare to find someone with such a great ability for teaching. You should do another one for XML parsing.

Love the tutorials Corey they help so much in learning Python. Just thought I would update this video because the syntax is off around 8:00. The context manager "with open('new_names', 'w') as new_file:" will return a CSV file with a blank row in-between each row. The quick fix is to add "with open('new_names', 'w', newline='') as new_file:" and the issue goes away.

What I love seeing in the below comments is people actually helping other people. There isn’t any bashing or calling each other names. Lovely.

I just realized whenever I have a question about python, as long as I come to your channel, I can find the answer! Thanks very much!

I've spent a week trying to figure this out. I watched your video and it took me 10 minutes! THANK YOU. THANK YOU.

Every time I need help with a certain topic (and you've made a video on it), your video pretty much instantly solves my problem. I've spent an hour or so looking through forums and tutorials and this solved my issue in about 5 minutes. Thank you yet again for your expertise. 5/5

You are so good at teaching man. I appreciate every video that you produce.

Thank You sir, this lectures are still, in 2022, faaarrr more better than other so called tutorials It is difficult to believe someone gave such free high quality content years ago, you helped millions!!!! Thank You so so much

if you have new csv file with blank lines this is for you # Python 2 with open('new_names.csv', 'wb') as outfile: writer = csv.writer(outfile) # Python 3 with open('new_names.csv', 'w', newline='') as outfile: writer = csv.writer(outfile)

I am taking Harvard University's online CS50 course and I could understand JACK about CSV file till I saw this vid 😂 .... Thanks a lot man 👍

I have never seen a negative comment on your videos. You are helping me get through this coding boot camp like you'll never believe. Thanks, Mr. Corey.

Brother Corey Schafer, your parents should be proud of you. You are a genius. Great at explaining. I have watched almost all videos of this python series. They are blessing to every python beginner. Thanks for all those videos.

I hadn't touched Python in years and I've learnt so much from your videos about requests/requests-html, reading APIs, and CSV files. Thanks so much!

I was doing this Data Science course on Coursera, and the lesson on the csv module covered a load of content in a very short time. Of course, not understanding a thing, I had to revert back to KZfaq. This video clears it up really well. Thanks.

I am a beginner in Python but whenever i watch your tutorials i feel its easy to write programs in python.The examples are very good. I wish if you can give some exercises based on the videos you show which will help beginners like me to write more programs.

For anyone getting spaces between lines using writerow method ( using python 3 ), you need to add newline=' ' inside open like this, open('file.csv', 'w',newline=' ') as ... : (the second with open iteration)

Any time I'm hunting for information on Python, my searches always lead to you and I'm never disappointed. Keep up the great work!

You are a natural professor. I appreciate the clarity & completeness. The text is easy to read on a desktop but was a little hard for me to read on a cell phone. If there was a way to zoom in on the text so it could be easier to read on a cell phone that is the only thing that could possible improve this video. Either that or I just need to visit my Optometrist and your videos are flawless.😀

Thank you very much Corey. I switched job and now work with python. your videos helped a lot not to lose it in the beginning :-)

Saved my life when doing my higher computing science coursework. Thanks so much!

This video is the best, I watched many videos on KZfaq, only this one really help

Hi Corey, thanks for this video. For my interview tomorrow this is what I was looking for.

Thank you SOOOO Much, even after 6 years this tutorial is so useful. my college professor just told use to do this with an article attachment and it's an intro class so I couldn't understand a single thing on there. THANK YOU FOR THE VIDEO TUTORIAL❣

1:25 fun fact, when they're not comma separated, it's used dsv instead of csv. D for delimiter. In this sense, all csv files are also dsv ones. Just a tiny sidenote to another awesome video of this series.

Corey, you make me have two interviews and real oportunities for a job, here in Argentina. Thanks you a lot. I'm now a member of your channel, hope u the best.

OMG Corey you are soooooo helpfullllllllllll. I love you!

Hello Corey, I just discovered your channel today and it is awesome. Funny that you cover all the topics I am interested in (Python, SQL, Pandas, MatPlotlib etc). For people like me who never even came close to going to college/university this is awesome. One topic I would really like to see would be a tutorial on (if at all possible) automating the process of extracting tabular data from PDF's using Python and convert them into useful Excel files (something I need to do on a daily basis at work). Awesome channel, keep it up!

Better than my professor! Thank you.

Excellent series and I'm learning a lot from them. Your tutorials are my goto when I have a question. I really wish you had extended this video to include writing the two individual fields instead of just using delete. It would have helped with my needs more. I am working on a project with 20 fields in my input, but needing to write only 15 fields from the original file, and add two new fields to my 17 field output file.

For Windows Python, to eliminate the blank rows between entries when writing, add the newline=''' parameter when opening the new_file for writing. "with open('new_names.csv', 'w', newline='') as new_file:"

Thanks for being so clear. Learning by yourself can be like decyphering hierogrypics

I can not quite put the finger around it, but your teaching is magical!

You have a very, very simple teaching style that makes it easy for newbies to understand. You're a great teacher! Thank you for the awesome FREE tutorial! This was so much more useful than online courses I am paying for!

I would sell my soul to have you as a teacher for a day.

very good, not only do you explain it very well, you explain each part of what you are doing and why. all in all a very good tutorial.

First of all Corey, I will like to say that you're an amazing teaching. You've inspired lots of people especially someone like me that is pretty new to Python. Your videos are awesome. Just keep up the good work we really do appreciate you. Thank you! With that been said, Corey, I have been searching and googling almost everywhere like stack overflow and many other python communities to see if I can at least find maybe an examples on how to work on or handle large files in python -- files ranging from 100 GB and up. Unfortunately, I haven't seen anything that actually explains the concept clear enough. So, I was wondering maybe if possible if you will consider making a video just for that purpose. Basically, the program should be able to read, chunk and write the file(s) or segments into a folder based on numbers of lines or size specified by the user. Please I will really appreciate it if you can help. Thanks in advance!

Coding after long time...Feeling excited! Thank you for your tutorial. Easy to follow.

you're videos are magic !! i love watching them , thank you so much !!!!!!!

First of all, your teaching style is good, and anyone grabs ur teachings easily, and thanks for teaching us. you are the best tutor I have ever come up with in python language. can u suggest any python language book, which is best to go through other than your channel? Moreover, I am a beginner to python language I thoroughly enjoyed ur videos, if u can suggest me best python book to ur sensibility and I guess it suits me and it helps me to learn further (I like physical like books). In case if u written any books related to this language can u suggest one (or) your favorite book, please......................................

best python tutorial I ever watched

YOU ARE GOD OF PYTHON

Thank you Corey for your time and effort. Keep spreading the knowledge.

Why this wasn't part of my introductory Python class, I will never know. But, thanks to you, it really doesn't matter.

Total life saver, I needed this for a project due today, thank you so much!

Thanks for the wonderful explanation ❤💫💪🏼

Before watching Corey video.. i always hit like..

I think and i hope you are on a path on start tutorials on pandas, and i guarantee that it could be the blockbuster series, people will love your quality videos and teachings. Their are no quality videos on pandas on youtube.

Short and down to the point.You Sir you're a God Sent.

I just found your channel! Come on man, come back to KZfaq: Your tutorials are great!

I like yours video. My english is poor but i learn a lot of things with your channel. Thanks ...

You make everything so simple to understand. thank you so much!

refreshingly thorough and helpful ! thanks for posting this

U are great Corey Sir ... waiting for Ur 1 million subscribers ❤️

to be honest you're the best instructor I've even seen on youtube, can you please make tutorial on simple website that when the user submits a form python code will run to get for example google result . I've been trying to do this for a while now still no luck. I just what to figure out how to run python code from html whenever the visitor searches or interacts with the website.

Hey thanks for posting this, I'm very new to Python (and watched a lot of your other tutorials). I'm a meteorologist that works with instrumentation datasets so i live and breathe HUGE csv files lol Hoping to use this method tutoring a local HS student for his project. Thx again and cheers from Maryland!

Super useful! Thanks dude!

You got some real talent man, I'm really appreciate with your video.

Hello Mr Corey ! Thanks for this incredible content!

Thank you for the tutorial.Helped me a lot in my miniproject.

Absolutely, fantastic video and simple to understand it. Many thanks for your time and efforts

This is the best tutorial the I never found! Thanks so much!

You are very thorough in your explanations. I've subbed and I hope you keep this up!

Awesome video, I very easy to understand! Thank you for the awesome video!

You covered very well through explaining simple way. Thank you very much

excellent stuff definitly helping with my masters project

Corey, you are the best. Thank you.

man you are a very good python presenter, keep up the great work and vids.

15:17 This works too: # use extrasaction='ignore' to ignore any fields not specified in fieldnames with open('names.csv', 'r') as csv_file: csv_reader = csv.DictReader(csv_file) # newline="" prevents double spacing with open('new_names.csv', 'w', newline="") as new_file: fieldnames = ['first_name', 'last_name'] csv_writer = csv.DictWriter(new_file, fieldnames=fieldnames, delimiter = '\t',extrasaction='ignore') csv_writer.writeheader() for line in csv_reader: csv_writer.writerow(line)

lovely back in college when I learned this with java I had to code all by myself incl logic for escaping ;)

Excellent work Sir, Your teaching style is awesome.

Thank you very much Sir for creating such an easy to understand tutorial about reading writing csv file.

I really enjoyed this tutorial as well as all of your other tutorials that I have seen. I was wondering if you had shown a method for updating csv files?

just what i needed for my problom set thanks bro .

Thank you so much.

You are amazing! Thank you so much!!!! I have a better understanding of csv and can apply it to my school assignment.

This is fantastic, no lies. Thank you very much

You are Awesome i used thes codes as a mad man .. I loved it

Great tutorial - thank you! Subscribed

Great video, very informative and helpful. You make it really easy to follow and understand

if you don't use the newline parameter, writing the data to a new file will result in every other line being skipped. to alleviate this, use the newline parameter newline='' that is newline with two single quotes with open('new_names.csv','w', newline='') as new_file:

Thank you man i will pass my gcse

Awesome, thank you corey!

Thanks Corey. Very Helpful! Cheers!

Master... teach me more... need more, more, more. Thanks

Whenever I make my own file (in notepad but in .csv form) and try it on it , it shows this... Traceback (most recent call last): File "C:/Users/union/Desktop/python/CSV.py", line 6, in for i in csv_reader: ValueError: I/O operation on closed file. someone gets what's wrong?

Thank you so much for these amazing videos.

Superb sir you make me to learn a lot

Corey, you are a god among men and a million times better than my shitty lecturers

Nice explanation, Thanks!

For anyone watching this using 3.8 and above, the DictReader now returns rows as a plain dictionary, no longer as an ordered dictionary.

thanks brother

1:06 csv = 'comma separated valued' "And what separates the values is called a delimiter. So the 'comma' is a common delimiter. But you can use just about anything. Sometimes you will see files with tab-delimited values or dashes or things like that but they are called csv files."

great vid man

Amazing video man , thank you so much

Very helpful videos, keep up the good work!!!!!

Amazing explanation.

Thank you , Thank you , Thank you , ... , Thank you

You are an awesome tutor!

SO helpful, thank you!!