Learn Python Pandas #2 - Data Selection, Viewing, & Indexing

In this video we'll cover:
- Review of dataframe creation
- Review of dataframe structure
- Viewing DataFrame attributes including: index, columns, dtypes
- selecting data by square brackets
- selecting data by labels: .at, .loc methods
- selecting data by integer: .iat, .iloc methods
- best practices for selecting data (Production vs Working code)

Sorry for the audio quality on this one - I had microphone struggles.

THANKS SO MUCH FOR ALL THE SUPPORT! 2760 Subscribers!!! You guys are incredible, thanks so much for all the support of my channel and videos

#Python #Pandas #Tutorial
*****************************************************************
Full code from the video:

Extended Code:

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Check out my website:

Pixabay Image for outro:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!!

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

[nickarrigo]

derricks instruction gets right to the point. He doesn't over talk and tells you only what you need to know. His channel is an awesome resource!

[TeverRus]

Thank you, man! I got a job where I have to work with pandas... and until I saw your videos I hadn't had a clue what to do about it! You are a life saver :)

[kevinwonart]

I recently started a job where I have to manage a ton of data files. This is what I've been wanting to learn how to do. Thank you for your easy step by step videos and explanation!

[William_sJazzLoft]

Hey Derrick; it's another outstanding video. Just a note of caution for anyone doing this in the venv of repl.it ( as I did ) make sure to install the xlrd dependency.

[deepaksaikumar]

great tutorial, But watch this at 0.5x for better understanding

I dropped a nice MIT lecture on differential equations in order to gather info to solve a problem in my pandas lecture, so this better be good teacher derrick

[DequanHarrison]

Excellent videos! I like how you give the diagram/chart and show the multiple ways of using a function.

[kumargautam]

Thanks Derrick, as usual your tutorials are apart from the crowd ...

[nasser-eddinemonir]

Excellent ! I've never seen such a presentation of dataframe's selections. *applause*

[maxbart]

really good explanation, thx. Now I understand that I need this

[nathalielink]

Thank you Derrick, your tutorial is helpful!

[thingstoknow]

All videos are useful..can you please make some tutorial on CSV file with pandas..like if there are 1000 lines in a CSV ..now if the data reperesets no of students, University, coures, in row by row..( that are in not in coloumn wise) then how we can create new CSV in different tab representing students, University, coureses

[englishtagalog]

Hey Derrick, i was wondering where was the excel file?
in your other tutorial the workbook was included

[adeyeyetemitayo]

Wonderful video. Really enjoy your videos. Do you have a video on how I can read Excel files, write into another Excel file and automate it if there's a new update on the Excel file we are reading from. Thank you

[FrankenLab]

@Derrick Sherrill, I like your videos, but this one felt *really* rushed, like you had too much caffeine, lol. There were parts where you didn't elaborate and were going so quick there wasn't time to extrapolate what you meant. So far this the only video where I've noticed you've done that. Otherwise, great stuff!

[bazareta]

I guess that loc and iloc is more convincing and updated as per version 0.25

[hardikpatel]

hey mate nice and useful video. i am trying to get table from 4 diff. wiki pages and want to club them in single page. i can get that 4 page individually but unable to club them in single page. can you give me any video link or ref. where i can learn it ? thanks in advance.

[camarojay]

I got a new boss at work and he wants me to learn Python and Tableau asap. Any recommendations for me?

[baophan]

thanks, can you give me take that excel file?

[duaafatima]

where do I download the excel sheet? :/