Help with datascraping script

[evrybdylvssebba]

Hello everybody, I'm going to be completely honest, I've recently started coding through ChatGPT, and this whole script has been completely written by ChatGPT and copilot for cross referencing. I want to learn coding, and this is how I'm doing that. Anyways, I've made chatgpt write me a script to automate a task that I need to get done at work, and it keeps failing. The way that it fails is either by spitting out a completely blank excel sheet, or by filling a column that should be filled with names and titles with "no relevant info found" and "failed to retrieve." I'm trying to see if there is a way that I could adjust the script in a way that chatgpt and copilot havent that way, I can have a more successful program? I'm going to link the script below, and a screenshot of what my current results are. If anyone would like to help me out, I'd really appreciate it!

 

[VBService]

To read data from a website you need to know the structure of the html code that was used to format the data, for example we have the following code:

<div>
  <p>
    Lorem ipsum dolor sit amet. Quo voluptatem cupiditate aut enim obcaecati a minus sapiente ut incidunt nemo ex nihil earum et odit ducimus sit necessitatibus praesentium. Sed consectetur enim 33 cupiditate minus non velit reprehenderit et ipsum dolore. Qui consequuntur mollitia sit eligendi consequatur eum accusantium suscipit. Est nemo optio ad aliquam aspernatur et aliquid recusandae aut sapiente fuga in maxime voluptas 33 repudiandae praesentium.
  </p>
  <p class="lorem">
    Lorem ipsum dolor sit amet. Quo voluptatem cupiditate aut enim obcaecati a minus sapiente ut incidunt nemo ex nihil earum et odit ducimus sit necessitatibus praesentium. Sed consectetur enim 33 cupiditate minus non velit reprehenderit et ipsum dolore. <b>Qui consequuntur mollitia</b> sit eligendi consequatur eum accusantium suscipit. Est nemo optio ad aliquam aspernatur et aliquid recusandae aut sapiente fuga in maxime voluptas 33 repudiandae praesentium.
  </p>
    <p>
    Lorem ipsum dolor sit amet. Quo voluptatem cupiditate aut enim obcaecati a minus sapiente ut incidunt nemo ex nihil earum et odit ducimus sit necessitatibus praesentium. Sed consectetur enim 33 cupiditate minus non velit reprehenderit et ipsum dolore. Qui consequuntur mollitia sit eligendi consequatur eum accusantium suscipit. Est nemo optio ad aliquam aspernatur et aliquid recusandae aut sapiente fuga in maxime voluptas 33 repudiandae praesentium.
  </p>
</div>

and we want to get the text between the b tags from the "middle" p tag.
In this case we will use javascript e.g. document.querySelector,

<div>
  <p>
    Lorem ipsum dolor sit amet. Quo voluptatem cupiditate aut enim obcaecati a minus sapiente ut incidunt nemo ex nihil earum et odit ducimus sit necessitatibus praesentium. Sed consectetur enim 33 cupiditate minus non velit reprehenderit et ipsum dolore. Qui consequuntur mollitia sit eligendi consequatur eum accusantium suscipit. Est nemo optio ad aliquam aspernatur et aliquid recusandae aut sapiente fuga in maxime voluptas 33 repudiandae praesentium.
  </p>
  <p class="lorem">
    Lorem ipsum dolor sit amet. Quo voluptatem cupiditate aut enim obcaecati a minus sapiente ut incidunt nemo ex nihil earum et odit ducimus sit necessitatibus praesentium. Sed consectetur enim 33 cupiditate minus non velit reprehenderit et ipsum dolore. <b>Qui consequuntur mollitia</b> sit eligendi consequatur eum accusantium suscipit. Est nemo optio ad aliquam aspernatur et aliquid recusandae aut sapiente fuga in maxime voluptas 33 repudiandae praesentium.
  </p>
  <p>
    Lorem ipsum dolor sit amet. Quo voluptatem cupiditate aut enim obcaecati a minus sapiente ut incidunt nemo ex nihil earum et odit ducimus sit necessitatibus praesentium. Sed consectetur enim 33 cupiditate minus non velit reprehenderit et ipsum dolore. Qui consequuntur mollitia sit eligendi consequatur eum accusantium suscipit. Est nemo optio ad aliquam aspernatur et aliquid recusandae aut sapiente fuga in maxime voluptas 33 repudiandae praesentium.
  </p>
</div>

<script>
  alert(
    document.querySelector('p.lorem b').textContent + '\n' +
    document.querySelector('p.lorem b').outerHTML
  );
</script>

IMO your python code performing a similar task does not have this specification regarding a specific page (its html code).