Hey everyone. Quick video on what I think are the top five most useful pandas library methods for data analysis. Mastering these will take you a long way in your projects.

5. Import / Output Methods
4. Data Selection
3. Boolean Selections
2. Concat
1. GroupBy

Let me know what I left out!

4640 + Subscribers at the time of writing. How awesome. Thank you all for your continued support. It means the world to me! Thank you for watching my content.

Join The Socials -- Picking Shoutouts Across YouTube, Insta, FB, and Twitter!
FB - www.facebook.com/CodeWithDerrick/
Insta - www.instagram.com/codewithderrick/
Twitter - twitter.com/codewithderrick
LinkedIn - www.linkedin.com/in/derricksherrill/
GitHub - github.com/Derrick-Sherrill
*****************************************************************
Full code from the video:
import pandas as pd

excel_file = 'Docs/contacts1.xlsx'
df = pd.read_excel(excel_file)
print(df)

print(df.loc[:,'Name'])
print(df.iloc[:,0])

print(df[df['Title'] =='Engineer'])

excel_file_2 = 'Docs/contacts2.xlsx'
df2 = pd.read_excel(excel_file_2)

df3 = pd.concat([df, df2], axis=0)
print(df3)

total_count = df3.groupby(['Title']).count()
print(total_count['Name'])

github.com/Derrick-Sherrill/DerrickSherrill.com/bl…
Packages (& Versions) used in this video:
Python==3.7
Pandas==0.25.0

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:
github.com/Derrick-Sherrill/DerrickSherrill.com

Check out my website:
www.derricksherrill.com/

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!