LEARN PANDAS in about 10 minutes! A great python module for Data Science!

Поділитися
Вставка
  • Опубліковано 8 лип 2024
  • This python pandas tutorial is taken from the lectures.quantecon.org/py/ pandas tutorial.
    Pandas is an excellent python module. It is designed for cleaning and analysing data. In this tutorial I show you how to use it.
    3 Data Science Learning Platforms I would recommend
    1. Data Quest - bit.ly/3hcLjbY (my favourite)
    2 Data Camp - bit.ly/39erDk8
    3 365 Data Science - bit.ly/3hbUHdd
    2 Recommended Python Courses
    1. Exploratory Data Analysis with Python and Pandas - bit.ly/2QXMpxJ
    2. Complete Python Programmer Bootcamp - bit.ly/2OwUA09
    Data Science Interview Preparation
    StrataScratch bit.ly/30ul0nX
    (These contain affiliate links, which means I receive a percentage of any sales made. There is no additional cost for anybody clicking on them)
    For the links from the tutorial go to my facebook page.
    / 2022022968091206
    Recommended books in my Amazon store www.amazon.com/shop/pythonpro...

КОМЕНТАРІ • 156

  • @ericptaylor10
    @ericptaylor10 4 роки тому +295

    This is just 10 minutes of him telling you to read the manual.

    • @abdellatifsbaiti9376
      @abdellatifsbaiti9376 4 роки тому +7

      Eric Taylor the good habits are part of the teachings I guess

    • @thePronto
      @thePronto 4 роки тому +17

      Teach a man to fish, instead of giving him a fish. I came here for the 10 minute overview...the rest of my time will be split between digging into the manual and writing code. But, I guess you're right: some people want to be spoon-fed...

    • @vinea9322
      @vinea9322 3 роки тому +25

      @@thePronto this is more like just telling a man to go fish with a fishing rod. Not teaching him how to fish!!

    • @punkisinthedetails1470
      @punkisinthedetails1470 3 роки тому +1

      @@vinea9322 that's Phishing

    • @punkisinthedetails1470
      @punkisinthedetails1470 3 роки тому +1

      Teach a man to Phish

  • @loucadufault6549
    @loucadufault6549 2 роки тому +70

    Tutorial starts at 3:16

  • @alpacapaca21
    @alpacapaca21 4 роки тому +81

    You seem like the kind of person who can teach someone something without making them feel stupid. Thanks for the video. It helped me with school:)

    • @gilesmcmullen
      @gilesmcmullen  4 роки тому +31

      Thank you, glad it helped. It's only bad teachers that make you feel stupid. Good teachers make you realise you can learn anything. And you can.

    • @aanchalsharma8481
      @aanchalsharma8481 2 роки тому +1

      ahh bts army ?

  • @renk.574
    @renk.574 2 роки тому +4

    Not to make it weird but I absolutely adore you and your videos. I have learned so much!!

  • @ameliac504
    @ameliac504 2 роки тому

    I fell in love with the channel after the first few seconds of this video! Excellent personality!

  • @davidweeks6090
    @davidweeks6090 5 років тому +18

    I’m just here for the, “ I watched a 10 minute video and I’m not an expert” comments. 🤣🤣🤣

  • @TheMasterfulcreator
    @TheMasterfulcreator 5 років тому +15

    Honestly I kind of like writing the code that cleans my data. It's very satisfying when I can build a nice sklearn pipeline that does everything I need. Sometimes that's not possible though. Or I'm not good enough.

  • @AlDenteFoSho
    @AlDenteFoSho 5 років тому +8

    Great job as always. Thanks for a brief explanation!

  • @NiccoloHamlin
    @NiccoloHamlin 5 років тому +4

    I've been using Pandas, Dask, SQL, and Scala for all sorts of data processing. Enjoyed the video cause I loved the relaxed and conversational manner in which you presented this tutorial. And I saw tea and nice lighting in the autoplay. Good stuff.

  • @alvarotoro6333
    @alvarotoro6333 5 років тому +11

    Thanks for the video, I found the info pretty interesting.
    Keep up with the good work.

  • @druestaples3044
    @druestaples3044 5 років тому +9

    I love your quick and easy tutorials!! Clear sound quality too👍

  • @yesubabutibirisetti8615
    @yesubabutibirisetti8615 5 років тому +9

    Good explanation. Expecting more from you in Datascience and Python

  • @roselinekolony2470
    @roselinekolony2470 11 місяців тому +6

    Hi there, I clicked on the link at it says page not found

  • @dair919
    @dair919 4 роки тому +3

    What benefits does Pandas have over tools like Tableau, SSRS/Power BI?

  • @sitinabilah6431
    @sitinabilah6431 5 років тому +6

    Thank you so much! Love your videos. I love panda, and always on the look out for more tutorials and projects to practise my panda skill.

  • @kunalr_ai
    @kunalr_ai 5 років тому +3

    Thanks for the video...treat to watch

  • @kathik595
    @kathik595 5 років тому +5

    So easily explained and language is so simple and understanding.

  • @tasnimislam8321
    @tasnimislam8321 4 роки тому +1

    Thanks Gill, for making excellent videos. Could you please tell where may I find the documentation?

  • @mohammadsafiuddin3614
    @mohammadsafiuddin3614 5 років тому +3

    Great video ! Thanka a lot!

  • @tfxobrien
    @tfxobrien 3 роки тому

    Love your videos but was especially excited when I saw the inside of your tea cup. I'm guessing a one-handed backhand.

  • @afifkhaja
    @afifkhaja Рік тому

    Short and sweet tutorial. Thanks

  • @Rob-nb6zi
    @Rob-nb6zi 4 місяці тому +1

    I have a suggestion - make a video describing how to use the documentation efficiently. I am a relatively new programmer, and it's a struggle for me to understand how to use methods and whatnot properly. An example would be the read_csv method and its associated documentation, shown at 8:04 in the video. Surely there must be a method to understand methods?

  • @jjjjjjjjjjjjjjjjjjjjjjjjjjjjj0
    @jjjjjjjjjjjjjjjjjjjjjjjjjjjjj0 5 років тому +7

    your tea kettle sounds just blew out my ear drums man gdi

  • @TrueIndian
    @TrueIndian 5 років тому +2

    great way to learn with the docs and tutorial. You get used to of the documentation and you can search for the relavate information in the docs

  • @timohelasvuo9650
    @timohelasvuo9650 4 роки тому +1

    Thanks for this.. iloc was something I just couldn't figure out last night.. life easier again... and yea read documentation seems to ge a great idea :D

  • @GoryWory
    @GoryWory 3 роки тому +16

    I really appreciate the intro - we definitely need to have more cozy atmosphere in programing tutorials

  • @training7574
    @training7574 3 місяці тому

    Very useful with the emphasis on documentation, thanks. Many instructions are far too action oriented, which triggers bad learning habits. Better read, think and do instead of beginning with doing - it saves you lots of time. (Also it saves lots of text book costs!)

  • @tejas8211
    @tejas8211 4 роки тому

    As an Indian I am happy to find out that tutorialspoint website is user by foreigner as well.

  • @mdtonmoyhossainjifat9117
    @mdtonmoyhossainjifat9117 3 роки тому

    random guy makes a playlist on pandas
    derek banas makes one video that is 2 hour long
    then comes this legend with a 10 min video

  • @kaushik5014
    @kaushik5014 5 років тому +2

    Love to see your channel grow!

  • @deepakshreevastav1563
    @deepakshreevastav1563 5 років тому +1

    Hello Sir, I am willing to become a data scientist and I am thinking of getting enrolled into one of the courses from different learning website such as Coursera,edx etc. I found Dataquest more interesting as compared to other side may I know is Dataquest is worth and if I follow data quest( data science) track where I will reach by end of the course ?

  • @rashilalamichhane9750
    @rashilalamichhane9750 2 роки тому

    Hey, thank you for your effort. Great job.

  • @SergioArroyoSailing
    @SergioArroyoSailing 3 роки тому +1

    great video! 30,000 foot overview with dips into code for the most popular features. can we get links to those articles you mentioned in the beginning?

  • @alexmusikkanal
    @alexmusikkanal 4 роки тому +5

    Coming from R it seems the author of Pandas just translated the R data.frame to Python. I guess good for me. Don't have to learn much new ;)

  • @vatsdimri3675
    @vatsdimri3675 4 роки тому

    great introductins. thanks

  • @gurudaki
    @gurudaki 5 років тому

    Any recommendations for online courses or methods to learn efficiently keras???

  • @africadeclassified
    @africadeclassified Рік тому

    Thank you so much!!

  • @canylmaz2461
    @canylmaz2461 3 роки тому

    Great video recording and editing

  • @87ricr
    @87ricr Рік тому

    Thanks for the info 🙏🙌👍👌

  • @kkdancer999
    @kkdancer999 5 років тому +1

    more pandas videos please!

  • @aslam1785
    @aslam1785 4 роки тому

    Please advise From where I can download this tutorial

  • @EdwardSileo
    @EdwardSileo 3 роки тому

    Great. Sometime show how to roll up or aggregate with Pandas.

  • @dhruvshetty2127
    @dhruvshetty2127 5 років тому

    hey where do I learn how to clean REAL WORLD datasets online comprehensively?I am not interested in kaggle kinda stérile datasets.

  • @eladzbir
    @eladzbir 3 роки тому

    Question. After I've downloaded the panda feature using " Anaconda", I want to uplaed CSV file to the pyton-panda program and can't. where is my problam? the CSV file should be under the same windows folder? and if so, what is this windows folder name?

    • @stevegross9617
      @stevegross9617 3 роки тому

      Have you figured it out? You’ll need to change your directory or move your csv to your current directory.

  • @zimmerhu
    @zimmerhu 4 роки тому +1

    Thanks for the video. It does point out where the VIPs are, saves my learning curve.

  • @AlidelOro
    @AlidelOro 2 роки тому +1

    Can you please share a link where you have done these functions: .loc,.iloc,.drop,.append,.groupby?
    I am struggling a bit with the syntax and use of arguements within those brackets. Thanks in advance :)

  • @YisraelDovL
    @YisraelDovL 5 років тому +15

    Most important take away from this video: RTFM!

  • @aadesh5401
    @aadesh5401 3 роки тому

    Watching it in 2x so I learning it in 5 mins. Big brains

  • @aleksandarbieber1841
    @aleksandarbieber1841 3 роки тому

    How did you open this pandas_tutorial .ipynb ?? Please help

  • @Robay146
    @Robay146 2 роки тому

    Those cut scenes funny af. 😁

  • @ScriptureFirst
    @ScriptureFirst 2 роки тому +1

    3:18 Action starts

  • @CaribouDataScience
    @CaribouDataScience 2 роки тому

    The link above is broken??

  • @laumfreeman9704
    @laumfreeman9704 5 років тому +2

    Maybe taking out the super loud sound of your kettle will be great 🤣 with headphones on is disturbing 🤣 otherwise i love your videos 🥳👌🏻

  • @DASUSIDDHARTHRA
    @DASUSIDDHARTHRA 2 роки тому

    is the quantecon link working?

  • @MrD215
    @MrD215 3 роки тому +1

    I like the way he pronounce Chutorial. LOL...

  • @monaxDme
    @monaxDme 5 років тому +1

    Anyone counted how often he says something about reading the documentation? :P

  • @kevinayers7144
    @kevinayers7144 5 років тому +2

    What are your thoughts on the recent articles highlighting that there’s to many people trying to become data scientists?

    • @BiancaAguglia
      @BiancaAguglia 5 років тому +1

      I think that it's good for everyone to know at least the basics of data science. The same way that learning the fundamentals of language, math, physics, biology, history, philosophy and so on can help you better understand the world and its people 😊, learning the fundamentals of coding and data science can help you understand the logic behind using computers and machine learning.
      Contrary to what many people think, I don't believe AI and automation will make us jobless. I think we'll have different jobs and data science will be one of the skills needed to do those jobs well. Plus, data science is fascinating. You could learn it just for the fun of it. 😊

    • @miguelcastillo1742
      @miguelcastillo1742 5 років тому

      Can you give the sources?

    • @BiancaAguglia
      @BiancaAguglia 5 років тому

      @@miguelcastillo1742 Do you mean resources for learning data science? If yes, Siraj Raval has a UA-cam video called "Learn data science in three months." In its description you'll find links to a good, doable plan for learning the basics of data science. It's a good start. 😊

    • @kevinayers7144
      @kevinayers7144 5 років тому +1

      @@BiancaAguglia I'm definitely learning it for fun. Currently working on a masters in computation analytics and love it. Just a little concerned about recent articles stating there's a glut of applicants. You're correct though these skills will still be valuable no matter what.

    • @michaelnurse9089
      @michaelnurse9089 5 років тому +1

      @@kevinayers7144 It can't be true because data scientist is the number 2 in demand/paying job for 2018, just after ML engineer. If 4th industrial revolution is real every single business has to learn DS and ML or be swept away by automated competition.

  • @Playstation_plus_ps
    @Playstation_plus_ps 5 років тому +1

    Hello! I am a beginner in data scientist so please tell me about the resource where I can learn eda to produce insights on the variables to prepare my data well.

  • @gingerkitty6380
    @gingerkitty6380 3 роки тому

    I would love to follow along but facebook is banned in my country. Is there another way i can see those links?

  • @billyyank2198
    @billyyank2198 Рік тому +1

    So what you're saying is, I need to read the documentation.

  • @sebastianmuller1210
    @sebastianmuller1210 5 років тому +1

    I would call the video: What is pandas (for)? Not "learn it".
    For learning it neede to go just a little deeper, more like the numpy version.

  • @murphygreen8484
    @murphygreen8484 4 роки тому

    How/why does multiplying it by le3 = the same as multiplying by 1000?

  • @NealeSamways
    @NealeSamways 3 роки тому

    What a refreshingly good video! Was just at the right level, without irrelevant self-important waffle - or the almost omnipotent self-promoting a-la "Please smash the like button, hit the notification bell, subscribe for more content, it really helps my channel / it helps me able to create more videos [...]". IMHO an excellent 10 min intro, which has made me more excited about working with PANDAS.

  • @hayathbasha4519
    @hayathbasha4519 3 роки тому

    Hi,
    Is it possible to convert below the input
    Customer_Name,Product_1,Price_1,Product_2,Price_2
    Zayn,Milk,30,Chocolate,40
    Peter,Cheese,190,Oil,80
    Andrew,Coconut,10,Milk,60
    Dwayne,Soya,100,Butter,120
    to this output where the Product name should be ascending and it should also have its price in the next column
    Customer_Name,Product_1,Price_1,Product_2,Price_2
    Zayn,Chocolate,40,Milk,30
    Peter,Cheese,190,Oil,80
    Andrew,Coconut,10,Milk,60
    Dwayne,Butter,120,Soya,100
    Can you please help

  • @knmfujiwara
    @knmfujiwara 4 роки тому

    Without context, it felt like listening to talks about pandas.

  • @josepha8415
    @josepha8415 5 років тому

    Is knowing differential equations important of data science

    • @BigJohn4516
      @BigJohn4516 5 років тому

      Joseph A , as with any question in such a broad field, the answer is “it depends”. Most likely, you will not use ordinary or partial differential equations in data science. However, if you are working with physical data, then you may. For instance, in pharmacology, having those tools as a basis for models is important. That said, there are far more applications of data science in which knowledge of systems of differential equations is not necessary.
      If you’re interested, One Blue Three Brown has a series of very intuitive videos on differential equations as well as vector algebra.

  • @maxbart1353
    @maxbart1353 4 роки тому

    thanks a lot

  • @cloudguru3018
    @cloudguru3018 Рік тому

    I hate tea! But I love Python. :)

  • @michaelnurse9089
    @michaelnurse9089 5 років тому +2

    You really need to equalise the sound level across the video. The 'other guy' sounds far away and echo-y.

  • @victorlucas6692
    @victorlucas6692 2 роки тому

    learning people how to fish not giving the fish directly, good job

  • @miguelcastillo1742
    @miguelcastillo1742 5 років тому +2

    Do I need a big knowledge in Data Science in order to learn ML or do I just need the fundamentals?

    • @michaelnurse9089
      @michaelnurse9089 5 років тому +2

      I am not an expert, but let me explain the little I know. ML is data science automated. When a company builds a ML product they automate what the data scientists have already done. So the the real design of the ML intelligence comes from the data scientist's work. The ML expert's job is automate that just like a programmer automates a spreadsheet that an accountant is preparing each month manually. At the end of the day a commercial ML product like Alexa has 3000 people working on it, and the MLE, DSE and SE designations start to blur fast into hundreds of different sub tasks. So it depends on where you want to get to. Entry level ML assistant in a team of 20 - basics only. Head engineer of ML at Amazon - super advanced.

  • @kengiiyeonnetidol6924
    @kengiiyeonnetidol6924 3 роки тому +1

    It takes me for years to start learning Python because I always think it’s sth hard....

  • @OEFarredondo
    @OEFarredondo 5 років тому +1

    Oh cooking crack? Tea. It’s just Tea...

  • @NawtieBoy96
    @NawtieBoy96 3 роки тому

    tutorial link doesn't work :(

  • @ramkoduri9907
    @ramkoduri9907 4 роки тому

    where is the documentation???

  • @ebezgin
    @ebezgin 4 роки тому

    The most of the logical one is that starting somewhere
    to learn immediately..

  • @cozmos1553
    @cozmos1553 2 роки тому

    Tabs please?..

  • @richardfan8055
    @richardfan8055 2 роки тому

    what 's the website at 4:36?

  • @joem8251
    @joem8251 3 роки тому

    The only thing he failed to mention is that you have to read the documentation.

  • @pony6061
    @pony6061 11 місяців тому

    But why use pandas instead of just using Excel? Excel can perform similar calculations in same amount of time....

  • @kruthikreddy7326
    @kruthikreddy7326 5 років тому +10

    jump to 3:18 for tutorial !I LOVE LIKES

  • @user-mi6pq2uu9s
    @user-mi6pq2uu9s 4 роки тому

    Haha you are one of a kind man, stay strange lol

  • @rohitchabukswar7266
    @rohitchabukswar7266 3 роки тому

    I wanted to give a like but at the same time dislikes were at 68, so i had to contribute there.

  • @Dave-nz5jf
    @Dave-nz5jf 4 роки тому

    Who thinks starting the title of their youtube video "Conquer Pandas" was a good idea.

  • @basit005
    @basit005 5 років тому +2

    Giles are you a prof? I don't mean disrespect, you remind me of my better profs

  • @sudarshankadam42
    @sudarshankadam42 5 років тому

    I paused this video to comment: Please stop with inserts of your hands on keyboard or a shot over the shoulder when you are talking business. I personally find it distracting. Of course just my opinion. Thank you for making so many useful videos, always appreciated.

  • @MachineLearningPro
    @MachineLearningPro 7 місяців тому

    Great video! Take a look at my Pandas tutorial if you want.

  • @user-fk8wl4uk7b
    @user-fk8wl4uk7b 6 днів тому +1

    Jesus christ bless you 😊😊😊😊 from Egypt ❤❤❤❤

  • @maybenew7293
    @maybenew7293 Рік тому

    great video.. but LEARN in the video a bit too much innit?

  • @FBR2169
    @FBR2169 2 роки тому

    safe your time. starts at 3:15

  • @Joel-vq3ch
    @Joel-vq3ch 3 роки тому

    Oh shit, i came here looking to find out the animal

  • @maxbart1353
    @maxbart1353 4 роки тому

    wenn es nur so einfach wäre

  • @shaxzod6485
    @shaxzod6485 4 роки тому

    best

  • @soykanilhan8349
    @soykanilhan8349 27 днів тому

    Turkish subtitles please

  • @nomadhomad3685
    @nomadhomad3685 2 роки тому

    kind of a slap to the face when you don't provide the link to the jupyter file for those who learn better by following along through practice

  • @hongyeegan733
    @hongyeegan733 3 роки тому

    his codes are too small in font size.i cant see his the codes clearly

  • @crazyweb953
    @crazyweb953 3 роки тому

    3:24 😎😎

  • @hamzaabdullahmoh
    @hamzaabdullahmoh Місяць тому

    Good tutorial. But, the B-rolls are just .....

  • @litojonny
    @litojonny 11 місяців тому

    this "how to learn" is better much look at the documentation

  • @joetooly8297
    @joetooly8297 5 років тому

    Hey, you use DuckDuckGo