Questions tagged [groupby]
A groupby operation: splits the data, applies a function to each group, and combines the results.
6
questions
0
votes
1answer
5 views
How to group by one column and count frequency from other column for each item in the previous column in python?
I am trying to group my data by the 'ID' column. Then I want to count the frequency of 'sequence' for each 'ID'. Here is a sample of the data frame:
...
0
votes
1answer
9 views
How to combine rows after Pandas Groupby function
May I know how to combine several rows into one single row after I used Pandas groupby function?
In below example, I would like to to group the data by Employee ID, Customer Last Name and Customer ...
0
votes
1answer
18 views
Normalize data from different groups
I have data that have been grouped in 27 groups by different criteria. The reason for these groupings is to show that each group has a different behavior. However, I would like to normalize everything ...
1
vote
1answer
36 views
Group_by 2 variables and pivot_wider distribution based on 2 others
Performing some calculations on a dataframe and stuck trying to calculate a few percentages. Trying to append 3 additional columns added for %POS/NEG/NEU. E.g., the sum of amount col for all ...
1
vote
0answers
15 views
Pushing down Group By clause [closed]
I've studied this exercise in class
But I cannot figure out why, when I push down the Group By clause, I can remove RLCode attribute from GroupBy. Does this action change the meaning of query tree?
0
votes
1answer
98 views
Problem with sort by and group by in pandas
I have a DataFrame with duplicate id's but have different dates.
For Example:
...
