Easy Spreadsheet Data Analysis Methods - Python Pandas Tutorial

Hey Everyone! In this one I just wanted to show you a few built in methods of the pandas package that we can use for quick data analysis on our spreadsheets.

Kite helps fund the channel, thanks for checking them out and supporting me --

Here's the spreadsheet I used in this tutorial:

Support the Channel on Patreon --
Join The Socials --
*****************************************************************
Full code from the video:
import pandas as pd

print(df_info)

print(grouped_df['torque'])

profile_id_4_df = df[df['profile_id'] == 4]

Packages (& Versions) used in this video:
Python 3.8
Pandas 0.25
Atom 1.41

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

Check out my website:

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

--- Channel FAQ --

What text editor do you use?

What Equipment do you use to film videos?

What computer do you use/desk setup?

What editing software do you use?
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!

Where do I get my music?
I get all my music from the copyright free Youtube audio library

Let me know if there's anything else you want answered!

-------------------------

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

[gurupartapkhalsa]

One of my favorite things to do with pandas is normalize data, it so happens that your data was already normalized. However, in pandas it's so easy to take a spreadsheet of arbitrary values and call (stats =pandas.DataFrame.describe( )) then stats.transpose( ) and then take the original frame and simply say (normalized = ((pandas.DataFrame - stats['mean']) / stats['std'])) I believe this is one of the hottest quick tips. I'm sorry if you've already covered this, but this is your first video I've ever seen.

[christoph]

more of that please - especially pandas methods 👍

[rynrbe]

Thank you for making the transition from Excel to Python a little more easier for us all! 🙂

[christineeubanks]

Derrick you make learning python easy!

[skyblue]

Great and very useful video, thank you Derrick, there are a lot of people appreciating your work!

[SaraAce]

Thank you for this, I am an accountant learning python. The course I am taking on Linkedin is great but i didn't know how it would be applied in the context of what i work with (spreadsheets). Going thru this video really helped the light bulb come on in my brain and helped python make more sense.

[faheemshaikh]

Your Voice is so perfect for YT. I'm sure you'll grow big...

[robertpearson]

You could talk about handling utf-8 characters. The problem can be when you pull a CSV into excel and it converts to the Microsoft character set. When you pull that up in pandas it can sometimes be a mess. Fix can be to load with encoding=’utf-8’. Thanks for the great videos.

[gee_rex]

Derrick your videos are cool, right to the point and clear

[nicombor]

Awesome easy to follow tutorial. Thank you!

[loveyoutube]

Thank you Derrick. U make Python so easy for us👋👋👋🙏😃

[FabioJulioRoque]

Excelent methods! Good explanation....I learn to much with you.

[devasenathipathi]

Hello Derrick Thank you for making useful videos on Python, Expecting more from you. Could you group all your videos in order to go through one after the another in sequence. Once again Kudos for your work.

[saadsalique]

Thank you sm for going through it
really helped me becuase I have a prog assesment that is 30% due in 3 days and had no idea on what to do.'

[luqmanhakim]

Love it very useful ! Looking forward for more content like this :)

[roger_rogers]

this is more data prep. would love to see random forest, regression, etc.

[nishantpurohit]

Hey nice video..looking forward to more>>>THANKSS

[anthonyrojas]

Hey Derrick great content. Do you have anything discussing web scraping for analysis type of videos?

[yuangchengyuancheng]

Pretty enjoy watching your awesome video...Inspire me a lot...Cheers mate.

[knocknck]

You should make a scpecific video about how to install pandas and nunpy on python, specially on Windows. I tried to look for it on how to on the internet and YT but it wasnt nearly as clear or easy as you showed in this very video. Im sure if you go a little into detail it will be great!