title: how to scrape multiple values for a single cell
body: <p>I want to scrape the cast name from <a href="https://editorial.rottentomatoes.com/guide/best-sci-fi-movies-of-all-time/" rel="nofollow noreferrer">rottentomatoes</a>. The first movie <code>THE HITCHHIKER'S GUIDE TO THE GALAXY</code> has four names as starring. They are <code> Sam Rockwell, Zooey Deschanel, Yasiin Bey, Martin Freeman</code>. My code is totally fine with star <strong>scraping</strong>. However, instead seeing the name of the four actors for one movie, it shows the name of the four actors for four movies.</p>
  <p>My code:</p>
  <pre><code>headers = {&quot;User-Agent&quot;:&quot;Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36&quot;, &quot;Accept-Encoding&quot;:&quot;gzip, deflate&quot;, &quot;Accept&quot;:&quot;text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8&quot;, &quot;DNT&quot;:&quot;1&quot;,&quot;Connection&quot;:&quot;close&quot;, &quot;Upgrade-Insecure-Requests&quot;:&quot;1&quot;}
  url= 'https://editorial.rottentomatoes.com/guide/best-sci-fi-movies-of-all-time/'
  r = requests.get(url, headers=headers)#, proxies=proxies)
  content = r.content
  soup = BeautifulSoup(content)
  name =[]
  year = []
  rating = []
  director = []
  starring = []
  
  movies = soup.find_all('div',{'class':'article_movie_title'})
  for movie in movies:
    title = movie.find('h2').find('a').text
    name.append(title)
    release = movie.find('h2').find('span', attrs={'class':'subtle start-year'}).text
    year.append(release)
    R = movie.find('h2').find('span', attrs={'class':'tMeterScore'}).text
    rating.append(R)
    for d in soup.find_all('div', attrs={'class': 'info director'}):
      for a in d.find_all('a'):
        director.append(a.string)
    for c in soup.find_all('div', attrs={'class': 'info cast'}):
      for c1 in c.find_all('a'):
        starring.append(c1.text)
  </code></pre>
  <p>I create a dictionary and then create a csv table from that dictionary.</p>
  <pre><code>import pandas as pd
  my_dict = {'Movie_name': name,
             'Release_year': year,
             'Movie_rating': rating,
             'Director of movie': director,
             'Starring': starring }
  movie_All = pd.DataFrame({ key:pd.Series(value) for key, value in my_dict.items() })
  movie_All.to_csv('movies_rot.csv', index=False, encoding='utf-8')
  movie_All.head()
  </code></pre>
  <p>The table looks like</p>
  <p><a href="https://i.stack.imgur.com/fknMJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fknMJ.png" alt="enter image description here" /></a></p>
  <p>It should looks like</p>
  <pre><code>         Movie_name                       Release_year  Movie_rating    Director of movie   Starring
  0   The Hitchhiker's Guide to the Galaxy    (2005)    60%          Garth Jennings   Sam Rockwell,Zooey Deschanel,Yasiin Bey, Martin Freeman
  </code></pre>
  <p>How could I select the name of the star as per movies?</p>