Python Tutorial: CSV Module - How to Read, Parse, and Write CSV Files
HTML-код
- Опубликовано: 12 май 2024
- In this Python Programming Tutorial, we will be learning how to work with csv files using the csv module. We will learn how to read, parse, and write to csv files. CSV stands for "Comma-Separated Values". It is a common format for storing information. Knowing how to read, parse, and write this information to files will open the door to working with a lot of data throughout the world. Let's get started.
The code from this video can be found at:
github.com/CoreyMSchafer/code...
✅ Support My Channel Through Patreon:
/ coreyms
✅ Become a Channel Member:
/ @coreyms
✅ One-Time Contribution Through PayPal:
goo.gl/649HFY
✅ Cryptocurrency Donations:
Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3
Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33
Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot
✅ Corey's Public Amazon Wishlist
a.co/inIyro1
✅ Equipment I Use and Books I Recommend:
www.amazon.com/shop/coreyschafer
▶️ You Can Find Me On:
My Website - coreyms.com/
My Second Channel - / coreymschafer
Facebook - / coreymschafer
Twitter - / coreymschafer
Instagram - / coreymschafer
#Python
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!
That's great, Nina! It makes my day to hear feedback like this. I wish you the best in getting the job. Good luck!
So guess what... I got the job! Big big thanks again, it means so much to me to get a job like this. I'll be sure to keep on recommending your videos!
Congrats Nina!
I guess it's special to me because of the struggle it took to get here. My degree isn't in Computer Science, but I really wanted to get into programming and I thought it'd be too difficult to get my foot in the door. But the job I've just got is at a tier 1 investment bank as a Developer, so now I'll get to do something I enjoy for a job, get paid really well for it, and live/work in a beautiful part of London. Not a bad place to start!
@@HellO-ly1bp Hey its been a year since you posted this. Im a CS well Computer ENgineer, and i learning this stuff for last 3 weeks goign for 3 months strait. I wanted to ask
What did they ask about what you needed to know about Python and what are you constatnly doing at your job with Python? Like type of things your coding or editing?
Thanks and its very late but grats on the job :)
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.
Hi Corey, thanks for this video. For my interview tomorrow this is what I was looking for.
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!
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
I've spent a week trying to figure this out. I watched your video and it took me 10 minutes! THANK YOU. THANK YOU.
You are so good at teaching man. I appreciate every video that you produce.
nitty? oh, are you wondering why you have no friends? because when someone produces something absolutely amazing you don't notice it???
it's a compliment. get over yourself.
+JDI2002 Seriously, the guy pays Corey a much deserved compliment and you manage to find fault with it?
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!
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!
This video is the best, I watched many videos on RUclips, only this one really help
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.
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
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.
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?
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!
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.
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.
Yeah, when I first started making videos I was worried about the comments, but this community of people is fantastic. Super nice and helpful.
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.
thanks you so much, I was wondering about what I did wrong...
@@francescob1904yeah me too and I was wondering why there was an extra line after each original line XD
Coding after long time...Feeling excited! Thank you for your tutorial. Easy to follow.
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.😀
You covered very well through explaining simple way. Thank you very much
Thank you Corey for your time and effort. Keep spreading the knowledge.
Thank you for the tutorial.Helped me a lot in my miniproject.
Total life saver, I needed this for a project due today, thank you so much!
You are very thorough in your explanations. I've subbed and I hope you keep this up!
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!
You make everything so simple to understand. thank you so much!
OMG Corey you are soooooo helpfullllllllllll. I love you!
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 RUclips. This video clears it up really well. Thanks.
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 👍
SAME
Me too!
Me too :) just 5 months later
I am taking the same course and have found the instruction to be quite lacking. I would be completely lost without Corey
me toooo
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!
Saved my life when doing my higher computing science coursework. Thanks so much!
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.
Thank you very much Sir for creating such an easy to understand tutorial about reading writing csv file.
refreshingly thorough and helpful ! thanks for posting this
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 :-)
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.
Thanks! I appreciate the kind words
best python tutorial I ever watched
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 had the same problem :P ...newline='' works just fine. Thank you.
Great lectures, I really like the way you teach it. ;) not too fast, not too slow, good examples, easy to understand, really brilliant teaching skills ;)
thank you, your way works fine.
cheers brother
I was spending 15 minutes to resolve it until you saved me with your comment. Thanks a lot!
I wish I had read the comments... I couldn't understand why my code was f-ing me up
you're videos are magic !! i love watching them , thank you so much !!!!!!!
+madyrebecca Corey's videos are 'magic.' I've started on Python books that just bored me. I've used Udemy, CodeCademy, other RUclips videos, as well as countless other tutorials, but *nothing* has helped me nearly as much as Cory's tutorials. So yeah, "magic" applies here. I bet he's a warlock! lol
Thanks for being so clear. Learning by yourself can be like decyphering hierogrypics
This is the best tutorial the I never found! Thanks so much!
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.
how'd the bootcamp go bruh
@okayest_pianist For me it was worth it. My class size was 17 or 19 and only two didn't get jobs right before/after graduation. Several of my classmates are going to college either while online/in person to get degrees. It is hard, our starting class size was 28. In my opinion, it's the way to go.
@@mediumshrimp9696 love to hear it brother. glhf
I’ll be joining a data analytics bootcamp this September and this comment gave me hope.Yes,it won’t be all rosy but it will be worth it!Thank you!
Thanks Corey. Very Helpful! Cheers!
Great video, very informative and helpful. You make it really easy to follow and understand
Absolutely, fantastic video and simple to understand it. Many thanks for your time and efforts
Hello Mr Corey ! Thanks for this incredible content!
Your introduction voice is amazing!
Thank you so much for the sucint tutorial. This precisely what I needed!
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!
I don't have a video specifically on large files, but if you watch my video on File Objects, I do go over reading a file in chunks. If you search my channel or Python playlist for "File Objects" then you should find that.
excellent stuff definitly helping with my masters project
Thank you so much for such a wonder full series!
Hi Corey, your videos are just great. Would it be possible to show us how to iterate the nested dictionaries
Great stuff as always - Thank you:)
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❣
awesome, my first CSV read\write tutorial! thank you sir!
-------------------------
Very helpful videos, keep up the good work!!!!!
Thanks for the wonderful explanation ❤💫💪🏼
Excellent work Sir, Your teaching style is awesome.
man you are a very good python presenter, keep up the great work and vids.
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)
thanks man
thx
Great tutorial - thank you! Subscribed
You are amazing! Thank you so much!!!! I have a better understanding of csv and can apply it to my school assignment.
don't go to school just code in your house and you can get a job in no time I promise you that. I'm 100% sure i swear this to our generation and mankind
great video sir..! :) thanks for uploading it....and can you make more videos on python most used libraries like you made on csv?
SO helpful, thank you!!
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.
I would really like to put together some web framework tutorials. I have some scripts in the making, but it will likely take a while longer to get everything recorded and edited. Hopefully in the near future.
just what i needed for my problom set thanks bro .
This is fantastic, no lies. Thank you very much
Your videos are fantastic, thank you for all your time and effort! I just have one question. How do you read through the csv file and had earch row to a prosgresSQL table?
Awesome video, I very easy to understand! Thank you for the awesome video!
Corey, you are the best. Thank you.
Great tutorial Cory, thanks so much, spent most of my weekend looking for ways to read a text file, and your tutorial showed me in 5 minutes lol. For an assignment I have to print first last name from a text file(done!) but the file has Y,Y or Y, , data at the end to show if the people are going to a conference, they get a pack, going bot st and Sunday the get an extra pack( packs read from another file) do i just do some else if statements to get that data or is there a better way now I have list data(hope that makes sense!)
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.
really helpful video thank you!!
Great video training. just what I was looking. What about a video on collecting frequencies from a csv file
concise and clear! thx so much
Awesome, thank you corey!
Super useful! Thanks dude!
Better than my professor! Thank you.
sick tutorial man thank you
Thank you so much I needed this
Short and down to the point.You Sir you're a God Sent.
Thanks, Corey for the tutorial. How do you write data starting from a specific column or/and row in CSV?
Beginner here, your tutorials have been a my go to! Thanks for the content. I am currently trying to export Webscraped data (using selenium, and creating a tuple using 'in zip' for the extracted data). But I am having trouble outputting to a CSV, anyway you can help with this? What is the best way to accomplish this?
Super .. helpfull.. Please do this kind of real word problems..
Thank you. This is helpful
Nice explanation, Thanks!
You are an awesome tutor!
Amazing explanation.
Thank you for this video, it was amazing.
Can you please let me know how to write one element of row at one time in CSV file and not whole row at one go?
Thank you for this lecture
This video was worth the viewing I wish I had found this days ago:)
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......................................
I can not quite put the finger around it, but your teaching is magical!
Very well explained
wow thank you for this, great explanation! Question, say i wanted to make an interactive search for a large csv database, that asks user input i.e "enter user name" and then it prints out e-mail or any other value in said row? :)
U are great Corey Sir ... waiting for Ur 1 million subscribers ❤️
Amazing video man , thank you so much
exactly what i want,Thanks !!
Great video! Thanks a lot for your lessons! I'm just curious, whether it's possible to apply DictReader method to csv file, which would have header not in the first line, but below? I have firt 6 lines as some metadata, and then 7th line - header, and remaining - data according to headers structure...