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: github.com/ifrankandrade/pyth...
🔗 Datasets: drive.google.com/drive/folder...
✏️ Course developed by Frank Andrade.
🔗 KZread 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

Пікірлер: 370

  • @quincylarsonmusic
    @quincylarsonmusic2 жыл бұрын

    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

  • @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

  • @mrCetus
    @mrCetus2 жыл бұрын

    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 :)

  • @malwalsabino519
    @malwalsabino5197 ай бұрын

    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.

  • @victoriabraimoh8994
    @victoriabraimoh8994 Жыл бұрын

    Frank went all out with this course. perfect beginner course. hope we all make you proud

  • @mansasow
    @mansasow2 жыл бұрын

    Thanks for this tutorial! It would have also been nice to show how to concatenate or merge multiples data frames (inner, left, right join).

  • @marcoventura9451
    @marcoventura9451 Жыл бұрын

    A very good begginer's course; it covers the basics of Python with Juipter Notebook IDE in a simple and understable way.

  • @dondata718
    @dondata718 Жыл бұрын

    Just finished this video. It is my first introduction to python and you did an excellent job. I appreciate this 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!!

  • @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 !!

  • @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!

  • @jessicaliu8885
    @jessicaliu8885 Жыл бұрын

    Great course! Thank you so much! Spent a half day finishing the course. Very Helpful!

  • @gimiemini3034
    @gimiemini303410 ай бұрын

    I have just finished this. Love it. So easy to follow and Frank was amazing. best video so far.

  • @swagat457
    @swagat4572 жыл бұрын

    Amazing content Frank.. How effortlessly you explained everything in the most simplistic way.. Thank you

  • @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
    @tim641632 жыл бұрын

    Fantastically explained, thank you so much. Clear, easy to understand and shows some good examples.

  • @usuis8541

    @usuis8541

    7 ай бұрын

    GENSHIN PREACH

  • @fififb8616
    @fififb86162 жыл бұрын

    Very clear and concise instructions! Thank you very much!

  • @dimasjimenez3396
    @dimasjimenez33962 жыл бұрын

    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.

  • @stathistsamis8964
    @stathistsamis89647 ай бұрын

    as a junior data analyst i found this video very useful keep going my friend!!!

  • @richardfinney2548
    @richardfinney25482 жыл бұрын

    Brilliant tutorial! You are a very gifted presenter.

  • @CodewithAby
    @CodewithAby2 жыл бұрын

    Great course, broken down like ABC. Thanks Frank

  • @caessar_mando
    @caessar_mando2 жыл бұрын

    one of the best if not the best tutorial this channel has ever presented. Excellent job!

  • @ajitmagar1195
    @ajitmagar1195 Жыл бұрын

    Nicely explained and step by step coverage of "whole" topic. ....Thank you Sir.

  • @lcastellanosm
    @lcastellanosm2 жыл бұрын

    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

  • @michal.tomczyk
    @michal.tomczyk2 жыл бұрын

    Enjoyed every last second of it. Great job!

  • @imadias1926
    @imadias19262 ай бұрын

    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 ❤

  • @AmG895
    @AmG895 Жыл бұрын

    Thank you 🙏 you have explained so well. Amazing video. Learned a lot!

  • @anthonynjoroge4641
    @anthonynjoroge46412 жыл бұрын

    From Kenya much Appreciated - Asante Sana-

  • @youtubewzd2196
    @youtubewzd21967 ай бұрын

    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=[ ].

  • @valentindumitru6648
    @valentindumitru6648 Жыл бұрын

    very clear and simple explanations , thank you!

  • @culturapoliticaycomputador9999
    @culturapoliticaycomputador99998 ай бұрын

    Thank you for share this! I recommend this video for everyone wants to learn some basics of python, numpy and pandas is awesome.

  • @amadikechidera2613
    @amadikechidera26137 ай бұрын

    Very nice course, you are truly blessed

  • @m.e-ph8sy
    @m.e-ph8sy13 күн бұрын

    Amazing content Frank.. How effortlessly you explained everything in the most simplistic way

  • @priyavarshanrg700
    @priyavarshanrg7005 ай бұрын

    This Channel deserves 100M Subscribers Hats Off You Guys👏👏👏

  • @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🙏

  • @nriezedichisom1676
    @nriezedichisom16762 жыл бұрын

    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 KZread channel has very little content. Can you upload more videos?

  • @thepycoachES

    @thepycoachES

    2 жыл бұрын

    @@nriezedichisom1676 Sure! More videos coming soon on my channel

  • @InnovativeIdeas-mp7up
    @InnovativeIdeas-mp7up2 ай бұрын

    The presentation is engaging and makes it easy to follow the instructions.

  • @geekyprogrammer4831
    @geekyprogrammer48312 жыл бұрын

    I already know Frank for writing exceptional technical articles! Good to see you here too 😁😁

  • @thepycoachES

    @thepycoachES

    2 жыл бұрын

    Nice meeting you on KZread too! :)

  • @sindiso_ndlovu
    @sindiso_ndlovu2 жыл бұрын

    No words can express how great your work is, thank you so much

  • @selcukdoven
    @selcukdoven Жыл бұрын

    Thanks for basic and effective course and plus English sound is perfect 👍

  • @mohamad5005
    @mohamad50052 жыл бұрын

    Great and simple to mind tutorial

  • @Delianur
    @Delianur2 жыл бұрын

    Excellent... thanks you mr Frank Andrade

  • @leasunsun
    @leasunsun Жыл бұрын

    Watched it during Chrismas Holiday. Enjoyed it and learned something new. Thank you!

  • @jmchisanga3
    @jmchisanga39 ай бұрын

    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.

  • @jasimmhj1526
    @jasimmhj15267 ай бұрын

    Amazing deep learning. Thankyou

  • @ItsTheBookah
    @ItsTheBookah5 ай бұрын

    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!!

  • @kevinliew3916
    @kevinliew39162 жыл бұрын

    Great introduction for everyday use!

  • @KingLiongWong
    @KingLiongWong Жыл бұрын

    This is a very good course for me, help me a lot. Thank you very much.

  • @user-kj4ni1rx4b
    @user-kj4ni1rx4b6 ай бұрын

    God bless you for this project, I learned a lot from it.

  • @sesematactivities2024
    @sesematactivities2024 Жыл бұрын

    THANKS FRANK, YOU MADE ME UNDERSTAND PANDAS

  • @DJ-ct6so
    @DJ-ct6so5 ай бұрын

    Excellent, very well explained. Very nice use of Jupyter notebooks. Many thanks for uploading.

  • @elfridhasman4181
    @elfridhasman41812 жыл бұрын

    Thank You Very Much, Much Much More❤️, Love From Indonesia

  • @Tradewithsimpleminded
    @Tradewithsimpleminded2 жыл бұрын

    Don't know where you watching this from my brother but I wished you all the best in life ❤️❤️

  • @MahmudYuldashev
    @MahmudYuldashev Жыл бұрын

    Thank you so much. This is what I was looking for!

  • @ThinhLe-eh9re
    @ThinhLe-eh9re7 ай бұрын

    Thank you very much Frank ❤

  • @belezaesaude1101
    @belezaesaude11014 ай бұрын

    Estou muito feliz por ter me inscrito e ter acesso a este conteúdo.

  • @seifaya3724
    @seifaya3724 Жыл бұрын

    good job Frank .. really it's very interesting highly recommended

  • @Aivanello
    @Aivanello Жыл бұрын

    Thank you so much. This is a great course.

  • @timothyfleur7596
    @timothyfleur75964 ай бұрын

    Thank you very much, this was very informative and explained in detail!

  • @TheAl217
    @TheAl2172 жыл бұрын

    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

  • @Tlholo7
    @Tlholo725 күн бұрын

    Love it. Thanks a lot, Frank! 🎉

  • @bsnljkd
    @bsnljkd2 жыл бұрын

    Great Course! Thanks

  • @F13TUN
    @F13TUN2 жыл бұрын

    Perfect Thanks شكرا

  • @davidgitau8825
    @davidgitau88255 ай бұрын

    Good learning here! The data should however be available for download to easily practice.

  • @user-jt4en7zg4c
    @user-jt4en7zg4c10 ай бұрын

    Thank you Frank, this is so useful

  • @user-ok5sm5ff1o
    @user-ok5sm5ff1o11 ай бұрын

    Amazing course big thanks!

  • @ici6308
    @ici63089 ай бұрын

    Wonderful tuto. Very well explained !

  • @victorgigreat1160
    @victorgigreat1160 Жыл бұрын

    Frank that was excellent work.

  • @princeademuwagun7870
    @princeademuwagun78708 ай бұрын

    Extremely nice.... thank you.

  • @cesarramos3569
    @cesarramos356918 күн бұрын

    Great video Frank!! regards from Peru

  • @rahul28thakur
    @rahul28thakur2 жыл бұрын

    Thank you Frank !!

  • @mrchuz0
    @mrchuz02 жыл бұрын

    I didn't understand the use of the lambda function in the ordering section (3:09:40), as you are trying to lower() the values but none of those are becoming lower. Could you explain deeper what failed there?

  • @muhdbasiirzulkifle5090
    @muhdbasiirzulkifle50904 ай бұрын

    Thank you for your guidance 😃

  • @Energy_with_Majd
    @Energy_with_Majd Жыл бұрын

    Very helpful thank you 🙏

  • @keithmason1485
    @keithmason14858 ай бұрын

    With the new Excel Python integration can everything in this course be done directly in Excel now?

  • @benjaminphilips3737
    @benjaminphilips37372 жыл бұрын

    Best python tutorial at least for me

  • @mayflower9562
    @mayflower95622 жыл бұрын

    THANK YOU!

  • @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?

  • @bensl3308
    @bensl33086 ай бұрын

    3:23:26 df_sales.pivot_table(index="Gender",aggfunc="sum") TypeError: datetime64 type does not support sum operations What to do ?

  • @bensl3308

    @bensl3308

    6 ай бұрын

    The only thing, that works for me! df_sales.groupby("Gender").sum(numeric_only=True)

  • @md.moniruzzaman7944
    @md.moniruzzaman7944 Жыл бұрын

    execellent tutorial for a beginner

  • @Dongnanjie
    @Dongnanjie4 ай бұрын

    Love it. Thank you so much!

  • @william1000
    @william1000 Жыл бұрын

    Great video thanks for posting

  • @arpanrastogi2844
    @arpanrastogi28442 жыл бұрын

    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 0:39:10 to 1:21:50. Is it explained later?

  • @georgejachvliani2288
    @georgejachvliani2288 Жыл бұрын

    Very good tutorial .Thank you

  • @saplay3372
    @saplay33722 жыл бұрын

    Great job sir

  • @pfz5487
    @pfz54872 жыл бұрын

    thanks you it's a very good course

  • @kocengineering769
    @kocengineering7692 жыл бұрын

    Thanks needed

  • @jhillyt
    @jhillyt2 жыл бұрын

    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.....

  • @hannsflip
    @hannsflip2 жыл бұрын

    Great tutorial, was really explanatory, and really easy to catch up-

  • @arionrares7764
    @arionrares77642 жыл бұрын

    Is this only for Excel or any other program like the one from LibreO?

  • @mahmoudalaref189
    @mahmoudalaref1892 жыл бұрын

    Great ❤️

  • @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

  • @boom78
    @boom782 жыл бұрын

    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?

  • @jimisonnjaravani7593
    @jimisonnjaravani7593 Жыл бұрын

    Awesome, Thank you

  • @frostyfreezemovies
    @frostyfreezemovies2 жыл бұрын

    Awsm ❤️

  • @INTELLIGENCE_Revolution
    @INTELLIGENCE_Revolution Жыл бұрын

    I was going to watch another video. But Frank’s voice was nicer to listen to 😂

  • @michelfilipebr
    @michelfilipebr6 ай бұрын

    Excellent course! Help me to come through. :)

  • @Patrickus23
    @Patrickus232 жыл бұрын

    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?

  • @WisamMSaeed
    @WisamMSaeed10 ай бұрын

    Thank you , useful course

  • @4-ck4wd
    @4-ck4wd8 күн бұрын

    💯Exceptionally awesome video clip

Келесі