Questions & Answers

(Frequently asked questions)

Questions & Answers › Tag: Data Aggregation

Filter:AllOpenResolvedClosedUnansweredSort byViewsAnswersVotes

Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the aggregate method shown in below code do? g = df.groupby(df.index.str.len()) g.aggregate({'A':len, 'B':np.sum})

AnsweredAdam asked 3 years ago • Programming Language

18376 views1 answers0 votes

Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters the rows whose column B values are greater than 45?

AnsweredAdam asked 3 years ago • Programming Language

3319 views1 answers0 votes

Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters the rows whose column B values are greater than 45 and column 'C' values are less than 30?

AnsweredAdam asked 3 years ago • Programming Language

18740 views1 answers0 votes

Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. What does the expression df[lambda x : x.index.str.endswith('3')] do?

AnsweredAdam asked 3 years ago • Programming Language

4864 views1 answers0 votes

Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. How many rows are obtained after executing the below expressions g = df.groupby(df.index.str.len()) g.filter(lambda x: len(x) > 1)

AnsweredAdam asked 3 years ago • Programming Language

3587 views1 answers0 votes

Which of the following method can be applied on a groupby object to get the group details?

AnsweredAdam asked 3 years ago • Programming Language

7281 views1 answers0 votes

Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3'], Which of the following expression is used to extract columns 'C' and 'D'?

AnsweredAdam asked 3 years ago • Programming Language

5366 views1 answers0 votes

Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the expression g = df.groupby(df.index.str.len()) do?

AnsweredAdam asked 3 years ago • Programming Language

5978 views1 answers0 votes

What does the expression df.iloc[:, lambda x : [0,3]] do? Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3'].

AnsweredAdam asked 3 years ago • Programming Language

7161 views1 answers0 votes

Which of the following methods is used to group data of a data frame, based on specific columns?

AnsweredAdam asked 3 years ago • Programming Language

6185 views1 answers0 votes