title: Import unstructured excel file to database
body: <p>I have to import data from excel files into the database.
  The structure of these files do not match with the structure of the model, so I guess i need to do some kind of data-manipulation to arrange the tupels accordingly.</p>
  
  <p>The files I have to import look like this:
  <img src="https://i.stack.imgur.com/AyQlm.png" alt="excel file"></p>
  
  <p>The django-model has the following attributes: Country, Commodity, Year, Value</p>
  
  <p>So what would be the best way to read the data, arrange it in the correct structure and import it into the database (preferably with automatic updates of existing tupels).</p>
  
  <p>I spent a lot of time researching the existing python- and django-libraries for this requirements (like PyExcel, Pandas, Django-Excel, Django-Import-Export), but I couldn't really find out wich is the best and if it supports the rearrangement of the data before importing.</p>
  
  <p>I hope you can give me some recommendations and solutions for this task :)</p>