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.
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!! 💜🦉
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!
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 =)
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
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.
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.
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.
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!
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!
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.
Working with dates and times is a delicate affair in any language. Especially when building client server systems that span time zones! Throw in countries with different DST rules, even though they're at the same line of longitude. For the finishing touch I dare you to find out the time in Arizona!
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
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))
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.
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.
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
Wear a Socratica Python shirt for good luck coding: shop.socratica.com/products/python-by-socratica
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.
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
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!
she's definitely one of the coolest python teachers on TH-cam. loved the way she teaches python.. keep making more tutorials
Felt like im getting debriefed for an MI5 mission
lol
Like it
Hahaha IMF or mission impossible
Lol😂
😂She's good
Best mix of humor with mournful and melancholic voice to deliver substance. In short, what a lovely video with great information
"With big data comes big responsibility !"
... you are just wow!
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.
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
You will never stop to amuse me with your use of words. The video is concise and precise.
This Python series deserves a TH-cam channel of its own. Please make more videos.
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 =)
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.
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. TH-cam places links for suggested videos there.
In love with Python because of You Socratica, May you live forever in the realms of Big Data :)
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... :(
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
Your mission:Should you choose to save the world.Or just save it in a CSV format.Love these videos.
lol this video is so dramatic... I love it!
Right? It's like the telenovela version of a programming guide.
A good presentation is one thing. When it stimulates further self motivated research; then it becomes excellent.
I hope 20 years from now, all youtube videos are all like this one. This is 20 years to the future.
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.
"with big data, comes big responsibility" that was the funniest line
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.
"Personally, I would've chosen a different name for a class. But I'm only a singleton".
Superb! :-)
@Paritosh Jadhav Oops! My mistake :-)
ha ha 😅 really good. Your way of teaching is different and exceptional.
Girl you rock and you need your own Stand up Comeday show!!!
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.
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!
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!
I love these tutorials. They remind me of the old C&C games.
the best educational video I have ever seen in youtube
thanks a bunch
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.
this is the coolest tutorial i have ever come across.
CSV? More like CS-yee...haw! Another phenomenal Python video from Socratica!
I'd love more Python from Socratica
every time she says RUN i hear the music in my head 😹, TBH the content is charming, thank you.
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
Starting from 00:49 .... that music in background simply great!
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.🙏
LOVE this intro, it reminds one of the game Command and Conquer Tiberian sun with those video cut scenes ❤
Best girl of socratica.. please make more programming courses.. make it more advanced.
I repeated this video 2 times, it's a very important lesson, Thank you.
i absolutely love her presentation! and team socratica too
... if you had only subscribed... genious!
She is ADDICTIVELY Amazing🤞
Working with dates and times is a delicate affair in any language. Especially when building client server systems that span time zones! Throw in countries with different DST rules, even though they're at the same line of longitude. For the finishing touch I dare you to find out the time in Arizona!
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
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))
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.
i also get "syntax error" althrough i did like you. can you help me?
@@tienphieubat Please post your line, maybe I can help.
Having watched many videos, I find this one is helpful and straightforward.
Why is there no separate python playlist...
Absolutely love these videos
Would love if better all videos were there in a playlist
There is a Socratica Teaches Python playlist!
Here it is: bit.ly/PythonSocratica
Very helpful, I needed to read and then write csv files and this tutorial helped me write my first useful program!
wow, you are one serious teacher
I was not sure why I like this lady teaching us Python. But then it clicked on me: she reminds me of Shaw from the Person of Interest! :-)
this is the best utube video I have ever seen
Ridiculously beautiful tutorial.
I found solution to remove quotes from each row, I was finding this video. Thank you very much!
You are a magic to my intellectual development.
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
oh god this has such a hackery vibe. love it lol
I thought, I was watching a movie.. great tutorial to Learn...the way of presentation is so good 🤗
Very Unique way to create tutorial.. Great Job.
I love your voice.......it should be used on more apps or GPS.......
really liked it , I am a beginner here
thanks for these
reporter: Why you want become rich?
me: To donate and force Socratica them make more vids!
Love at python vids from Socratica.
expecting more video tutorials on python
Its like future AI ..amazing . keep it up 👍
The ISO standard date format is the least esoteric date format out there! (YYYY-MM-DD)
Always a pleasure!! 🥰
New presentation ......first time seen ..thanks ..best explanation
I am in love with this baji♥️
advance teaching great lessons like a sci-fi movie style tutorials grt work !!!
best python channel
And here's me parsing CSVs by hand. Of course there's a CSV module because of course there is.
import pandas as pd
data = pd.read_csv("/path/to/file.csv") #enjoy!
great video though
lol
Woww now that's something i never expected.. You got a subscriber🤩
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!
This video format is amazing!!!
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.
Thank you a lot for the provided tutorial. Saved much time to understand, how the current things work.
I like the way they explain Python.
22 seconds in and wishing Lynda.com would redo all their tuts like this lmao. So reminiscent of Command and Conquer.
"Welcome back, Programmer."
Python - Socratica
Excel -Leila Gharani
Good finds :)
love you. Lifesaver🤧🤧
Awesome! thumbs up Ulka and your team.
Really like your videos. Always to the point.
Amaizing video format. The best I've seen. I'm continue watching even I'm not a python dev :D
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
This channel is awesome and this video was extremely helpful. Thank you!!
Perfect demo and explanation
Saved my life! Thank you so much!! Furthermore It is so inspiring. What a legend!!
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 love this singleton!
Interesting. I like the format, a little strange, but engaging. THank you.
Great work Socratica , really excellent presentation on python and stock returns process
got my subscription. Dayum well presented
I thought I recognised Ulka, and sure enough, there she is!
That's amazing! Small world!!
Isn't she incredible?!
Thanks for watching! :)
yashnu who is ulka
Do you wanna marry her!!! Focus on python...lol
is she hawt or what ;-;