CSV Files in Python || Python Tutorial || Learn Python Programming

𝙎𝙩𝙖𝙮 𝙞𝙣 𝙩𝙝𝙚 𝙡𝙤𝙤𝙥 𝙄𝙉𝙁𝙄𝙉𝙄𝙏𝙀𝙇𝙔: snu.socratica.... 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/PythonHe...
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/...
► 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
♦♦♦♦♦♦♦♦♦♦

[@Socratica]

Wear a Socratica Python shirt for good luck coding: shop.socratica.com/products/python-by-socratica

[@brutalbutler]

Felt like im getting debriefed for an MI5 mission

[@ayencoscolfield3312]

lol

[@ricardowong1813]

Like it

[@ricardowong1813]

Hahaha IMF or mission impossible

[@brothercaleb]

Lol😂

[@motorexodus933]

😂She's good

[@NeoGhiofish]

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.

[@jetaimemina]

@ehud kotegaro No, but he did find out that Jesus was born!

[@gauravnegi4312]

@@jetaimemina lmfao! great comment.

[@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!! 💜🦉

[@equitymonk34]

absolutely superb explanations on all videos and we will love to see more such videos.

[@krishnathakur2138]

Please do a little graphics but i loved the explaination

[@AnkitBindal97]

she's definitely one of the coolest python teachers on KZbin. loved the way she teaches python.. keep making more tutorials

[@ronimiguel]

Best presentation I've ever seen, I felt like I was in the future. Thanks

[@Nasreddiin]

In the future? The future will be without machine...

[@spencerjames9417]

@@Nasreddiin bet

[@ulysses1904]

I felt like I was in 1967's cliched vision of the future. Regardless, the content is great.

[@Zook919]

Dude, I swear I felt the same... lol

[@mviktor21]

Socratica teaches as all learning videos must be, emphatetic but simple, to the point.

[@pravin8419]

Best mix of humor with mournful and melancholic voice to deliver substance. In short, what a lovely video with great information

[@aws96314]

the presentation is superb

[@TheNsn666]

future of learning is by games and things that looks like games.

[@zbzb-ic1sr]

Better than a lot of paid tutorials.

[@shobharoy2033]

Exactly my opinion, better than Lynda and Udemy

[@PrestonBannister]

From back-of-mind: You should be cast in the next Tron movie. :)

[@EmileAI]

Preston Bannister there won’t be another one

[@arthurnonimus]

@@EmileAI Just wait.....

[@dirkmcnasty8585]

@@EmileAI yep, it was turned TROFF now... :(

[@ademolaorolu5930]

You will never stop to amuse me with your use of words. The video is concise and precise.

[@naveedhunzai]

In love with Python because of You Socratica, May you live forever in the realms of Big Data :)

[@Helen-lm6bb]

lol this video is so dramatic... I love it!

[@dabbrill4609]

Right? It's like the telenovela version of a programming guide.

[@KapilMarwaha]

"With big data comes big responsibility !" ... you are just wow!

[@onecanina]

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 =)

[@darkguardian1314]

Cortana's weird sister. 🤣 The instructor is an an actor listed in IMDB.

[@jesalgandhi]

That's because she's an actor lol

[@jhtrico1850]

I thought she was an AI

[@osein8900]

the best educational video I have ever seen in youtube thanks a bunch

[@riskyrun]

Your mission:Should you choose to save the world.Or just save it in a CSV format.Love these videos.

[@guiray2000]

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!

[@gmccalip]

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.

[@tawhidshahrior8804]

this is the coolest tutorial i have ever come across.

[@mindsetnuggets]

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.

[@mahajanravish]

ha ha 😅 really good. Your way of teaching is different and exceptional.

[@Socratica]

We're halfway there. We still need your help! Support Socratica Python Kickstarter: bit.ly/PythonKickstarter

[@-x-dx7295]

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.🙏

[@Socratica]

Welcome to Socratica! You can see our entire Python Playlist here: bit.ly/PythonSocratica Subscribe to see all our new videos! bit.ly/SocraticaSubscribe

[@abhishekbhandari2203]

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.

[@evergriven7402]

Thank you for the videos ..Great Quality!! I love the tome in which you present the information .. Liked and subscribed

[@Socratica]

We're halfway there. We still need your help! Support Socratica Python Kickstarter: bit.ly/PythonKickstarter

