Skip to main content

Data Analysis with Python for Excel Users - Full Course


Curriculum for the course 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. 💻 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: 👾 Wong Voon jinq 👾 hexploitation 👾 Katia Moran 👾 BlckPhantom 👾 Nick Raker 👾 Otis Morgan 👾 DeezMaster 👾 AppWrite -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp

Watch Online Full Course: Data Analysis with Python for Excel Users - Full Course


Click Here to watch on Youtube: Data Analysis with Python for Excel Users - Full Course


This video is first published on youtube via freecodecamp. If Video does not appear here, you can watch this on Youtube always.


Udemy Data Analysis with Python for Excel Users - Full Course courses free download, Plurasight Data Analysis with Python for Excel Users - Full Course courses free download, Linda Data Analysis with Python for Excel Users - Full Course courses free download, Coursera Data Analysis with Python for Excel Users - Full Course course download free, Brad Hussey udemy course free, free programming full course download, full course with project files, Download full project free, College major project download, CS major project idea, EC major project idea, clone projects download free

What's Hot

CVR Nummer : Register CVR Number for Denmark Generate and Test Online

CVR Nummer : Register CVR Number for Denmark Generate and Test Online | Image credit: Pexel What Is Danish CVR The Central Business Register (CVR) is the central register of the state with information on all Danish companies. Since 1999, the Central Business Register has been the authoritative register for current and historical basic data on all registered companies in Denmark. Data comes from the companies' own registrations on Virk Report. There is also information on associations and public authorities in the CVR. As of 2018, CVR also contains information on Greenlandic companies, associations and authorities. In CVR at Virk you can do single lookups, filtered searches, create extracts and subscriptions, and retrieve a wide range of company documents and transcripts. Generate Danish CVR For Test (Fake) Click the button below to generate the valid CVR number for Denmark. You can click multiple times to generate several numbers. These numbers can be used to Test your ...

Bing Homepage Quiz: Fun, Win Rewards, and Brain Teasers

Bing, Microsoft's search engine, has taken interactive engagement to the next level with its captivating feature - the Bing Homepage Quiz. This intriguing daily quiz not only challenges your knowledge but also offers a chance to earn rewards. In this comprehensive guide, we will explore the ins and outs of the Bing Homepage Quiz, including how to play, the different types of quizzes, and how you can earn and use rewards through this engaging feature. Bing homepage Quiz | Image credit: LanguageLassi How to Play the Bing Homepage Quiz Playing the Bing Homepage Quiz is simple and enjoyable. Here's how you can get started: Visit Bing : Open your preferred web browser and navigate to the Bing homepage (bing.com). Look for the Quiz : On the Bing homepage, keep an eye out for the interactive quiz card. This card is usually located near the bottom of the page and features a captivating image related to the quiz. Click to Start : Click on the quiz card to begin the quiz. It...

How To Iterate Dictionary Object

Dictionary is a object that can store values in Key-Value pair. its just like a list, the only difference is: List can be iterate using index(0-n) but not the Dictionary . Generally when we try to iterate the dictionary we get below error: " Collection was modified; enumeration operation may not execute. " So How to parse a dictionary and modify its values?? To iterate dictionary we must loop through it's keys or key - value pair. Using keys