Pandas Tutorial : Pandas Full Course 

It's a crime you make so much informative high quality content for free and don't have a million more subs.

Wow, fire, heat, energy, enthusiasm. I can feel all these in this channel. 2 to 4 videos in a week is simply amazing. Thanks Derek

loc and iloc was something that I used to always get confused about. Thanks Derek for making it extremely clear to me by just mentioning what those mean.

Hi Derek, I came here after watching your video from which I learnt Perl. I think you've made self-teaching a lot easier by just showing different things programmers can do with specific tools, because whenever I practise along with your video, at the end I already have so many examples of the variety of capabilities of the tool and from there it's just a matter of experimentation and practice. Keep up the great work! Make informal training great forever!

extremely underrated channel and I cant stress enough! the amount of you info you put out is phenomenal.

I can't tell you how much I have been looking forward to this one!

It's hard to believe you packed this much information in such a short video Man you are an artist

watched it to the end :) thanks again for the great content! I have some regular python experience and now dipping my feet into Data Science, pandas seems to have an immense amount of functions, a lot to learn.

Taking the time to tell you! ❤ Also, when I just started coding I was a bartender watching your Java tutorial vids. Eventually switched to web development, did bootcamp, now professional dev and coming to you to learn about pandas.

Your videos are truly phenomenal!! I’ve never seen videos that are this succinct and informative at the same time!

Thank you so much!!! I was thinking about reading the docs and then *clear and concise tutorial came up* :)

You're a Data Science rockstar, Derek! I am addicted to your videos. Thank you for making Data Science fun! :)

Thank you so much for doing this!! :)

Brillant! I love YT and I love creators like you!!!! Thanks for sharing your knowledge! And thanks for letting me learn :)))

Great tutorial, I followed on my own data until the end !

Thank you for your sharing knowledge! So Cooool your videos are!

Yes Derek, there are people that watch your videos til the end. These videos are gold.

Used your videos to learn python and pandas in one go and now I am using the knowledge to do algotrading in 2 days. You, sir are the moses of programmers.

Honestly, I am at a loss for words. All I can say is God bless you mightily

Derek, 53:10 why was the 'f' used inside the print statement and flower brackets used for 'index' and 'row' ? Thanks in advance

i just was about to get started doing pandas but came here first and found a potential gem haha. you are helping the world my friend

I can't thank you enough for such an amazing and informative video!

Thank you, pretty dope.

Wow! Your channel is highly underrated Your content is amazing! Thanks

can't believe this is free material, thank you!!!

Derek Banas, you are my superhero!! SMASHING the LIKE Button!!!!

This is amazing. I will be using this for work tomorrow. Thanks

I watched till the end. Great overview of pandas and features.

Hi Derek, great video as always. Are you planning to cover streamlit as well? I just found out about it and it looks really great and straightforward for data visualization :).

Great series, I rather watch your videos than netflix. Keep it up!!!

Hey RU-vid, our man is making videos day after day, acknowledge him give him boost and views..:

Exactly what I needed.

1:08:40 I think a better way might be to use "product" from "itertools": >>> days = ['Day 1', 'Day 2', 'Day 3'] >>> meals = [1,2,3] >>> list(product(days, meals)) [('Day 1', 1), ('Day 1', 2), ('Day 1', 3), ('Day 2', 1), ('Day 2', 2), ('Day 2', 3), ('Day 3', 1), ('Day 3', 2), ('Day 3', 3)]

Working on my data analysis skills… hoping i can find a job as a recent graduate. Thanks for the vid

Love you Derek... !!! MASHALLAH.. you are one Awesome Tutor... !!!

love from india bro, keep doing this great work

Great lesson. I am the one, who watched tutorial till the end;)

59:22 Hi, what in function means? df[names.columns] = names

Have you considered a "learn how to learn" video or series? I've seen your anki tutorial but would be great to see your methodologies of how you pick up and master so many things so readily.

Hey at 59:00 can you explain how df[names.columns] = names works inside split_names function

great video!

Great video! How do I set up a database like the one you accessed at around 29:27?