[@gordontang7837]

"with big data, comes big responsibility" that was the funniest line

[@BryanTyner]

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.

[@jessicabrock3220]

Bryan Tyner also, I would suggest not to use the top 1/10 of the window. KZbin places links for suggested videos there.

[@narsinghyadav1071]

I'd love more Python from Socratica

[@akramsystems]

if you're using python 2.7 the newline=' ' wont work, instead add import io dependency and use io.open() instead of open()

[@ramaks8186]

thank you so much ali akram for your tip.

[@paulmichaud3230]

Thanks!

[@alamagha2039]

You are a magic to my intellectual development.

[@plaifaha.2674]

I found solution to remove quotes from each row, I was finding this video. Thank you very much!

[@ubermensch5472]

wow, you are one serious teacher

[@collardwe1]

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

[@silversolver7809]

She does a great voice-over, very convincing as if she knew the material.

[@CarbonsHDTuts]

@@silversolver7809 I think it's because she does know the material, her twitter says shes a comp-sci geek

[@silversolver7809]

@@CarbonsHDTuts :) I was just poking fun at the text-to-speech delivery.

[@oinn6216]

Amaizing video format. The best I've seen. I'm continue watching even I'm not a python dev :D

[@cjstevens6405]

If you get "SyntaxError: (unicode error)" when defining 'path' (as I did), try replacing each single slash \ with a double slash \\. This makes it a *raw* string, and this worked for me.

[@tienphieubat]

i also get "syntax error" althrough i did like you. can you help me?

[@captainfuture2882]

@@tienphieubat Please post your line, maybe I can help.

[@eduardolopes243]

import pandas as pd data = pd.read_csv("/path/to/file.csv") #enjoy! great video though

[@pegcailla4625]

lol

[@aryanmn1569]

reporter: Why you want become rich? me: To donate and force Socratica them make more vids!

[@Socratica]

Support what you love! Socratica has a Kickstarter to make more Python: bit.ly/PythonKickstarter

[@chetbal]

It's better to take path as a raw string like path = (r"F:\etcetc") because when the file is under User directory, python will complain about unicodeescape codec.

[@jefferybutler1656]

Thanks for this!

[@porridgenoats]

Thank you so much! You're a saviour!

[@ok.5753]

it says no such file or directory found still

[@ΒαγγέληςΠατρικαλος]

Thanks for the tip!! kept getting the error no matter what i tried but this worked out quite well!

[@davidfoo6974]

The other way is to replace "\" with "\\" in the path, but your solution is more elegant and easier to read.

[@zeyadramadan8759]

Really like your videos. Always to the point.

[@igorthelight]

"Personally, I would've chosen a different name for a class. But I'm only a singleton". Superb! :-)

[@igorthelight]

@Paritosh Jadhav Oops! My mistake :-)

[@ezequielgallo1961]

Saved my life! Thank you so much!! Furthermore It is so inspiring. What a legend!!

[@MarsVlogSoon]

expecting more video tutorials on python

[@clairee4572]

Hi please, why is todays_price = todays_row[-1] not todays_row[1]

[@shshbatzar]

Love your videos! Any chance you'll make Java Tutorial?

[@Aymanee]

The example being used is far too complex and it doesn't make much sense, sure knowing the stock values of the first 10 years of Google sounds cool, but in terms of learning, it doesn't contribute. I've tried to follow the example with my CSV file and there aren't as many data types, it only made sense for me if I downloaded the same exact CSV.

[@joshambush8574]

oh god this has such a hackery vibe. love it lol

[@Wibblium]

The ISO standard date format is the least esoteric date format out there! (YYYY-MM-DD)

[@mrmuranga]

Very useful as usual...however the path for the stock data file seems to have changed or removed for those who want to follow along

[@ravengwo]

for Windows the line: file=open(returns_path, 'w') should have newline=' ' parameter as well, as without it the new CSV has blank lines between records

[@enockoloo3814]

Awesome indeed - thanks for sharing.

[@charlesabernathy5842]

Thanks, Socratica.

[@MrNagios]

I like the way they explain Python.

[@timothy8428]

And here's me parsing CSVs by hand. Of course there's a CSV module because of course there is.

[@abdulhamidyusuf2848]

every time she says RUN i hear the music in my head 😹, TBH the content is charming, thank you.

[@greenwavemonster]

