Classwork 10

Advanced Techniques for Python selenium

Question 1

• Use selenium to get to https://qavbox.github.io/demo/delay/.
  1. Use selenium to click the button with “Click me!”
  2. Use selenium to locate the text element that will be displayed after 5 seconds using WebDriverWait with EC.presence_of_element_located.
  • Its XPath is '//*[@id="two"]'

Answer:

Question 2

• Use selenium to download all the Excel files in the following Census page:
  • https://www2.census.gov/programs-surveys/popest/tables/2010-2019/counties/totals/

Answer:

Question 3

• Provide your Python Selenium code to scrape the following information for each book in this website.
  • category: category of a book
  • title: title of a book
  • price: price of a book
• Find the most expensive book
• Find the category with the most number of books.

Answer:

Question 4

• Use a for loop to collect historical stock price data for AAPL, MSFT, and NVDA, store it as a DataFrame, and export it as a CSV file.
  • Add a variable of Symbol to the resulting DataFrame.
  • Date ranges from 2024-01-01 to 2025-03-31.

symbols = ['AAPL', 'MSFT', 'NVDA']

Answer:

Discussion

Welcome to our Classwork 10 Discussion Board! 👋

This space is designed for you to engage with your classmates about the material covered in Classwork 10.

Whether you are looking to delve deeper into the content, share insights, or have questions about the content, this is the perfect place for you.

If you have any specific questions for Byeong-Hak (@bcdanl) regarding the Classwork 10 materials or need clarification on any points, don’t hesitate to ask here.

Let’s collaborate and learn from each other!