title: Problems with CSV output using Pandas for webscraping
body: <p>Early today with the help of an user i could get this nobbie webscraping project work. But the final CSV has all the information in just one column (Photo Attached).
  How can i put each class in one particular column with the respective row?</p>
  
  <p>Thanks guys in advance.</p>
  
  <p><a href="https://i.stack.imgur.com/QLAKX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QLAKX.png" alt="Print of the final result"></a></p>
  
  <p>CODE:</p>
  
  <pre><code>from bs4 import BeautifulSoup
  import pandas as pd
  from selenium import webdriver
  import pandas as pd
  
  products=[] #List to store name of the product
  prices=[] #List to store price of the product
  ratings=[] #List to store rating of the product
  driver = webdriver.Chrome(executable_path = r'C:\Users\gomes\Desktop\chromedriver.exe')
  driver.get("https://www.flipkart.com/laptops/~buyback-guarantee-on-laptops-/pr?sid=6bo%2Cb5g&amp;amp;amp;amp;uniq")
  content = driver.page_source
  soup = BeautifulSoup(content, 'html.parser')
  for a in soup.findAll('a',href=True, attrs={'class':'_31qSD5'}):
      name=a.find('div', attrs={'class':'_3wU53n'})
      price=a.find('div', attrs={'class':'_1vC4OE _2rQ-NK'})
      rating=a.find('div', attrs={'class':'hGSR34'})
      products.append(name.text)
      prices.append(price.text)
      ratings.append(rating.text)
      data = dict({'Product Name': products,
                   'Price': prices,
                   'Rating': ratings
                   })
      # create dataframe
      products_df = pd.DataFrame(
          dict([(k, pd.Series(v)) for k, v in data.items()])
          )
      products_df.to_csv("C:\\Users\\gomes\\Desktop\\preços.csv")
  </code></pre>