BW #5: Ukrainian exports (solution)

This week, the world marks the first anniversary of Russia's invasion of Ukraine. Despite the war, how much is Ukraine successfully exporting? And who is receiving those products?

This week’s topic: Ukrainian exports

This week, we looked at various aspects of Ukraine’s agricultural exports in the wake of the Russian invasion, as well as the Black Sea Grain Initiative that allows products to be sent to other countries.

The URL to download the data in Excel format is:

https://docs.google.com/spreadsheets/d/e/2PACX-1vRisnQjodySbp6-XXPGhdsVMp2stg_gyuxw42pP41tuxeic63IARau6bV1TgjLiw_ciAWsTO5LarPqT/pub?output=xlsx

Here is what I asked you to do:

1. Read the Excel data into a data frame. Again, the “Data” sheet is what interests us.

2. Create a pivot table, showing how many tons of each commodity (rows) have left each port (columns).

3. Create a pivot table, showing how many tons of each commodity (columns) were going to each destination country (rows).

4. The worry was that lower-income countries would not have enough food to eat, because of the war. According to the data's "income group," what proportion of the grain are low-income countries receiving?

5. Have we seen growth in the total tonnage shipped each month to developing countries?

6. Finally, what 10 flags are most commonly used on the ships coming from Ukraine? Do any country's names appear more than once? If so, why, and how can you fix it?