{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5782da1e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "73a1eb00",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('pairs.txt', sep=\"\\t\", header=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5fe3f547",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>chr1</td>\n",
       "      <td>2499</td>\n",
       "      <td>chr1</td>\n",
       "      <td>2723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3495</td>\n",
       "      <td>chr1</td>\n",
       "      <td>3795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3519</td>\n",
       "      <td>chr1</td>\n",
       "      <td>3735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3641</td>\n",
       "      <td>chr1</td>\n",
       "      <td>72429988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>chr1</td>\n",
       "      <td>4866</td>\n",
       "      <td>chr1</td>\n",
       "      <td>5022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587308</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309380</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82036721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587309</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309559</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82293151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587310</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309416</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587311</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309516</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587312</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309887</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82090383</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4587313 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            0         1     2         3\n",
       "0        chr1      2499  chr1      2723\n",
       "1        chr1      3495  chr1      3795\n",
       "2        chr1      3519  chr1      3735\n",
       "3        chr1      3641  chr1  72429988\n",
       "4        chr1      4866  chr1      5022\n",
       "...       ...       ...   ...       ...\n",
       "4587308  chrZ  82309380  chrZ  82036721\n",
       "4587309  chrZ  82309559  chrZ  82293151\n",
       "4587310  chrZ  82309416  chrZ  82309572\n",
       "4587311  chrZ  82309516  chrZ  82309709\n",
       "4587312  chrZ  82309887  chrZ  82090383\n",
       "\n",
       "[4587313 rows x 4 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "20441b6e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns=['c1', 'p1', 'c2', 'p2']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c6408627",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>c1</th>\n",
       "      <th>p1</th>\n",
       "      <th>c2</th>\n",
       "      <th>p2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>chr1</td>\n",
       "      <td>2499</td>\n",
       "      <td>chr1</td>\n",
       "      <td>2723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3495</td>\n",
       "      <td>chr1</td>\n",
       "      <td>3795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3519</td>\n",
       "      <td>chr1</td>\n",
       "      <td>3735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3641</td>\n",
       "      <td>chr1</td>\n",
       "      <td>72429988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>chr1</td>\n",
       "      <td>4866</td>\n",
       "      <td>chr1</td>\n",
       "      <td>5022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587308</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309380</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82036721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587309</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309559</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82293151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587310</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309416</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587311</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309516</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587312</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309887</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82090383</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4525219 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           c1        p1    c2        p2\n",
       "0        chr1      2499  chr1      2723\n",
       "1        chr1      3495  chr1      3795\n",
       "2        chr1      3519  chr1      3735\n",
       "3        chr1      3641  chr1  72429988\n",
       "4        chr1      4866  chr1      5022\n",
       "...       ...       ...   ...       ...\n",
       "4587308  chrZ  82309380  chrZ  82036721\n",
       "4587309  chrZ  82309559  chrZ  82293151\n",
       "4587310  chrZ  82309416  chrZ  82309572\n",
       "4587311  chrZ  82309516  chrZ  82309709\n",
       "4587312  chrZ  82309887  chrZ  82090383\n",
       "\n",
       "[4525219 rows x 4 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('c1==c2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dc0d3cfd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>c1</th>\n",
       "      <th>p1</th>\n",
       "      <th>c2</th>\n",
       "      <th>p2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>chr1</td>\n",
       "      <td>2499</td>\n",
       "      <td>chr1</td>\n",
       "      <td>2723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3495</td>\n",
       "      <td>chr1</td>\n",
       "      <td>3795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3519</td>\n",
       "      <td>chr1</td>\n",
       "      <td>3735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>chr1</td>\n",
       "      <td>3641</td>\n",
       "      <td>chr1</td>\n",
       "      <td>72429988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>chr1</td>\n",
       "      <td>4866</td>\n",
       "      <td>chr1</td>\n",
       "      <td>5022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587285</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82307023</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82307302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587297</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82308869</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587298</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309036</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587310</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309416</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587311</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309516</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309709</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4356414 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           c1        p1    c2        p2\n",
       "0        chr1      2499  chr1      2723\n",
       "1        chr1      3495  chr1      3795\n",
       "2        chr1      3519  chr1      3735\n",
       "3        chr1      3641  chr1  72429988\n",
       "4        chr1      4866  chr1      5022\n",
       "...       ...       ...   ...       ...\n",
       "4587285  chrZ  82307023  chrZ  82307302\n",
       "4587297  chrZ  82308869  chrZ  82309117\n",
       "4587298  chrZ  82309036  chrZ  82309308\n",
       "4587310  chrZ  82309416  chrZ  82309572\n",
       "4587311  chrZ  82309516  chrZ  82309709\n",
       "\n",
       "[4356414 rows x 4 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('c1==c2 & p1<p2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "1ec42f3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>c1</th>\n",
       "      <th>p1</th>\n",
       "      <th>c2</th>\n",
       "      <th>p2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>chr1</td>\n",
       "      <td>20091</td>\n",
       "      <td>chr1</td>\n",
       "      <td>9288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>chr1</td>\n",
       "      <td>28807</td>\n",
       "      <td>chr1</td>\n",
       "      <td>17707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>chr1</td>\n",
       "      <td>28819</td>\n",
       "      <td>chr1</td>\n",
       "      <td>17703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>chr1</td>\n",
       "      <td>28842</td>\n",
       "      <td>chr1</td>\n",
       "      <td>17796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>chr1</td>\n",
       "      <td>28851</td>\n",
       "      <td>chr1</td>\n",
       "      <td>17818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587306</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309120</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82292613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587307</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309669</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82020370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587308</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309380</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82036721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587309</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309559</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82293151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4587312</th>\n",
       "      <td>chrZ</td>\n",
       "      <td>82309887</td>\n",
       "      <td>chrZ</td>\n",
       "      <td>82090383</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>168638 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           c1        p1    c2        p2\n",
       "11       chr1     20091  chr1      9288\n",
       "12       chr1     28807  chr1     17707\n",
       "13       chr1     28819  chr1     17703\n",
       "14       chr1     28842  chr1     17796\n",
       "15       chr1     28851  chr1     17818\n",
       "...       ...       ...   ...       ...\n",
       "4587306  chrZ  82309120  chrZ  82292613\n",
       "4587307  chrZ  82309669  chrZ  82020370\n",
       "4587308  chrZ  82309380  chrZ  82036721\n",
       "4587309  chrZ  82309559  chrZ  82293151\n",
       "4587312  chrZ  82309887  chrZ  82090383\n",
       "\n",
       "[168638 rows x 4 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query('c1==c2 & p1>p2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a5194909",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}