Ideal Ski Resorts That Might Be Fit for The First-Timer

Project Description

All right, in this project, I played a role as a person who give a recommendation of the ideal ski resorts to the ski enthusiasts based on data. However, i focus on helping those who want skiing for the first time.

About the Dataset

The dataset contains two tables:

1. The Resorts table contains information on 499 ski resorts around the world, including their location, slopes, lifts, prices, and ski season.
2. The Snow table contains supplemental data on the surface of the earth covered by snow for each month in 2022, by latitude & longitude.

My Approach

First things first, I tried to figure out what are the factors that need to be considered to choose the best ski resorts. That's why I came to Reddit and looked for a ski community thread to gather the information. One of the top comments said that the best ski resort is wherever it's snowed the most. (Source: https://www.reddit.com/r/skiing/comments/7jzz8q/best_ski_resort/)

OK, maybe I could start from this statement, since I had the Snow table that contains data on the surface of the earth covered by snow for each month in 2022. Here are my assumptions and limitations:

1. I only focused on February until April data, instead of using all the months.
2. To find either the expected snowy region or countries, I'd like to visualize it by Map. I didn't use any forecasting techniques.

After finding out which countries that have the most snow, I'd like to check if there are any resorts in each country. Moreover, it would be great if we know the price range of the resorts based on the selected countries. I assumed that the lift ticket or pass is included in the ski pass, so that we could assess how much we should pay for 1 day.

##Additional Info

In the data cleansing stage, there are several steps I did:

1. For the Snow table, I only filtered the months that range from February until April 2022
2. For the Resorts table, I filtered out any resorts that have zero price. Moreover, I also replaced the question mark value in each resort name.