csci-4830-002-2014 / challenge-week-7

Name

write-your-name

How many points have you earned?

0/100

(Make your own calculation and replace the number 0 with the points you think you've earned.)

How many hours have you spent on this?

fill-in-your-answer

What is the most difficult part about this week's challenge?

fill-in-your-answer

Show and tell (10 points)

Link (2 points)

title-of-the-article

Explain why you found the project interesting. (8 points)

fill-in-your-answer

GDELT (I) (5 points x 6 + 20 points x 3 = 90 points)

Checkpoints

1 (5 points)

2 What types of questions do you think this database could provide insight into? (5 points)

fill-in-your-answer

3 (5 points)

4 (5 points)

5a (5 points)

5b Do you have any thoughts on why these events are missing geographic information? (5 points)

fill-in-your-answer

Challenges

1 (20 points)

{{one-paragraph-discussion-of-your-answer}}

2 (20 points)

3 (20 points)

{{one-paragraph-discussion-of-your-answer}}

challenge-week-7's Issues

Data import issue

A little too late, but I still couldn't quite get my tableau data imports working and was wondering if anyone had this problem (I read the other issues and they helped with some issues).

After header modifications, line 1 looks like this:

GLOBALEVENTID   SQLDATE MonthYear   Year    FractionDate    Actor1Code  Actor1Name  Actor1CountryCode   Actor1KnownGroupCode    Actor1EthnicCode    Actor1Religion1Code Actor1Religion2Code Actor1Type1Code Actor1Type2Code Actor1Type3Code Actor2Code  Actor2Name  Actor2CountryCode   Actor2KnownGroupCode    Actor2EthnicCode    Actor2Religion1Code Actor2Religion2Code Actor2Type1Code Actor2Type2Code Actor2Type3Code IsRootEvent EventCode   EventBaseCode   EventRootCode   QuadClass   GoldsteinScale  NumMentions NumSources  NumArticles AvgTone Actor1Geo_Type  Actor1Geo_FullName  Actor1Geo_CountryCode   Actor1Geo_ADM1Code  Actor1Geo_Lat   Actor1Geo_Long  Actor1Geo_FeatureID Actor2Geo_Type  Actor2Geo_FullName  Actor2Geo_CountryCode   Actor2Geo_ADM1Code  Actor2Geo_Lat   Actor2Geo_Long  Actor2Geo_FeatureID ActionGeo_Type  ActionGeo_FullName  ActionGeo_CountryCode   ActionGeo_ADM1Code  ActionGeo_Lat   ActionGeo_Long  ActionGeo_FeatureID DATEADDED   SOURCEURL

and line 2 looks like:

"314343478  20040919    200409  2004    2004.7096   AFR AFRICA  AFR                             CHN CHINA   CHN                             0   061 061 06  2   6.4 30  1   30  1.21802679658952    1   China   CH  CH  35  105 CH  1   China   CH  CH  35  105 CH  1   China   CH  CH  35  105 CH  20140917    http://one.trust.org/item/20140917114116-76mpv/?source=jtTheWire&c=sJbV8fYxw5s8A8rdz-4Zj2q769iZlGXfrJ50FsH9_bQ&mkt=en-us"                                                                                                                                                                                                                                   

Although Tableau is finding the field names, it isn't organizing the data into measurements and dimensions correctly and a lot of fields seem to just have null data (even when I try to manipulate it). I've looked at this for quite some time, so please let me know if you have any tips! Thanks.

Tableau is not recognizing the field names

When I extracted the raw data file into Tableau, Tableau did not recognize any of the field names. When I try to examine the export file in my terminal, I don't get the field names like I the assignment says I'm supposed to. Instead, I get the first row of actual data:

Is there something I'm missing? Should I go ahead and rename the fields in Tableau?

Is it cool if we do a BASH script for Challenge 2?

Seems like much more of a bash job than a JS one.

Dimensions and Measure Field Names Not in the Data Extract

I downloaded the previous days csv file, but when I import to data into tableau, the columns have no names. Do I have to manually name all the fields? The instructions for the checkpoint simply say to import the data. Would really appreciate some help. Thank You.

Fascinating Assignment! Issue with Checkpoint 5

I am looking at the graph provided by Checkpoint 5 and it seems to be listing all records as opposed to just ones with null values for longtitude. When I tried to find the null values in the dataset I got about 112 records, if yours is true, you seem to have 10,000s of null values which isn't the case for me.

How should I proceed with CP5?

Getting ActionGeo into a map

For some reason, ActionGeo will not allow me to throw it on a map. Any clues?

Tableau is not recognizing the field names

When I extracted the raw data file into Tableau, Tableau did not recognize any of the field names. Should I go ahead and rename all of the fields (is that part of the assignment) , or have I made a mistake in importing the file?

GDELT Page Not Found

When you click on the learning challenge unit to go to GDELT (I), it takes you to a 404 page.