Get max values based on unique values in another list

Get max values based on unique values in another list - python

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Get max values based on unique values in another list - python

Antonio
Programmer named Tim

Posts: 17

Threads: 8

Joined: May 2018

Reputation: 0

Jun-12-2018, 03:21 PM

(Jun-12-2018, 10:00 AM)volcano63 Wrote:
(Jun-12-2018, 09:32 AM)Mekire Wrote: Hmm, I was looking for something like that and didn't find what I need.
I'm surprised there isn't a sort of findgroups in numpy itself (and there may well be), but I didn't have any luck finding it.

There's pandas.DataFrame.groupby - so that will work too
import pandas as pd
df = pd.DataFrame(sys_func)
np.array([g.max() for _, g in df.groupby(df[0])])
Closer to home - but still not pure-numpy solution

I actually love this one! Thanks y'all!

Find

Messages In This Thread

Get max values based on unique values in another list - python - by Antonio - Jun-12-2018, 02:20 AM

RE: Get max values based on unique values in another list - python - by Mekire - Jun-12-2018, 07:54 AM

RE: Get max values based on unique values in another list - python - by killerrex - Jun-12-2018, 08:32 AM

RE: Get max values based on unique values in another list - python - by Mekire - Jun-12-2018, 08:53 AM

RE: Get max values based on unique values in another list - python - by volcano63 - Jun-12-2018, 09:25 AM

RE: Get max values based on unique values in another list - python - by Mekire - Jun-12-2018, 09:32 AM

RE: Get max values based on unique values in another list - python - by volcano63 - Jun-12-2018, 10:00 AM

RE: Get max values based on unique values in another list - python - by Antonio - Jun-12-2018, 03:21 PM

RE: Get max values based on unique values in another list - python - by Mekire - Jun-12-2018, 07:49 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Assigning conditional values in Pandas	Scott	3	947	Dec-19-2023, 03:10 AM Last Post: Larz60+
	attempt to split values from within a dataframe column	mbrown009	8	2,538	Apr-10-2023, 02:06 AM Last Post: mbrown009
	Make unique id in vectorized way based on text data column with similarity scoring	ill8	0	931	Dec-12-2022, 03:22 AM Last Post: ill8
	Increase df column values decimals	SriRajesh	2	1,154	Nov-14-2022, 05:20 PM Last Post: deanhystad
	replace sets of values in an array without using loops	paul18fr	7	1,846	Jun-20-2022, 08:15 PM Last Post: paul18fr
	Changing Values in a List	DaveG	1	1,332	Apr-04-2022, 03:38 PM Last Post: jefsummers
	How does one clean a populated table in MySQL/MariaDB? Copying values across tables?	BrandonKastning	2	1,620	Jan-17-2022, 05:46 AM Last Post: BrandonKastning
	Matplotlib scatter plot in loop with None values	ivan_sc	1	2,322	Nov-04-2021, 11:25 PM Last Post: jefsummers
	pandas: Compute the % of the unique values in a column	JaneTan	1	1,834	Oct-25-2021, 07:55 PM Last Post: jefsummers
	Write a dictionary with arrays as values into JSON format	paul18fr	3	5,850	Oct-20-2021, 10:38 AM Last Post: buran

Users browsing this thread: 1 Guest(s)

View a Printable Version

Get max values based on unique values in another list - python

User Panel Messages

Announcements