title: CSV -(excel)- Python. Seems like wrong writing on csv from python
body: <p>I´m trying to export some data from a website and I first tried on one single page. I´ve to import text delimited by titles:
  ['Drug name','General Information','Clinical Results','Side Effects','Mechanism of Action','Literature
  References','Additional Information','Approval Date','Date Created','Company Name']</p>
  <p>The url is <a href="https://www.centerwatch.com/directories/1067-fda-approved-drugs/listing/3092-afinitor-everolimus" rel="nofollow noreferrer">https://www.centerwatch.com/directories/1067-fda-approved-drugs/listing/3092-afinitor-everolimus</a></p>
  <p>The code currently works, it gives me all the data. But when I insert it on the CSV , the information is not delimited as I wish.
  As it is one single page, the excel should have ONE row... but it doesn´t</p>
  <p>The code:</p>
  <pre><code>from bs4 import BeautifulSoup
  import requests
  import csv
  
  csv_file = open('Drugs.csv','w')
  csv_writer = csv.writer(csv_file, delimiter ='+')
  csv_writer.writerow(['Drug name','General Information','Clinical Results','Side Effects','Mechanism of Action','Literature References','Additional Information','Approval Date','Date Created','Company Name'])
  
  link = requests.get('https://www.centerwatch.com/directories/1067-fda-approved-drugs/listing/3092-afinitor-everolimus')
  aux =[]
  
  soup = BeautifulSoup(link.content, 'lxml')
  drugName = soup.find('div', class_='company-navigation').find('h1').text
  gralInfo = soup.find('div', class_='body directory-listing-profile__description')
  y = 0
  for h2 in gralInfo.find_all('h2'):
      print (y)
      text =''
      for sibling in h2.find_next_siblings():
          if (sibling.name == 'h2'):
              break
          else:
              text = text + sibling.get_text(separator ='\n') + '\n'
      print(text)
      aux.append(text)
      print()
      print()
      y = y + 1
  
  
  auxi = []
  for info in soup.find_all('div', class_='contact directory-listing-profile__master-detail'):
      print(info.text)
      auxi.append(info.text)
   
  csv_writer.writerow([drugName, aux[0], aux[1], aux[2], aux[3], aux[4], aux[5], auxi[0], auxi[1], auxi[2]])
  </code></pre>
  <p><a href="https://i.stack.imgur.com/18kzY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/18kzY.png" alt="Here, we can see the wrong delimitation that i get" /></a></p>