Question

How to iterate over rows in a Dataframe in pandas (Python)?

Answer 1

Follow this code. hope it helps.

for index,row in df.iterrows():
    print(row['a'],row['b'])

Answer 2

You can use:

DataFrame.iterrows()

for index, row in df.iterrows():
    print row["c1"], row["c2"]

Answer 3

You can also use :

DataFrame.itertuples()

for row in df.itertuples(index=True, name='Pandas'):
    print getattr(row, "c1"), getattr(row, "c2")

itertuples() is supposed to be faster than iterrows()

Answer 4

itertuples is a good option.

Answer 5

You can also use df.apply(), something like this:

def valuation_formula(x, y):
    return x * y * 0.5
df['price'] = df.apply(lambda row: valuation_formula(row['x'], row['y']), axis=1)

Answer 6

You can use the df.iloc function as follows:

for i in range(0, len(df)):
    print df.iloc[i]['c1'], df.iloc[i]['c2']

Answer 7

You can use IMHO:

for ind in df.index:
     print df['c1'][ind], df['c2'][ind]