iterate over pandas columns code example
Example 1: 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 2: pandas iterate columns
for name, values in df.iteritems():
print('{name}: {value}'.format(name=name, value=values[0]))
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)
Example 4: how to iterate through a pandas dataframe
# creating a list of dataframe columns
columns = list(df)
for i in columns:
# printing the third element of the column
print (df[i][2])