Easy Spreadsheet Data Analysis Methods - Python Pandas Tutorial

preview_player
Показать описание
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!
Рекомендации по теме
Комментарии
Автор

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.

gurupartapkhalsa
Автор

more of that please - especially pandas methods 👍

christoph
Автор

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

rynrbe
Автор

Derrick you make learning python easy!

christineeubanks
Автор

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

skyblue
Автор

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.

SaraAce
Автор

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

faheemshaikh
Автор

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.

robertpearson
Автор

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

gee_rex
Автор

Awesome easy to follow tutorial. Thank you!

nicombor
Автор

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

loveyoutube
Автор

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

FabioJulioRoque
Автор

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.

devasenathipathi
Автор

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

saadsalique
Автор

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

luqmanhakim
Автор

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

roger_rogers
Автор

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

nishantpurohit
Автор

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

anthonyrojas
Автор

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

yuangchengyuancheng
Автор

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!

knocknck
visit shbcf.ru