> ## 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 #30: Uncertainty
- URL: https://www.bambooweekly.com/bw-30-uncertainty/
- Published: 2023-08-30T15:00:30.000Z
- Updated: 2026-08-06T10:45:49.000Z
- Description: Get practice with Excel files, string manipulation, index operations, plotting, and multi-indexes
- Author: Reuven M. Lerner
- Tags: excel, strings, index-operations, plotting, multi-index

*\[Personal note: My father, Rabbi Barry Dov Lerner, passed away on Tuesday morning, at the age of 81\. I’ll be observing the Jewish week-long mourning ritual known as shiva, and thus don’t expect to put out an issue next week. I wrote this issue of Bamboo Weekly earlier in the week, while he was getting hospice care from some of the most patient, caring, devoted people I’ve ever met.*

*My father came up with the idea of using the word “bamboo” in the name of this newsletter, and was always interested in the intersection of current events and education. Indeed, he made a point of reading the newspaper every Saturday morning before going to synagogue, in order to make a connection between his sermon and current events. I hope that you enjoy this week’s edition, and I hope to be back in two weeks with more insights inspired by everything I learned from my father.\]*

I’m writing this while on a flight to the US. Until just a few days ago, I was expecting to be flying in the opposite direction right now, to attend [PyCon Taiwan](https://tw.pycon.org/2023/?ref=bambooweekly.com). I've been to Taiwan once before, and it was one of the most delightful places I've ever visited — so I was really excited to return, to attend the conference, to have some business meetings, and to bring my family with me. Python is important, and conferences are important... but health and family are even more important, and there's some business I can conduct while in the US, as well, so there you have it.

When I told my friends that I was planning to visit Taiwan, many were concerned. After all, isn't Taiwan dangerous, given all of the threats that we've heard from China, and the dire headlines we’ve seen time and again? I had to laugh a bit, especially when Israelis asked me this question, given that people are hesitant to visit Israel, where I live, because of headlines describing it as dangerous. (For the record, Israel is extremely safe, except certain for specific places at limited times.)

And so, when I was looking around for an interesting data set having to do with Taiwan, I was amused and excited to find the "World Uncertainly Index," (WUI, at [https://worlduncertaintyindex.com](https://worlduncertaintyindex.com/?ref=bambooweekly.com) and [https://www.imf.org/en/Publications/fandd/issues/2020/03/imf-launches-world-uncertainty-index-wui-furceri](https://www.imf.org/en/Publications/fandd/issues/2020/03/imf-launches-world-uncertainty-index-wui-furceri?ref=bambooweekly.com)) a metric that tries to describe how worried we should be about the world in general, or certain regions and countries in particular.

![](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-2fdff2b835-7aed-4b7e-9145-1b7f255909cf_1024x1024.jpg)

From DALL-E, in response to “Person unsure which option to choose”

The index, created by Hites Ahir, Nicholas Bloom, and Davide Furceri, has a fairly simple methodology: It reads reports written by the Economist Intelligence Unit (a research firm under the same corporate umbrella as the Economist magazine), and counts uses of the word "uncertainty". That's basically it -- but it seems that the measure does have some predictive power; the authors say that "innovations in the WU foreshadow significant declines in output."

This week, then, I decided to look at the WUI data. Can we identify times when uncertainty in the world went up? Which countries are more reliably uncertain? And how do Israel and Taiwan compare, with each other and with other countries in the world?

### Data and seven questions

This week, we'll be working at the [WUI data set](https://worlduncertaintyindex.com/data/?ref=bambooweekly.com). It consists of a single Excel file with a number of different sheets, each with a different piece or collection of uncertainty data. You can get it from:

```
/content/files/wp-content/uploads/2023/06/wui_data.xlsx
```

The learning goals for this week include breaking up date information, multi-indexes, method chaining, lambda and assign, and plotting.

Here are my seven tasks and questions for this week:

- Read tab T1 into a data frame. Turn the "Year" column into a multi-index consisting of the year and quarter, both integers, and also remove the original "Year" column. Also: Do it all in a single, chained query starting with a call to "read\_excel".
- Which of the final five columns (comparing regions) currently has the greatest uncertainty? Does this strike you as a reasonable region to be the most uncertain in the world? Looking at the absolute numbers, what do you see with the measurement?
- Now read tab T2 into a data frame, again turning the year into a multi-index containing both year and quarter as integers, and again doing it all in a single, chained query starting with a call to "read\_excel". What 10 countries had the greatest degree of uncertainty 10 years ago, in 2013 q2? What 10 countries have the greatest degree of uncertainty according to the latest data, in 2023 q2?
- What countries, if any, were in the top-10 uncertain in both 2013 q2 and 2023 q2?
- Create a line graph showing the mean uncertainty score per year for Israel, Taiwan, the US, and UK. Which two countries have the highest uncertainty scores? Which has the lowest?
- Load the data from tab T7 into a data frame. Use the data there to repeat our graph, but with country names rather than abbreviations.
- Does any quarter have a clearly higher or lower uncertainty rate than the others? Let's find out by loading sheet F1 into a data frame. We only need the quarter number and the WUI score. Find the mean per quarter, across all years. Does any of them have a clearly higher or lower value?

I’ll be back tomorrow with my detailed answers. Meanwhile, if you have any questions or comments, share them with us here!

Reuven