This toutorial is showing what it will mean, when AI will takeover and make their own toutorials

[@powerhour4602]

22 seconds in and wishing Lynda.com would redo all their tuts like this lmao. So reminiscent of Command and Conquer.

[@patricksturgill9441]

"Welcome back, Programmer."

[@disneykidzshowhd4377]

I hope 20 years from now, all youtube videos are all like this one. This is 20 years to the future.

[@Stafford674]

I love Socratica, and you explain things well but I wish you would speak normally.

[@frankkoslowski6917]

A good presentation is one thing. When it stimulates further self motivated research; then it becomes excellent.

[@swadhikarc7858]

Awesome video. Subscribed. Expecting more videos

[@carpenter315]

Ya know! After three hours of trying to figure out "ValueError: Unconverted Data Remains", it's come to my attention that the strptime method requires the "Y" be capitalized.

[@lizs004]

You've pretty much saved my life. Thanks

[@utkarshagarwal6798]

Great video tutorials Could you also provide Data science tutorials

[@charlescham2024]

great video!

[@FriezaE46]

Awesome style!

[@eyeinthesky888]

I felt like in the class of 2050-2099.

[@techniumunlimited4567]

Please do more ^_^ Will feature you in my programming playlist if thats ok ^_^

[@mtcondie]

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.

[@avecNava]

I needed to prefix "r" to the path to make it work

[@kevincardenas6629]

yeah me too was weird had to search it myself they didn't even explained that haha :(

[@johnmiller0000]

Just a quibble but using date formats such as 3/4/2014 is a bad idea. I've lived half my life in the UK that uses the format that all of the planet except Japan and the US use, and the other half in the US which uses its own illogical format. Whenever I read a date in either format, my brain just wants to explode or shutdown. I'd always use 03-Apr-2014 or 04-Mar-2014 so that 3/4/2014 isn't ambiguous. It also means that the string length is constant. Love this series, though.

[@Socratica]

It is maddening, these mixed date conventions. Here at Socratica, we write 20171201 on our digital files (year month day) so we can sort easily. But for writing, we write 01 December 2017, like you, because you can read it in a glance. Don't get us started on Daylight Savings Time...

[@reathm]

Speaking of "quibble": the only international standard for dates (and I do mean the *only* standard in existence) is 2017-12-01 (see ISO 8601 for details). 12/1/2017 is as wrong as 1/12/2017 or 01-Dec-2017 or xkcd.com/1179/. As far as I can tell, it's only used consistently in the PRC, but it's a good first step!

[@onesandzeroes]

@@reathm Let's just talk about logic rather than standards. Day-month-year is logical. So is year-month-day. The US system of month-day-year is illogical and a brain that isn't specifically taught to override logic since childhood has a problem processing it.

[@reathm]

I appreciate the polite response, but I disagree with its conclusion. Numbers are written, as a matter of convention, by writing the most significant number to the left, and the least significant number to the right. You have, growing up, become accustomed to seeing dates written the opposite way, but dd/mm/yyyy is as logical as writing 00:30:12 for "half past noon", or 5.10 for "ten and a half". The European way of writing dates is a historical artifact, not the product of "logic". You have an appreciation for the format's order (small to big, i.e. "monotonic"), but "monotonicity" isn't the same as "logic" when it defies the only number ordering method used in the world. The ISO standard is not just a standard, it is the only logical and coherent way of writing a datetime (YYYY-MM-DD hh-mm-ss.etc). As an exercise, imagine writing a piece of software to order filenames written in the format DDMMYYYY. I think you will conclude "something isn't right".

[@onesandzeroes]

@@reathm Yes, something isn't right, and that is the American way of writing 12/25/2018. I'm not saying that the European method is the result of logical calculation, but it has the logical order that would be expected of this kind of system (from least to most or vice versa). And I agree that the ISO standard is superior, and that is actually the way a lot of documents in Europe and elsewhere use. It's quite natural for us to use this system. And it is also the only logical system for computers. But I think whether you go from most to least or vice versa in daily life is a matter of convention. What is inexcusable is introducing a logical mess. And I don't mean phrases like December 25th, 2018, which are perfectly understandable because of their descriptive nature. The "not right" thing is the above mentioned purely numerical system with the arbitrary placement of month before day before year.

[@ayushkapri1857]

I have tried to open csv file but I am getting error as SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

[@mainsequence1055]

