title: Parsing a string with multiple xml files into a dataframe in pyspark
body: <p>I have a string s with multiple XML files given below: </p>
  
  <pre><code>['https://irs-form-990.s3.amazonaws.com/201611339349202661_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201611309349201761_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201543179349200944_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201631099349200733_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201610909349200511_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201630749349201058_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201601319349200235_public.xml',
   'https://irs-form-990.s3.amazonaws.com/201641069349200909_public.xml',]
  </code></pre>
  
  <p>I have 1000 in that string s and I want to parse all that to a df using pyspark</p>
  
  <p>I am using the below code:</p>
  
  <pre><code>df = sql.read.format("xml").options(rowTag="xyze").load(s).coalesce(10)
  </code></pre>
  
  <p>and it is giving me and error</p>
  
  <p>I also used </p>
  
  <pre><code>sc.addFile(s)
  df4 = sql.read.format("xml").options(rowTag="xyze").load(pyspark.SparkFiles.get("*_public.xml")) 
  </code></pre>
  
  <p>It is giving me the same error as Path to XML need to be specified</p>
  
  <p>And I am using jupyter notebook for all these.</p>
  
  <p>Any kind of help would be appreciated.</p>