Data Analysis with Python for Excel Users - Full Course

Channel:
United States freeCodeCamp.org
Subscribers:
10,700,000
Published on ● Video Link: https://www.youtube.com/watch?v=WcDaZ67TVRo


Duration: 3:57:46
1,284,327 views
25,287

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.

💻 Source Code & Datasets: https://github.com/ifrankandrade/python-course-for-excel-users
🔗 Datasets: https://drive.google.com/drive/folders/12hFh6RPlX5bWzSqpoMvAeT94RCjCvHw5?usp=sharing

✏️ Course developed by Frank Andrade.
🔗 YouTube Channel: https://www.youtube.com/c/FrankAndrade5
🔗 PDF Python Cheat Sheet for this Course: https://frankandrade.ck.page/d3b1761715
🔗 My Complete Python Courses for Data Analysis & Data Science: https://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: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news



Other Videos By freeCodeCamp.org


2021-12-20Internet History, Technology, and Security - Full Course from Dr. Chuck
2021-12-15Linked Lists for Technical Interviews - Full Course
2021-12-14Web App Vulnerabilities - DevSecOps Course for Beginners
2021-12-13Full Stack Web Development in the Cloud Course - Svelte, Postgres, Vercel, Gitpod
2021-12-08Can you code on a phone? Android Mobile Programing Tutorial
2021-12-07Bootstrap CSS Framework - Full Course for Beginners
2021-12-06The Business of Building Apps - App Product Management Course for Developers
2021-12-02Razor Pages for ASP.NET Core - Full Course (.NET 6)
2021-11-30Rust Programming Course for Beginners - Tutorial
2021-11-29NoSQL Database Tutorial – Full Course for Beginners
2021-11-24Data Analysis with Python for Excel Users - Full Course
2021-11-23Feature Toggles - Why and How to Add to Your Software
2021-11-22Learn ASP.NET Core MVC (.NET 6) - Full Course
2021-11-18Advanced Git Tutorial - Interactive Rebase, Cherry-Picking, Reflog, Submodules and more
2021-11-17AWS Certified Cloud Practitioner Certification Course (CLF-C01) - Pass the Exam!
2021-11-16Infrastructure as Code - Crash Course
2021-11-15C++ Programming Tutorial - Build a 3-Band Compressor Audio Plugin (w/ JUCE Framework)
2021-11-11Unreal Engine & C++ Tutorial - 1st Person Shooter Game
2021-11-10Micro-Frontends Course - Beginner to Expert
2021-11-09Code a Squid Game JavaScript Game Using Three.js - Tutorial for Beginners
2021-11-04Web Applications for Everybody Course - Dr. Chuck Teaches HTML, PHP, SQL, CSS, JavaScript, and more!