Pandas iterate over rows and columns code example
Example 1: pandas loop through rows
for index, row in df.iterrows():
print(row['c1'], row['c2'])
Output:
10 100
11 110
12 120
Example 2: iterate over rows dataframe
df = pd.DataFrame([{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}])
for index, row in df.iterrows():
print(row['c1'], row['c2'])
Example 3: pandas iterate columns
for name, values in df.iteritems():
print('{name}: {value}'.format(name=name, value=values[0]))
Example 4: pandas iterate rows
import pandas as pd
import numpy as np
df = pd.DataFrame({'c1': [10, 11, 12], 'c2': [100, 110, 120]})
for index, row in df.iterrows():
print(row['c1'], row['c2'])
Example 5: python - iterate with the data frame
for row in df.iterrows():
print row.loc[0,'A']
print row.A
print row.index()
for i in range(len(df)) :
print(df.iloc[i, 0], df.iloc[i, 2])
Example 6: how to iterate through a pandas dataframe
columns = list(df)
for i in columns:
print (df[i][2])