Data Analysis with Python for Excel Users - Full Course

  Переглядів 2,029,874

freeCodeCamp.org

freeCodeCamp.org

День тому

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: github.com/ifrankandrade/pyth...
🔗 Datasets: drive.google.com/drive/folder...
✏️ Course developed by Frank Andrade.
🔗 UKposts Channel: / frankandrade5
🔗 PDF Python Cheat Sheet for this Course: artificialcorner.com/p/redeem...
🔗 My Complete Python Courses for Data Analysis & Data Science: www.udemy.com/user/frank-andr...
⭐️ 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: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

КОМЕНТАРІ: 369
@Tradewithsimpleminded
@Tradewithsimpleminded 2 роки тому
Don't know where you watching this from my brother but I wished you all the best in life ❤️❤️
@AlexisAndradeMonteiro
@AlexisAndradeMonteiro Рік тому
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
@quincylarsonmusic
@quincylarsonmusic 2 роки тому
That is one gorgeous cheat sheet. Thanks for everything you're doing for the global developer community, Frank. This course is gold.
@levarish
@levarish Рік тому
Can you please share the link for the cheat sheet?
@Thalescosta592
@Thalescosta592 7 місяців тому
@@levarish it's in the video description
@malwalsabino519
@malwalsabino519 7 місяців тому
I am a decent Excel user who has been so reluctant to learn any programming language. Your video changed my mind and after few hours of watching this video, I feel I can learn the basics of python in a short period of time. Your teaching style is amazing and your ability to explain things is fascinating. Thank you so much.
@mansasow
@mansasow 2 роки тому
Thanks for this tutorial! It would have also been nice to show how to concatenate or merge multiples data frames (inner, left, right join).
@victoriabraimoh8994
@victoriabraimoh8994 Рік тому
Frank went all out with this course. perfect beginner course. hope we all make you proud
@nournissan1786
@nournissan1786 Рік тому
I just finished this python course and I have to say it was so fascinating to learn about this language. Frank did a great job at breaking everything down !!
@marcoventura9451
@marcoventura9451 Рік тому
A very good begginer's course; it covers the basics of Python with Juipter Notebook IDE in a simple and understable way.
@mrCetus
@mrCetus 2 роки тому
That's the best content I've seen on jupyter and pandas so far! well done champ! I've spent my whole weekend going along on this course and I totally love it! Very well structured and full of examples you can run and you can test out on your own. had a minor set back on opening the csv file dgp but added the encoding parameter: df_gdp = pd.read_csv("gdp.csv" , encoding="latin-1")
@ThePyCoach
@ThePyCoach 2 роки тому
Thanks :)
@shishirdutt
@shishirdutt Рік тому
Hi Frank! Many thanks for creating this wonderful course. You have taken humungous efforts for creating such a long and flawless content for everyone to learn. Highly commendable efforts!!
@dondata718
@dondata718 Рік тому
Just finished this video. It is my first introduction to python and you did an excellent job. I appreciate this thanks
@swagat457
@swagat457 2 роки тому
Amazing content Frank.. How effortlessly you explained everything in the most simplistic way.. Thank you
@lcastellanosm
@lcastellanosm 2 роки тому
I still didn't finish the full course but I already find it very useful and well explained. Thank you Frank!
@boknows8263
@boknows8263 Рік тому
have you finished it by now?
@gorkemoncul6565
@gorkemoncul6565 Рік тому
@@boknows8263 Not yet
@boknows8263
@boknows8263 Рік тому
@@gorkemoncul6565 he will never finish it, he is watching TV now lol
@kku6749
@kku6749 Рік тому
Best Tutorial on Python for Data Analytics I have seen so far... Your approach is commendable. Well done! I need to see more of your contents. This is good stuff!
@gimiemini3034
@gimiemini3034 10 місяців тому
I have just finished this. Love it. So easy to follow and Frank was amazing. best video so far.
@dimasjimenez3396
@dimasjimenez3396 2 роки тому
Extraordinary content, crystal clear explanation. Pure gold. We should be able to like the video a couple of times. Thanks a ton for such an wonderful content.
@jessicaliu8885
@jessicaliu8885 Рік тому
Great course! Thank you so much! Spent a half day finishing the course. Very Helpful!
@robertspalding5635
@robertspalding5635 Рік тому
Frank Andrade, thank you for the best, and most helpful tutorial of this type and this subject that I have ever seen.
@tim64163
@tim64163 2 роки тому
Fantastically explained, thank you so much. Clear, easy to understand and shows some good examples.
@usuis8541
@usuis8541 7 місяців тому
GENSHIN PREACH
@stathistsamis8964
@stathistsamis8964 7 місяців тому
as a junior data analyst i found this video very useful keep going my friend!!!
@imadias1926
@imadias1926 2 місяці тому
Best INSTRUCTOR with the best English accent that we can easily understand and you never miss any step for running Python, even though I'm a beginner but now I know How to use python because of this video 😍, some tutorial they skip some step and even we try to follow their instructions but we got lost 😊😊😊Thank you Instructor ❤
@caessar_mando
@caessar_mando 2 роки тому
one of the best if not the best tutorial this channel has ever presented. Excellent job!
@sindiso_ndlovu
@sindiso_ndlovu 2 роки тому
No words can express how great your work is, thank you so much
@fififb8616
@fififb8616 2 роки тому
Very clear and concise instructions! Thank you very much!
@CodewithAby
@CodewithAby 2 роки тому
Great course, broken down like ABC. Thanks Frank
@michal.tomczyk
@michal.tomczyk 2 роки тому
Enjoyed every last second of it. Great job!
@ajitmagar1195
@ajitmagar1195 Рік тому
Nicely explained and step by step coverage of "whole" topic. ....Thank you Sir.
@m.e-ph8sy
@m.e-ph8sy 10 днів тому
Amazing content Frank.. How effortlessly you explained everything in the most simplistic way
@richardfinney2548
@richardfinney2548 2 роки тому
Brilliant tutorial! You are a very gifted presenter.
@culturapoliticaycomputador9999
@culturapoliticaycomputador9999 8 місяців тому
Thank you for share this! I recommend this video for everyone wants to learn some basics of python, numpy and pandas is awesome.
@nriezedichisom1676
@nriezedichisom1676 2 роки тому
This was a refresher course for me but notwithstanding, I learnt a whole lot.. Well done
@nriezedichisom1676
@nriezedichisom1676 2 роки тому
You are an excellent teacher but your UKposts channel has very little content. Can you upload more videos?
@thepycoachES
@thepycoachES 2 роки тому
@@nriezedichisom1676 Sure! More videos coming soon on my channel
@AmG895
@AmG895 Рік тому
Thank you 🙏 you have explained so well. Amazing video. Learned a lot!
@geekyprogrammer4831
@geekyprogrammer4831 2 роки тому
I already know Frank for writing exceptional technical articles! Good to see you here too 😁😁
@thepycoachES
@thepycoachES 2 роки тому
Nice meeting you on UKposts too! :)
@valentindumitru6648
@valentindumitru6648 Рік тому
very clear and simple explanations , thank you!
@youtubewzd2196
@youtubewzd2196 7 місяців тому
The course is really good but has a few caveats: 1. The Dataframe CSV for the short .pivot() method demonstration is not included. 2. The file gdp.csv is in Windows-1252 encoding in the zip file. This cannot be imported into a Dataframe without prior recoding into UTF-8. 3. The .pivot_table() example throws a FutureWarning. I had to list all features in values=['Quantity', 'Rating',...] to make it working. The problem comes from the attempt to sum non-numerical values. So only include columns with numerical values in values=[ ].
@ItsTheBookah
@ItsTheBookah 5 місяців тому
Thanks for the amazing tutorial Frank! For people getting the unicode error: df_gdp = pd.read_csv('gdp.csv', encoding='latin-1')
@abdala-in-tech
@abdala-in-tech 3 місяці тому
Thanks man!!
@leasunsun
@leasunsun Рік тому
Watched it during Chrismas Holiday. Enjoyed it and learned something new. Thank you!
@selcukdoven
@selcukdoven Рік тому
Thanks for basic and effective course and plus English sound is perfect 👍
@jmchisanga3
@jmchisanga3 9 місяців тому
I love this content it's well structured with lots of examples to make you understand and master it without any problem. 🇿🇲
@giantdutchviking
@giantdutchviking 8 місяців тому
Did you happen to run into issues making a line graph? I used the provided code in the tutorial but keep getting errors I need matplotlib.
@amadikechidera2613
@amadikechidera2613 7 місяців тому
Very nice course, you are truly blessed
@anthonynjoroge4641
@anthonynjoroge4641 2 роки тому
From Kenya much Appreciated - Asante Sana-
@InnovativeIdeas-mp7up
@InnovativeIdeas-mp7up 2 місяці тому
The presentation is engaging and makes it easy to follow the instructions.
@priyavarshanrg700
@priyavarshanrg700 5 місяців тому
This Channel deserves 100M Subscribers Hats Off You Guys👏👏👏
@MahmudYuldashev
@MahmudYuldashev Рік тому
Thank you so much. This is what I was looking for!
@Delianur
@Delianur 2 роки тому
Excellent... thanks you mr Frank Andrade
@Tlholo7
@Tlholo7 22 дні тому
Love it. Thanks a lot, Frank! 🎉
@DJ-ct6so
@DJ-ct6so 5 місяців тому
Excellent, very well explained. Very nice use of Jupyter notebooks. Many thanks for uploading.
@KingLiongWong
@KingLiongWong Рік тому
This is a very good course for me, help me a lot. Thank you very much.
@jasimmhj1526
@jasimmhj1526 7 місяців тому
Amazing deep learning. Thankyou
@timothyfleur7596
@timothyfleur7596 4 місяці тому
Thank you very much, this was very informative and explained in detail!
@kevinliew3916
@kevinliew3916 2 роки тому
Great introduction for everyday use!
@sesematactivities2024
@sesematactivities2024 Рік тому
THANKS FRANK, YOU MADE ME UNDERSTAND PANDAS
@mohamad5005
@mohamad5005 2 роки тому
Great and simple to mind tutorial
@elfridhasman4181
@elfridhasman4181 2 роки тому
Thank You Very Much, Much Much More❤️, Love From Indonesia
@user-kj4ni1rx4b
@user-kj4ni1rx4b 6 місяців тому
God bless you for this project, I learned a lot from it.
@rafimaulana8294
@rafimaulana8294 Рік тому
Definitely the best Python course for a data analyst who wants to level up from sql and excel only!!! Would recommend it!
@focus1007
@focus1007 Рік тому
Sir currently I am working in excel only..will this course help me in getting job? I mean is it sufficient to land a job as data analyst? Pls guide🙏
@rafimaulana8294
@rafimaulana8294 Рік тому
​@@focus1007 for an entry level actually a combination of sql+excel only is fine, but as you level up you'll eventually need Python/R. I was like that too at first.
@focus1007
@focus1007 Рік тому
@@rafimaulana8294 thankyou so much fr replying🙏...sir so acc to you ,can i start applying for data analyst with the knowledge of excel and SQL only? Or should i learn anything else also?
@rafimaulana8294
@rafimaulana8294 Рік тому
@@focus1007 Yes, but try learning any data viz either google data studio/tableau/power BI. This would make an extra bonus point and quite easy to learn.
@focus1007
@focus1007 Рік тому
@@rafimaulana8294 thankyou so much sir for replying..means a lot to me🙏
@ThinhLe-eh9re
@ThinhLe-eh9re 7 місяців тому
Thank you very much Frank ❤
@Aivanello
@Aivanello Рік тому
Thank you so much. This is a great course.
@seifaya3724
@seifaya3724 Рік тому
good job Frank .. really it's very interesting highly recommended
@user-jt4en7zg4c
@user-jt4en7zg4c 10 місяців тому
Thank you Frank, this is so useful
@belezaesaude1101
@belezaesaude1101 4 місяці тому
Estou muito feliz por ter me inscrito e ter acesso a este conteúdo.
@davidgitau8825
@davidgitau8825 5 місяців тому
Good learning here! The data should however be available for download to easily practice.
@arpanrastogi2844
@arpanrastogi2844 2 роки тому
Like the way you have explained the concepts - thanks Frank. Not sure if I missed out, but I could not find anything related to tuples between the timestamp <a href="#" class="seekto" data-time="39">0:39</a>:10 to <a href="#" class="seekto" data-time="81">1:21</a>:50. Is it explained later?
@ankurchanda1112
@ankurchanda1112 Рік тому
Conditional formatting is probably the most powerful feature of Excel. Would be tough to replicate these features (say highlighting duplicate values) in Python. Or no?
@TheAl217
@TheAl217 2 роки тому
Thank you for taking the time to create this course and sharing your knowledge with others. Just some constructive criticism here, based on my experience using Excel for many years. In my opinion people looking to move to pandas from Excel are serious users of this package. I didn't find content here that will make me think I really need to move away from Excel to gain this capability. Also Excel's PowerQuery has a lot of powerful transformation capabilities. Instead of doing the visualizations, people may have benefitted more from examples covering merge, groupby, stack, unstack, melt, resampling and even how list comprehensions can be used to add columns based on conditions.
@robertstahl8835
@robertstahl8835 2 роки тому
My thoughts as well
@cesarramos3569
@cesarramos3569 16 днів тому
Great video Frank!! regards from Peru
@victorgigreat1160
@victorgigreat1160 Рік тому
Frank that was excellent work.
@user-ok5sm5ff1o
@user-ok5sm5ff1o 11 місяців тому
Amazing course big thanks!
@bsnljkd
@bsnljkd 2 роки тому
Great Course! Thanks
@mrchuz0
@mrchuz0 2 роки тому
I didn't understand the use of the lambda function in the ordering section (<a href="#" class="seekto" data-time="189">3:09</a>:40), as you are trying to lower() the values but none of those are becoming lower. Could you explain deeper what failed there?
@princeademuwagun7870
@princeademuwagun7870 8 місяців тому
Extremely nice.... thank you.
@Dongnanjie
@Dongnanjie 4 місяці тому
Love it. Thank you so much!
@ladydi8712
@ladydi8712 2 роки тому
Thank you so much, looking for more data analyst course!! Im a noob helped so much👍
@rahul28thakur
@rahul28thakur 2 роки тому
Thank you Frank !!
@4-ck4wd
@4-ck4wd 6 днів тому
💯Exceptionally awesome video clip
@jhillyt
@jhillyt 2 роки тому
Great corse Frank! Thank you for sharing. I'm just about to the end and I'm getting error loading the gdp.csv? 'UnicodeDecodeError' Any advice on this? Thanks in advance... UPDATE: saved csv as excel and was able to parse the file.....
@muhdbasiirzulkifle5090
@muhdbasiirzulkifle5090 3 місяці тому
Thank you for your guidance 😃
@roywilson9580
@roywilson9580 6 місяців тому
Nice video intro to pandas. I only found one problem: In the section on pivot tables, I had to set the encoding to ANSI to read the gdp.csv file as it errored out using the default UTF-8 encoding.
@INTELLIGENCE_Revolution
@INTELLIGENCE_Revolution Рік тому
I was going to watch another video. But Frank’s voice was nicer to listen to 😂
@mahmoudalaref189
@mahmoudalaref189 2 роки тому
Great ❤️
@hannsflip
@hannsflip 2 роки тому
Great tutorial, was really explanatory, and really easy to catch up-
@Patrickus23
@Patrickus23 2 роки тому
I love your content! Can you do a tutorial for using Redux arhitecture in Fluttter or can you tell me some resources to learn this arhitecture?
@arionrares7764
@arionrares7764 2 роки тому
Is this only for Excel or any other program like the one from LibreO?
@michelfilipebr
@michelfilipebr 6 місяців тому
Excellent course! Help me to come through. :)
@keithmason1485
@keithmason1485 8 місяців тому
With the new Excel Python integration can everything in this course be done directly in Excel now?
@boom78
@boom78 2 роки тому
Questions: does Jupyter Notebook have a feature to show the cursor horizontal location? PEP 8 says to limit lines to 79 characters, but I cannot tell where this is. Also, it the common style to put spaces in-between operators but not when including function arguments?
@nomad_grant
@nomad_grant 3 місяці тому
cheat sheet is no longer available through the link :( any chance you have an alternative download link for that? It looked very helpful! Fantastic video by the way. The pace was perfect for me!
@benjaminphilips3737
@benjaminphilips3737 2 роки тому
Best python tutorial at least for me
@ici6308
@ici6308 9 місяців тому
Wonderful tuto. Very well explained !
@md.moniruzzaman7944
@md.moniruzzaman7944 Рік тому
execellent tutorial for a beginner
@pfz5487
@pfz5487 2 роки тому
thanks you it's a very good course
@william1000
@william1000 Рік тому
Great video thanks for posting
@Al-Ahdal
@Al-Ahdal Рік тому
For example we have 10 rows of values that is random numbers and in columns, we have col1, col2, col3, col4. I need to pick the minimum row wise value first, and then pick out name of the column header for all the series, how can we do it in Python???? I know how to do it in Excel, we can do it by MATCH and INDEX functions in Excel, but how can we do it in Python, once data is read in Python. Product/Supplier Supplier 1 Supplier 2 Supplier 3 Supplier 4 Supplier 5 Supplier 6 Supplier 7 Product 1 57.97 72.20 39.01 60.33 71.40 72.82 60.93 Product 2 51.67 29.87 52.23 48.34 51.37 52.58 51.64
@Energy_with_Majd
@Energy_with_Majd Рік тому
Very helpful thank you 🙏
@Behappytruthfully
@Behappytruthfully 2 роки тому
Thanks. I am trying to learn at 55😊
@rockymani94
@rockymani94 2 роки тому
It good for beginners, if you add all sql operation like groupby , merge, fill and etc
@dynamictechnocrat
@dynamictechnocrat 2 роки тому
In pandas right
@rockymani94
@rockymani94 2 роки тому
Yeah pandas
@dynamictechnocrat
@dynamictechnocrat 2 роки тому
@@rockymani94 the object oriented technique in matplotlib is still confusing me ...
@rockymani94
@rockymani94 2 роки тому
@@dynamictechnocrat let me share you the right tutorials for that
@dynamictechnocrat
@dynamictechnocrat 2 роки тому
@@rockymani94 thanks dear
@georgejachvliani2288
@georgejachvliani2288 Рік тому
Very good tutorial .Thank you
@kunalrath5352
@kunalrath5352 Рік тому
In the section on reading a csv file to create a Dataframe, the syntax used by you, i.e df_exams = pd.read_csv('file_name.csv') doesn't execute as the file local directory is gonna be whole different as when tried in different PC local systems. Instead we can try using df_exams = pd.read_csv(r"file_name.csv") This syntax works perfectly.
@tical_fm
@tical_fm Рік тому
You're right, i also used the second option.
@vignesh28kk
@vignesh28kk Рік тому
i tried both the medthod, its not working
@vignesh28kk
@vignesh28kk Рік тому
Do we need to include the path of that csv file?
@tical_fm
@tical_fm Рік тому
@@vignesh28kk I copied the path of the file
@georgelam1878
@georgelam1878 Рік тому
could someone advise where to download "StudentsPerformance.csv" file used in the course
@kocengineering769
@kocengineering769 2 роки тому
Thanks needed
@F13TUN
@F13TUN 2 роки тому
Perfect Thanks شكرا
Object Oriented Programming with Python - Full Course for Beginners
2:12:35
freeCodeCamp.org
Переглядів 1,6 млн
Nonomen funny video😂😂😂 #magic
00:29
Nonomen ノノメン
Переглядів 62 млн
I PUT MY ARMOR ON (Creeper) (PG Version)
00:19
Sam Green
Переглядів 4 млн
😱СНЯЛ ФИКСИКОВ НА КАМЕРУ‼️
00:35
OMG DEN
Переглядів 898 тис.
Exploratory Data Analysis with Pandas Python
40:22
Rob Mulla
Переглядів 402 тис.
Python for Beginners - Learn Python in 1 Hour
1:00:06
Programming with Mosh
Переглядів 16 млн
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Переглядів 712 тис.
Data Analytics vs Data Science
6:30
IBM Technology
Переглядів 290 тис.
Software Engineering Job Interview - Full Mock Interview
1:14:29
freeCodeCamp.org
Переглядів 1,2 млн
How I use Python as a Data Analyst
13:56
Luke Barousse
Переглядів 336 тис.
Python Machine Learning Tutorial (Data Science)
49:43
Programming with Mosh
Переглядів 2,7 млн
A Day in the Life of a Data Analyst (2023)
13:34
CareerFoundry
Переглядів 372 тис.
Machine Learning for Everybody - Full Course
3:53:53
freeCodeCamp.org
Переглядів 4,9 млн
Introducing Python in Excel 😱
19:01
Leila Gharani
Переглядів 1,4 млн
Nonomen funny video😂😂😂 #magic
00:29
Nonomen ノノメン
Переглядів 62 млн