experiments.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python2.7/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (40,41) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>SizeSectionHeader</th>\n",
       "      <th>...</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "      <th>labels</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>91124</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>292.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>982.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7f 45 4c 46 01 01 01 03 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1739776</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>12115.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7812.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>308.0</td>\n",
       "      <td>2867.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>193764</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>302.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>987.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>127116</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>407.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>74108</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>290.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>983.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Identification  MachineType  ELFVersion  \\\n",
       "0  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00  Intel 80386           1   \n",
       "1  7f 45 4c 46 01 01 01 03 00 00 00 00 00 00 00 00  Intel 80386           1   \n",
       "2  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00  Intel 80386           1   \n",
       "3  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00  Intel 80386           1   \n",
       "4  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00  Intel 80386           1   \n",
       "\n",
       "   ProgramHeaderOffset  SectionHeaderOffset  Flags  HeaderSize  \\\n",
       "0                   52                91124      0          52   \n",
       "1                   52              1739776      0          52   \n",
       "2                   52               193764      0          52   \n",
       "3                   52               127116      0          52   \n",
       "4                   52                74108      0          52   \n",
       "\n",
       "   SizeProgramHeader  EntriesProgram  SizeSectionHeader  ...        nop  \\\n",
       "0                 32               3                 40  ...      292.0   \n",
       "1                 32               5                 40  ...    12115.0   \n",
       "2                 32               3                 40  ...      302.0   \n",
       "3                 32               3                 40  ...      407.0   \n",
       "4                 32               3                 40  ...      290.0   \n",
       "\n",
       "   pushf rdtsc     sbb  setb  setle  shld    std   (bad) labels  \n",
       "0    4.0   0.0    30.0  26.0    1.0   2.0  178.0   982.0      M  \n",
       "1  376.0  10.0  7812.0  73.0   60.0  31.0  308.0  2867.0      M  \n",
       "2    9.0   0.0    42.0  31.0    1.0   2.0  181.0   987.0      M  \n",
       "3    1.0   0.0    28.0   6.0    1.0   0.0  183.0    63.0      M  \n",
       "4    1.0   0.0    50.0  15.0    0.0   2.0  186.0   983.0      M  \n",
       "\n",
       "[5 rows x 1066 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('final_postprocessing.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df = df.drop(['EntryPointAddress'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nominal_columns = ['Identification', 'MachineType', '.text_type', '.text_flags', '.bss_type', '.bss_flags', '.comment_type', '.comment_flags', '.data_type', '.data_flags', '.data1_type', '.data1_flags', '.dynamic_type', '.dynamic_flags', '.dynstr_type', '.dynstr_flags', '.dynsym_type', '.dynsym_flags', '.fini_type', '.fini_flags', '.hash_type', '.hash_flags', '.gnu.hash_type', '.gnu.hash_flags', '.init_type', '.init_flags', '.got_type', '.got_flags', '.interp_type', '.interp_flags', '.note_type', '.plt_type', '.plt_flags', '.rodata_type', '.rodata_flags', '.shstrtab_type', '.strtab_type', '.symtab_type', '.sdata_type', '.sdata_flags', '.sbss_type', '.sbss_flags', '.rel.dyn_type', '.rel.dyn_flags', '.rel.plt_type', '.rel.plt_flags', '.got.plt_type', '.got.plt_flags']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in nominal_columns:\n",
    "    df2[i] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3 = df2.groupby('labels', as_index=False).mean().round(0).iloc[[0]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>labels</th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>...</th>\n",
       "      <th>int</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>190483.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>312.0</td>\n",
       "      <td>912.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>2211.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  labels  Identification  MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "0      B             0.0          0.0         1.0                 64.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "0             190483.0    0.0        64.0               56.0             9.0   \n",
       "\n",
       "    ...      int    nop  pushf  rdtsc    sbb  setb  setle  shld    std   (bad)  \n",
       "0   ...    312.0  912.0   21.0    0.0  343.0   4.0    1.0   0.0  494.0  2211.0  \n",
       "\n",
       "[1 rows x 1066 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>labels</th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>...</th>\n",
       "      <th>int</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>190483.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>...</td>\n",
       "      <td>312.0</td>\n",
       "      <td>912.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>2211.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  labels Identification MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "0      B      <unknown>   <unknown>         1.0                 64.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "0             190483.0    0.0        64.0               56.0             9.0   \n",
       "\n",
       "    ...      int    nop  pushf rdtsc    sbb  setb  setle  shld    std   (bad)  \n",
       "0   ...    312.0  912.0   21.0   0.0  343.0   4.0    1.0   0.0  494.0  2211.0  \n",
       "\n",
       "[1 rows x 1066 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in nominal_columns:\n",
    "    df3[i] = '<unknown>'\n",
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df3.drop(['labels'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>SizeSectionHeader</th>\n",
       "      <th>...</th>\n",
       "      <th>int</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>190483.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>...</td>\n",
       "      <td>312.0</td>\n",
       "      <td>912.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>2211.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1065 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Identification MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "0      <unknown>   <unknown>         1.0                 64.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "0             190483.0    0.0        64.0               56.0             9.0   \n",
       "\n",
       "   SizeSectionHeader   ...      int    nop pushf rdtsc    sbb  setb  setle  \\\n",
       "0               64.0   ...    312.0  912.0  21.0   0.0  343.0   4.0    1.0   \n",
       "\n",
       "   shld    std   (bad)  \n",
       "0   0.0  494.0  2211.0  \n",
       "\n",
       "[1 rows x 1065 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df3['labels'] = 'B'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>SizeSectionHeader</th>\n",
       "      <th>...</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "      <th>labels</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>190483.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>...</td>\n",
       "      <td>912.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>2211.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Identification MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "0      <unknown>   <unknown>         1.0                 64.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "0             190483.0    0.0        64.0               56.0             9.0   \n",
       "\n",
       "   SizeSectionHeader  ...      nop  pushf rdtsc    sbb  setb  setle  shld  \\\n",
       "0               64.0  ...    912.0   21.0   0.0  343.0   4.0    1.0   0.0   \n",
       "\n",
       "     std   (bad) labels  \n",
       "0  494.0  2211.0      B  \n",
       "\n",
       "[1 rows x 1066 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>SizeSectionHeader</th>\n",
       "      <th>...</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "      <th>labels</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>91124</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>292.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>982.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7f 45 4c 46 01 01 01 03 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1739776</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>12115.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7812.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>308.0</td>\n",
       "      <td>2867.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>193764</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>302.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>181.0</td>\n",
       "      <td>987.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>127116</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>407.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>74108</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>290.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>983.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>65836</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>277.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>982.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>539420</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>3722.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>703.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>602.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>54300</td>\n",
       "      <td>9</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>553224</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>3705.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>726.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>788.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>82268</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>285.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>183.0</td>\n",
       "      <td>984.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Advanced Micro Devices X86-64</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>8608</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>9</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Advanced Micro Devices X86-64</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>4552</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>9</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>103684</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>311.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>984.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>965476</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>3513.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>763.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>965476</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>3530.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>765.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>1084</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>35956</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>8</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>89.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>4484</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>8</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Advanced Micro Devices X86-64</td>\n",
       "      <td>1</td>\n",
       "      <td>64</td>\n",
       "      <td>37720</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>56</td>\n",
       "      <td>9</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>154.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>376.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1</td>\n",
       "      <td>52</td>\n",
       "      <td>965476</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>32</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>...</td>\n",
       "      <td>3513.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>763.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>953.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Identification  \\\n",
       "0   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "1   7f 45 4c 46 01 01 01 03 00 00 00 00 00 00 00 00   \n",
       "2   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "3   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "4   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "5   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "6   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "7   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "8   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "9   7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "10  7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00   \n",
       "11  7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00   \n",
       "12  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "13  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "14  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "15  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "16  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "17  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "18  7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00   \n",
       "19  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "\n",
       "                      MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "0                     Intel 80386           1                   52   \n",
       "1                     Intel 80386           1                   52   \n",
       "2                     Intel 80386           1                   52   \n",
       "3                     Intel 80386           1                   52   \n",
       "4                     Intel 80386           1                   52   \n",
       "5                     Intel 80386           1                   52   \n",
       "6                     Intel 80386           1                   52   \n",
       "7                       <unknown>           1                   52   \n",
       "8                     Intel 80386           1                   52   \n",
       "9                     Intel 80386           1                   52   \n",
       "10  Advanced Micro Devices X86-64           1                   64   \n",
       "11  Advanced Micro Devices X86-64           1                   64   \n",
       "12                    Intel 80386           1                   52   \n",
       "13                    Intel 80386           1                   52   \n",
       "14                    Intel 80386           1                   52   \n",
       "15                    Intel 80386           1                   52   \n",
       "16                    Intel 80386           1                   52   \n",
       "17                    Intel 80386           1                   52   \n",
       "18  Advanced Micro Devices X86-64           1                   64   \n",
       "19                    Intel 80386           1                   52   \n",
       "\n",
       "    SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "0                 91124      0          52                 32               3   \n",
       "1               1739776      0          52                 32               5   \n",
       "2                193764      0          52                 32               3   \n",
       "3                127116      0          52                 32               3   \n",
       "4                 74108      0          52                 32               3   \n",
       "5                 65836      0          52                 32               3   \n",
       "6                539420      0          52                 32               5   \n",
       "7                 54300      9          52                 32               3   \n",
       "8                553224      0          52                 32               5   \n",
       "9                 82268      0          52                 32               3   \n",
       "10                 8608      0          64                 56               9   \n",
       "11                 4552      0          64                 56               9   \n",
       "12               103684      0          52                 32               3   \n",
       "13               965476      0          52                 32               5   \n",
       "14               965476      0          52                 32               5   \n",
       "15                 1084      0          52                 32               3   \n",
       "16                35956      0          52                 32               8   \n",
       "17                 4484      0          52                 32               8   \n",
       "18                37720      0          64                 56               9   \n",
       "19               965476      0          52                 32               5   \n",
       "\n",
       "    SizeSectionHeader  ...        nop  pushf rdtsc     sbb   setb  setle  \\\n",
       "0                  40  ...      292.0    4.0   0.0    30.0   26.0    1.0   \n",
       "1                  40  ...    12115.0  376.0  10.0  7812.0   73.0   60.0   \n",
       "2                  40  ...      302.0    9.0   0.0    42.0   31.0    1.0   \n",
       "3                  40  ...      407.0    1.0   0.0    28.0    6.0    1.0   \n",
       "4                  40  ...      290.0    1.0   0.0    50.0   15.0    0.0   \n",
       "5                  40  ...      277.0    1.0   0.0    24.0   18.0    0.0   \n",
       "6                  40  ...     3722.0   29.0   0.0   703.0   56.0    6.0   \n",
       "7                  40  ...        0.0    0.0   0.0     0.0    0.0    0.0   \n",
       "8                  40  ...     3705.0   24.0   0.0   726.0   59.0    7.0   \n",
       "9                  40  ...      285.0    1.0   0.0    29.0   16.0    1.0   \n",
       "10                 64  ...       24.0    0.0   0.0    14.0    0.0    0.0   \n",
       "11                 64  ...       18.0    0.0   0.0     7.0    0.0    0.0   \n",
       "12                 40  ...      311.0    9.0   0.0    40.0   28.0    1.0   \n",
       "13                 40  ...     3513.0   63.0   0.0   763.0  139.0   11.0   \n",
       "14                 40  ...     3530.0   63.0   0.0   765.0  139.0   11.0   \n",
       "15                 40  ...        2.0    0.0   0.0     0.0    0.0    0.0   \n",
       "16                 40  ...       89.0    0.0   0.0    33.0    0.0    0.0   \n",
       "17                 40  ...       29.0    0.0   0.0     3.0    0.0    0.0   \n",
       "18                 64  ...      154.0    2.0   0.0    91.0    0.0    0.0   \n",
       "19                 40  ...     3513.0   63.0   0.0   763.0  139.0   11.0   \n",
       "\n",
       "    shld    std   (bad) labels  \n",
       "0    2.0  178.0   982.0      M  \n",
       "1   31.0  308.0  2867.0      M  \n",
       "2    2.0  181.0   987.0      M  \n",
       "3    0.0  183.0    63.0      M  \n",
       "4    2.0  186.0   983.0      M  \n",
       "5    2.0  192.0   982.0      M  \n",
       "6    3.0  190.0   602.0      M  \n",
       "7    0.0    0.0     0.0      M  \n",
       "8    3.0   79.0   788.0      M  \n",
       "9    2.0  183.0   984.0      M  \n",
       "10   0.0   10.0    79.0      B  \n",
       "11   0.0    2.0    72.0      B  \n",
       "12   2.0  178.0   984.0      M  \n",
       "13   3.0   49.0   953.0      M  \n",
       "14   3.0   49.0   953.0      M  \n",
       "15   0.0    0.0     0.0      M  \n",
       "16   2.0    6.0    15.0      M  \n",
       "17   0.0    4.0    12.0      M  \n",
       "18   0.0  118.0   376.0      B  \n",
       "19   3.0   49.0   953.0      M  \n",
       "\n",
       "[20 rows x 1066 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>labels</th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>...</th>\n",
       "      <th>int</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>416636.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1964.0</td>\n",
       "      <td>2449.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>608.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>888.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  labels  Identification  MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "1      M             0.0          0.0         1.0                 52.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "1             416636.0    0.0        52.0               32.0             4.0   \n",
       "\n",
       "   ...       int     nop  pushf  rdtsc    sbb  setb  setle  shld    std  (bad)  \n",
       "1  ...    1964.0  2449.0   52.0    0.0  608.0  38.0    4.0   5.0  165.0  888.0  \n",
       "\n",
       "[1 rows x 1066 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4 = df2.groupby('labels', as_index=False).mean().round(0).iloc[[1]]\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>labels</th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>...</th>\n",
       "      <th>int</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>416636.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1964.0</td>\n",
       "      <td>2449.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>608.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>888.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  labels Identification MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "1      M      <unknown>   <unknown>         1.0                 52.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "1             416636.0    0.0        52.0               32.0             4.0   \n",
       "\n",
       "   ...       int     nop  pushf rdtsc    sbb  setb  setle  shld    std  (bad)  \n",
       "1  ...    1964.0  2449.0   52.0   0.0  608.0  38.0    4.0   5.0  165.0  888.0  \n",
       "\n",
       "[1 rows x 1066 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in nominal_columns:\n",
    "    df4[i] = '<unknown>'\n",
    "df4.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>SizeSectionHeader</th>\n",
       "      <th>...</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "      <th>labels</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>416636.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2449.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>608.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>888.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Identification MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "1      <unknown>   <unknown>         1.0                 52.0   \n",
       "\n",
       "   SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  EntriesProgram  \\\n",
       "1             416636.0    0.0        52.0               32.0             4.0   \n",
       "\n",
       "   SizeSectionHeader  ...       nop  pushf rdtsc    sbb  setb  setle  shld  \\\n",
       "1               40.0  ...    2449.0   52.0   0.0  608.0  38.0    4.0   5.0   \n",
       "\n",
       "     std  (bad) labels  \n",
       "1  165.0  888.0      M  \n",
       "\n",
       "[1 rows x 1066 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.drop(['labels'], axis=1, inplace=True)\n",
    "df4['labels'] = 'M'\n",
    "df4.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9106, 1066)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = df.append(df3, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = df.append(df4, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(9108, 1066)"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Identification</th>\n",
       "      <th>MachineType</th>\n",
       "      <th>ELFVersion</th>\n",
       "      <th>ProgramHeaderOffset</th>\n",
       "      <th>SectionHeaderOffset</th>\n",
       "      <th>Flags</th>\n",
       "      <th>HeaderSize</th>\n",
       "      <th>SizeProgramHeader</th>\n",
       "      <th>EntriesProgram</th>\n",
       "      <th>SizeSectionHeader</th>\n",
       "      <th>...</th>\n",
       "      <th>nop</th>\n",
       "      <th>pushf</th>\n",
       "      <th>rdtsc</th>\n",
       "      <th>sbb</th>\n",
       "      <th>setb</th>\n",
       "      <th>setle</th>\n",
       "      <th>shld</th>\n",
       "      <th>std</th>\n",
       "      <th>(bad)</th>\n",
       "      <th>labels</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9103</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>539420.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3722.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>704.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>602.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9104</th>\n",
       "      <td>7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Advanced Micro Devices X86-64</td>\n",
       "      <td>1.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>7096.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>...</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9105</th>\n",
       "      <td>7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00</td>\n",
       "      <td>Intel 80386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>56680.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>...</td>\n",
       "      <td>225.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>961.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9106</th>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>190483.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>...</td>\n",
       "      <td>912.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>494.0</td>\n",
       "      <td>2211.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9107</th>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>&lt;unknown&gt;</td>\n",
       "      <td>1.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>416636.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2449.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>608.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>165.0</td>\n",
       "      <td>888.0</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 1066 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Identification  \\\n",
       "9103  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "9104  7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00   \n",
       "9105  7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00   \n",
       "9106                                        <unknown>   \n",
       "9107                                        <unknown>   \n",
       "\n",
       "                        MachineType  ELFVersion  ProgramHeaderOffset  \\\n",
       "9103                    Intel 80386         1.0                 52.0   \n",
       "9104  Advanced Micro Devices X86-64         1.0                 64.0   \n",
       "9105                    Intel 80386         1.0                 52.0   \n",
       "9106                      <unknown>         1.0                 64.0   \n",
       "9107                      <unknown>         1.0                 52.0   \n",
       "\n",
       "      SectionHeaderOffset  Flags  HeaderSize  SizeProgramHeader  \\\n",
       "9103             539420.0    0.0        52.0               32.0   \n",
       "9104               7096.0    0.0        64.0               56.0   \n",
       "9105              56680.0    0.0        52.0               32.0   \n",
       "9106             190483.0    0.0        64.0               56.0   \n",
       "9107             416636.0    0.0        52.0               32.0   \n",
       "\n",
       "      EntriesProgram  SizeSectionHeader  ...       nop  pushf rdtsc    sbb  \\\n",
       "9103             5.0               40.0  ...    3722.0   29.0   0.0  704.0   \n",
       "9104             9.0               64.0  ...      14.0    0.0   0.0    7.0   \n",
       "9105             3.0               40.0  ...     225.0    1.0   0.0   13.0   \n",
       "9106             9.0               64.0  ...     912.0   21.0   0.0  343.0   \n",
       "9107             4.0               40.0  ...    2449.0   52.0   0.0  608.0   \n",
       "\n",
       "      setb  setle  shld    std   (bad) labels  \n",
       "9103  56.0    6.0   3.0  190.0   602.0      M  \n",
       "9104   0.0    0.0   0.0   15.0    54.0      B  \n",
       "9105  22.0    0.0   2.0  169.0   961.0      M  \n",
       "9106   4.0    1.0   0.0  494.0  2211.0      B  \n",
       "9107  38.0    4.0   5.0  165.0   888.0      M  \n",
       "\n",
       "[5 rows x 1066 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('final_nominal.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Identification ['7f 45 4c 46 01 01 01 00 00 00 00 00 00 00 00 00'\n",
      " '7f 45 4c 46 01 01 01 03 00 00 00 00 00 00 00 00'\n",
      " '7f 45 4c 46 02 01 01 00 00 00 00 00 00 00 00 00'\n",
      " '7f 45 4c 46 01 02 01 00 00 00 00 00 00 00 00 00'\n",
      " '7f 45 4c 46 02 01 01 03 00 00 00 00 00 00 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 b4 3b 00 00'\n",
      " '7f 45 4c 46 01 01 01 09 00 00 00 00 00 00 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 25 32 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 20 3b 00 00'\n",
      " '7f 45 4c 46 01 01 01 ab 01 4c 61 53 61 6c 6c 65'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 1a 42 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 4e 2f 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 e4 30 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 bc 3e 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 7b 31 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 1b 43 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 2c 28 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 6d 2a 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 ac 3b 00 00'\n",
      " '7f 45 4c 46 01 01 01 00 00 00 00 00 39 31 00 00' '<unknown>']\n",
      "MachineType ['Intel 80386' '<unknown>' 'Advanced Micro Devices X86-64' 'Sparc'\n",
      " 'PowerPC' 'MC68000']\n",
      ".text_type ['PROGBITS' 'NOBITS' nan '<unknown>']\n",
      ".text_flags ['AX' nan '<unknown>']\n",
      ".bss_type ['NOBITS' nan 'PROGBITS' '<unknown>']\n",
      ".bss_flags ['WA' nan '<unknown>']\n",
      ".comment_type ['PROGBITS' nan '<unknown>']\n",
      ".comment_flags [nan 'MS' '<unknown>']\n",
      ".data_type ['PROGBITS' nan 'NOBITS' '<unknown>']\n",
      ".data_flags ['WA' nan '<unknown>']\n",
      ".data1_type [nan 'PROGBITS' '<unknown>']\n",
      ".data1_flags [nan 'WA' '<unknown>']\n",
      ".dynamic_type [nan 'DYNAMIC' 'NOBITS' '<unknown>']\n",
      ".dynamic_flags [nan 'WA' '<unknown>']\n",
      ".dynstr_type [nan 'STRTAB' 'NOBITS' '<unknown>']\n",
      ".dynstr_flags [nan 'A' '<unknown>']\n",
      ".dynsym_type [nan 'DYNSYM' 'NOBITS' '<unknown>']\n",
      ".dynsym_flags [nan 'A' '<unknown>']\n",
      ".fini_type ['PROGBITS' nan 'NOBITS' '<unknown>']\n",
      ".fini_flags ['AX' nan '<unknown>']\n",
      ".hash_type [nan 'HASH' 'NOBITS' '<unknown>']\n",
      ".hash_flags [nan 'A' '<unknown>']\n",
      ".gnu.hash_type [nan 'GNU_HASH' 'NOBITS' '<unknown>']\n",
      ".gnu.hash_flags [nan 'A' '<unknown>']\n",
      ".init_type ['PROGBITS' nan 'NOBITS' '<unknown>']\n",
      ".init_flags ['AX' nan '<unknown>']\n",
      ".got_type [nan 'PROGBITS' 'NOBITS' '<unknown>']\n",
      ".got_flags [nan 'WA' 'WAX' '<unknown>']\n",
      ".interp_type [nan 'PROGBITS' 'NOBITS' '<unknown>']\n",
      ".interp_flags [nan 'A' '<unknown>']\n",
      ".note_type [nan 'NOTE' '<unknown>']\n",
      ".plt_type [nan 'PROGBITS' 'NOBITS' '<unknown>']\n",
      ".plt_flags [nan 'AX' 'WAX' '<unknown>']\n",
      ".rodata_type ['PROGBITS' 'NOBITS' nan '<unknown>']\n",
      ".rodata_flags ['A' 'AMS' 'AM' nan '<unknown>']\n",
      ".shstrtab_type ['STRTAB' nan '<unknown>']\n",
      ".strtab_type ['STRTAB' nan '<unknown>']\n",
      ".symtab_type ['SYMTAB' nan '<unknown>']\n",
      ".sdata_type [nan 'PROGBITS' '<unknown>']\n",
      ".sdata_flags [nan 'WA' '<unknown>']\n",
      ".sbss_type [nan 'NOBITS' 'PROGBITS' '<unknown>']\n",
      ".sbss_flags [nan 'WA' 'W' '<unknown>']\n",
      ".rel.dyn_type [nan 'REL' 'NOBITS' '<unknown>']\n",
      ".rel.dyn_flags [nan 'A' '<unknown>']\n",
      ".rel.plt_type [nan 'REL' 'NOBITS' '<unknown>']\n",
      ".rel.plt_flags [nan 'A' 'AI' '<unknown>']\n",
      ".got.plt_type ['PROGBITS' nan 'NOBITS' '<unknown>']\n",
      ".got.plt_flags ['WA' nan '<unknown>']\n"
     ]
    }
   ],
   "source": [
    "for i in nominal_columns:\n",
    "    print i, df[i].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}