Are you a mini god or something? Just tomorrow I was thinking it would be great if there is learn numpy and pandas in one video and there is one. Wow. Thanks a lot. Please matplotlib next.

can we use "and" and "or" instead of "&" and "|" for the conditions?

AWESOME!!!!!!! nothing else to say

Finally got to watching this. It has been in my "Watch Later" for 2-3 weeks now. Now for Matplotlib... Maybe tomorrow? Or the day after?

Muchas gracias a lot (:

Great tutorial as usual! Just a small correction. At 1:20:32 the most profitable product is (Product ID GT13-0024, Profit 230.89) which can be obtained by using something like: df.loc[df['Profit'].idxmax()][['Product ID', 'Profit']].

I watched until the end!

Yes yes :) can we expect Signal processing with SciPy as next series ??

Great tutorial, like always! :) Don't forget that Derek has a patreon page, guys! 😊 😉

Thanks =)

Awesome content a minimal data visualization tutorial please for analysis

Thank you

What is the part one, two and three? What is the part five?

I freaking love this channel. Derek I 8> you

db_connection.close() is not defined this error is showing while connecting database I think u didn't gave the database of students in your github rep

Hi sir 1. I have 300 columns in one csv without headers where i need only 4 columns pd.read_csv('ab.csv',names=[a1,......a300],usecols=[a1,a2,a34,a54]) Is this efficient or further can be optimise 2. In a csv i have uncommon columns Row 1: 15 columns Row2: 20 columns When i do readcsv it throws found 20 expected 15 columns Please advise 3. I have two csv where i need to compare row1 from csv1 to row1 from csv2 Currently using for loop Please suggest better way

Is web Scraping included in series likes of scrapy..?

Hi Derek, Really like your videos! I think I noticed an error in this one. for the line: # Get the product with the highest profit cs_df[['Profit','Product ID']].max(axis=0) I think this is actually returning the max of each row, not the product with the highest profit. If you look at the product ID of the system with the highest output the answer should actually be GT13-0024.The profit of the answer Q526FA is only 143.09. A way I found to get the desired answer is cs_df[cs_df['Profit'] == cs_df['Profit'].max()][['Profit','Product ID']]

Hi sir plz make a video on Ethical hacking

Why don't you create a new cell every time, for new output. It would be a lot easier to understand if same thing is not on output over and over again,

I have a question, if I want to make 2d games that are kinda like 3d but not really, what are some languages I should learn?

1:35:33 I’m taking the time to tell you. And thanks!

Why is data created by column instead of by rows? It seems to me in the real world you’d add records, not a column at a time. So if I grabbed all the products from Amazon, I would not add a product list csv and then a price list csv praying they’d match up properly. I’d add a product in one row with all the info for the product, or a table of products with the product info schema. Not just this tutorial but other tutorials start off with adding data by column and it doesn’t make sense to me what am I missing

Can it be used for Game A.I. development?

how do i get the cheetsheat from Github?

Hello sir can you provide me the link to csv files? Thank you

pd.melt is not there

