Turnstile Counter Reset

MTA_Data3_Blog2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "252044   -8291685.0\n",
       "264128        -91.0\n",
       "264129         -4.0\n",
       "264130        -34.0\n",
       "264131        -25.0\n",
       "            ...    \n",
       "341647     -17768.0\n",
       "339394    -210087.0\n",
       "342664     -80186.0\n",
       "337985     -32882.0\n",
       "337631      -1508.0\n",
       "Name: ENTRY_DELTA, Length: 1724, dtype: float64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ENTRY_DELTA'][df['ENTRY_DELTA']<0]\n",
    "# Checking reset of entry counter values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "271427    1.057536e+09\n",
       "271465    1.549702e+09\n",
       "300430    8.368614e+07\n",
       "297544    1.443527e+06\n",
       "297546    1.443555e+06\n",
       "241440    6.512100e+04\n",
       "241509    3.245470e+05\n",
       "241515    1.966110e+05\n",
       "296920    1.405439e+06\n",
       "Name: ENTRY_DELTA, dtype: float64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ENTRY_DELTA'][df['ENTRY_DELTA']>10000]\n",
    "# Checking reset of entry counter values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "252044   -5618417.0\n",
       "372575         -1.0\n",
       "372585         -2.0\n",
       "371439      -2794.0\n",
       "378552         -1.0\n",
       "            ...    \n",
       "341647      -2261.0\n",
       "339394     -27583.0\n",
       "342664    -101904.0\n",
       "337985    -266037.0\n",
       "337631      -1199.0\n",
       "Name: EXIT_DELTA, Length: 1345, dtype: float64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['EXIT_DELTA'][df['EXIT_DELTA']<0]\n",
    "# Checking reset of exit counter values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "300430      82744.0\n",
       "297544    2955446.0\n",
       "297546    2955411.0\n",
       "241509      53279.0\n",
       "296920     228341.0\n",
       "Name: EXIT_DELTA, dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['EXIT_DELTA'][df['EXIT_DELTA']>10000]\n",
    "# Checking reset of exit counter values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}