title: Create a dictionary for each row
body: <p>I have an excel <a href="http://administracja.sgh.waw.pl/en/dsm/schedules/session/Documents/SMMB%2020172%20-%20changes%2017.05.18.xls" rel="nofollow noreferrer">file</a> which for each line there is an event, out of this excel file I would like to create a dictionary with for example</p>
  
  <pre><code>{ 'summary' : '223051-0011 Advanced Macroeconomics I',
    'location' : 'C5-d'
  } 
  </code></pre>
  
  <p>and so on.</p>
  
  <p>The problem I have is that somehow I cannot iterate through every column, and for each of them create a separate dictionary, this is how I am trying to solve this challenge:</p>
  
  <pre><code>excel_file = pd.read_excel(
  'http://administracja.sgh.waw.pl/en/dsm/schedules/session/Documents/SMMB%2020172%20-%20changes%2017.05.18.xls',
  encoding='utf-8', header=1)
  
  n = 0
  while n &lt; len(excel_file.index) - 1:
      events = excel_file.iloc[n]
      n += 1
  
  event_summary = {}
  event_start = {}
  event_end = {}
  location = {}
  event = {}
  
  for row in events:
      event['summary'] = events.iloc[0]
  
      event_start['dateTime'] = events[6].replace(';', ' ') + events[3]
      print(event_start)
  
      event_end['dateTime'] = events[6].replace(';', ' ') + events[4]
  </code></pre>