title: Parsing PubMed data and extracting multiple columns from multiple files
body: <p>I have multiple <code>xml</code> files from PubMed. Several files are <a href="https://drive.google.com/drive/folders/1MP5DSCYs8Eh4WILM07Xn8BahXUtK1MuN?usp=sharing" rel="nofollow noreferrer">here</a>.</p>
  <p>How to parse it and get these columns in a single dataframe.
  If an article has several authors, I want to have them as separate rows</p>
  <p>Expected output (all authors should be included):</p>
  <pre><code>Title  Year ArticleTitle     LastName ForeName
  Nature 2021 Inter-mosaic ... Roy      Suva
  Nature 2021 Inter-mosaic ... Pearson  John
  Nature 2021 Neural dynamics  Pearson  John
  Nature 2021 Neural dynamics  Mooney   Richard
  </code></pre>