Data Analysis with Python for Excel Users - Full Course
2,029,282
Published 2021-11-24
💻 Source Code & Datasets: github.com/ifrankandrade/python-course-for-excel-u…
🔗 Datasets: drive.google.com/drive/folders/12hFh6RPlX5bWzSqpoM…
✏️ Course developed by Frank Andrade.
🔗 YouTube Channel: youtube.com/c/FrankAndrade5
🔗 PDF Python Cheat Sheet for this Course: artificialcorner.com/p/redeem-my-udemy-courses-for…
🔗 My Complete Python Courses for Data Analysis & Data Science: www.udemy.com/user/frank-andrade-13/
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Intro
⌨️ (0:01:48) Install Python and Jupyter Notebook with Anaconda
⌨️ (0:03:53) Jupyter Notebook Interface
⌨️ (0:13:56) Cell Types and Cell Mode
⌨️ (0:21:34) Jupyter Notebook Shortcuts
⌨️ (0:26:39) Module 1 - Hello World
⌨️ (0:30:30) Data Type
⌨️ (0:39:10) Variables
⌨️ (0:46:53) Lists
⌨️ (1:11:14) Dictionaries
⌨️ (1:21:50) IF Statement
⌨️ (1:28:04) FOR Loop
⌨️ (1:33:49) Functions
⌨️ (1:40:59) Modules
⌨️ (1:44:41) Module 2 -Introduction to Pandas
⌨️ (1:51:08) How to create a dataframe
⌨️ (2:07:34) How to show a dataframe
⌨️ (2:14:24) Basic Attributes, Functions and Methods
⌨️ (2:26:17) Selecting One Column from a Dataframe
⌨️ (2:32:13) Selecting Two or More Columns from a Dataframe
⌨️ (2:37:50) Add New Column to a Dataframe (Simple Assignment)
⌨️ (2:47:51) Operations in dataframes
⌨️ (2:56:04) The value_counts() method
⌨️ (3:00:16) Sort a DataFrame with the sort_values() method
⌨️ (3:09:56) Module 3: Introduction to Pivot Tables in Pandas
⌨️ (3:14:42) The pivot() method
⌨️ (3:20:49) The pivot_table() method
⌨️ (3:29:00) Data Visualization with Pandas (New Dataset + Pivot Table)
⌨️ (3:38:38) Lineplot
⌨️ (3:43:05) Barplot
⌨️ (3:50:52) Piechart
⌨️ (3:54:36) Save Plot and Export Pivot Table
🎉 Thanks to our Champion and Sponsor supporters:
👾 Raymond Odero
👾 Agustín Kussrow
👾 aldo ferretti
👾 Otis Morgan
👾 DeezMaster
--
Learn to code for free and get a developer job: www.freecodecamp.org/
Read hundreds of articles on programming: freecodecamp.org/news
All Comments (21)
-
Don't know where you watching this from my brother but I wished you all the best in life ❤️❤️
-
BEST PYTHON COURSE i EVER SEEN. i LITERALLY ENJOYED AND SPEND MY WEEKEND CONSUMING THESE CONTENT WITH PLEASURE. THANK YOU FOR YOUR MASSIVE SUPPORT FRANK
-
That is one gorgeous cheat sheet. Thanks for everything you're doing for the global developer community, Frank. This course is gold.
-
I am a decent Excel user who has been so reluctant to learn any programming language. Your video changed my mind and after few hours of watching this video, I feel I can learn the basics of python in a short period of time. Your teaching style is amazing and your ability to explain things is fascinating. Thank you so much.
-
Thanks for this tutorial! It would have also been nice to show how to concatenate or merge multiples data frames (inner, left, right join).
-
Frank went all out with this course. perfect beginner course. hope we all make you proud
-
I just finished this python course and I have to say it was so fascinating to learn about this language. Frank did a great job at breaking everything down !!
-
A very good begginer's course; it covers the basics of Python with Juipter Notebook IDE in a simple and understable way.
-
That's the best content I've seen on jupyter and pandas so far! well done champ! I've spent my whole weekend going along on this course and I totally love it! Very well structured and full of examples you can run and you can test out on your own. had a minor set back on opening the csv file dgp but added the encoding parameter: df_gdp = pd.read_csv("gdp.csv" , encoding="latin-1")
-
Hi Frank! Many thanks for creating this wonderful course. You have taken humungous efforts for creating such a long and flawless content for everyone to learn. Highly commendable efforts!!
-
Just finished this video. It is my first introduction to python and you did an excellent job. I appreciate this thanks
-
Amazing content Frank.. How effortlessly you explained everything in the most simplistic way.. Thank you
-
I still didn't finish the full course but I already find it very useful and well explained. Thank you Frank!
-
Best Tutorial on Python for Data Analytics I have seen so far... Your approach is commendable. Well done! I need to see more of your contents. This is good stuff!
-
I have just finished this. Love it. So easy to follow and Frank was amazing. best video so far.
-
Extraordinary content, crystal clear explanation. Pure gold. We should be able to like the video a couple of times. Thanks a ton for such an wonderful content.
-
Great course! Thank you so much! Spent a half day finishing the course. Very Helpful!
-
Frank Andrade, thank you for the best, and most helpful tutorial of this type and this subject that I have ever seen.
-
Fantastically explained, thank you so much. Clear, easy to understand and shows some good examples.
-
as a junior data analyst i found this video very useful keep going my friend!!!