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.
SQL quiz : HAVING
Solve the task by completing the SQL script
Quiz on LAG function
Learn about LAG function in SQL and solve the quiz.
Quiz on Python Function basics
fill in the blanks to complete the code.
Quiz on pandas basics
Brush up on your pandas basics knowledge. Drag and drop quizzes.
Numpy Excercise
Improve your analytical skills by practicing the following tasks
Random Forest with python
Random forest trees combine multiple decision trees to obtain an output. And it is flexible enough to adapt to Classification and Regression.Â
Standard Deviation
In measures of dispersion, the standard deviation is one of the prominent tools to calculate the dispersion of the data
Methods Of Dispersion
Let’s learn to calculate the spread of the data and measure it. with Absolute measures and Relative measures
Interquartile Range
Interquartile range is the difference between first and last quarters in a series of numbers. A Quartile range means a four-partition series of numbers.
IQR with Excel and python
In this article, we will learn how to utilize the functionalities provided by excel and python libraries to calculate IQR,
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.