how to loop in pandas dataframe code example
Example 1: for row in column pandas
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 2: 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 3: dataframe for loop
import pandas as pd
data = {'Name': ['Ankit', 'Amit', 'Aishwarya', 'Priyanka'],
'Age': [21, 19, 20, 18],
'Stream': ['Math', 'Commerce', 'Arts', 'Biology'],
'Percentage': [88, 92, 95, 70]}
df = pd.DataFrame(data, columns = ['Name', 'Age', 'Stream', 'Percentage'])
print("Given Dataframe :\n", df)
print("\nIterating over rows using iterrows() method :\n")
for index, row in df.iterrows():
print (row["Name"], row["Age"])