Pandas Part 11- The Groupby() function

In this video, we will learn about the Groupby function in detail.
Dataset used in the video:
www.kaggle.com... About CampusX:
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:
Website: www.campusx.in
Medium Blog: / campusx
Facebook: / campusx.official
Linkedin: linkedin.com/company/campusx-official
Instagram: / campusx.official
Github: github.com/cam...
Email: [e-mail]

[@sudhanshukumar4380]

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

[@madhavagrawal5581]

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

[@anupammishra994]

Arey bhaiiii😂😂😂

[@madhavagrawal5581]

@@anupammishra994 😅😅😅

[@shivastar1148]

Go in next video gus with ipl file ❤❤❤❤❤ sir u r the best guys no need to sad ---- file got change move in next videos

[@39-jyotisingh65]

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

[@7lyrics302]

The datasets is different from the above datasets shown in the video

[@nickr3971]

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

[@ARPITASINGH-ru2er]

Thanks bro...finally dataset aa gya☺️😶

[@samarpanrai5924]

or you can simple change the csv file encoding to UTF-8 from text editor and it will work

[@shrutijaiswal7357]

Thank youuu

[@manash787]

Thanks a lot bro

[@yashrastogi9072]

Thank You

[@anjan371]

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

[@craftykidsclub7039]

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

[@Pushpenderkumawat986]

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

[@lawrencepaul6780]

I too face the same problem. Can some one help us please..... Thank you.

[@dikshagupta3276]

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

[@prabhatverma4243]

right

[@imaankhan4144]

Aukaat story ka wait rhga Sir🥲😇

[@atgnandu]

dataset changed from last video to this video

[@butterscotch_695]

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

[@jainamdoshi7109]

i wanna listen that story too sir :)

[@ajaykushwaha-je6mw]

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

[@PowerOfAI.1]

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

[@raghavmittal7112]

Values_count column is selected and it will tell how many times the same value comes through out whole data frame( only count the values) where as group by for every sector it store all the values of others coulmn inside them and shown only data frame according to unique sector.

[@dilipgyawali1776]

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

[@campusx-official]

www.kaggle.com/vineetjaiswal/fortune500-2017

[@dilipgyawali1776]

@@campusx-official Thank you

[@MRAgundli]

@@campusx-official , Respected sir, great work

[@rajeevranjan5007]

6:14 Me in 1st company in the df. :)

[@deeksha-cm8kq]

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

[@anubhavpandey7682]

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

[@manavdesai1703]

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

[@manishs327]

Aukaat wala story nahi mila🙄🙄🙄...Hume bhi sunna hai.. Btw binaural beats works😁😁😁😁

[@shubhamawale4881]

I appriciate your work

[@kaleemfaisal9134]

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

[@MRAgundli]

done

[@dikshagupta3276]

There is no eda video

[@prabhatverma4243]

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

[@sanketsuryawanshi]

Yes Same Issue

[@dikshagupta3276]

Pls help

[@zkhan2023]

Thanks

[@naturevideos8029]

on kaggle the data set name is Fortune_1000.csv

[@year-old21]

Sir, What is the difference between loc and iloc?

[@bharatbatra979]

i in iloc stands for integer, so you can pass integer index to get the rows and columns. if you have named index you use loc

[@year-old21]

@@bharatbatra979 thank You

[@aryastark4064]

company = pd.read_csv('Fortune500.csv', encoding='latin-1')