search

jsoma / data-studio-projects

12 stars 18 forks source link

Iran_Import_Data [project] #5

Closed deniseajiri83 closed 7 years ago

deniseajiri83 commented 7 years ago

Please complete all of the following sections, or a robot will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1

Pitch

Mapping Iran's import in a specific year (ideally for the course of 7 years)

Summary

I would like to visualize Iran's exporting trend for 7 years (20- 2015). As the economic sanctions hit Iran in 2010, due to banking hurdles, Iran was forced to shift to new suppliers, mostly non-Western.

Details

During the sanctions, due to economic and banking hurdles, Iran was forced to find new suppliers. My assumption is that this changed the whole import trend in Iran. For example if Germany was one of their main suppliers of pharmaceuticals, during the sanction they had to look for new suppliers, including China and India.

I want to see:

Possible headline(s): Iran on the look out for new suppliers as sanctions kick in sanctions pushes Iran to change it's trade habit

Data set(s): I have xls files downloaded from the customs office and Tehran Chamber of Commerce: http://www.tccim.ir/ImpExpStats.aspx?slcImpExp=Import&slcCountry=&sYear=1391&mode=doit

Code repository: https://github.com/deniseajiri83/studio-projects

Possible problems/fears/questions: Sometimes I have problems downloading files. And sometimes Python isn't able to read Persian files.

screen shot 2017-07-16 at 19 54 29

Work so far

Just typing some stuff in here for you so the bot doesn't yell at you.

Checklist

This checklist must be completed before you submit your draft.

wonderfulexperience commented 7 years ago

I think it would be great to focus on certain products and trading partners. Sanctions affected trading patterns probably in a certain way which should be highlighted in that story.

maijaliisa commented 7 years ago

Excited to see what you find! I would suggest narrowing down to one or two import industries as we discussed. I am excited to see if you can map/graph change over time before/after the sanctions

SYChJung commented 7 years ago

I think it is really interesting. Korea buy most of its oil from Iran and was affected by the sanction

deniseajiri83 commented 7 years ago

Update

Content

In June 2010, in response to Iran's nuclear program, the UN's Security Council imposed economic sanctions on Iran. These set of sanctions were followed by EU sanctions in October 2010, and a round of US sanctions (September 2010, May 2011 and November 2011). As a result Iran faced many banking hurdles/restrictions. The sanctions showed it's effect in late 2012 and Iran's imports, including the import of pharmaceuticals dropped.

screen shot 2017-07-20 at 21 24 42

‌‌Between 2012-2013 there were reports on the lack of medicine in Iran. In November 2012 Iran media reported on a death of a Haemophiliac Iranian boy due to the shortage of medicine in Iran.

Prior to sanctions, Iran's main pharmaceutical suppliers were the European countries and the USA. But after the sanctions were imposed, things gradually began to change.

screen shot 2017-07-20 at 21 52 04 screen shot 2017-07-20 at 21 54 54

As the imports from Switzerland, Germany, and France (Iran's three main suppliers) started to drop, imports from UAE, Turkey and India began to rise.

screen shot 2017-07-20 at 21 56 23

screen shot 2017-07-20 at 21 56 49

screen shot 2017-07-20 at 21 57 06

On the other hand, new suppliers lined up to take over, including Oman, Georgia, Egypt, Qatar, Bulgaria, Czechia, Russia and Tajikistan. [I HAVE BAR CHARTS FOR EACH, BUT WASN'T ABLE TO PUT THEM ON TOP OF EACH OTHER]

In 2013 Iranian ministry of health warned about the bad quality of medicine, especially anesthetics, in the market adding that every week a number of patients die from low-quality anesthetics.

At that's not all. Besides the International hurdles, Iran also didn't help solve the issue, but added to the problem. From March 2012 to July 2013, Iran’s Central Bank made available an undisclosed amount of US dollars at a highly subsidised rate of 12,260 rials to pay for the imports of vital goods, especially food and medicine, but as the ministry of health scrambled for supplies, Custom documents show that Iran spent subsidised dollars on luxury goods, including cars.

In the end the economic uncertainty in Iran not only changed Iran's import trend, but also had irrecoverable consequences on Iranian patients.

Any changes in direction or topic?

I just narrowed it down to pharmaceuticals.

Problems/Questions

I am not sure if I can prove my hypothesis without interviewing people. This data by itself is not that interesting. It doesn't really tell a story.

Checklist

playfairbot commented 7 years ago

Greetings! This is the Playfair Bot, let's take a peek.

Please post your project draft! It should be posted by Friday. More details available here. If you posted one but I'm not seeing it, make sure you followed the template.

ElisaHarlan commented 7 years ago

Very interesting topic ! Visualization: Could also imagine to do a map with flows between the countries.

wonderfulexperience commented 7 years ago

Of course it would enhance the story if you would interview people. But I think just looking at the data, I find it interesting who was taking over from the former main suppliers. It is also interesting due to the human costs of imposing sanctions on a country.

SYChJung commented 7 years ago

How about looking for articles or something, and check the reactions. I think this way is easier than interviewing.

deniseajiri83 commented 7 years ago

Update

I have changed the graphs a little bit.

Content

Between 2010-2012 the West set a round of economic sanctions against Iran's nuclear program which caused a disruption in import of pharmaceuticals in Iran. As the main Western European suppliers were struggling to resume their exports to Iran, the pharmaceutical market opened for new suppliers.

med

In June 2010, in response to Iran's nuclear program, the UN's Security Council imposed economic sanctions on Iran. These set of sanctions were followed by EU sanctions in October 2010, and a round of US sanctions in September 2010, May 2011 and November 2011. As a result Iran faced many banking restrictions. The sanctions showed its effect in late 2012 and Iran's imports, including the import of pharmaceuticals dropped.

1

‌‌Between 2012-2013 there were reports on the lack of medicine in Iran. Former main suppliers were having difficulties to resume their business in Iran, therefore Iran had to look for other suppliers.

Prior to sanctions, Iran's main pharmaceutical suppliers were the European countries. But after the sanctions, things gradually began to change as Iran was forced to find new suppliers. As the imports from Iran's three main suppliers- Switzerland, Germany, and France- started to drop, The market opened for other suppliers, including UAE, Turkey and India, to play a bigger part in Iran's pharmaceuticals market.

allline

swfrger

inturuae

The sanctions not only created more opportunities for countries that were already involved in business with Iran, but, on a smaller scale, it opened the market for new temporary suppliers from the Arab world and the Eastern block.

Some suppliers entered the market temporarily;

temp

And some entered the market to stay;

sdsdsd

Iran and the world powers reached a nuclear deal in 2015. As a result some of the economic sanctions against Iran were lifter. Now as Iran's pharmaceutical market is gradually recovering, the western European countries that used to dominate the market, are not alone anymore.

Any changes in direction or topic?

Previously I was all over the place with what I really want to talk about. Now I think I have been able to narrow it down to two main points: - who were Iran's new suppliers during the sanctions? - Were they temporary suppliers or are they still doing business with Iran?

Problems/Questions

  1. When we look at the graph on the import of pharmaceuticals in Iran, there is a fast rise in 2012 (right before the stories on the lack of medicine in Iran emerges. What is that sudden rise for? Medicine has a shelf life so it doesn't make sense to import too much of medicine ahead of time. I have an idea: in 2015 I wrote a story about how Iranian importers illegally used the pharmaceutical budget to import cars while pretending that they were importing medicine. So I assume the rise is related to the import of cars.

  2. Charts without the human element are not interesting. I can't see how I can have a well-balanced interesting story without being able to interview people.

Checklist