Data Analysis with Python for Excel Users – Full Course
Discover ways to use Python and Pandas for knowledge evaluation. This course will likely be particularly useful if in case you have expertise with Excel, however that’s not required. Discover ways to create pivot tables, work with knowledge, and make visualizations utilizing Python, Pandas, and Jupyter Pocket book.
Thank you for reading this post, don't forget to subscribe!
💻 Supply Code & Dataunits:
🔗 Dataunits:
✏️ Course developed by Frank Andrade.
🔗 YouTube Channel:
🔗 PDF Python Cheat Sheet for this Course:
🔗 My Full Python Courses for Data Analysis & Data Science:
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Intro
⌨️ (0:01:48) Set up Python and Jupyter Pocket book with Anaconda
⌨️ (0:03:53) Jupyter Pocket book Interface
⌨️ (0:13:56) Cell Sorts and Cell Mode
⌨️ (0:21:34) Jupyter Pocket book Shortcuts
⌨️ (0:26:39) Module 1 – Hi there World
⌨️ (0:30:30) Data Sort
⌨️ (0:39:10) Variables
⌨️ (0:46:53) Lists
⌨️ (1:11:14) Dictionaries
⌨️ (1:21:50) IF Assertion
⌨️ (1:28:04) FOR Loop
⌨️ (1:33:49) Features
⌨️ (1:40:59) Modules
⌨️ (1:44:41) Module 2 -Introduction to Pandas
⌨️ (1:51:08) Easy methods to create a dataframe
⌨️ (2:07:34) Easy methods to present a dataframe
⌨️ (2:14:24) Primary Attributes, Features and Strategies
⌨️ (2:26:17) Choosing One Column from a Databody
⌨️ (2:32:13) Choosing Two or Extra Columns from a Databody
⌨️ (2:37:50) Add New Column to a Databody (Easy Task)
⌨️ (2:47:51) Operations in dataframes
⌨️ (2:56:04) The value_counts() technique
⌨️ (3:00:16) Kind a DataBody with the sort_values() technique
⌨️ (3:09:56) Module 3: Introduction to Pivot Tables in Pandas
⌨️ (3:14:42) The pivot() technique
⌨️ (3:20:49) The pivot_table() technique
⌨️ (3:29:00) Data Visualization with Pandas (New Dataset + Pivot Desk)
⌨️ (3:38:38) Lineplot
⌨️ (3:43:05) Barplot
⌨️ (3:50:52) Piechart
⌨️ (3:54:36) Save Plot and Export Pivot Desk
🎉 Due to our Champion and Sponsor supporters:
👾 Raymond Odero
👾 Agustín Kussrow
👾 aldo ferretti
👾 Otis Morgan
👾 DeezMaster
—
Study to code without cost and get a developer job:
Learn a whole bunch of articles on programming:
source
