The SDM-Joint-Project is designed to leverage Neo4j graph database technologies to manage and analyze property-related data effectively. This project aims to provide advanced analytics for price prediction and property management insights, particularly tailored for hotels owners in the Catalonia area.
initialize_neo4j_database.py- Python script to initialize the Neo4j database with the necessary schema and data.bnb_insight_queries.cypher- Contains Cypher queries for extracting insights from the data.sdm_preprocessing.ipynb- Jupyter Notebook for preprocessing data used in the project.test.csv- Sample data file for testing our Property Graph.
- Neo4j (Preferably the latest version)
- Python 3.8+
- Jupyter Notebook or an environment to run .ipynb files (like Google Colab)
-
Clone the repository:
git clone https://github.com/yourusername/SDM-Joint-Project.git cd SDM-Joint-Project -
Set up the Neo4j Database: Ensure Neo4j is installed and running on your system. Run the initialize_neo4j_database.py to set up the database schema and load initial data.
-
Data Preprocessing： Open the sdm_preprocessing.ipynb notebook in Jupyter or Colab and execute the cells to preprocess the data.
https://drive.google.com/file/d/14Wo7hFK97nkzSbsxl63ZpiCw-tWWjaTI/view?usp=sharing
Query properties with air conditioning available
Query properties with ratings higher than 4.5
Query properties and prices near Sagrada Família
Query properties, their locations, prices, and amenities on St. George's Day of Catalonia
Recommend properties with similar amenities to the hotel owner named Sandra, and compare these properties' prices and amenities on a specific date.
Recommend properties with similar amenities to the hotel owner named Sandra, and compare these properties' prices and amenities on a specific date.
For further assistance, please contact the project maintainer Jintao Ma([email protected])
Thank you for following this guide to know our SDM project!
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.