title: I have to create a dataframe from webscraping in a specific way
body: <p>I have to create a dataframe in python by creating a bunch of lists from a table in a wikipedia article.</p>
  <p>code:</p>
  <pre><code>from urllib.request import urlopen
  from bs4 import BeautifulSoup
  import csv
  import pandas as pd
  import numpy as np
  url = &quot;https://en.wikipedia.org/wiki/Texas_Killing_Fields&quot;
  page = urlopen(url)
  soup = BeautifulSoup(page, 'html.parser')
  
  all_tables = soup.find_all('table')
  all_sortable_tables = soup.find_all('table', class_='wikitable sortable')
  right_table = all_sortable_tables
  
  
  A = []
  B = []
  C = []
  D = []
  E = []
  for row in right_table.find_all('tr'):
      cells = row.find_all('td')
      if len(cells) == 5:
          row.strip('\n')
          A.append(cells[0].find(text=True))
          B.append(cells[1].find(text=True))
          C.append(cells[2].find(text=True))
          D.append(cells[3].find(text=True))
          E.append(cells[4].find(text=True))
  
  df = pd.DataFrame(A, columns=['Victim'])
  df['Victim'] = A
  df['Age'] = B
  df['Residence'] = C
  df['Last Seen'] = D
  df['Discovered'] = E
  </code></pre>
  <p>I keep getting an attribute error &quot;ResultSet object has no attribute 'find_all'. You're probably treating a list of elements like a single element. Did you call find_all() when you meant to call find()?&quot;</p>
  <p>I have tried a bunch of methods and nothing has helped me. I'm also following a tutorial the teacher gave us and its not helpful either.</p>
  <p>tutorial: <a href="https://alanhylands.com/how-to-web-scrape-wikipedia-python-urllib-beautiful-soup-pandas/#heading-10.-loop-through-the-rows" rel="nofollow noreferrer">https://alanhylands.com/how-to-web-scrape-wikipedia-python-urllib-beautiful-soup-pandas/#heading-10.-loop-through-the-rows</a></p>
  <p>first time here btw as a questioner.</p>