title: How to merge CSV files but the data in each csv has different position?
body: <p>I have many CSV files in one folder and these CSV files have different names with no regularity. I want to merge them in one by Python.</p>
  <p>These CSVs have the same columns, but some of the files start with different positions because the first few raws are occupied with information and also the bottom has messages as well.</p>
  <p>For example, one file's data starts from A6 because A1 to A5 has information and the bottom also has message, and some of the file's data start from A5 and the bottom message ends depending on the data.</p>
  <p>How can I merge these CSV files into one dataframe ? Thanks
  <a href="https://i.stack.imgur.com/wyUDk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wyUDk.png" alt="enter image description here" /></a></p>