Pandas Conditional Columns: Set Pandas Conditional Column Based on Values of Another Column

In this video, you'll learn how to set a Pandas column values based on values of another column. You'll learn how to set values based on a single condition, multiple conditions, and emulating a VLOOKUP in Python.

0:00 Introduction
0:55 Using loc to Set Conditional Values
3:50 Using Numpy Select
6:23 Pandas Map a Dictionary
9:00 Pandas Apply a Custom Function
12:20 Conclusion

Learn Python programming the right way!

----------------------------------------------------------

✅ Follow me on other platforms:

[guidysoll]

I spend two days looking for a solution for a conditional problem. This video was exactly what I needed. Thank you very much!!!

[AKS]

There are SO many, quite frankly TOO many instructional videos, and they are tedious, too long, and unclear, but YOURS is EXACTLY on point

[hashemrashidi]

Guys he is the best and simplest, best one seriously, just trust and watch till the end .

[brtb]

The numpy option was exactly what I needed and worked great. Thank you, also for the other videos. Keep up the good work…

[alihobballah]

This is an excellent Tutorial !!! . Beautifully explained, and you went over issues I have been struggling with. Thank you so much for taking the time to make this video

[Zenoandturtle]

Great presntation. I am building a trading bot using algorythm that deals with conditional columns (candlestick lengths of previous columbs) This is the video I was looking for. Thanks for the vid. Very clear and informative. Exactly what I was looking for.

[AndrewCB]

I've been looking for a video to help with my code for days. Your vid was by far the best and only one that added value. Well done!

[DavidWhiteJazz]

This was a clear and concise explanation that helped me a lot. Thank you for all that you do!

[kathryngomes]

This is really awesome. Thankyou for this tutorial.

[thetudors]

Excellent presentation… you really helped me understand map & apply methods

[wearerunnersw.a.r]

great explanation, used the numpy method. works brilliantly

[andyb]

Oh man -- I've been trying to figure out more efficient ways of defining bins for a df. While I'm fairly new to Python, I've coded (in SAS) for 15 years, but that experience is only helpful in knowing how I would solve a coding problem -- in SAS.

The numpy approach you mentioned is very simple and intuitive -- your tips are going to save me so much time! Thanks for making this video!!!

[Dataanalyticspro]

Excellent video! Just what I need to solve a problem. Thank you!

[amirarsalanghazali]

thanks a lot, you saved me a lot of time and effort

[kawsydaisy]

Thus video is very helpful and exactly what I needed! Thank you for the multiple examples with different scenarios!

[Puma_]

your video is so good, thank u so much I was looking for this everywhere :)

[Drezzomir]

Works like a charm! Many thanks dude :)

[sonkamblepraveenkumar]

Thank you bro that what i was looking for my problem to be solved. Great!!!!

[thecommonwheel]

Excellent. Thanks for sharing your knowledge.

[Sandeepkumar-dmbp]

Excellent tutorial nice explanations, concise, covered many related concepts, various ways to do,