> ## Content Index
> Fetch the complete content index at: https://www.bambooweekly.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Bamboo Weekly #60: Iceland
- URL: https://www.bambooweekly.com/bw-60-iceland/
- Published: 2024-04-03T19:31:14.000Z
- Updated: 2026-08-06T10:45:24.000Z
- Description: Get better at: Web scraping, regular expressions, joins, CSV, plotting, and pivot tables
- Author: Reuven M. Lerner
- Tags: web-scraping, regular-expressions, joins, csv, plotting, pivot-table

I returned late Sunday night from a trip to Iceland, where we (my wife, one daughter, and I) drove around the island via the famous ring road. Iceland is a truly amazing place, full of endless mountains, waterfalls, and natural wonders. We hiked on a glacier, explored an ice cave, and enjoyed soaking in naturally heated mineral baths while snow was falling. Oh, and we saw the northern lights on several occasions, including on our drive back to the airport — at the same time as we could see a volcano erupting just to our south.

Any photographs you've seen of Iceland don't even come close to doing it justice. The overwhelming size and number of natural wonders awe inspiring.

![](https://storage.ghost.io/c/06/ba/06ba0cc0-be6f-4de7-af2f-5c20165279b9/content/images/image/fetch/f_auto,q_auto:good,fl_progressive:steep/https-3a-2f-2fsubstack-post-media.s3.amazonaws.com-2fpublic-2fimages-2fee29a367-c6b3-4e1c-8bcb-e3ed75027915_1024x1024.jpg)

The thing is, Iceland is a huge place, but its population is very small. We saw many more foreigners than locals; I'm not really sure how many native Icelanders we encountered during our trip. Even many of the local staff we encountered (e.g., at hotels) were immigrants or foreign workers.

![](https://storage.ghost.io/c/06/ba/06ba0cc0-be6f-4de7-af2f-5c20165279b9/content/images/image/fetch/f_auto,q_auto:good,fl_progressive:steep/https-3a-2f-2fsubstack-post-media.s3.amazonaws.com-2fpublic-2fimages-2faaa5c574-89ec-4515-8064-3ffb78599d98_1024x1024.jpg)

I thought that it would be fun to spend this week looking at some information about Iceland, to share at least a bit of what I enjoyed on my trip there. (And my apologies for the late publication of this week's questions, but I returned to a packed week of corporate training and writing proposals for new clients.)

### Data and six questions

This week, we'll be looking at a number of different data sets, all having to do with Iceland. The learning goals for this week include joining, cleaning data, pivot tables, regular expressions, and plotting. I’ll be back tomorrow with full solutions, including the Jupyter notebook I used to solve these problems.

- Create a data frame from Wikipedia's page listing the size of each country and territory ([https://en.wikipedia.org/wiki/List\_of\_countries\_and\_dependencies\_by\_area](https://en.wikipedia.org/wiki/List%5Fof%5Fcountries%5Fand%5Fdependencies%5Fby%5Farea?ref=bambooweekly.com)). Now create a second data frame from Wikipedia's page listing the population of each country and territory ([https://en.wikipedia.org/wiki/List\_of\_countries\_by\_population\_(United\_Nations)](https://en.wikipedia.org/wiki/List%5Fof%5Fcountries%5Fby%5Fpopulation%5F%28United%5FNations%29?ref=bambooweekly.com) ). Where does Iceland rank in terms of size? In terms of population? In terms of people per square kilometer of land?
- Next, we'll look at tourism to Iceland. Go to the OECD's data portal ([https://stats.oecd.org/?lang=en](https://stats.oecd.org/?lang=en&ref=bambooweekly.com)). Even though it claims that this page is no longer relevant, that's not true! Search for "inbound tourism" in the widget on the left side, and download the CSV file with info about inbound tourism for the entire OECD. Create a data frame from that data in which the year is the index, and the value (i.e., number of tourists) is a column. You'll want only those rows where the variable is INB\_ARRIVALS\_TOTAL.
- Create a line plot showing tourism over the years to Iceland, the UK, and Australia. Interpolate any missing values with the mean of the adjacent values.
- Calculate, for 2019, the number of tourists per the (2023) population we calculated earlier. Where does Iceland rank, in terms of tourists per citizen?
- Download Airbnb data for Iceland from Doorbll ([https://doorbll.com/report?location=Reykjavik&country=Iceland](https://doorbll.com/report?location=Reykjavik&country=Iceland&ref=bambooweekly.com)). (There's a small link at the bottom of the page, allowing you to download the data in CSV format.) Create a data frame from that data. Remove any listings whose basic\_night\_price is more than 2 standard deviations above the mean. Create a scatter plot showing the number of bedrooms (x axis) vs. the price of the Airbnb rental (y axis). Color the dots based on the number of pictures shown on the Airbnb site. Do we see any correlation between the number of rooms and the basic night price?
- If we calculate the correlation between basic night price and the number of bedrooms, do we find a correlation? How strong of a correlation is it?

I’ll be back tomorrow with my detailed solutions.

Reuven