Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

ITSE 1359 – Program12 Page 1 of 2 General Points • Program12 can be completed using content from the following chapters: o Python @ ACC - Welcome! through File I/O & Modules o Textbook - Chapters 6 –...

1 answer below »
ITSE 1359 – Program12

Page 1 of 2

General Points
• Program12 can be completed using content from the following chapters:
o Python @ ACC - Welcome! through File I/O & Modules
o Textbook - Chapters 6 – 14 with emphasis on 12, 13, and 14
• You are encouraged to work with Google Spreadsheets. However, this
optional since it requires the use of your Google account to enable the API.
• Create a file named program12.py.
• Do not repeat identical examples from the course material.





Requirements (these are the requirements to identify by number):

See the Resources link in Blackboard to download files required by Program12.

1. Output a header in the console: “This is Program12 -
2. Print “This program demonstrates using Python to perform web scraping
and working with Excel spreadsheets.”
3. Ask the user to copy a U.S. street address to the clipboard.
Programmatically open a web
owser with Google maps pointing to the
address supplied by the user.
4. Ask the user to enter the URL of a web page. Programmatically select the
p> elements on the page and display the text of each

.
5. Create a class named ExcelProcessing. Use that class and any other
functions you may need to organize the operations of this program. Include
the data and functions in the class to perform the requirements below.
https:
www.austincode.com/itse1359
https:
automatetheboringstuff.com
ITSE 1359 – Program12

Page 2 of 2

6. Display the list of sheets in example.xlsx.
7. Inform the user of cells that can be read from example.xlsx and ask the user
to enter a cell (e.g. B7). Display the value located in that cell (e.g.
Strawbe
ies).
8. Ask the user to enter a rectangular section from example.xlsx (e.g. A3:C7).
Display the values in the cells of that rectangular section.
9. Print a statement explaining your experiences with Program12. Make this
authentic (minimum of 2-3 sentences).
TEST – TEST – TEST your application to ensure the requirements are met.
• Use the list above and the common requirements as a checklist.
• Not meeting all requirements = 0 points for the assignment.

Answered Same Day Nov 25, 2021

Solution

Vicky answered on Nov 27 2021
138 Votes
'''This is Program12 - Matthew'''
print("This program demonstrates using Python to perform web scraping and working with Excel spreadsheets.")
# command line or clipboard.
import we
owser, sys, pyperclip
address = input('Enter an address: ')
pyperclip.copy(address)
we
owser.open('https:
www.google.com/maps/place/' + address)
import requests, bs4
url = input('Enter a url of webpage: ')
es = requests.get(url)
soup = bs4.BeautifulSoup(res.text, 'html.parser')
pElems = soup.select('p')
for pElem in pElems:
print(pElem.getText())
import openpyxl
from openpyxl.utils import...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here