Python Pandas Tutorial ( Basics ) - Start Replacing Excel for Python 2021 Series

In this one we'll take a look at how we can start using pandas to do simple tasks

⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing.

Merch Store --
Support the Channel on Patreon --
Join The Socials --
*****************************************************************
0:00 Introduction
0:50 Viewing The Data Source
1:14 Setting up Pandas
1:30 Importing Data
2:25 Viewing Data
3:34 Selecting Columns
4:40 Simple Operations
8:20 Graphing Data
9:56 Viewing Graph

Full code from the video:
import pandas as pd

# Viewing data

dates = df_gold_prices['Date']
prices = df_gold_prices['Price']

# simple operations
df_gold_prices['buy_price'] = prices * .9
print(df_gold_prices['Price'].max())

print(df_gold_prices)

Packages (& Versions) used in this video:
Pandas 1.3.2
Plotly

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

[yoxify]

Finally He remembered YouTube password

[daksh_joshi]

Man your channel deserves to blow up -- to-the-point, organised, clean and genuinely helpful videos. Thank you so much!!

[esquire]

Happy you're back. I'm really in Python and glad to found your videos :)

[jarrodvos]

Thanks, Derrick! Looking forward to more advanced stuff explained in your usual clear and encouraging way. Great work.

[philippecolin]

My saviour! glad you are back... a 64 years old mini geek

[denniii]

He's back! Excited for future advanced techniques from you ;)

[Edddaye]

My man! your videos have been helping me understand pandas lib. Glad you're back!

[AcceptableBread]

You are the man. The content, editing, and your adept teaching ability is exceptional. Thank you.

[oscarsanchez]

Hey I just wanted to say is that I have been binge watching your videos. In my opinion you have a gift for teaching please continue to make videos you provide tons of value. Thank you for everything!

[BoredSpaceRoo]

Derek, you legend. What an amazing intro to Pandas 🐼 Thank you so much kind ser! ☺️🙏✨

[omarjanuyghur]

Oh my GOSH. this is the one I was looking for a long time, the best video of the month. Thanks for sharing this, very good explanation in very details. I can guarantee farmers or elementary school students also can understand your video, which is to the point, very simple and very clear.

[gussta]

Your short videos teach me more then videos 2 or 3 times as long. Great job...thanks.

[d]

GOD, you answered all of my questions in 11 minutes. thank you

[rynrbe]

Thanks to your youtube videos, I am starting to use python for replacing some of my excel work that used to take a lot of time to do but once that script is ready, I can replicate it over and over again with a different project.

[applepie]

I just found you and realised you hadn't posted for 10 months... 😭 pls come back, I'd gladly take your course if you have one to sell, the way you do things is simply brilliant.

[cordularaecke]

Welcome back! Good that you make more Pandas videos ... I refactored your code to include assign method - please do a video on this!

import pandas as pd
import plotly.express as px

df =
.assign(Date=lambda x: x.Date.apply(pd.to_datetime),
buy_price=lambda x: x.Price * .9))

print(df.max(), '\n')
print(df.tail(3))

fig = px.line(df, x='Date', y='Price', title='Gold prices over time')
fig.show()

[edsonwinnerify]

Thank you Derrick... keep your videos coming!

[livingiON]

Man, your explaining is on another level.

[shinstorm]

Loved your indepth walk through. Looking forward to another Pandas video 🍻 cheers

[davidstone]

Welcome back!!! Awesome tutorial, Derrick.