Reading in Files in Pandas | Python Pandas Tutorials

[@Brucex19]

This is how people should teach - easy, smooth, and clear breakdown of concepts.

[@bear76917]

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!

[@damaslan2246]

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.

[@dan.6398]

Thanks !

[@olamaciak831]

@@dan.6398 thanks!!

[@stephenwagude9330]

You are a life saver, now let me get back to the video

[@norawallberg1345]

Thank you!!

[@beardedmtbr]

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!

[@kpeyialale1104]

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

[@victorchinemerem2704]

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

[@vishnuekilwale4186]

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

[@dccoulthard]

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!

[@litaogechi86]

I feel like giving you a hug @Alex. Thanks for relieving me hours searching for this solution. Thanks alot

[@kmetriqs]

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)

[@SidiMohamed-x4y]

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!!

[@emmanuelojuyenum879]

This is so simplified and informative, thanks Alex.

[@chahineatallah2636]

great video, new for me is the "copy for path" lol, used to do that different way or "type manually"

[@MuhammadSohail-w6r]

Very fantastic way to teach.

[@ajaybhandari9596]

Amazing tutorial. thanks for straightforwardly explaining this. I want to request you to please make a video on Mathematics used in Data analysis.

[@rajeshkumar2k567]

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.

[@theauroralightyr]

Great job, easy to understand. Thank you so much.

[@sajuthomas9659]

Alex, thanks for the video. Nicely explained. Looking forward to future videos.

[@srijanrawat4014]

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

[@İsmayılSadıqov-v6b]

Great video! Thanks, keep moving forward!

[@MohsinAminAnjum]

18:22 this statement doesn't work Alex Please can u explain it. or anyone else

[@moxie1189]

Chris Bruehl from Maven Analytics has an outstanding Pandas and NumPy master class course. I would recommend that over some unknown course.

[@AlexTheAnalyst]

I've taken both and I prefer this one actually

[@ivanko-nebo]

not having intro sounded so different. It feels that I've missed some part of the video or even lost a complete previous episode.

[@AlexTheAnalyst]

Haha sorry about that! :D

[@John-pb7gb]

Hi Alex, What if my csv file which is separated by a comma has uneven number of columns, can we import it using pandas?

[@DeranKumar-sz3co]

Yes import the Csv file, read the Csv file and go for data cleaning and manipulation

[@samshepherd6197]

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' ​

[@amal7411jo]

please add the correct file name

[@preetshah3793]

Please make a video on numpy for data analysis

[@yurobert3007]

Brilliant tutorial. Thanks.

[@AlexTheAnalyst]

Glad it was helpful!

[@abhishekmarubadi5718]

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

[@Nandhu470]

Can you make a playlist of numpy and matplotlib libraries it will help us a lot

[@infiniteboredom1]

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

[@daewanshbansal6173]

Hi can anybody help me im getting error refers that no such module exists named “pandas“?

[@KvintKek]

Nice channel you have got!!! Thank you!!!

[@yagndabhi2178]

1:58 4:55 7:42 9:52

[@pitaszekfistaszek]

I love the tutorial so far but the line: print(data_frame.loc['Uzbekistan']) does not work neither in jupyter, nor in VSO.

[@pitaszekfistaszek]

Alright. I had to change index_col attribute to 'Country'.

[@kunalkaushal6466]

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.

[@EatingGuo]

Loc[‘john’] always showing key error

[@the_seahawk22]

kept getting an error when trying to import the excel file. Not sure what is going on. Help? kept telling me persmission denied

[@Kishor_D7]

Me also,but you should close the excel file for importing otherwise permission denied will come..

[@harisshi]

shift + right Click on folder, now copy as path option will be visible.

[@AnieAnime]

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.

[@namaaazaizeh1258]

thank you Alix for every thing I want to ask you smth how can I download the txt , json , csv files form gethup ?

[@evansyaran233]

countries

[@ianafele6196]

Finally!!!!!!!!!!

[@azamat.tkht47]

my country mentioned yay

[@milanvulic7947]

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

[@akbotazhardemkulova2039]

same

[@milanvulic7947]

@@akbotazhardemkulova2039 it works for me now but not csv, try to use excel file instead and put df.read_excel()

[@arundaniel7817]

@@akbotazhardemkulova2039if you are using windows you have to use two ‘\\’ rather than one ‘\’. Example: c:\\users\\mickeymouse\\data\\my.csv

[@aashishmittal206]

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!

[@SyahmirSupardi]

If you using window 10, hold shift while right click to get that option

[@aashishmittal206]

@@SyahmirSupardi Yeah. I figured it out. Thank you anyway.

[@chefernandez563]

so i got an error when importing 'sheet1' i then renamed the sheet to somthing else and then it worked

[@AnastasiaFreeland]

pd.options.display.max_rows = 235 for anybody who couldn't run the code

[@antoninarudnytska596]

Thanks! Same issue🙃

[@rajeshgautam-k2r]

@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?

[@praneshs-zt2nd]

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)

[@juhairmanar7055]

Datasets links not working

[@akhmadmikael6576]

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?

[@zoestoermer1129]

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

[@AnastasiaFreeland]

thank you so much for your optionError: No such keys(s): 'dispaly.max.rows' why I have that error guys

[@Hanap.s-jp4sv]

thank you soo much sir

[@positively8461]

Thank You

[@moseistrujillo8300]

no intro?

[@AlexTheAnalyst]

Haha I didn't know people wanted it! I just went straight in - next series I will :)

[@PawanSahare]

How do I read .dat file?

[@wise6469]

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.

[@catarinamacedo2864]

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

[@morris9973]

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?

[@codingtrap5389]

Is it the first video of pandas??

[@arvindeleon4527]

What IDE is this?

[@mulikinatisiddarthasiddu8245]

Jupyter

[@odiljoniminov6866]

Uzbekistan 😄🙌

[@Bendelman911]

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!

[@AlexTheAnalyst]

Of course - should be provided on my github to download :)

[@benrum]

sangat bermanfaat

[@shadow6161]

finally pandas came to the zoo now slowly import Numpy animal also from numerical statistics city .

[@DavidBurgermeister]

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?

[@onlysrk]

18:19 Uzbek sila

[@nesa6582]

Why you didnt show how to set everything up???? xD

[@samshepherd6197]

How to use pandas in 2023

[@vxintruder]

??

[@agadirmaroc6908]

Alex thanks for the video but for information (“western sahara) is not an official country it’s a part of kingdom of Morocco 🇲🇦

[@oussamasteam1028]

😂😂😂😂😂😂😂

[@FredyArg]

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

[@bennguyen1313]

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?