I have this
How do i find max value of MMAX, but the vendor must be an "amdahl"?
Should I make a new data manually?
Use Python, pls..
I have this
How do i find max value of MMAX, but the vendor must be an "amdahl"?
Should I make a new data manually?
Use Python, pls..
df[df.Vendor == "amdahl"].MMAX.max()
The explanation:
df[df.Vendor == "amdahl"]
selects only rows which fulfill the condition in brackets, then.MMAX
returns only the NMAX
column (as a series), and finally.max()
method returns the maximum of that series values.Note:
A more verbose version of the same approach is using the ["colname"]
notations (instead of the abbreviated ones .colname
):
df[df["Vendor"] == "amdahl"]["MMAX"].max()