Top Five Pandas Functions for Data Scientists (And How to Use Them)
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 - / codewithderrick
Insta - / codewithderrick
Twitter - / codewithderrick
LinkedIn - / derricksherrill
GitHub - https://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'])
https://github.com/Derrick-Sherrill/D...
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:
https://github.com/Derrick-Sherrill/D...
Check out my website:
https://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!
