title: Combine CSV files to one file using python
body: <p>I have a lot of files with following sample content</p>
  
  <p>File1</p>
  
  <pre><code>ENGLISH|0|1|0|0|3|0|1483|1|0|183
  TURKISH|1|0|0|0|1|60649|0|0|0|649
  AZERBAIJANI|0|0|2|0|2|0|0|45|0|45
  URDU|0|10|0|1|1|0|0|0|1409|109
  </code></pre>
  
  <p>File2</p>
  
  <pre><code>HINDI|0|2|0|0|2|0|1183|0|0|1183
  TURKISH|1|0|0|0|1|60649|0|0|0|60649
  AZERBAIJANI|0|0|2|0|2|0|0|45|0|45
  URDU|0|0|0|1|1|0|0|0|1409|1409
  </code></pre>
  
  <p>FileN</p>
  
  <pre><code>DANISH|0|2|0|0|2|0|1183|0|0|1183
  ENGLISH|1|0|0|0|1|60649|0|0|0|60649
  AZERBAIJANI|0|0|2|0|2|0|0|45|0|45
  URDU|0|0|0|1|1|0|0|0|1409|1409
  </code></pre>
  
  <p>I have to sort all these files and then add each column to same column number of all files and finally have a single file bases on language name. Language name can be considered as KEY. So all records with same KEY in all files should be added. How I can do it ?</p>
  
  <p>I am using linux as OS. Is there any other utility that can do the same job ?</p>