A First-Time Homebuyer's Guide in Houston, TX

My Capstone project repository, the culmination of my academic journey, tackles best areas to purchase a home in the Houston city limits. Leveraging Excel, Python, and SQL, it showcases my skills in data cleaning, wrangling and execution.

Features

Folders & Files:

1. Cleaned Data sets via Excel, Python & SQL tables
2. Raw data sets aquired for crime rates, mls sold homes, and school ratings.
3. Tableau Visualization
4. Capstone Project Planner (Word Doc)

Getting Started

Prerequisites

• Python 3.6 or higher
• Jupyter Notebook
• Pandas
• Matplotlib
• Microsoft Excel
• SQLite
• Tableau

Installation

Clone the repo

git clone (https://github.com/blessingbuddha/Capstone-Project.git)

Install Python packages

pip install jupyter notebook
pip install numpy
pip install matplotlib
pip install pandas

Directory

1. Click on "Cleaned Data" Folder
2. Click to TableauPublic Workbook to see full visualization story
   • OPTIONAL: Can look through Python and SQL to see the data being wrangled or Excel to see the fully cleaned data set