jsoma / data-studio-projects

12 stars 18 forks source link

North Korea Missile Launches [Project] #24

Closed amandolinjames closed 6 years ago

amandolinjames 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

Summary

North Korea since 1984, how far the traveled, where they left from, and what kind of missile it was. I'd like to map the number of missiles by decade on separate maps for the 1980s-current, and see if the number of missiles by decade has increased.

Details

This graph is a bit hard to see because the labels are so small. The x-axis is the name of the facility where the missile was launched from. The y-axis shows the number of missiles launched from that facility. Possible headline(s): Rate of North Korea Missile Launches Accelerating Data set(s): http://www.nti.org/analysis/articles/cns-north-korea-missile-test-database/ Code repository: https://github.com/amandolinjames/Data-Studio/tree/master/

Possible problems/fears/questions: I want to create bubble sizes on the map that are larger by number of missiles launched at each facility, but I don't know how to increase the bubble or buffer size, so I need to research this skill. I also will have to use regular expressions to look at the dates, which is somewhat difficult.

Work so far

Checklist

This checklist must be completed before you submit your draft.

Update

Content

screen shot 2017-07-20 at 7 25 43 pm

Any changes in direction or topic?

I chose to make a chart instead of a map when I realized that looking at the apogee was more interesting than the distance. I used annotation to help tell the story.

Problems/Questions

I had some challenges uploading the dataset because of the high number of NaN values, and 'error rows' but once this issue was fixed with the right code, it was easy to work with this dataset.

Update Code Repository

https://github.com/amandolinjames/Data-Studio/blob/master/Code/North-Korea/North-Korea.ipynb

Checklist

RodrigoMenegat commented 7 years ago
cathrinesot commented 7 years ago

Very interesting !!! I like it very much! Can't wait to see your map! If you do a leaflet map I would suggest you try a satellite layout !!

playfairbot commented 7 years ago

Hi! This is the Playfair Bot, here for a surprise inspection.

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.

sarahslo commented 7 years ago

This is very interesting data, something I was curious to see. You know what I want to know? What are the total number of missiles launched each year. You could simply add a count number below the chart because sometimes when the heigh overlaps we can see them.

I will help with this is class, but think of labeling as an object and not as type. The more consistent you make the shape of the typography and cleaner it will look. We try to do what is called, 'squaring the type.'

Wondering if there was a layer of information that could have been added here. I doubt the data tells us if there were successes vs failures, but if there were other categories that you could surface that might have been an interesting addition.

I wonder about all the missing data...One thing you could do whenever you have a time series is turn it into chapters. Who was the leader over time? When you add this for context it helps us know what is going on. Maybe the missing data are because it was a particularly repressive moment for the regime.

Excellent start. Glad you changed tactics with charting.