Pandas Part 11- The Groupby() function

In this video, we will learn about the Groupby function in detail.

Dataset used in the video:

CampusX is an online mentorship program for engineering students. We offer a 6-month long mentorship to students in the latest cutting - edge technologies like Machine Learning, Python, Web Development, and Deep Learning & Neural networks.

At its core, CampusX aims to change this education system of India. We believe that high-quality education is not just for the privileged few. It is the right of everyone who seeks it. Through our mentorship program, we aim to bring quality education to every single student. A mentored student is provided with guidance on how to ace a technology through 24x7 mentorship, live and recorded video lectures, daily skill-building activities, project assignments, and evaluation, hackathons, interactions with industry experts, soft skill training, personal counseling, and comprehensive reports. All we need from you is intent, a ray of passion to learn.

Connect with us:

[sudhanshukumar]

sir the data what you are working on is differ than the link you gave for the data

[craftykidsclub]

This is one of best learning resources of Pandas. Explanation is very clear and understandable for me....all video are awesome….

[ajaykushwaha-jemw]

After seeing 9 groupby videos, this is what I was looking for, here i got all data in video.

[kaleemfaisal]

from so long i couldn't understand this groupby() thx a lot of you...really brilliant teacher..

[madhavagrawal]

File got changed sir!!! There are significant changes in the file can you please upload the file which u used?

[nickr]

For those who are struggling with the dataset -- It requires an encoding, which is why its not working

use this code -- company = pd.read_csv('Fortune 500 Companies US.csv', encoding='cp1252')
company.head()

[anjan]

The dataset you are showing and the dataset in the link is not same. There is no sector or industry in the linked dataset.

[anubhavpandey]

does anyone have the file used in this video because the file in the link given in description is significantly changed

[butterscotch_]

2 years later & still waiting for that aaukat wala story.

[manavdesai]

The dataset differs from the video that you shared in the link.

[Pushpenderkumawat]

sector.get_group('Energy') sir when i run this code in jupyter note book it show the Sector columns and when I run 'sector.sum()' it show all the columns in the Output

[deeksha-cmkq]

Couldn't get the dataset used in this video, so i performed the tasks on the previous data set(ipl vala) .

[dilipgyawali]

i couldn't find the dataset that u have used following the link u have mentioned

[karantechy]

difference b/w .value_count() and groupby() ??

[dikshagupta]

In that link there is fortune 500 companies not file match that in video

[-jyotisingh]

the dataset has been changed if u r not understanding just move on to next video he has explained groupby on ipl dataset in next

[prabhatverma]

In that link there is fortune 500 companies not file match that in video

please update the file

[atgnandu]

dataset changed from last video to this video

[naturevideos]

on kaggle the data set name is Fortune_1000.csv

[year-old]

Sir, What is the difference between loc and iloc?