Data Analysis with Python for Excel Users – Full Course
August 29, 2024 2024-08-29 0:21
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://artificialcorner.com/p/redeem-my-udemy-courses-for-free
🔗 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
source
Comments (26)
@user-bu5uw3oc3k
Excellent course, simply put!
@RAFA-tg3yt
Thank you legend
@LuciaKatsumbe
Simply the best!. I was stuck on "Hello World!!!" Your method of teaching really elevates the experience of learning. I love the little reminders you throw in along the way. This course will be my "Go To" as I progress on my Python Journey. Thank you.
@njanesibokmani
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
@stefan5249
Thanks a lot for that course!! For starting with pandas, numpy dataframes perfect for getting basics to built up on them.
@---lm5si
I wish there was a video of Excel which teaches the most essential/most-used 20% of Excel to be able to do 80% of the work usually done in Excel.
@theodoreith9564
Nice
@bastadriverswitlaber9359
Kahirap haha
@rejal.a.r
i got a type error at this point "make a pivot table and add an aggregate function". I had change the datatypes in the excel files, still giving me the same error.
@VaalaakMr
Проверил связку еще раз, работает.
@InspirationJunction2
Terrific
@karanchunawala4662
Thanks team, for working out for us, I had zero knowledge when I had started but you have cleared very basic aspects for the first steps of learning, Highly recommended content thoese who wants to start from zero.
@vincentiousedeson3279
My best platform
@user-ff7ei4ob8b
my solution for datetime64 not supported in sum in
df_sales_numbers.pivot_table(index='Gender', aggfunc='sum').round(1)
“`
df_sales_numbers = df_sales.select_dtypes(include='number')
df_sales_numbers['Gender'] = df_sales['Gender']
df_sales_numbers.pivot_table(index='Gender', aggfunc='sum').round(1)
“`
@chuckbecker4983
For me it xomes down to one thing: how easy and simple it is to maintain a robust analysis environment. R and RStudio win hands down. Compared to Python + Conda or pip, R wins by a mile. Spyder takes 10X longer to liad than RStudio and that matters. Python is a dumpster fire.
@komialokpa8858
❤❤👍👍
@4-ck4wd
💯Exceptionally awesome video clip
@asfire937
리방하셨군요
@nhaitiahtaupo
nice video
@m.e-ph8sy
Amazing content Frank.. How effortlessly you explained everything in the most simplistic way
@thungivan3650
congrats!!
@jeanillecogtas
nag throwback lng…. those were the days…..
@IINelixII
Anyone here who has acces to the cheat sheet and would like to share it with me?
It looks like the link in the description doesn't work anymore.
@MikkyIGuess
14:39
@cesarramos3569
Great video Frank!! regards from Peru
@samsunga32-ml6pz
Account is cancelled and can not accept new subscribers…..error for cheat sheet page.