watermark logo

2 ืฆืคื™ื•ืชยท 16 ืื•ื’ื•ืกื˜ 2022

Data Analysis with Python for Excel Users - Full Course

Advertisement


MaggieN383
ืžื ื•ื™ื™ื

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/ifrankandra....de/python-course-for
๐Ÿ”— Datasets: https://drive.google.com/drive..../folders/12hFh6RPlX5

โœ๏ธ 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

ืœื”ืจืื•ืช ื™ื•ืชืจ


ื”ื‘ื

Advertisement