Test your knowledge on pandas groupby with this quiz
Quiz on Group By
Refer to this Dataset to solve Quiz
Fill in the blanks by drag and drop operation in right spot
pandas
pd
“Name”
[20, 21, 19, 15, 25, 35, 20]
[‘Tom’, ‘Nick’,’Tom’, ‘John’,’Nick’,’Tom’, ‘John’]
Python
import as
df = pd.DataFrame({'Name': , 'Bill': })
df_grouped = df.groupby( ).sum()
df_grouped
Output:
Bill
Name
John 35
Nick 46
Tom 74Aggregate
“City, Age”
mean
df = pd.DataFrame({'Name': ['Tom', 'Nick', 'John'], 'Age': [20, 21, 19], 'City': ['NY', 'NY', 'CH']})
df.groupby([ ])['Age']. ().sum()
Output:
60Pivot
Age
Name
Year
df = pd.DataFrame({'Name': ['Tom', 'Nick', 'John'], 'Age': [20, 21, 19], 'City': ['NY', 'NY', 'CH'], 'Year': [2020, 2021, 2022]})
df.pivot_table(values=" ", index=" ", columns=" ")
Output:
Name John Nick Tom
Year
2020 NaN NaN 20.0
2021 NaN 21.0 NaN
2022 19.0 NaN NaNGroup By Multi Columns
“Name”
“City”
df = pd.DataFrame({'Name': ['Tom', 'Nick', 'John'], 'Age': [20, 21, 19], 'City': ['NY', 'NY', 'CH'], 'Sales': [100, 200, 300]})
df.groupby([ , ]).sum()
Output:
Age Sales
Name City
John CH 19 300
Nick NY 21 200
Tom NY 20 100Filter Group By
Name
mean
df = pd.DataFrame({'Name': ['Tom', 'Nick', 'John'], 'Age': [20, 17, 19]})
df.groupby(" ").filter(lambda x: x["Age"]. () > 18)
Output:
Name Age
0 Tom 20
2 John 19ANCOVA: Analysis of Covariance with python
ANCOVA is an extension of ANOVA (Analysis of Variance) that combines blocks of regression analysis and ANOVA. Which makes it Analysis of Covariance.
Learn Python The Fun Way
What if we learn topics in a desirable way!! What if we learn to write Python codes from gamers data !!
Meet the most efficient and intelligent AI assistant : NotebookLM
Start using NotebookLM today and embark on a smarter, more efficient learning journey!
Break the ice
This can be a super guide for you to start and excel in your data science career.
Mastering Python Dictionary: A Beginner’s Guide to Coding Elegance
In this following article we will familiarize with dictionary and it’s numerous functionalities that makes it so versatile.
Decoding Python Byte Sequences: A Beginner’s Guide
Learn to store bytes and byte-arrays. Learn to convert normal datatypes to byte sequence. The bytes() function in Python returns an immutable bytes sequence.
Mastering Print in Python: A Beginner’s Guide to Output, Formatting,
At its heart, the `print()` function sends data to the standard output, typically the console.
Python Lists: A Beginner’s Expedition
List is one of the four data types in Python. Python allows us to create a heterogeneous collection of items inside a list.
Unraveling the Magic of NLP
NLP is a branch of AI that concerns with computers(AI) understanding natural languages.
The Boolean Tapestry: Weaving Logic into Python
Booleans are most important aspects of programming languages.
Everything You Need To Know About Booleans in python
Booleans are most important aspects of programming languages.
Sentiment Analysis
Sentiment analysis can determine the polarity of sentiments from given sentences. We can classify them into certain ranges positive, neutral, negative
Mastering Strings in Python: A Beginner’s Guide
Strings is one of the important fundamental datatypes in python. Interactions of input and output console’s are conveyed using strings.
Stemming and Lemmatization with nltk
Read this article further to know where to use stemmers and lemmatization. Lemmatization maybe better than stemmer but is it worth your time.
2 responses to “Quiz on Group By”
solved the problems
Nice
Points You Earned
0 distinction_points
python_points 0
0 Solver points
Leave a Reply
You must be logged in to post a comment.