BW #1: Government corruption

Which countries are most (and least) corrupt? Which countries have improved the most in the last decade?

Welcome to Bamboo Weekly, my new publication that looks at the news via Pandas.

I’m still experimenting with the types of articles I’m going to write, the ways in which I’m going to share information, and the topics that I’m going to explore.

But about some things, I already have no doubt: I’m going to make a lot of mistakes, and I’ll depend on you to help me correct them. I’ll probably refer to some bad data, engage in bad analysis, and use Pandas in sub-optimal ways.

When (not if) this happens, please don’t hesitate to reach out and let me know! (Positive comments and general questions are also welcome, of course.) You can always reach me at reuven@lerner.co.il, or by replying to this message.

Bamboo Weekly is a reader-supported publication. To receive new posts and support my work, consider becoming a free or paid subscriber.

This week’s topic: Government corruption

Transparency International is a non-profit that tries to track how corrupt (or not) various governments are. They just came out with their rankings for 2022, and I’m happy to say that they made their data available.

For this week’s questions, you’ll need to download the data, which is available here: /content/files/images/cpi2022_globalresultstrends.xlsx

With that in hand, I’d like you to answer the following questions:

  • According to Transparency International, what five countries were least corrupt in 2022?
  • According to the same data, what five countries were most corrupt in 2022?