SOOOOOOOOO here is what i got: 1. Tasi and her BF had a girl that died of an unknown/genetic illness that cant be healed by conventional medicine 2. this traumatized Tasi but she lived on with her BF 3. they decide to go onto an excoursion in west africa, crossing the sahara desert with a plane to get there. Slightly before thehy start the journey, Tasi and her BF realize that she has a second child in waiting, which gives her great hope. MEANWHILE IN THE OTHER WORLD: 4. This seems to be the homeworld of alexander. The people are technologically advanced and highly stratified. They have used the ORBs are sourced of great power and as a gateway to gather knowledge, to which OUR world has no access. One of these powers is the Ability to rip open Reality itself, in order to enter different dimensions and timelines. 5. Another technology is the extraction of VITAE as a form of energy, although it is not clear whether they discorvered this by themselves or via use of the orb....the first game makes it seem as if Alexander found out about vitae during his Exile (or at least figured out that it CAN be harvested from humans) Hinting at the idea that his knowledge must have been conveyed to his old world either by Agrippa or Alexander himself (depending on the ending you got) 6. Vitae is a powerfull energy source, capable of even controlling and making use of the power of the ORBS. Another main advantage is that it can heal people AND allow them to basically life forever, as long as a steady supply is available. To get such a supply, VITAE must be harvested constantly through torture (seemingly the only efficient way of doing so) 7. So the Other world sends out agents into our world via the ORBS and kidnaps people to be tortured forever and provide limitless energy for the civilization and the empress. 8. the empress herself, on the other hand, is not fully satisfied, as the VITAE injections have destroyed her ability to have a child, something she seems to have an incredibly strong instinct for. 9. Some workers at the "VITAE plants" start to rebel against the order. They can not accept the torture of human beings for the rest of their lifes as a justifiable cost to their own happiness/prosperity and plan to destroy the system. They first plan to destroy the "Gate" which allows them to send through and communicate with the "Harvesters" on OUR world. Effectively cutting off the VITAE supply at the source. They also plan to sabotage the existing VITAE plants. 10. The Shadow of the ORB (the red flesh) is well known to the scientists in that world and they purposefully plan to use some of it and sabotage the VITAE flow to the Empresses chamber, by injecting it into the "pipe system" . the flesh feeds off of the VITAE and would quickly not only Clog the VITAE flow but also spread through the entire city and Tower, killing everybody and destroying the system 11. The plan is enacted, the Main gate is destroyed and the Red flesh is injected into ONE of the Vitae pipes, but it has terrible consequences: The World gets basically destroyed, Everything outisde the protective wall of the city is turned into a wind swept wasteland of constant storms. We can not tell how this has impacted the Civilian population of the OTHER WORLD, but it seems that the empress is still in control and still getting vitae via her mindless Harvester troops. The Red Flesh was only inserted into ONE of the 4 Supply lines and therefore she is still secure. BACK TO OUR WORLD: 12. As the Main gate is destroyed, a great chain reaction is unleashed that also affects the Plane Tasi and her Team are traveling in. A great sandstorm appears out of nowhere and pictures of the OTHER WORLD flash in and out, leading the plane to crash. 13. The survivors Push for some nearby caves to seek shelter, but many are heavily wounded. Tasi, Yasmin, Hank, the Guy with the Thick accent and the Doctor try to reach a settlement for help, the rest remain in the cave (including tasis BF. who is also gravely wounded) 14. They reach a French fort, but find it full of dead (people that had been attacked and killed by the Harvesters, frantically send out from the OTHER WORLD by the empress to get more vitae, after the sabotage didnt fully work out). Hank gets wounded as the Ghuls in the fort attack the survivors and will surely die before they can reach help. The survivors try to go further but conflict breaks out over whether to abandon Hank or not. amulet 16. With the help of Tasis amulet, they are transported to the OTHER WORLD (as a side note: that amulett mateches Alexanders descripotion of the Device capable of opening rifts between worlds. He lamented the fact that a device, small enough to fit in the palm of his hand, must be recreated by him with Steam and pipes and is the size of a mansion). In that world, the empress tries to manipulate them, by claiming she can only help them if they surrender the Child (tasi staying in the OTHER WORLD until she gives birth, then leaving the Child there) 17. Tasi refuses, even though the others try to convince her that this could save not only hank, but also her BF AND that they need the help in order to survive the desert and get back home. Tasi is unwilling to give up her child, even if the others die. slowly

When you tried to find the most profitable product, you did it wrong. All you actually did was find the product with the lexicographically largest product ID.

Hey man! How are you?!

35:33

If I close my eyes, I can hear "Bueller? Bueller?"

Dang Derek, you must be really busy

Oh man, not a single bamboo eating panda in the video.

Watched till the end, just fyi

First

Your channel and playlists are a gift. Such a relatable style and intuitively set out playlists. Cheers and I hope you're reaping the benefits of kharma.

What's your Instagram Username?

Pandas are gonna provide black and white fluff. Thank me later

Not even a single panda.

I’m here to make you feel good @DerekBanas