Analyzing the Price of Macintosh Computers Over Time using Scrapy

Alex Guyton
Posted on Dec 12, 2019

Apple Inc. (AAPL), founded in 1976, became the first U.S. corporation to surpass $1 trillion in market capitalization last year as its iPhone fueled spectacular growth in sales, profits and its share price. Since then, the company aggressively moves to transform itself from a seller mainly of tech hardware devices into one of the world’s leading providers of digital services. To do that, Apple must sharply boost the sales it gets from software and services. As a result, the sale of Macintosh Computers now makes up a mere 16% of its total revenue.

To extract Data, I used Python & Scrapy. Scrapy is a wonderful tool within Python, it is a perfect fit for Data Scientists who want to answer a question where the current data set does not currently exist.  For my implementation of the library, I decided to look at Macintosh computers, their prices over time & how they related to the interest rates & the price of Apple’s stock price.

To get the correct information for my data set I looked for websites that contain large amounts of data about historical pricing of Macintosh machines, as Apple.com has no pricing outside of their current product lineup.  I eventually landed with everymac.com, as it stores large amounts of data, matched my query & had a wide range of different machines from 1991 to present.

Here we see Price over time that is not adjusted for Inflation
Price over Time ~ Inflation Adjusted

You can find more information on this project here.

About Author

Alex Guyton

Alex Guyton

Tech, Coffee & Data
View all posts by Alex Guyton >

Leave a Comment

No comments found.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 airbnb Alex Baransky alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus API Application artist aws beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep Bundles California Cancer Research capstone Career Career Day citibike clustering Coding Course Demo Course Report D3.js data Data Analyst data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization Deep Learning Demo Day Discount dplyr employer networking feature engineering Finance Financial Data Science Flask gbm Get Hired ggplot2 googleVis Hadoop higgs boson Hiring hiring partner events Hiring Partners Industry Experts Instructor Blog Instructor Interview Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter lasso regression Lead Data Scienctist Lead Data Scientist leaflet linear regression Logistic Regression machine learning Maps matplotlib Medical Research Meet the team meetup Networking neural network Neural networks New Courses nlp NYC NYC Data Science nyc data science academy NYC Open Data NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time Portfolio Development prediction Prework Programming PwC python python machine learning python scrapy python web scraping python webscraping Python Workshop R R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn Selenium sentiment analysis Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau team TensorFlow Testimonial tf-idf Top Data Science Bootcamp twitter visualization web scraping Weekend Course What to expect word cloud word2vec XGBoost yelp