Loop / Iterate over pandas DataFrame (2020)

In this video we go over how to iterate (or loop) over the rows in a Pandas DataFrame using Python. There are many ways to accomplish this and we go over some of the most common methods and how we can improve our performance for even faster results. I also discuss how you can reassign values as we loop through the rows in a DataFrame.

Github link to annotated Jupyter Notebook
https://github.com/bvalgard/How-to-iterate-over-rows-in-a-Pandas-DataFrame

Other helpful links

YouTube Videos (Pycon Talks)
1000x faster data manipulation: vectorizing with Pandas and Numpy
https://www.youtube.com/watch?v=nxWginnBklU
Sofia Heisler No more sad pandas optimizing pandas code for speed and efficiency PyCon 2017
https://www.youtube.com/watch?v=HN5d490_KKk&feature=youtu.be

Articles
Optimum approach for iterating over a DataFrame
https://medium.com/@rtjeannier/pandas-101-cont-9d061cb73bfc

Crude looping in Pandas, or That Thing You Should Never Ever Do
https://engineering.upside.com/a-beginners-guide-to-optimizing-pandas-code-for-speed-c09ef2c6a4d6

0:00 Intro
0:33 Setup
1:23 df.iterrows
5:00 iloc
6:39 Lambda
7:40 np.where
8:40 np.where .values

Видео Loop / Iterate over pandas DataFrame (2020) канала Chart Explorers