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!
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 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 =)
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.
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
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!
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.
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.
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.
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.
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!
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
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 realize you wanted to demonstrate the strftime function, but I feel year-month-day *is* the reader friendly format. Just needed to get rid of the useless time part.
I came across this channel liking it for some of the initial videos. However, my test of teaching python is teaching how the arguments are passed in python: by reference, by value, or another model. Do you have a video on that please?
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
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 RUclips. 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!
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
We're halfway there. We still need your help! Support Socratica Python Kickstarter: bit.ly/PythonKickstarter
Support what you love! Socratica has a Kickstarter to make more Python: bit.ly/PythonKickstarter
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
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.
This Python series deserves a RUclips channel of its own. Please make more videos.
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. RUclips places links for suggested videos there.
"with big data, comes big responsibility" that was the funniest line
lol this video is so dramatic... I love it!
Right? It's like the telenovela version of a programming guide.
In love with Python because of You Socratica, May you live forever in the realms of Big Data :)
"Personally, I would've chosen a different name for a class. But I'm only a singleton".
Superb! :-)
@Paritosh Jadhav Oops! My mistake :-)
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
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.
I hope 20 years from now, all youtube videos are all like this one. This is 20 years to the future.
A good presentation is one thing. When it stimulates further self motivated research; then it becomes excellent.
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!
Your mission:Should you choose to save the world.Or just save it in a CSV format.Love these videos.
ha ha 😅 really good. Your way of teaching is different and exceptional.
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.
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!
Girl you rock and you need your own Stand up Comeday show!!!
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.
every time she says RUN i hear the music in my head 😹, TBH the content is charming, thank you.
CSV? More like CS-yee...haw! Another phenomenal Python video from Socratica!
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.
I love these tutorials. They remind me of the old C&C games.
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.
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.🙏
Starting from 00:49 .... that music in background simply great!
this is the coolest tutorial i have ever come across.
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 absolutely love her presentation! and team socratica too
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'd love more Python from Socratica
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
import pandas as pd
data = pd.read_csv("/path/to/file.csv") #enjoy!
great video though
lol
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))
I repeated this video 2 times, it's a very important lesson, Thank you.
reporter: Why you want become rich?
me: To donate and force Socratica them make more vids!
Having watched many videos, I find this one is helpful and straightforward.
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?
@@minh_tien3911 Please post your line, maybe I can help.
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! :-)
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 thought, I was watching a movie.. great tutorial to Learn...the way of presentation is so good 🤗
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!
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
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
wow, you are one serious teacher
Woww now that's something i never expected.. You got a subscriber🤩
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
The ISO standard date format is the least esoteric date format out there! (YYYY-MM-DD)
Amaizing video format. The best I've seen. I'm continue watching even I'm not a python dev :D
I found solution to remove quotes from each row, I was finding this video. Thank you very much!
this is the best utube video I have ever seen
Very Unique way to create tutorial.. Great Job.
She is ADDICTIVELY Amazing🤞
Love at python vids from Socratica.
... if you had only subscribed... genious!
And here's me parsing CSVs by hand. Of course there's a CSV module because of course there is.
You are a magic to my intellectual development.
really liked it , I am a beginner here
thanks for these
Ridiculously beautiful tutorial.
Its like future AI ..amazing . keep it up 👍
New presentation ......first time seen ..thanks ..best explanation
Thank you a lot for the provided tutorial. Saved much time to understand, how the current things work.
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!
22 seconds in and wishing Lynda.com would redo all their tuts like this lmao. So reminiscent of Command and Conquer.
"Welcome back, Programmer."
This video format is amazing!!!
advance teaching great lessons like a sci-fi movie style tutorials grt work !!!
oh god this has such a hackery vibe. love it lol
expecting more video tutorials on python
Great work Socratica , really excellent presentation on python and stock returns process
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 :)
Great video, but you did not close the file when you were done with it?
This channel is awesome and this video was extremely helpful. Thank you!!
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,
I love your voice.......it should be used on more apps or GPS.......
Saved my life! Thank you so much!! Furthermore It is so inspiring. What a legend!!
I realize you wanted to demonstrate the strftime function, but I feel year-month-day *is* the reader friendly format. Just needed to get rid of the useless time part.
best python channel
I came across this channel liking it for some of the initial videos. However, my test of teaching python is teaching how the arguments are passed in python: by reference, by value, or another model. Do you have a video on that please?
Always a pleasure!! 🥰
I am in love with this baji♥️
Really like your videos. Always to the point.
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