In [1]:

    

## Print the working directory on this computer
pwd()


    

    
Out[1]:





"/Users/arindambose/Documents/julia"

In [4]:

    

## list the files in the working directory
readdir()


    

    
Out[4]:





13-element Array{ByteString,1}:
 ".ipynb_checkpoints"            
 "GTD-Export.csv"                
 "Tutorial.jl"                   
 "cofreewy.txt"                  
 "health.csv"                    
 "juliamaterials.ipynb"          
 "learnJlsanders.ipynb"          
 "learning.jl"                   
 "learningJulia.ipynb"           
 "myplot.png"                    
 "terrorism-analysis-julia.ipynb"
 "testing.jl"                    
 "tryingjulia.ipynb"             

In [15]:

    

## read the GTD-export.csv file and import to a data frame. 
# Load the DataFrames package, Distributions pakage, and HypothesisTests package
using DataFrames, Distributions, HypothesisTests, StatsBase, StatsFuns

mydata = DataFrame(readcsv("GTD-Export.csv"))

## Simple preprocessing data
## we now need to delete the second row
## we also will rename the x1 ... x7

## First rename the variables

mydata = rename!(mydata, Dict(:x1 => :Gtdid,
:x2=>:Date, :x3=>:country, :x4=>:city, 
:x5=>:perpetrator, :x11=>:fatalities, 
:x12=>:injured, :x17=>:attacktype,
:x20=>:weapon))

## next, remove the row 1 from the data set

mydata = deleterows!(mydata, 1)

## next, we remove the unwanted columns x6..x10, x13...x16,
## x18, x19,x21...x24

mydata = delete!(mydata, [:x6, :x7, :x8, 
    :x9, :x10, :x13, :x14, :x15, :x16,
    :x18, :x19, :x21, :x22, :x23, :x24])


    

    
Out[15]:




Gtdid
Date
country
city
perpetrator
fatalities
injured
attacktype
weapon
1
201404090005
2014-04-09
Pakistan
Islamabad
United Baloch Army (UBA)
2
201403140027
2014-03-14
Pakistan
Saraband
Tehrik-i-Taliban Pakistan (TTP)
13
50
Bombing/Explosion
Explosives/Bombs/Dynamite
3
201401210002
2014-01-21
Pakistan
Mastung district
Lashkar-e-Jhangvi
30
31
Bombing/Explosion
Explosives/Bombs/Dynamite
4
201308080011
2013-08-08
Pakistan
Quetta
Tehrik-i-Taliban Pakistan (TTP)
39
50
Bombing/Explosion
Explosives/Bombs/Dynamite
5
201306300001
2013-06-30
Pakistan
Badaber
Tehrik-i-Taliban Pakistan (TTP)
20
50
Bombing/Explosion
Explosives/Bombs/Dynamite
6
201306180001
2013-06-18
Pakistan
Mardan
Unknown
35
43
Bombing/Explosion
Explosives/Bombs/Dynamite
7
201305120011
2013-05-12
Pakistan
Quetta
Lashkar-e-Jhangvi
11
76
Assassination
Explosives/Bombs/Dynamite
8
201305070004
2013-05-06
Pakistan
Parachinar
Tehrik-i-Taliban Pakistan (TTP)
23
70
Bombing/Explosion
Explosives/Bombs/Dynamite
9
201304290001
2013-04-29
Pakistan
Peshawar
Unknown
9
43
Bombing/Explosion
Explosives/Bombs/Dynamite
10
201304260001
2013-04-26
Pakistan
Karachi
Tehrik-i-Taliban Pakistan (TTP)
11
40
Bombing/Explosion
Explosives/Bombs/Dynamite
11
201304160003
2013-04-16
Pakistan
Peshawar
Tehrik-i-Taliban Pakistan (TTP)
18
60
Bombing/Explosion
Explosives/Bombs/Dynamite
12
201302210003
2013-02-21
India
Hyderabad
Lashkar-e-Taiba (LeT)
8
58
Bombing/Explosion
Explosives/Bombs/Dynamite
13
201302210002
2013-02-21
India
Hyderabad
Lashkar-e-Taiba (LeT)
8
58
Bombing/Explosion
Explosives/Bombs/Dynamite
14
201301100003
2013-01-10
Pakistan
Quetta
United Baloch Army (UBA)
12
50
Bombing/Explosion
Explosives/Bombs/Dynamite
15
201212150001
2012-12-15
Pakistan
Peshawar
Tehrik-i-Taliban Pakistan (TTP)
14
40
Bombing/Explosion
Explosives/Bombs/Dynamite
16
201211250001
2012-11-25
Pakistan
Dera Ismail Khan
Tehrik-i-Taliban Pakistan (TTP)
5
83
Bombing/Explosion
Explosives/Bombs/Dynamite
17
201211220001
2012-11-21
Pakistan
Rawalpindi
Tehrik-i-Taliban Pakistan (TTP)
25
62
Bombing/Explosion
Explosives/Bombs/Dynamite
18
201209100002
2012-09-10
Pakistan
Parachinar
Tehrik-i-Taliban Pakistan (TTP)
14
70
Bombing/Explosion
Explosives/Bombs/Dynamite
19
201206160002
2012-06-16
Pakistan
Landi Kotal
Unknown
25
50
Bombing/Explosion
Explosives/Bombs/Dynamite
20
201205140002
2012-05-14
Pakistan
Quetta
Baloch Republican Army (BRA)
6
58
Bombing/Explosion
Explosives/Bombs/Dynamite
21
201205040001
2012-05-04
Pakistan
Khar
Tehrik-i-Taliban Pakistan (TTP)
21
40
Bombing/Explosion
Explosives/Bombs/Dynamite
22
201203110007
2012-03-11
Pakistan
Badaber
Tehrik-i-Taliban Pakistan (TTP)
18
35
Bombing/Explosion
Explosives/Bombs/Dynamite
23
201201100002
2012-01-10
Pakistan
Jamrud
Tehrik-i-Taliban Pakistan (TTP)
35
60
Bombing/Explosion
Explosives/Bombs/Dynamite
24
201109200002
2011-09-20
Pakistan
Quetta
Lashkar-e-Jhangvi
26
30
Armed Assault
Firearms
25
201108200002
2011-08-20
Pakistan
Karachi
Unknown
8
50
Armed Assault
Firearms
26
201107130009
2011-07-13
India
Mumbai
Indian Mujahideen
7
44
Bombing/Explosion
Explosives/Bombs/Dynamite
27
201106110006
2011-06-11
Pakistan
Peshawar
Tehrik-i-Taliban Pakistan (TTP)
18
40
Bombing/Explosion
Explosives/Bombs/Dynamite
28
201106110005
2011-06-11
Pakistan
Peshawar
Tehrik-i-Taliban Pakistan (TTP)
18
40
Bombing/Explosion
Explosives/Bombs/Dynamite
29
201105030019
2011-05-03
India
Lohardaga
Communist Party of India - Maoist (CPI-Maoist)
11
40
Bombing/Explosion
Explosives/Bombs/Dynamite
30
201103090020
2011-03-09
Pakistan
Peshawar
Tehrik-i-Taliban Pakistan (TTP)
26
50
Bombing/Explosion
Explosives/Bombs/Dynamite
&vellip
&vellip
&vellip
&vellip
&vellip
&vellip
&vellip
&vellip
&vellip
&vellip

In [ ]:

    

myda