Получите максимальное значение и соедините текст из фрейма данных, используя groupby(), value_counts(), join ⇐ Python
-
Anonymous
Получите максимальное значение и соедините текст из фрейма данных, используя groupby(), value_counts(), join
I want to group the date and count the same item in the each day and then I want to get max value of count and join the item. My data frame is like this.
df= pd.DataFrame({'date': ['2020-09-10','2020-09-10','2020-09-10','2020-09-10','2020-09-08','2020-09-08'], 'fruit':['apple','banana','apple','oragne','apple','orange'], 'value':['1','1','2','3','3','3']}) input: x = df.groupby('date')['value'].value_counts().rename('count').reset_index().drop_duplicates('date') output: date value count 0 2020-09-08 3 2 1 2020-09-10 1 2 input : df.groupby(['date', 'value'])['fruit'].apply(' '.join) output: date value 2020-09-08 3 apple orange 2020-09-10 1 apple banana 2 apple 3 oragne My expected output is : output: date value count fruit 0 2020-09-08 3 2 apple orange 1 2020-09-10 1 2 apple orange
Источник: https://stackoverflow.com/questions/781 ... upby-value
I want to group the date and count the same item in the each day and then I want to get max value of count and join the item. My data frame is like this.
df= pd.DataFrame({'date': ['2020-09-10','2020-09-10','2020-09-10','2020-09-10','2020-09-08','2020-09-08'], 'fruit':['apple','banana','apple','oragne','apple','orange'], 'value':['1','1','2','3','3','3']}) input: x = df.groupby('date')['value'].value_counts().rename('count').reset_index().drop_duplicates('date') output: date value count 0 2020-09-08 3 2 1 2020-09-10 1 2 input : df.groupby(['date', 'value'])['fruit'].apply(' '.join) output: date value 2020-09-08 3 apple orange 2020-09-10 1 apple banana 2 apple 3 oragne My expected output is : output: date value count fruit 0 2020-09-08 3 2 apple orange 1 2020-09-10 1 2 apple orange
Источник: https://stackoverflow.com/questions/781 ... upby-value
