title: Creating new mean coloumns for multliple files using loop using python
body: <p>I've got this dataframe that looks like this </p>
  
  <pre><code>df = pd.DataFrame({'A':[230,345,222],'':[235,375,292],'B':[210,385,260],' ':[235,378,292],'C':[255,379,333],'D':[555,321,121],'E':[999,123,333],'  ':[1231,1231,222]})
       A               B               C       D       E  
  0   230     235     210     235     255     555     999     1231
  1   345     375     385     378     379     321     123     1231
  2   222     292     260     292     333     121     333     222  
  </code></pre>
  
  <p>I want to make means coloumns for each parameter because the parameter like A, B, and E have 2 coloumn that have values in it. So far, I can only make 1 parameter coloumns and got lost when I want to create parameter for another coloumns. The code is below</p>
  
  <pre><code>dflist=pd.DataFrame()
  for i, file in enumerate(flist):
      df = pd.read_csv(file, skiprows = [0,1,3,4])
      data = df.iloc[:,1:2]
      dflist['A%i'%i] = data.mean(axis=1)   
  </code></pre>
  
  <p>I want the result to be somewhat like this.</p>
  
  <pre><code>     A              Aavg     B              Bavg     C       D        E            Eavg
  0   230     235     123     210     235     123     255     555     999     1231    111
  1   345     375     456     385     378     324     379     321     123     1231    222
  2   222     292     333     260     292     1231    333     121     333     222     333
  </code></pre>
  
  <p>Any help would be appreciated</p>
  
  <p>Edit :
  My csv files look likes this
  <a href="https://i.stack.imgur.com/SufBA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SufBA.jpg" alt="enter image description here"></a>        </p>