title: Pandas outputting with coilumn names in rows
body: <p>I have the below script, which does what I need. Except, the Pandas dataframe has one row for each column like below. Title, Excerpt and url should be the column names</p>
  
  <p>How can I achieve this?</p>
  
  <p>Thanks in advance!!!!</p>
  
  <p><a href="https://i.stack.imgur.com/LAx6V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LAx6V.png" alt="enter image description here"></a></p>
  
  <pre><code>#Get post titles &amp; links
  import pandas as pd
  raw_data = pd.DataFrame([])
  
      for container in post_containers:
          # find the first &lt;a&gt; tag and get the text. Split the text using '/' to get an array with developer name and repo name
          container_name = container.find(class_="elementor-post__title").text.split('&gt;')[0].strip()
          for link in container.find_all('a'):
              link = link.get('href')  
          excerpt = container.find(class_="elementor-post__excerpt").text.split('&gt;')[0].strip()    
          d = {'title': container_name, 'excerpt': excerpt, 'url': link}
          df = pd.DataFrame(list(d.items()))
          raw_data = raw_data.append(df)
  </code></pre>