CSV Files in Python || Python Tutorial || Learn Python Programming
VloĆŸit
- Äas pĆidĂĄn 25. 01. 2017
- đđ©đđź đđŁ đ©đđ đĄđ€đ€đ„ đđđđđđđđđđ: snu.socratica.com/python Working with CSV files is simple in Python. Today we will introduce the CSV module and show you how to read and write CSV files. As a demo, we will analyze the first ten years of stock data for Google.
You can download a CSV containing the first 10 years of Google stock data here: goo.gl/3zaUlD
To learn Python, start our Python Playlist HERE:
bit.ly/PythonHelloWorld
Subscribe to Socratica: bit.ly/1ixuu9W
âŠâŠâŠâŠâŠâŠâŠâŠâŠâŠ
We recommend:
Python Cookbook, Third edition from OâReilly
amzn.to/2sCNYlZ
The Mythical Man Month - Essays on Software Engineering & Project Management
amzn.to/2tYdNeP
Shop Amazon Used Textbooks - Save up to 90%
amzn.to/2pllk4B
âŠâŠâŠâŠâŠâŠâŠâŠâŠâŠ
Ways to support our channel:
âș Join our Patreon : / socratica
âș Make a one-time PayPal donation: www.paypal.me/socratica
âș We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9
Thank you!
âŠâŠâŠâŠâŠâŠâŠâŠâŠâŠ
Connect with us!
Facebook: / socraticastudios
Instagram: / socraticastudios
Twitter: / socratica
âŠâŠâŠâŠâŠâŠâŠâŠâŠâŠ
Python instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Michael Harrison (@mlh496 on Twitter)
FX by Andriy Kostyuk
âŠâŠâŠâŠâŠâŠâŠâŠâŠâŠ
Wear a Socratica Python shirt for good luck coding: shop.socratica.com/products/python-by-socratica
It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! đđŠ
absolutely superb explanations on all videos and we will love to see more such videos.
Please do a little graphics but i loved the explaination
Socratica. @3:45 saved my ass during my job interview Monday. I had to convert a text file with garbled data to a file that could be opened in Excel. I usually use Linux so I was mortified when I discovered that it was inserting blank lines after each row in the file. Then I remembered this video that I watched while cramming for the interview. They left a voicemail last night, saying they had "good news."
Thank you so much.
@ehud kotegaro No, but he did find out that Jesus was born!
@@jetaimemina lmfao! great comment.
Felt like im getting debriefed for an MI5 mission
lol
Like it
Hahaha IMF or mission impossible
Lolđ
đShe's good
I went through about 20 Python tutorial sites to try to figure out how to just read a CSV file and still was confused (I am a programmer but new to Python). Then I discovered this video. It was one of the best presentations ever and very clear and exactly what I needed to know. It was also very futuristic like an intelligent robot on a spaceship giving instructions. So very well done indeed!
Best mix of humor with mournful and melancholic voice to deliver substance. In short, what a lovely video with great information
she's definitely one of the coolest python teachers on CZcams. loved the way she teaches python.. keep making more tutorials
Best presentation I've ever seen, I felt like I was in the future. Thanks
In the future? The future will be without machine...
@@Nasreddiin bet
I felt like I was in 1967's cliched vision of the future. Regardless, the content is great.
Dude, I swear I felt the same... lol
Socratica teaches as all learning videos must be, emphatetic but simple, to the point.
"With big data comes big responsibility !"
... you are just wow!
Thank you so much for the tutorials. These are excellent and so fun to watch. One suggestion, if possible, try not having the codes written on the very bottom of the video screen. When pausing the video to follow the steps and copy the codes the loading bar will appear and block the content. it is not even a problem, but I guess this could help the viewers trying to copy the codes =)
You will never stop to amuse me with your use of words. The video is concise and precise.
"with big data, comes big responsibility" that was the funniest line
From back-of-mind: You should be cast in the next Tron movie. :)
Preston Bannister there wonât be another one
@@EmileAI Just wait.....
@@EmileAI yep, it was turned TROFF now... :(
the presentation is superb
future of learning is by games and things that looks like games.
Better than a lot of paid tutorials.
Exactly my opinion, better than Lynda and Udemy
lol this video is so dramatic... I love it!
Right? It's like the telenovela version of a programming guide.
Cortana's weird sister. đ€Ł
The instructor is an an actor listed in IMDB.
That's because she's an actor lol
I thought she was an AI
This Python series deserves a CZcams channel of its own. Please make more videos.
if all subjects in school were presented in a unique way like this, it would make things much more interesting and attainable.
thank you for this.
In love with Python because of You Socratica, May you live forever in the realms of Big Data :)
A good presentation is one thing. When it stimulates further self motivated research; then it becomes excellent.
My oh my!! This is out of this world tutorial. Best presentation ever. I have subscribed so that I know what I should know but don't know or could know if I didn't subscribe.
Great tutorials! Simple tip for accessibility: Avoid using the bottom 1/10th of the video window, as it will be covered by closed captions. With captions on, I can't see the code, arrows, and other content you're describing. Keeping content above the bottom 1/10th of the video window improves accessibility for users with hearing impairments and those who aren't fluent English speakers.
Bryan Tyner also, I would suggest not to use the top 1/10 of the window. CZcams places links for suggested videos there.
I hope 20 years from now, all youtube videos are all like this one. This is 20 years to the future.
Having watched many videos, I find this one is helpful and straightforward.
This is an amazing job you guys have been doing! So great to learn!
Thank you so much for helping me to go towards Data Science!
Very helpful, I needed to read and then write csv files and this tutorial helped me write my first useful program!
omg straight to the point tutorial with a practical example what will make my job easier. no noise what so ever. outstanding channel. thank u
"Personally, I would've chosen a different name for a class. But I'm only a singleton".
Superb! :-)
@Paritosh Jadhav Oops! My mistake :-)
Best resource on this that I have found. Outstanding job of presenting a simple, yet robust method to handle CSVs.
I did have one minor glitch, an error message about "file = open(path, newline='')"
The solution is "file = open(path,'rU')" # the U is uppercase.
Un grand merci d'Aix les Bains en France. Vos vidĂ©os sont simples, claires et prĂ©cises. IdĂ©ales pour le dĂ©butant que je suis.đ
i absolutely love her presentation! and team socratica too
Ulka Simone Mohanty you are one of the best teachers in the world. Your style and clear explanations make the learning experience one of the best I have ever had. Thank you very much
She does a great voice-over, very convincing as if she knew the material.
@@silversolver7809 I think it's because she does know the material, her twitter says shes a comp-sci geek
@@CarbonsHDTuts :) I was just poking fun at the text-to-speech delivery.
awesome tutorials, really looking forward to seeing a lot more of yalls work you guys obviously work very hard to achieve this level of quality,
every time she says RUN i hear the music in my head đč, TBH the content is charming, thank you.
ha ha đ really good. Your way of teaching is different and exceptional.
I thought, I was watching a movie.. great tutorial to Learn...the way of presentation is so good đ€
the best educational video I have ever seen in youtube
thanks a bunch
Thank you a lot for the provided tutorial. Saved much time to understand, how the current things work.
Love at python vids from Socratica.
I love these tutorials. They remind me of the old C&C games.
Saved my life! Thank you so much!! Furthermore It is so inspiring. What a legend!!
Great work Socratica , really excellent presentation on python and stock returns process
this is the coolest tutorial i have ever come across.
I found solution to remove quotes from each row, I was finding this video. Thank you very much!
hahaha the presentation đ
*dramatic tone* "Get ready to look at values, that have been seperated....*dramatic pause* by commas".
Funny, entertaining and educational. Good job!
LOVE this intro, it reminds one of the game Command and Conquer Tiberian sun with those video cut scenes â€
Thank you for being so amazing! Description is outstanding, thank you so much!
Amaizing video format. The best I've seen. I'm continue watching even I'm not a python dev :D
I repeated this video 2 times, it's a very important lesson, Thank you.
Your mission:Should you choose to save the world.Or just save it in a CSV format.Love these videos.
Welcome to Socratica! You can see our entire Python Playlist here: bit.ly/PythonSocratica
Subscribe to see all our new videos! bit.ly/SocraticaSubscribe
ma'am, can you please tell?
If I want to change the order of the data with respect to date, then what should we do? for example:- If I want to change the order like the data with odd date will come first or any random order. please help.
Thank you for the videos ..Great Quality!! I love the tome in which you present the information .. Liked and subscribed
You are a magic to my intellectual development.
As far as i can understand the main goal of this tutorial is a demonstration of advantages of the csv-module over general python's method of reading csv-files. More precisely you declare that the csv-module can parse csv-file and manage exceptions more robust than the general method. But all that you demonstrate for csv-module can be implemented by general python's file reading ways equally. You doesn't demonstrate by examples what exactly can do csv-module that couldn't do general python's file reading techniques.
In the rest very good, clear, creative and visually attractive tutorial.
This channel is awesome and this video was extremely helpful. Thank you!!
Hey Socratica, I absolutely adore your videos, and Ulka is perfect in her role.
May I suggest one thing regarding the "open"? It's a good practice to close the file after usage, but even better is to use '''with open(fileName, "wb") as file:'''
it closes the file at the end of indentation by itself so you don't have to worry about it :)
I liked how fast the video goes. I paused and go back, but it's great to have a lot of info in short videos.
LOL, the voice sounds so strict and seems like a sci-fi movie. haha
we would love to see some dlib for python tutorials . i just love how you take those small details into account . thank you
this is the best utube video I have ever seen
Awesome! thumbs up Ulka and your team.
I usually hate robot narration, but this may just be the sexiest robot ever. I can't get enough of this. On a more serious note, GREAT job! and thank you!
Starting from 00:49 .... that music in background simply great!
Thank you for this great video! Really helped me out.
Ridiculously beautiful tutorial.
advance teaching great lessons like a sci-fi movie style tutorials grt work !!!
... if you had only subscribed... genious!
CSV? More like CS-yee...haw! Another phenomenal Python video from Socratica!
Woww now that's something i never expected.. You got a subscriberđ€©
Really like your videos. Always to the point.
oh god this has such a hackery vibe. love it lol
Girl you rock and you need your own Stand up Comeday show!!!
New presentation ......first time seen ..thanks ..best explanation
really liked it , I am a beginner here
thanks for these
This video format is amazing!!!
Perfect demo and explanation
Very Unique way to create tutorial.. Great Job.
Interesting. I like the format, a little strange, but engaging. THank you.
Awesome video. Subscribed. Expecting more videos
got my subscription. Dayum well presented
Best girl of socratica.. please make more programming courses.. make it more advanced.
Awesome indeed - thanks for sharing.
I love the socratica movies!
However, if you just want to show the data prettytable is also a nice option:
from prettytable import from_csv
csv_file = open('google_stock_data.csv')
print(from_csv(csv_file))
Please do more ^_^ Will feature you in my programming playlist if thats ok ^_^
This is the first video I have watched of the python series and I am only 22 seconds in to the video. But, I feel like this video is a mission briefing in a video game cut scene. also, I am picking up a very seven of nine vibe. lol.
great video!
thank's for your tutorial, it's so helpfull for me..
Awesome style!
Very well explained and informative video. You are really good at breaking down points. Can you explain what a KIX script is? Thanks in advance.
wow, you are one serious teacher
This is soooo hecka awesome I love it!!
Wow! Excellent.
Always a pleasure!! đ„°
I love this singleton!
I'd love more Python from Socratica
I just ran this video once again in case i did not understand something...I did not even on the second time.......but i damn love that voice
Great video! Thanks!
if you're using python 2.7 the newline=' ' wont work, instead add import io dependency and use io.open() instead of open()
thank you so much ali akram for your tip.
Thanks!
I am in love with this bajiâ„ïž
Amaze-balls video series first off. I love the deadpan delivery of jokes. Do a pandas tutorial. Csv is going the way of the dodo
Its like future AI ..amazing . keep it up đ
exceptional!! Thanks!!