Move from Excel to Python with Pandas Transcripts
Chapter: Welcome to the course
Lecture: Welcome!
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Hello and welcome to my course Excel,
0:02
to Python. We're so excited to have you here.
0:07
Have you been using excel a lot in your data work and feel like there
0:10
has to be a better way?
0:12
Or maybe you have heard the python is a good language to learn for data science
0:16
and you will see how you could apply these concepts to your job.
0:20
If so, then you're in the right place.
0:22
We're going to have a lot of fun and get many ideas for using python as
0:26
an alternative to the task. You might try to use Excel for today before taking
0:31
this course. You should have some experience with Python.
0:34
If you are not comfortable with the basic concepts of python.
0:37
Then should look at our other course python "Jump Start by Building 10 Applications" or "Python for the Absolute Beginner.
0:42
In this course,
0:45
you will learn how to set up and use a robust python environment form,
0:49
organized and repeatable process that could be used to replace many of the cumbersome tasks you use
0:54
excel for today. The majority of the code in this class will be using the
0:58
"Pandas Library" we will take a unique way to teach this powerful library by showing you
1:03
examples and excel and translating them to the pandas version.
1:07
You will start to learn more about pandas and understand when it will be a good alternative
1:11
to your current Excel solutions. By the end of this course,
1:14
you will understand how to incorporate python into your daily analysis workflow.
1:18
You will also find ways to streamline and automate many of the boring and repetitive tasks
1:23
use typically do in Excel. Michael Kennedy frequently says that knowing python is like having
1:28
a superpower. I think there's a great analogy,
1:31
and I suspect that by the time you finish this course,
1:34
you will have many ideas for how you can take this knowledge back to your job,
1:37
improve a tedious process and look like a super hero for saving your organization time