Question

How to iterate over pandas DataFrame rows in Python

Answer 1

import pandas as pd
  
df = pd.DataFrame(
    [['Tom', 91, 80, 94],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])
  
for index, row in df.iterrows():
    print(index, ':', row['name'], 'has', row['algebra'], 'in algebra and', row['java'], "in java")

   
   
'''
run:
   
0 : Tom has 91 in algebra and 94 in java
1 : Emmy has 98 in algebra and 96 in java
2 : Rubeus has 87 in algebra and 87 in java
3 : Dumbledore has 99 in algebra and 98 in java
4 : Axel has 75 in algebra and 90 in java

'''

 

70+ SQL courses for beginners and professionals