Find the Min and Max Values for Rows and Columns - Pandas

In this video we review how to find the minimum and maximum values for rows and columns in a pandas DataFrame.

We also discuss how to find the min and max values of a specific row or column (i.e., find the min and max values in a pandas Series).

Sometimes we want want the index location instead of the actual value. Don't worry, this video covers how to find the index location of the min and max values as well.

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
$15 off Annual Dataquest subscription
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Did you find this video helpful? Consider subscribing for weekly tips, tricks, and tutorials.

Other Helpful Videos:

0:00 Intro
0:15 Setup
0:59 Column Max
1:38 Column Min
1:56 Specific Col
2:14 Row Max
2:42 Row Min
2:53 Specific Row
3:46 Index Location
4:24 Conclusion

[shervintheprodigy]

Thank you!!!
I am 12 years old and I am making a heart disease predictor!!!
This video helps me a lot!!!

[shresththakur]

I am completing my project on the last day and this helped me immensely, thank you so much!

[CleoWaterDevelopment]

i have a project with a large data set and was wonder how could i find the avrage of multiple columns

[elijonam]

thanks for your useful video. I'm wondering how I can get max for a specific column after every nth row in pandas? let's say max of column 3 every 3months

[kondareddy]

In a data set we have city column consist of 5 different cities like new york, Texas and in other column total charges how to get mininum and maximum charges of particular city

[ingridarellano]

Hi I wanted to thank you for sharing your knowledge that is helping me a lot, I have a question and I hope you can help please.
When you find the max_index, in the result you get the name of the months, how could I get one more column with the numerical result, this is my question, if you could help me, please.

[krisztiankovacs]

How would you find the max value in specific rows? For example I want to know the max and min of col_2, col_3, col_4 for every month and create a new column with those values. I tried about twenty different things but can't seem to get the syntax right :(

[harsinchh]

Sir,
A B C
20 40 30
(10) 50 [60
20 30 20
50 10 10
60 10 80
30 (90) 50]
20 20 70
From column A min value 10 to column b max value 90, how can I sum column c all cells from min value to max value at column A to column B.

[mikeyg]

Really like this video, simple to understand. Am new to python, trying solve a project. Say df similar to above example, I would like to determine that for Col_1, the latest value of 56 is largest since Nov, Col_2 72 is largest since Jul, Col_3 42 is smallest since Nov, Col_4 59 largest since Sep and Col_5 31 largest since Nov. What would be the fastest way to do it, specially for thousands of data points? thanks!

[HugoRSCC]

Someone knows how to find the 5 mínimum values in a data frame (Column or row)?

[netoremining]

what if they are even? i have some that are even :(

[ultimategamer]

how do i find the max and the min for the last 5 rows of a df? thank you