Question: use the web scraping methods that were covered in class to gain competitive intelligence on used cars. As your source, please use the recommended car

use the web scraping methods that were covered in class to gain competitive intelligence on used cars. As your source, please use the recommended car dealership site that was provided with the sample code for this exercise. Please also use Jupyter Notebook to run your code.

URL1: https://www.cargurus.com/Cars/inventorylisting/viewDetailsFilterViewInventoryListing.action?zip=73301&distance=50&sortType=DEAL_SCORE&entitySelectingHelper.selectedEntity=d1512&showNegotiable=true&sortDir=ASC&sourceContext=carGurusHomePageModel

URL2: https://www.cargurus.com/Cars/inventorylisting/viewDetailsFilterViewInventoryListing.action?zip=90210&showNegotiable=true&sortDir=ASC&sourceContext=carGurusHomePageModel&distance=50&sortType=DEAL_RATING_RPL&entitySelectingHelper.selectedEntity=d1512

Task 4-1: Pick a car make and model of your choice. Select two different cities or locations that you are interested in getting competitive data of your selected car. Extract the prices of your selected car for each of the locations you've identified by using the web scraping code provided. Visualizations of your results are encouraged here.

Task 4-2: Determine the average price point for your selected car in each of the locations identified.

Task 4-3: Calculate the depreciation of the car you've selected across the two locations identified. Compare this value across the two locations. Note: You have to use a depreciation formula to determine the depreciation of the car.

Task 4-4: provide a competitive intelligence report describing your findings for tasks 4-1 to 4-3. Provide your recommended price for a 3-year-old car of the model you've selected in both cities.

Comparison of Prices through Web scraping import bs4, requests import re import pandas as pd import numpy as np import json from re import sub from decimal import Decimal [2] url= 'https://www.cargurus.com/Cars/inventorylisting/viewDetailsFilterViewInventoryListing.action?sourceContext=carGurusHomePageModel&entitySelectingHelper.selectedEntity-d1512&zip=02215 BMW 3 Series in Boston Hur12 = "https://www.cargurus.com/Cars/inventorylisting/viewDetailsFilterViewInventoryListing.action?zip-98218&showNegotiable=true&sortDir=ASC&sourceContext=carGurusHomePageModel&distance-58&sortType=DEAL_RATING_RPL&entitySelectingHelper.selectedEntity=d1512* res = requests.get(ur1) [3] soup = bs4. BeautifulSoup(res.text) llprint (soup.prettify()) [4] #find data in dictionary format dataset soup.find_all("script") dictionary = [] for data in dataset: data strstr(dictionary) dict object = json.loads (re.search('({.+})', data_str).group(0).replace(***, ***)) print(type(dict_object)) #print(dict_object) #print(type(data)) #print(data) if 'PREFLIGHT' in str(data): dictionary.append(data) #print('found') [5] for key, value in dict_object.itens(): #print(key) break listings = dict_object["listings"] #print (type(listings)) #print(listings) output frame = pd.DataFrame(columns = ["Title", "Price", "Mileage', "Year']) for car in listings: 0 1 2 3 4 5 output_frame year car['carYear'] title = car["listingTitle"] price = car['price"] mileage car['mileage'] output_frame.loc[len(output_frame.index)] = [title, price, mileage, year] Title Price Mileage Year 8. 2021 BMW 3 Series 330i xDrive AWD 33590.0 32426 2021 25364 2020 25753 2021 18468 2020 20211 2020 2020 BMW 3 Series 330i xDrive Sedan AWD 34498.0 2021 BMW 3 Series 330i xDrive AWD 35988.0 2020 BMW 3 Series 330i xDrive Sedan AWD 34798.0 2020 BMW 3 Series 330i xDrive Sedan AWD 34798.0 2020 BMW 3 Series 330i vDrive Serian AWD 33008 0 30735 2020

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Car sharing is a growing and competitive business in the United States. Scott Griffith, Chairman and CEO of Zipcar, is considered a leading authority in the industry. Under his command, Zipcar, which...

Read and answer the question below. EMBRACE DEMOGRAPHICS AND SOCIETAL CHANGES Using Differences to Drive Value Force 7: Demographics and Societal Changes. One of the most important forces that is...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Implement a Digraph data type that represents directed graphs, where the direction of edges is significant: \(\operatorname{addEdge}(v, w)\) means to add an edge from \(v\) to \(w\) but not from...

Supply chain management has enabled some companies to operate more efficiently and compete more effectively on a global basis. What inherent characteristics of supply chain management contribute to...

Create a fill-in web form that uses a JavaScript implementation of the Luhn formula to check for typos in credit card numbers. Figure 14.15: Adder Adder 12 First addend function doAdd () { 34 Second...

2. Be clear about how and where assignments should be collected. Some teachers collect assignments in a box or bin; others have a student collect work while they introduce the next activity.

Have Imagination at Work, Ecomagination, and Healthymagination successfully communicated GEs focus on its newer endeavors? Why or why not?

compensate the ifvestor for tisk. changes in the amsunt of debt it uses; Quantitathe Problem: You are ghen the following information for Wine and Cork fincerpripes (W)ct):...

Tesla CEO Elon Musk has employed you as a consultant to assess the company's overall situation as of mid-2020 and recommend a set of actions to improve the company's future prospects. (1) Critique...

Type your answer and then click Done.The radius of the base of a cone is 22 m. Its slant height is 10 m. Find the surface area in terms of .

Solve the following optimization problems. (c) min z = f(x) = ln(x+x+1) subject to x = R. (d) max z = f(x) = 1 e subject to x = R.

No matter where you are in the Americas, the place where you live has a history tied to its Indigenous Community whose land you live on or work on. Using the link above, do a search on your own...

You be The Arbitrator" Remember, you are the Arbitrator, or judge and must follow the contract and the facts presented. Fully explain your ruling. 4.How do "school voucher programs" threaten public...

A company has three production departments P, Q and R and two service departments M and C . Following details in respect of indirect expenses incurred are furnished for a month : Indirect labour Rs....

Using the data for Project S and Project T below, conduct an Incremental IRR Analysis. MARR is 10% per year. S T First Cost -50,000 -75,000 Annual Cost -9,300 -3,000 Salvage 5,000 8,000 Value Life 5 5

please create a new corrected statement of financial position. The statement of financial position of Aguero Corporation follows (in thousands): Manion Corporation Statement of Financial Position...

Given the table below, about how much force does the rocket engine exert on the 4.0 kg payload? Distance traveled with rocket engine firing (m) Payload final velocity (m/s) 500 320 490 310 1020 450...

Harold Conners (Social Security number 785-23-9873) lives at 13234 DeMilo Drive, Houston, TX 77052, and is self-employed for 2012. He estimates his required annual estimated tax payment for 2012 to...

Olive Corporation was formed and began operations on January 1, 2012. The corporation's income statement for the year and the balance sheet at year-end are presented below. The corporation made...

Jim is fired from his job as a waiter and decides to take an extended trip to Europe. After touring Europe for 3 months, Jim returns to look for a new job as a waiter. Are his job-hunting expenses...

Let Z be a standard normal random variable and calculate the following probabilities, drawing pictures wherever appropriate. a. b. c. d. e. f. g. h. i. j.

The article Monte Carlo SimulationTool for Better Understanding of LRFD (J. of Structural Engr., 1993: 15861599) suggests that yield strength (ksi) for A36 grade steel is normally distributed with...

a. If a normal distribution has and , what is the 91st percentile of the distribution? b. What is the 6th percentile of the distribution? c. The width of a line etched on an integrated circuit chip...