Data Analysis with Python for Excel Users - Full Course

Learn how to use Python and Pandas for data analysis. This course will be especially helpful if you have experience with Excel, but that is not required. Learn how to create pivot tables, work with data, and make visualizations using Python, Pandas, and Jupyter Notebook.

✏️ Course developed by Frank Andrade.

⭐️ 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

--

[AlexisAndradeMonteiro]

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

[malwalsabino]

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.

[mrCetus]

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")

[victoriabraimoh]

Frank went all out with this course. perfect beginner course. hope we all make you proud

[quincylarsonmusic]

That is one gorgeous cheat sheet. Thanks for everything you're doing for the global developer community, Frank. This course is gold.

[kku]

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!

[nournissan]

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

[marcoventura]

A very good begginer's course; it covers the basics of Python with Juipter Notebook IDE in a simple and understable way.

[imadias]

Best INSTRUCTOR with the best English accent that we can easily understand and you never miss any step for running Python, even though I'm a beginner but now I know How to use python because of this video 😍, some tutorial they skip some step and even we try to follow their instructions but we got lost 😊😊😊Thank you Instructor ❤

[gimiemini]

I have just finished this. Love it. So easy to follow and Frank was amazing. best video so far.

[dondata]

Just finished this video. It is my first introduction to python and you did an excellent job. I appreciate this thanks

[dimasjimenez]

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.

[Tradewithsimpleminded]

Don't know where you watching this from my brother but I wished you all the best in life ❤️❤️

[swagat]

Amazing content Frank.. How effortlessly you explained everything in the most simplistic way.. Thank you

[jessicaliu]

Great course! Thank you so much! Spent a half day finishing the course. Very Helpful!

[mansasow]

Thanks for this tutorial! It would have also been nice to show how to concatenate or merge multiples data frames (inner, left, right join).

[robertspalding]

Frank Andrade, thank you for the best, and most helpful tutorial of
this type and this subject that I have ever seen.

[stathistsamis]

as a junior data analyst i found this video very useful keep going my friend!!!

[shishirdutt]

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

[CodewithAby]

Great course, broken down like ABC. Thanks Frank