title: Loop through and create and new dataframe
body: <p>I have a Shared folder where .CSV files are be stored...
   i will take all the .CSV file to do my manipulation     </p>
  
  <pre><code>import glob
  x = glob.glob(r'C:\Users\Desktop\files\*.csv')
  # x  has path of all the file, say i have 3 file in folder
  i=0
  while i &lt; len(x):
  
  df=pd.read_csv(x[i],header=1)
  #x[i] is full file path,so now we assumed we have 3 files 
  ..
  # Some data manipulation
  ..
  print(avg)
  # with 3 file, 3 different AVG value calculated
  print(sum)
  # with 3 file, 3 different SUM value calculated
  i += 1
  </code></pre>
  
  <p>Now i want a new Data Frame as below..</p>
  
  <p>also file name should not be entire path.. </p>
  
  <p><a href="https://i.stack.imgur.com/3f8bS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3f8bS.png" alt="enter image description here"></a></p>