Well, you might as well just give up learning Python.

[@alwalid9547]

its realy very good and usefull in lots of times but it can bemore easier to use Pandas Import Pandas as pd file = pd.read_csv("path/to/file.csv", index_col = 0)

[@thecodinghustle1006]

i absolutely love her presentation! and team socratica too

[@alooooshm]

I can't say anything but WOW! do more videos for python3🙏.

[@alialani3991]

Thank you for great movies about python programming ...I want ask you question, How I can I convert the set of images in black and white format in tho the scv file.

[@morenomx1]

Where have you been ....I love your videos but I had not seen them before thanks

[@Socratica]

It's such a mystery when KZbin decides to show our videos to someone. We're so glad you've found us!! 💜🦉

[@alexhooper27]

I thought I was watching a python video, not playing halo.

[@NourAhmed-go5jo]

don't name your python file csv.py

[@larrycash5250]

I'm having an issue i'm trying to count int in a csv file, but its not counting how many times it comes up i'm checking the row[that has data] ,for num it is not counting. could you help

[@abdulkarimqureshi4680]

3:26 "I'm already outside"

[@grannygrandma5185]

pretty useful for high school novice programmers lol

[@josejuliopl2140]

it would be a good idea not to call the variables and methods with the same name. It can be confused. For example: writer = csv.writer(file).

[@manasaedula6015]

please make a video on Threads concept in python.

[@AlexSage]

How can I return a line #4 from a csv file? I want my app to read from a CSV file line #4 and then create another CSV file and place it in the end of the new csv file if it already existed. And also remove a particular line in a csv file?

[@azhar145]

Awesome, Thank You.

[@brianekibro8311]

Very fast for us beginners

[@edu1113]

My datetime in my CSV file is like the following: 2011/1/1 0:00 2011/1/1 0:30 2011/1/1 1:00 when I run: date = datetime.strptime(row[0], '%Y/%m/%d %H:%M') I get datetime output as: [datetime.datetime(2011, 1, 1, 0, 0)] [datetime.datetime(2011, 1, 1, 0, 30)] How can i format it to the original datetime?

[@bsykesbeats]

@6:16 when I print, it prints "[datetime.datetime(2014, 8, 19, 0, 0)...etc"...doesn anybody know why it's printing datetime.datetime and why the format is wrong? I looked over it multiple times and see no difference btwn her code and mine.

[@111ark]

This is so cool.

[@MrTigerstyle80]

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

[@2198151]

I'm getting an UNCONVERTED DATA REMAINS ERROR WHILE USING STRPTIME IN PYTHON could you please add a video on all these errors so that we can relate and decipher these errors.

[@anterprites]

1:35 the date is not in ISO format (yyyy-mm-dd). My disappointment is immeasurable and my day ruined! Literally unwatchable! Generally never use read csv, only pandas module, which handles everything in this tutorial and more.

[@elenalearnenglish7219]

what is the difference b/t using print() and not using it when i use print() i get Date,Open,High,Low,Close,Volume,Adj Close when i dont use it i get Date,Open,High,Low,Close,Volume,Adj Close when i should use PRINT and when not

[@hahaa678]

Please anyone help. I lost my password to my ETH wallet and am trying to install/run this python program. When I try to click on the downloaded file with the python icon, it opens then quickly closes. When I try to run the file through python ver 3.0 (command line), i keep getting errors. Am I doing something wrong or is the file corrupted? Please someone help me will give you some ETH if I succeed in cracking my wallet. Here is the python file: github.com/Isaacdelly/Plutus

[@PunmasterSTP]

CSV? More like CS-yee...haw! Another phenomenal Python video from Socratica!

[@laurencejackson4871]

python no longer supports Windows 7 ? Did bill gutless buy out Python? I mean really! Windows 7 will be used as long as Win XP. Doesn't matter what bill gutless says and I will NEVER put anything above Windows 7 on my personal computers.

[@fharrison3011]

Socratica: you never know when there is sth you should know but dont know but could know if only you subcribe me: Im keeping this KZbin Library not subscribing :P

[@andrewlankford9634]

CSV = the least common denominator for storing ordered data. Of course, it's the LCD, but that doesn't mean it's the absolute worst way of storing data. For instance, if you like giving Bill Gates your money, store it in a spreadsheet.

[@abdullahmoiz8151]

excellent