Finding max /min value of individual columns

Question

I am a beginner to Data Analysis using Python and stuck on the following:

I want to find maximum value from individual columns (pandas.dataframe) using Broadcasting /Vectorization methodology.

A snapshot of my data Frame is as follows:

enter image description here

I am trying to find max value using idxmax() /max() methods. e.g- df_Close['AAPL'].max()-- This gives me max value of AAPL column. However, when I try to pass a list of columns e.g df_Close[col_list].max(), it errors out saying 'TypeError: unhashable type: 'Index'' — SeleCoder, Oct 30 '17 at 00:28
You should be passing column names in the list, not an index object — Alex S, Oct 30 '17 at 00:35

陳耀融 · Accepted Answer · 2017-10-30T02:30:02.440

26

you can use pandas.DataFrame built-in function max and min to find it

example

df = pandas.DataFrame(randn(4,4))
df.max(axis=0) # will return max value of each column
df.max(axis=0)['AAL'] # column AAL's max
df.max(axis=1) # will return max value of each row

or another way just find that column you want and call max

df = pandas.DataFrame(randn(4,4))
df['AAL'].max()
df['AAP'].min()

min is the same

edited Oct 30 '17 at 02:30

answered Oct 30 '17 at 00:32

陳耀融

366
3
5

I was already doing it. However, I wanted to get max values of every column. Thanks. – SeleCoder Oct 30 '17 at 01:54

Roy · Answer 2 · 2022-09-29T20:29:47.483

11

You can use aggregate function to get the min and max value in a single line of code.

For the entire dataset:

df.agg(['min', 'max'])

For a specific column:

df['column_name'].agg(['min', 'max'])

edited Sep 29 '22 at 20:29

answered Aug 15 '22 at 20:29

Roy

924
1
6
17

Finding max /min value of individual columns

2 Answers2