Properties for sale or rent in Spain

Description of the Dataset of Properties in Spain

This dataset contains 542 records of properties available in Spain, with a total of 19 columns that describe different aspects of each property, from its location and price to specific characteristics such as surface, number of rooms, and bathrooms, among others. The columns and their main characteristics are detailed below:

1. Energy_Consumption: Energy consumption in kWh/m² per year. Has missing values.
2. Reference: Unique reference code for each property, numeric type.
3. Heating: Heating type. Has missing values.
4. Country: The country where the property is located, is always "es" (Spain).
5. City: City of the property.
6. Zone: Specific zone within the city, 492 valid records.
7. Energy_Class: Energy class of the property. Has missing values.
8. Publish_date: Date and time the property was published in `YYYY-MM-DD HH:MM:SS` format.
9. Sale_Price: Sale price in Euros.
10. Floor: The floor on which the property is located. Has missing values.
11. Street: Address of the property, with 507 unique streets.
12. Bedrooms: Number of bedrooms, presented as text (e.g., `3 bedr.`).
13. Elevator: Indicates whether the property has an elevator (only `Yes` or null).
14. Bathrooms: Number of bathrooms, with values like `1 bath` and `2 baths`.
15. Year_Construction: The year the property was built.
16. Surface: The surface area of the property in square meters.
17. Autonomous_Community: Autonomous Community of the property.
18. Contrat: Type of contract (`sale` or `rent`).
19. Property_Type: Type of property.

This dataset is suitable for the analysis of property characteristics in the Spanish real estate market, whether to identify price trends, surface distribution, energy efficiency, or to assess the popularity of certain areas and types of properties.