for loop in dataframe column python code example
Example 1: pandas iterate columns
for name, values in df.iteritems():
print('{name}: {value}'.format(name=name, value=values[0]))
Example 2: dataframe for loop
import pandas as pd
# Define a dictionary containing students data
data = {'Name': ['Ankit', 'Amit', 'Aishwarya', 'Priyanka'],
'Age': [21, 19, 20, 18],
'Stream': ['Math', 'Commerce', 'Arts', 'Biology'],
'Percentage': [88, 92, 95, 70]}
# Convert the dictionary into DataFrame
df = pd.DataFrame(data, columns = ['Name', 'Age', 'Stream', 'Percentage'])
print("Given Dataframe :\n", df)
print("\nIterating over rows using iterrows() method :\n")
# iterate through each row and select
# 'Name' and 'Age' column respectively.
for index, row in df.iterrows():
print (row["Name"], row["Age"])
Example 3: python loop through column in dataframe
# Iterate over two given columns only from the dataframe
for column in empDfObj[['Name', 'City']]:
# Select column contents by column name using [] operator
columnSeriesObj = empDfObj[column]
print('Colunm Name : ', column)
print('Column Contents : ', columnSeriesObj.values)