{ "cells": [ { "cell_type": "markdown", "id": "33b02c16-447c-497d-b0fc-39cab084af0a", "metadata": {}, "source": [ "# 1、导入包" ] }, { "cell_type": "code", "execution_count": 2, "id": "d9a05e4e-4f8d-4814-b5ab-e2120e5ef6d6", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "from matplotlib import pyplot as plt" ] }, { "cell_type": "markdown", "id": "58b2d584-c70d-4621-8f4a-30e4ee5f3790", "metadata": {}, "source": [ "# 2、读取数据" ] }, { "cell_type": "code", "execution_count": 3, "id": "05d009cc-a927-49e5-afc3-73459653c3da", "metadata": {}, "outputs": [], "source": [ "terrorism_data = pd.read_excel(\"附件1.xlsx\",sheet_name='Data')" ] }, { "cell_type": "code", "execution_count": 4, "id": "bf99b07d-11cb-4c48-90a2-782b6eb2e534", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | eventid | \n", "iyear | \n", "imonth | \n", "iday | \n", "approxdate | \n", "extended | \n", "resolution | \n", "country | \n", "country_txt | \n", "region | \n", "... | \n", "addnotes | \n", "scite1 | \n", "scite2 | \n", "scite3 | \n", "dbsource | \n", "INT_LOG | \n", "INT_IDEO | \n", "INT_MISC | \n", "INT_ANY | \n", "related | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "199801010001 | \n", "1998 | \n", "1 | \n", "1 | \n", "NaN | \n", "0 | \n", "NaT | \n", "34 | \n", "Burundi | \n", "11 | \n", "... | \n", "NaN | \n", "“Burundi Rebels, Ex-Rwandan Army Soldiers Blam... | \n", "“Burundi--Attack Reported on Bujumbura Airport... | \n", "NaN | \n", "CETIS | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "
| 1 | \n", "199801010002 | \n", "1998 | \n", "1 | \n", "1 | \n", "NaN | \n", "0 | \n", "NaT | \n", "167 | \n", "Russia | \n", "9 | \n", "... | \n", "NaN | \n", "“Bomb injures 3 in Moscow subway system,” The ... | \n", "“Bomb injures 3 in Moscow subway,” Charleston ... | \n", "“Bomb Injures 3 Workers in Moscow Metro,” Los ... | \n", "CETIS | \n", "-9 | \n", "-9 | \n", "0 | \n", "-9 | \n", "NaN | \n", "
| 2 | \n", "199801010003 | \n", "1998 | \n", "1 | \n", "1 | \n", "NaN | \n", "0 | \n", "NaT | \n", "603 | \n", "United Kingdom | \n", "8 | \n", "... | \n", "NaN | \n", "“Protestant gunmen kill Catholic in New Year's... | \n", "“Ulster Peace Shattered by Shooting: Catholic ... | \n", "NaN | \n", "CETIS | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "NaN | \n", "
| 3 | \n", "199801020001 | \n", "1998 | \n", "1 | \n", "2 | \n", "NaN | \n", "0 | \n", "NaT | \n", "95 | \n", "Iraq | \n", "10 | \n", "... | \n", "NaN | \n", "“Iraq Condemns Attack on UNSCOM Baghdad Office... | \n", "Farouk Choukri , “Iraq, UN Officials Continue ... | \n", "“Iraqi Interior Minister on UNSCOM Attack, Kuw... | \n", "CETIS | \n", "-9 | \n", "-9 | \n", "1 | \n", "1 | \n", "NaN | \n", "
| 4 | \n", "199801020002 | \n", "1998 | \n", "1 | \n", "2 | \n", "NaN | \n", "0 | \n", "NaT | \n", "155 | \n", "West Bank and Gaza Strip | \n", "10 | \n", "... | \n", "NaN | \n", "“Woman Shot,” The Philadelphia Inquirer, Janua... | \n", "“Israeli Woman Critically Hurt by Gunfire in W... | \n", "NaN | \n", "CETIS | \n", "-9 | \n", "-9 | \n", "0 | \n", "-9 | \n", "NaN | \n", "
5 rows × 135 columns
\n", "| \n", " | extended | \n", "crit1 | \n", "crit2 | \n", "crit3 | \n", "doubtterr | \n", "multiple | \n", "success | \n", "suicide | \n", "guncertain1 | \n", "claimed | \n", "... | \n", "propvalue | \n", "nhostkid | \n", "nreleased | \n", "ransom | \n", "region | \n", "attacktype1 | \n", "targtype1 | \n", "natlty1 | \n", "weaptype1 | \n", "hostkidoutcome | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "11 | \n", "2 | \n", "4 | \n", "34.0 | \n", "5 | \n", "NaN | \n", "
| 1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "9 | \n", "3 | \n", "19 | \n", "167.0 | \n", "6 | \n", "NaN | \n", "
| 2 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "1 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "8 | \n", "2 | \n", "14 | \n", "233.0 | \n", "5 | \n", "NaN | \n", "
| 3 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "10 | \n", "3 | \n", "7 | \n", "999.0 | \n", "6 | \n", "NaN | \n", "
| 4 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "10 | \n", "2 | \n", "14 | \n", "97.0 | \n", "5 | \n", "NaN | \n", "
5 rows × 28 columns
\n", "| \n", " | extended | \n", "crit1 | \n", "crit2 | \n", "crit3 | \n", "doubtterr | \n", "multiple | \n", "success | \n", "suicide | \n", "guncertain1 | \n", "claimed | \n", "... | \n", "propvalue | \n", "region | \n", "attacktype1 | \n", "targtype1 | \n", "natlty1 | \n", "weaptype1 | \n", "nhostkidisnull | \n", "ransomisnull | \n", "hostkidoutcomeisnull | \n", "nreleasedisnull | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "11 | \n", "2 | \n", "4 | \n", "34.0 | \n", "5 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "9 | \n", "3 | \n", "19 | \n", "167.0 | \n", "6 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 2 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "1 | \n", "... | \n", "37661.190113 | \n", "8 | \n", "2 | \n", "14 | \n", "233.0 | \n", "5 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 3 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "10 | \n", "3 | \n", "7 | \n", "999.0 | \n", "6 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 4 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "10 | \n", "2 | \n", "14 | \n", "97.0 | \n", "5 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 5 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "1.0 | \n", "1 | \n", "0 | \n", "1.0 | \n", "1 | \n", "... | \n", "37661.190113 | \n", "9 | \n", "3 | \n", "3 | \n", "118.0 | \n", "6 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 6 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "1.0 | \n", "1 | \n", "0 | \n", "1.0 | \n", "1 | \n", "... | \n", "37661.190113 | \n", "9 | \n", "3 | \n", "3 | \n", "118.0 | \n", "6 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 7 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "8 | \n", "3 | \n", "3 | \n", "15.0 | \n", "6 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 8 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "1.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "3 | \n", "3 | \n", "10 | \n", "86.0 | \n", "6 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
| 9 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0.0 | \n", "1.0 | \n", "1 | \n", "0 | \n", "0.0 | \n", "0 | \n", "... | \n", "37661.190113 | \n", "11 | \n", "2 | \n", "14 | \n", "168.0 | \n", "5 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
10 rows × 28 columns
\n", "| \n", " | extended | \n", "crit1 | \n", "crit2 | \n", "crit3 | \n", "doubtterr | \n", "multiple | \n", "success | \n", "suicide | \n", "guncertain1 | \n", "claimed | \n", "... | \n", "propvalue | \n", "region | \n", "attacktype1 | \n", "targtype1 | \n", "natlty1 | \n", "weaptype1 | \n", "nhostkidisnull | \n", "ransomisnull | \n", "hostkidoutcomeisnull | \n", "nreleasedisnull | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "... | \n", "1.141830e+05 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "114183.000000 | \n", "
| mean | \n", "0.060736 | \n", "0.989324 | \n", "0.995586 | \n", "0.878791 | \n", "0.161777 | \n", "0.157958 | \n", "0.873869 | \n", "0.057198 | \n", "0.104057 | \n", "0.163378 | \n", "... | \n", "3.766119e+04 | \n", "8.024548 | \n", "3.343168 | \n", "8.752310 | \n", "127.688838 | \n", "6.391179 | \n", "0.918105 | \n", "0.910144 | \n", "0.918219 | \n", "0.920251 | \n", "
| std | \n", "0.238846 | \n", "0.102771 | \n", "0.066291 | \n", "0.326371 | \n", "0.368246 | \n", "0.364702 | \n", "0.331998 | \n", "0.232221 | \n", "0.304827 | \n", "0.369712 | \n", "... | \n", "1.173638e+06 | \n", "2.370121 | \n", "1.860464 | \n", "6.527255 | \n", "95.804500 | \n", "2.070908 | \n", "0.274206 | \n", "0.285976 | \n", "0.274032 | \n", "0.270906 | \n", "
| min | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000e+00 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "4.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
| 25% | \n", "0.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "3.154510e+03 | \n", "6.000000 | \n", "2.000000 | \n", "3.000000 | \n", "92.000000 | \n", "5.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "
| 50% | \n", "0.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "3.766119e+04 | \n", "9.000000 | \n", "3.000000 | \n", "4.000000 | \n", "97.000000 | \n", "6.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "
| 75% | \n", "0.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "3.766119e+04 | \n", "10.000000 | \n", "3.000000 | \n", "14.000000 | \n", "160.000000 | \n", "6.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "
| max | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "... | \n", "3.500000e+08 | \n", "12.000000 | \n", "9.000000 | \n", "22.000000 | \n", "1004.000000 | \n", "13.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "1.000000 | \n", "
8 rows × 28 columns
\n", "| \n", " | extended | \n", "crit1 | \n", "crit2 | \n", "crit3 | \n", "doubtterr | \n", "multiple | \n", "success | \n", "suicide | \n", "guncertain1 | \n", "claimed | \n", "... | \n", "propvalue | \n", "region | \n", "attacktype1 | \n", "targtype1 | \n", "natlty1 | \n", "weaptype1 | \n", "nhostkidisnull | \n", "ransomisnull | \n", "hostkidoutcomeisnull | \n", "nreleasedisnull | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "2.276259 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "6.199490e-18 | \n", "1.255401 | \n", "-0.721953 | \n", "-0.728072 | \n", "-0.977917 | \n", "-0.671773 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 1 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "6.199490e-18 | \n", "0.411562 | \n", "-0.184453 | \n", "1.569985 | \n", "0.410327 | \n", "-0.188893 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 2 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "2.262902 | \n", "... | \n", "6.199490e-18 | \n", "-0.010357 | \n", "-0.721953 | \n", "0.803966 | \n", "1.099230 | \n", "-0.671773 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 3 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "6.199490e-18 | \n", "0.833481 | \n", "-0.184453 | \n", "-0.268460 | \n", "9.094679 | \n", "-0.188893 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 4 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "-2.632150 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "6.199490e-18 | \n", "0.833481 | \n", "-0.721953 | \n", "0.803966 | \n", "-0.320328 | \n", "-0.671773 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 114178 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "-2.692611 | \n", "2.276259 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "2.262902 | \n", "... | \n", "6.199490e-18 | \n", "1.255401 | \n", "-0.721953 | \n", "-0.728072 | \n", "0.566896 | \n", "-0.671773 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 114179 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "-2.692611 | \n", "2.276259 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "-3.208927e-02 | \n", "0.833481 | \n", "-0.184453 | \n", "-0.728072 | \n", "0.410327 | \n", "-0.188893 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 114180 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "0.379914 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "-3.208927e-02 | \n", "-1.276116 | \n", "1.965548 | \n", "0.803966 | \n", "0.337261 | \n", "0.776868 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 114181 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "-2.632150 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "6.199490e-18 | \n", "-0.854196 | \n", "-0.184453 | \n", "-1.034479 | \n", "-0.372517 | \n", "-0.188893 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
| 114182 | \n", "-0.254289 | \n", "0.10388 | \n", "0.066585 | \n", "0.371383 | \n", "-0.439317 | \n", "-0.433116 | \n", "-2.632150 | \n", "-0.246307 | \n", "-0.341364 | \n", "-0.441906 | \n", "... | \n", "6.199490e-18 | \n", "-1.276116 | \n", "-0.184453 | \n", "1.723188 | \n", "0.337261 | \n", "-0.188893 | \n", "0.298662 | \n", "0.314207 | \n", "0.298436 | \n", "0.29438 | \n", "
114183 rows × 28 columns
\n", "| \n", " | eventid | \n", "iyear | \n", "imonth | \n", "iday | \n", "approxdate | \n", "extended | \n", "resolution | \n", "country | \n", "country_txt | \n", "region | \n", "... | \n", "addnotes | \n", "scite1 | \n", "scite2 | \n", "scite3 | \n", "dbsource | \n", "INT_LOG | \n", "INT_IDEO | \n", "INT_MISC | \n", "INT_ANY | \n", "related | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4968 | \n", "200107240001 | \n", "2001 | \n", "7 | \n", "24 | \n", "NaN | \n", "0 | \n", "NaT | \n", "186 | \n", "Sri Lanka | \n", "6 | \n", "... | \n", "NaN | \n", "Peter Foster, Richard Allyne, Vilma Wimaladasa... | \n", "\"Tamil Tigers hit Sri Lanka airport; Suicide b... | \n", "\"Attack on airbase, airport leaves 14 dead, 13... | \n", "CETIS | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "NaN | \n", "
| 5619 | \n", "200109110004 | \n", "2001 | \n", "9 | \n", "11 | \n", "NaN | \n", "0 | \n", "NaT | \n", "217 | \n", "United States | \n", "1 | \n", "... | \n", "This attack was one of four related incidents ... | \n", "United States Government, The 9/11 Commission ... | \n", "Lindsay Kines, “United States on high alert af... | \n", "Joe Frolick, “Hijackers Ram Two Airliners Into... | \n", "CETIS | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "200109110004, 200109110005, 200109110006, 2001... | \n", "
| 5620 | \n", "200109110005 | \n", "2001 | \n", "9 | \n", "11 | \n", "NaN | \n", "0 | \n", "NaT | \n", "217 | \n", "United States | \n", "1 | \n", "... | \n", "This attack was one of four related incidents ... | \n", "United States Government, The 9/11 Commission ... | \n", "Lindsay Kines, “United States on high alert af... | \n", "Joe Frolick, “Hijackers Ram Two Airliners Into... | \n", "CETIS | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "200109110005, 200109110004, 200109110006, 2001... | \n", "
| 8840 | \n", "200403210001 | \n", "2004 | \n", "3 | \n", "21 | \n", "NaN | \n", "0 | \n", "NaT | \n", "141 | \n", "Nepal | \n", "6 | \n", "... | \n", "The Agence France Presse reported that there w... | \n", "Kedar Man Sing, “2 Deadly clashes in Nepal as ... | \n", "“AFP: Clashes in Nepal Reportedly Leave 500 Ma... | \n", "NaN | \n", "CETIS | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
| 69238 | \n", "201408200027 | \n", "2014 | \n", "8 | \n", "19 | \n", "NaN | \n", "1 | \n", "NaT | \n", "200 | \n", "Syria | \n", "10 | \n", "... | \n", "NaN | \n", "\"IS 'kills dozens of Syrian soldiers',\" BBC, A... | \n", "\"Islamic State group seizes Syrian air base,\" ... | \n", "\"IS steps up attack on last Syria army bas... | \n", "START Primary Collection | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "
| 66010 | \n", "201406150063 | \n", "2014 | \n", "6 | \n", "12 | \n", "NaN | \n", "1 | \n", "NaT | \n", "95 | \n", "Iraq | \n", "10 | \n", "... | \n", "Casualty numbers for this incident conflict ac... | \n", "\"Iraq exhumes 470 bodies of 'ISIL massacre vic... | \n", "\"Scene of Iraqi Massacre Becomes Shiite Pilgri... | \n", "\"Iraq Empties Mass Graves in Search for Cadets... | \n", "START Primary Collection | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "
| 102690 | \n", "201612100011 | \n", "2016 | \n", "12 | \n", "10 | \n", "NaN | \n", "1 | \n", "NaT | \n", "200 | \n", "Syria | \n", "10 | \n", "... | \n", "NaN | \n", "\"IS Kills 12 People in Historic Syrian City of... | \n", "\"Russian military explain how Palmyra was reta... | \n", "\"Islamic State militants return to Syria's anc... | \n", "START Primary Collection | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "
| 82 | \n", "199802010001 | \n", "1998 | \n", "2 | \n", "1 | \n", "NaN | \n", "0 | \n", "NaT | \n", "186 | \n", "Sri Lanka | \n", "6 | \n", "... | \n", "NaN | \n", "“300 rebels reported killed in Sri Lanka: 'Rin... | \n", "“Asia: Heavy Fighting Grips Sri Lanka, Toll hi... | \n", "“Asia: Sri Lankan Army Claims 220 Rebels Dead,... | \n", "CETIS | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
| 91580 | \n", "201602180049 | \n", "2016 | \n", "2 | \n", "17 | \n", "NaN | \n", "0 | \n", "NaT | \n", "209 | \n", "Turkey | \n", "10 | \n", "... | \n", "NaN | \n", "\"PKK attack on oil pipeline cost KRG $100mn: S... | \n", "\"BRIEF: Oil pipeline blown up in Turkey [Trend... | \n", "NaN | \n", "START Primary Collection | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
| 73834 | \n", "201412070129 | \n", "2014 | \n", "12 | \n", "7 | \n", "NaN | \n", "0 | \n", "NaT | \n", "217 | \n", "United States | \n", "1 | \n", "... | \n", "NaN | \n", "\"Man Convicted of Starting Massive Da Vinci Fi... | \n", "\"Man Pleads Guilty, Gets 15 Years In Prison Fo... | \n", "\"Man accused of Da Vinci apartment arson was a... | \n", "START Primary Collection | \n", "-9 | \n", "-9 | \n", "0 | \n", "-9 | \n", "NaN | \n", "
10 rows × 135 columns
\n", "| \n", " | eventid | \n", "iyear | \n", "imonth | \n", "iday | \n", "approxdate | \n", "extended | \n", "resolution | \n", "country | \n", "country_txt | \n", "region | \n", "... | \n", "addnotes | \n", "scite1 | \n", "scite2 | \n", "scite3 | \n", "dbsource | \n", "INT_LOG | \n", "INT_IDEO | \n", "INT_MISC | \n", "INT_ANY | \n", "related | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4968 | \n", "200107240001 | \n", "2001 | \n", "7 | \n", "24 | \n", "NaN | \n", "0 | \n", "NaT | \n", "186 | \n", "Sri Lanka | \n", "6 | \n", "... | \n", "NaN | \n", "Peter Foster, Richard Allyne, Vilma Wimaladasa... | \n", "\"Tamil Tigers hit Sri Lanka airport; Suicide b... | \n", "\"Attack on airbase, airport leaves 14 dead, 13... | \n", "CETIS | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "NaN | \n", "
| 5619 | \n", "200109110004 | \n", "2001 | \n", "9 | \n", "11 | \n", "NaN | \n", "0 | \n", "NaT | \n", "217 | \n", "United States | \n", "1 | \n", "... | \n", "This attack was one of four related incidents ... | \n", "United States Government, The 9/11 Commission ... | \n", "Lindsay Kines, “United States on high alert af... | \n", "Joe Frolick, “Hijackers Ram Two Airliners Into... | \n", "CETIS | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "200109110004, 200109110005, 200109110006, 2001... | \n", "
| 5620 | \n", "200109110005 | \n", "2001 | \n", "9 | \n", "11 | \n", "NaN | \n", "0 | \n", "NaT | \n", "217 | \n", "United States | \n", "1 | \n", "... | \n", "This attack was one of four related incidents ... | \n", "United States Government, The 9/11 Commission ... | \n", "Lindsay Kines, “United States on high alert af... | \n", "Joe Frolick, “Hijackers Ram Two Airliners Into... | \n", "CETIS | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "200109110005, 200109110004, 200109110006, 2001... | \n", "
| 8840 | \n", "200403210001 | \n", "2004 | \n", "3 | \n", "21 | \n", "NaN | \n", "0 | \n", "NaT | \n", "141 | \n", "Nepal | \n", "6 | \n", "... | \n", "The Agence France Presse reported that there w... | \n", "Kedar Man Sing, “2 Deadly clashes in Nepal as ... | \n", "“AFP: Clashes in Nepal Reportedly Leave 500 Ma... | \n", "NaN | \n", "CETIS | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
| 91580 | \n", "201602180049 | \n", "2016 | \n", "2 | \n", "17 | \n", "NaN | \n", "0 | \n", "NaT | \n", "209 | \n", "Turkey | \n", "10 | \n", "... | \n", "NaN | \n", "\"PKK attack on oil pipeline cost KRG $100mn: S... | \n", "\"BRIEF: Oil pipeline blown up in Turkey [Trend... | \n", "NaN | \n", "START Primary Collection | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "
| 73834 | \n", "201412070129 | \n", "2014 | \n", "12 | \n", "7 | \n", "NaN | \n", "0 | \n", "NaT | \n", "217 | \n", "United States | \n", "1 | \n", "... | \n", "NaN | \n", "\"Man Convicted of Starting Massive Da Vinci Fi... | \n", "\"Man Pleads Guilty, Gets 15 Years In Prison Fo... | \n", "\"Man accused of Da Vinci apartment arson was a... | \n", "START Primary Collection | \n", "-9 | \n", "-9 | \n", "0 | \n", "-9 | \n", "NaN | \n", "
| 564 | \n", "199808070002 | \n", "1998 | \n", "8 | \n", "7 | \n", "NaN | \n", "0 | \n", "NaT | \n", "104 | \n", "Kenya | \n", "11 | \n", "... | \n", "NaN | \n", "Laura Myers, “U.S. promises to hit back if any... | \n", "“Kenya; New Twist in bomb Tragedy,” Africa New... | \n", "“Blast toll tops 200,” Evening Herald (Plymout... | \n", "CETIS | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "199808070002, 199808070003 | \n", "
| 6285 | \n", "200202150002 | \n", "2002 | \n", "2 | \n", "15 | \n", "NaN | \n", "0 | \n", "NaT | \n", "45 | \n", "Colombia | \n", "3 | \n", "... | \n", "NaN | \n", "“Two Bombs in Riohacha Cause Property Damage W... | \n", "“Highlights: Colombian Guerrilla/Paramilitary ... | \n", "NaN | \n", "CETIS | \n", "-9 | \n", "-9 | \n", "0 | \n", "-9 | \n", "NaN | \n", "
| 69379 | \n", "201408230034 | \n", "2014 | \n", "8 | \n", "23 | \n", "NaN | \n", "0 | \n", "NaT | \n", "200 | \n", "Syria | \n", "10 | \n", "... | \n", "Casualty numbers for this incident conflict ac... | \n", "\"Jihadists killed in new push to take Syria ai... | \n", "\"Third ISIL Attempt to Seize Tabaqa Airport Fa... | \n", "\"Syrian Army Inflict 'Heavy Losses' on ISIL at... | \n", "START Primary Collection | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "
| 96079 | \n", "201606120025 | \n", "2016 | \n", "6 | \n", "12 | \n", "NaN | \n", "0 | \n", "NaT | \n", "110 | \n", "Lebanon | \n", "10 | \n", "... | \n", "Casualty numbers for this incident conflict ac... | \n", "\"CCTV footage holds clues to bombing,\" The Dai... | \n", "\"Bomb explodes outside Lebanese Blom Bank in B... | \n", "\"Lebanon's interior minister says Beirut blast... | \n", "START Primary Collection | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "NaN | \n", "
10 rows × 135 columns
\n", "