As a python beginner without any programming background, I watched a lot of videos on youtube and found them very hard to follow. This video is the best I've ever watched so far! Thanks!
Great video from Alex as always. For those who don't know how to access to "copy as a path", you hold shift and right-click the file. I hope this helps.
Great video Alex as always, still can’t believe how much I have learned from you and your videos in the last 6 months! Definitely tunning in to brush up and keep it fresh! Bring back the intro!
This is the thing I was looking for. I had wish to someone make it more easy. This is my first step 🚶♂️ to learn python. Lots of love ❤️ for this video
Thank you for being a truely outstanding teacher. Your passion for impacting knowledge and your dedication to your students is obvious in everything you do. I feel so lucky to learn from you sir. I hope you know the priceless impact you are making in so many lives. Sir, please I have a humble request. I would appreciate if you would make a video of PYTHON in Data Analysis. A complete series. Much love sir.....
Great video. It's been really hard to find good Python videos. It seems like EVERY Python for Data Analytics course that I buy has a teacher that comes from the computer science world, and talks about it that way. Your approach makes is SO much easier for us non-computer scientists to learn!
Thank you Alex! I watched the first video and it automatically switched to the next one, but I came back to hit thumbs-up and leave this comment. The best Pandas course (I tried many of them)
The best before the course l was disappointed because I couldn’t open the bath of file and now it’s going up 😂😂❤thanks you’re the best now l will see all your videos and if you have a group not free l will join it really it’s helpful and fantastic explanation!!
Great videos MAN , one thing i struggled with was no module named panda , would have helped if you told us how to download the library or maybe its because i am doing it in vs code : still great vidoes man u are G.O.A.T
Hello Alex, I have been going through your videos and learned a lot from them. Really thankful for it. Just wanted a little bit of your time to review my Resume which I have made. Your advice would be of great help. Looking forward to your time. Thank you.
i need your help! I try to brimg in Pandas as pd but i get error message: it is there i can see it.? FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\Samson\\Documents\\CSV Excel Databasse\\sales'
can you tell me or if possible make a video of how to get started with jupyter. I tried to install and run the first line "import pandas as pd", it always gives me an error..
@Alex hi Alex , " import pandas as pd pd.read_csv(r"C:\Users\munag\OneDrive\Desktop\Learnings\Data Analyst\countries of the world.csv")" FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\munag\\OneDrive\\Desktop\\Learnings\\Data Analyst\\countries of the world.csv' ---- I am getting this error. Can you Please point out where did i do wrong?
1)check if you have assigned it to a variable, df = pd.read_csv(r"C:\Users\munag\OneDrive\Desktop\Learnings\Data Analyst\countries of the world.csv") 2)double check if the file path is correct(you might have moved file to someother location)
Hello Alex, I would like to know your opinion on Data Analyst freelancer jobs. Is there actually such a thing? It would be great if you'd share your thoughts on this.
No matter how far I get in data analytics, I will always think of black and white bears first when I hear pandas. Where the heck did the name come from, anyway?
Hey! :) I'm having problems with pd.set_option("display.max_rows",200). If I write pd.get_option(("display.max_rows") it says is 200, but when i run df again, its only showing first and last columns as before. Do you know what the problem could be?🙏
Hello, great videos, do you know how to use python pandas to read excel files from sharepoint online, using certificate or PKI or x509? I have tried everything and cant get access, keep getting 401 errors…thanks
What if your text file doesn't contain a perfect table. For example, I have a huge text files that looks like this: #Time (HHH:MM:SS): 002:34:02 # T(ms) BUS CMD1 CMD2 FROM SA TO SA WC TXST RXST ERROR DT00 DT01 DT02 DT03 DT04 DT05 DT06 DT07 # ===== === ==== ==== ==== == ==== == == ==== ==== ====== ==== ==== ==== ==== ==== ==== ==== ==== 816 B0 D84E BC RT27 2 14 D800 2100 0316 0000 0000 0000 0000 CCCD 0000 817 A0 DC50 RT27 2 BC 16 D800 2120 0000 4080 3000 0000 3000 0000 0000 #Time (HHH:MM:SS): 002:34:03 # T(ms) BUS CMD1 CMD2 FROM SA TO SA WC TXST RXST ERROR DT00 DT01 DT02 DT03 DT04 DT05 DT06 DT07 # ===== === ==== ==== ==== == ==== == == ==== ==== ====== ==== ==== ==== ==== ==== ==== ==== ==== 056 B0 D84E BC RT27 2 14 D800 2100 0316 0000 0000 0000 0000 CCCD 0000 057 A0 DC50 RT27 2 BC 16 D740 2120 0000 4080 3000 0000 3000 0000 0000 How can I do pd.read_table to get just the data from DT00 thru DT07 into an array, without doing lots of preprocessing to scrub out the repeating #Time headers that appear throughout the file?
This is how people should teach - easy, smooth, and clear breakdown of concepts.
As a python beginner without any programming background, I watched a lot of videos on youtube and found them very hard to follow. This video is the best I've ever watched so far! Thanks!
Great video from Alex as always. For those who don't know how to access to "copy as a path", you hold shift and right-click the file. I hope this helps.
Thanks !
@@dan.6398 thanks!!
You are a life saver, now let me get back to the video
Great video Alex as always, still can’t believe how much I have learned from you and your videos in the last 6 months! Definitely tunning in to brush up and keep it fresh! Bring back the intro!
This is the thing I was looking for. I had wish to someone make it more easy.
This is my first step 🚶♂️ to learn python.
Lots of love ❤️ for this video
Thank you for being a truely outstanding teacher. Your passion for impacting knowledge and your dedication to your students is obvious in everything you do.
I feel so lucky to learn from you sir. I hope you know the priceless impact you are making in so many lives.
Sir, please I have a humble request.
I would appreciate if you would make a video of PYTHON in Data Analysis. A complete series. Much love sir.....
You teach in the most simple way. Thank you for zooming the screen so one can see the text clearly. God bless you. Keep up the good work
I feel like giving you a hug @Alex. Thanks for relieving me hours searching for this solution. Thanks alot
Great video. It's been really hard to find good Python videos. It seems like EVERY Python for Data Analytics course that I buy has a teacher that comes from the computer science world, and talks about it that way. Your approach makes is SO much easier for us non-computer scientists to learn!
Thank you Alex! I watched the first video and it automatically switched to the next one, but I came back to hit thumbs-up and leave this comment.
The best Pandas course (I tried many of them)
The best before the course l was disappointed because I couldn’t open the bath of file and now it’s going up 😂😂❤thanks you’re the best now l will see all your videos and if you have a group not free l will join it really it’s helpful and fantastic explanation!!
This is so simplified and informative, thanks Alex.
Very fantastic way to teach.
Amazing tutorial.
thanks for straightforwardly explaining this.
I want to request you to please make a video on Mathematics used in Data analysis.
great video, new for me is the "copy for path" lol, used to do that different way or "type manually"
Great job, easy to understand. Thank you so much.
Alex, thanks for the video. Nicely explained. Looking forward to future videos.
Great videos MAN , one thing i struggled with was no module named panda , would have helped if you told us how to download the library or maybe its because i am doing it in vs code : still great vidoes man u are G.O.A.T
13:26 how does the comand knows that it has to do changes for jason file, you did not mention that show all the columns for Jason file.
Great video! Thanks, keep moving forward!
not having intro sounded so different. It feels that I've missed some part of the video or even lost a complete previous episode.
Haha sorry about that! :D
my country mentioned yay
Brilliant tutorial. Thanks.
Glad it was helpful!
Chris Bruehl from Maven Analytics has an outstanding Pandas and NumPy master class course. I would recommend that over some unknown course.
I've taken both and I prefer this one actually
Nice channel you have got!!! Thank you!!!
Finally!!!!!!!!!!
pd.options.display.max_rows = 235
for anybody who couldn't run the code
Thanks! Same issue🙃
Hello Alex, I have been going through your videos and learned a lot from them. Really thankful for it. Just wanted a little bit of your time to review my Resume which I have made. Your advice would be of great help. Looking forward to your time.
Thank you.
18:22 this statement doesn't work Alex Please can u explain it. or anyone else
1:58 4:55 7:42 9:52
Uzbekistan 😄🙌
Please make a video on numpy for data analysis
how would I manipulate the data frame such that I could set a min and max? lets say in the case of the example above, ranking from 12 to max 35
Hi Alex, What if my csv file which is separated by a comma has uneven number of columns, can we import it using pandas?
Yes import the Csv file, read the Csv file and go for data cleaning and manipulation
i need your help! I try to brimg in Pandas as pd but i get error message:
it is there i can see it.?
FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\Samson\\Documents\\CSV Excel Databasse\\sales'
please add the correct file name
Can you make a playlist of numpy and matplotlib libraries it will help us a lot
can you tell me or if possible make a video of how to get started with jupyter. I tried to install and run the first line "import pandas as pd", it always gives me an error..
thank you soo much sir
Thank You
thank you Alix for every thing
I want to ask you smth how can I download the txt , json , csv files form gethup ?
countries
Hi can anybody help me im getting error refers that no such module exists named “pandas“?
kept getting an error when trying to import the excel file. Not sure what is going on. Help? kept telling me persmission denied
Me also,but you should close the excel file for importing otherwise permission denied will come..
shift + right Click on folder, now copy as path option will be visible.
for some reason i am not able to download these files from github, the raw files end up not opening the page and the download button doesn't work.
finally pandas came to the zoo now slowly import Numpy animal also from numerical statistics city .
I love the tutorial so far but the line: print(data_frame.loc['Uzbekistan']) does not work neither in jupyter, nor in VSO.
Alright. I had to change index_col attribute to 'Country'.
Can anyone please explain how to get "copy as path" in Windows right click context menu?
I don't think it is there by default!
If you using window 10, hold shift while right click to get that option
@@SyahmirSupardi Yeah. I figured it out. Thank you anyway.
Hi Alex! Thanks for video. 12 out 10 as usually. I would like to ask you if you could give us permission to download the files? Thanks in advance!
Of course - should be provided on my github to download :)
Loc[‘john’] always showing key error
@Alex hi Alex , " import pandas as pd
pd.read_csv(r"C:\Users\munag\OneDrive\Desktop\Learnings\Data Analyst\countries of the world.csv")"
FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\munag\\OneDrive\\Desktop\\Learnings\\Data Analyst\\countries of the world.csv' ---- I am getting this error. Can you Please point out where did i do wrong?
1)check if you have assigned it to a variable,
df = pd.read_csv(r"C:\Users\munag\OneDrive\Desktop\Learnings\Data Analyst\countries of the world.csv")
2)double check if the file path is correct(you might have moved file to someother location)
Hello Alex, I would like to know your opinion on Data Analyst freelancer jobs. Is there actually such a thing?
It would be great if you'd share your thoughts on this.
I have a problem :D It cannot read a file when i input path and do all the things like "r". It shows me FileNotFoundError
same
@@akbotazhardemkulova2039 it works for me now but not csv, try to use excel file instead and put df.read_excel()
@@akbotazhardemkulova2039if you are using windows you have to use two ‘\\’ rather than one ‘\’. Example: c:\\users\\mickeymouse\\data\\my.csv
thank you so much for your
optionError: No such keys(s): 'dispaly.max.rows'
why I have that error guys
so i got an error when importing 'sheet1' i then renamed the sheet to somthing else and then it worked
Like always this video is very good. But when i try to read the Excel. But why it can't read it? Should i download the openpyxl?
I ran into the same problem and realized it was because I had that excel file open, maybe that is why it was not reading it for you as well
sangat bermanfaat
Datasets links not working
no intro?
Haha I didn't know people wanted it! I just went straight in - next series I will :)
How do I read .dat file?
Is it the first video of pandas??
No matter how far I get in data analytics, I will always think of black and white bears first when I hear pandas. Where the heck did the name come from, anyway?
18:19 Uzbek sila
What IDE is this?
Jupyter
Hey! :) I'm having problems with pd.set_option("display.max_rows",200). If I write pd.get_option(("display.max_rows") it says is 200, but when i run df again, its only showing first and last columns as before. Do you know what the problem could be?🙏
I see you have "display.max_rows", but in the video Alex used "display.max.rows", so a dot, not an underscore. have you tried that?
Why you didnt show how to set everything up???? xD
Alex thanks for the video but for information (“western sahara) is not an official country it’s a part of kingdom of Morocco 🇲🇦
😂😂😂😂😂😂😂
How to use pandas in 2023
??
Hello, great videos, do you know how to use python pandas to read excel files from sharepoint online, using certificate or PKI or x509? I have tried everything and cant get access, keep getting 401 errors…thanks
What if your text file doesn't contain a perfect table. For example, I have a huge text files that looks like this:
#Time (HHH:MM:SS): 002:34:02
# T(ms) BUS CMD1 CMD2 FROM SA TO SA WC TXST RXST ERROR DT00 DT01 DT02 DT03 DT04 DT05 DT06 DT07
# ===== === ==== ==== ==== == ==== == == ==== ==== ====== ==== ==== ==== ==== ==== ==== ==== ====
816 B0 D84E BC RT27 2 14 D800 2100 0316 0000 0000 0000 0000 CCCD 0000
817 A0 DC50 RT27 2 BC 16 D800 2120 0000 4080 3000 0000 3000 0000 0000
#Time (HHH:MM:SS): 002:34:03
# T(ms) BUS CMD1 CMD2 FROM SA TO SA WC TXST RXST ERROR DT00 DT01 DT02 DT03 DT04 DT05 DT06 DT07
# ===== === ==== ==== ==== == ==== == == ==== ==== ====== ==== ==== ==== ==== ==== ==== ==== ====
056 B0 D84E BC RT27 2 14 D800 2100 0316 0000 0000 0000 0000 CCCD 0000
057 A0 DC50 RT27 2 BC 16 D740 2120 0000 4080 3000 0000 3000 0000 0000
How can I do pd.read_table to get just the data from DT00 thru DT07 into an array, without doing lots of preprocessing to scrub out the repeating #Time headers that appear throughout the file?