Skip to content

Instantly share code, notes, and snippets.

@nagishin

nagishin/groupby_aggでorderbook集計.ipynb

Created October 3, 2018 02:56
Show Gist options
  • Save nagishin/a6c096883976137adbc674ec5d7f81fd to your computer and use it in GitHub Desktop.
Save nagishin/a6c096883976137adbc674ec5d7f81fd to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
groupby_aggでorderbook集計.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 217,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"bid/ask別に[price, size]からDataFrameを作成\n"
]
},
{
"data": {
"text/plain": [
"'【bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>price</th>\n",
" <th>order_size</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>749898.0</td>\n",
" <td>0.069697</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>749891.0</td>\n",
" <td>0.250000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>749890.0</td>\n",
" <td>0.337744</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>749813.0</td>\n",
" <td>0.100000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>749812.0</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" price order_size\n",
"0 749898.0 0.069697\n",
"1 749891.0 0.250000\n",
"2 749890.0 0.337744\n",
"3 749813.0 0.100000\n",
"4 749812.0 0.010000"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>price</th>\n",
" <th>order_size</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>749902.0</td>\n",
" <td>0.649</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>749906.0</td>\n",
" <td>0.400</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>749910.0</td>\n",
" <td>0.100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>749916.0</td>\n",
" <td>0.010</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>749937.0</td>\n",
" <td>0.047</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" price order_size\n",
"0 749902.0 0.649\n",
"1 749906.0 0.400\n",
"2 749910.0 0.100\n",
"3 749916.0 0.010\n",
"4 749937.0 0.047"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import requests\n",
"import pandas as pd\n",
"\n",
"# bitFlyerFXの板情報取得\n",
"url = \"https://api.bitflyer.jp/v1/board?product_code=FX_BTC_JPY\"\n",
"data = requests.get(url).json()\n",
"\n",
"print(\"bid/ask別に[price, size]からDataFrameを作成\")\n",
"cols = [\"price\", \"order_size\"]\n",
"df_bids = pd.DataFrame([[r[\"price\"], r[\"size\"]] for r in data[\"bids\"]], columns=cols)\n",
"df_asks = pd.DataFrame([[r[\"price\"], r[\"size\"]] for r in data[\"asks\"]], columns=cols)\n",
"display(\"【bids】\", df_bids.head())\n",
"display(\"【asks】\", df_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 218,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"集計Key(unit_price)列を追加\n"
]
},
{
"data": {
"text/plain": [
"'【bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>price</th>\n",
" <th>order_size</th>\n",
" <th>unit_price</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>749898.0</td>\n",
" <td>0.069697</td>\n",
" <td>749800.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>749891.0</td>\n",
" <td>0.250000</td>\n",
" <td>749800.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>749890.0</td>\n",
" <td>0.337744</td>\n",
" <td>749800.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>749813.0</td>\n",
" <td>0.100000</td>\n",
" <td>749800.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>749812.0</td>\n",
" <td>0.010000</td>\n",
" <td>749800.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" price order_size unit_price\n",
"0 749898.0 0.069697 749800.0\n",
"1 749891.0 0.250000 749800.0\n",
"2 749890.0 0.337744 749800.0\n",
"3 749813.0 0.100000 749800.0\n",
"4 749812.0 0.010000 749800.0"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>price</th>\n",
" <th>order_size</th>\n",
" <th>unit_price</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>749902.0</td>\n",
" <td>0.649</td>\n",
" <td>749900.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>749906.0</td>\n",
" <td>0.400</td>\n",
" <td>749900.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>749910.0</td>\n",
" <td>0.100</td>\n",
" <td>749900.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>749916.0</td>\n",
" <td>0.010</td>\n",
" <td>749900.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>749937.0</td>\n",
" <td>0.047</td>\n",
" <td>749900.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" price order_size unit_price\n",
"0 749902.0 0.649 749900.0\n",
"1 749906.0 0.400 749900.0\n",
"2 749910.0 0.100 749900.0\n",
"3 749916.0 0.010 749900.0\n",
"4 749937.0 0.047 749900.0"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# 板が細か過ぎるので指定単位円で集計する\n",
"print(\"集計Key(unit_price)列を追加\")\n",
"unit = 100 # 100円幅単位にまとめる\n",
"df_bids[\"unit_price\"] = (df_bids[\"price\"] // unit) * unit # priceを100円単位に切り捨て\n",
"df_asks[\"unit_price\"] = (df_asks[\"price\"] // unit) * unit # priceを100円単位に切り捨て\n",
"display(\"【bids】\", df_bids.head())\n",
"display(\"【asks】\", df_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 219,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"unit_priceでグループ化\n",
"groupbyオブジェクトはそのまま参照はできない\n"
]
},
{
"data": {
"text/plain": [
"<pandas.core.groupby.DataFrameGroupBy object at 0x7fb1f3245438>"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"<pandas.core.groupby.DataFrameGroupBy object at 0x7fb1e045ccc0>"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"group情報表示\n"
]
},
{
"data": {
"text/plain": [
"{351200.0: Int64Index([3189], dtype='int64'),\n",
" 352000.0: Int64Index([3188], dtype='int64'),\n",
" 353100.0: Int64Index([3187], dtype='int64'),\n",
" 353200.0: Int64Index([3186], dtype='int64'),\n",
" 354200.0: Int64Index([3185], dtype='int64'),\n",
" 360000.0: Int64Index([3183, 3184], dtype='int64'),\n",
" 367800.0: Int64Index([3182], dtype='int64'),\n",
" 368000.0: Int64Index([3181], dtype='int64'),\n",
" 368800.0: Int64Index([3180], dtype='int64'),\n",
" 370000.0: Int64Index([3178, 3179], dtype='int64'),\n",
" 377700.0: Int64Index([3177], dtype='int64'),\n",
" 379000.0: Int64Index([3176], dtype='int64'),\n",
" 379900.0: Int64Index([3175], dtype='int64'),\n",
" 380000.0: Int64Index([3173, 3174], dtype='int64'),\n",
" 385800.0: Int64Index([3172], dtype='int64'),\n",
" 387800.0: Int64Index([3171], dtype='int64'),\n",
" 388000.0: Int64Index([3170], dtype='int64'),\n",
" 388800.0: Int64Index([3169], dtype='int64'),\n",
" 389600.0: Int64Index([3168], dtype='int64'),\n",
" 389900.0: Int64Index([3167], dtype='int64'),\n",
" 390000.0: Int64Index([3165, 3166], dtype='int64'),\n",
" 399500.0: Int64Index([3164], dtype='int64'),\n",
" 399900.0: Int64Index([3163], dtype='int64'),\n",
" 400000.0: Int64Index([3160, 3161, 3162], dtype='int64'),\n",
" 402300.0: Int64Index([3159], dtype='int64'),\n",
" 403900.0: Int64Index([3158], dtype='int64'),\n",
" 406000.0: Int64Index([3157], dtype='int64'),\n",
" 410000.0: Int64Index([3155, 3156], dtype='int64'),\n",
" 411000.0: Int64Index([3154], dtype='int64'),\n",
" 420000.0: Int64Index([3153], dtype='int64'),\n",
" 423200.0: Int64Index([3152], dtype='int64'),\n",
" 430000.0: Int64Index([3150, 3151], dtype='int64'),\n",
" 433000.0: Int64Index([3149], dtype='int64'),\n",
" 436000.0: Int64Index([3148], dtype='int64'),\n",
" 440000.0: Int64Index([3147], dtype='int64'),\n",
" 445500.0: Int64Index([3146], dtype='int64'),\n",
" 450000.0: Int64Index([3144, 3145], dtype='int64'),\n",
" 451300.0: Int64Index([3143], dtype='int64'),\n",
" 452500.0: Int64Index([3142], dtype='int64'),\n",
" 452900.0: Int64Index([3141], dtype='int64'),\n",
" 455000.0: Int64Index([3140], dtype='int64'),\n",
" 458000.0: Int64Index([3139], dtype='int64'),\n",
" 460000.0: Int64Index([3137, 3138], dtype='int64'),\n",
" 460100.0: Int64Index([3136], dtype='int64'),\n",
" 462500.0: Int64Index([3135], dtype='int64'),\n",
" 466000.0: Int64Index([3134], dtype='int64'),\n",
" 470000.0: Int64Index([3132, 3133], dtype='int64'),\n",
" 472500.0: Int64Index([3131], dtype='int64'),\n",
" 474200.0: Int64Index([3130], dtype='int64'),\n",
" 476000.0: Int64Index([3129], dtype='int64'),\n",
" 480000.0: Int64Index([3128], dtype='int64'),\n",
" 482500.0: Int64Index([3127], dtype='int64'),\n",
" 488000.0: Int64Index([3126], dtype='int64'),\n",
" 488100.0: Int64Index([3125], dtype='int64'),\n",
" 489600.0: Int64Index([3124], dtype='int64'),\n",
" 490000.0: Int64Index([3122, 3123], dtype='int64'),\n",
" 491600.0: Int64Index([3121], dtype='int64'),\n",
" 492500.0: Int64Index([3120], dtype='int64'),\n",
" 492700.0: Int64Index([3119], dtype='int64'),\n",
" 495400.0: Int64Index([3118], dtype='int64'),\n",
" 496000.0: Int64Index([3117], dtype='int64'),\n",
" 498000.0: Int64Index([3116], dtype='int64'),\n",
" 499500.0: Int64Index([3115], dtype='int64'),\n",
" 500000.0: Int64Index([3111, 3112, 3113, 3114], dtype='int64'),\n",
" 500600.0: Int64Index([3110], dtype='int64'),\n",
" 502300.0: Int64Index([3109], dtype='int64'),\n",
" 502500.0: Int64Index([3108], dtype='int64'),\n",
" 505000.0: Int64Index([3107], dtype='int64'),\n",
" 505100.0: Int64Index([3106], dtype='int64'),\n",
" 505500.0: Int64Index([3105], dtype='int64'),\n",
" 510000.0: Int64Index([3104], dtype='int64'),\n",
" 511000.0: Int64Index([3103], dtype='int64'),\n",
" 511300.0: Int64Index([3102], dtype='int64'),\n",
" 512100.0: Int64Index([3101], dtype='int64'),\n",
" 512500.0: Int64Index([3100], dtype='int64'),\n",
" 513000.0: Int64Index([3099], dtype='int64'),\n",
" 519600.0: Int64Index([3098], dtype='int64'),\n",
" 520000.0: Int64Index([3096, 3097], dtype='int64'),\n",
" 520600.0: Int64Index([3095], dtype='int64'),\n",
" 520800.0: Int64Index([3094], dtype='int64'),\n",
" 522500.0: Int64Index([3093], dtype='int64'),\n",
" 523100.0: Int64Index([3092], dtype='int64'),\n",
" 523300.0: Int64Index([3091], dtype='int64'),\n",
" 525000.0: Int64Index([3090], dtype='int64'),\n",
" 525300.0: Int64Index([3089], dtype='int64'),\n",
" 528700.0: Int64Index([3088], dtype='int64'),\n",
" 530000.0: Int64Index([3085, 3086, 3087], dtype='int64'),\n",
" 532500.0: Int64Index([3084], dtype='int64'),\n",
" 533000.0: Int64Index([3083], dtype='int64'),\n",
" 536000.0: Int64Index([3082], dtype='int64'),\n",
" 537200.0: Int64Index([3081], dtype='int64'),\n",
" 537600.0: Int64Index([3080], dtype='int64'),\n",
" 537800.0: Int64Index([3079], dtype='int64'),\n",
" 538000.0: Int64Index([3078], dtype='int64'),\n",
" 540000.0: Int64Index([3076, 3077], dtype='int64'),\n",
" 542500.0: Int64Index([3075], dtype='int64'),\n",
" 542800.0: Int64Index([3074], dtype='int64'),\n",
" 543100.0: Int64Index([3073], dtype='int64'),\n",
" 548700.0: Int64Index([3072], dtype='int64'),\n",
" 549000.0: Int64Index([3071], dtype='int64'),\n",
" 550000.0: Int64Index([3068, 3069, 3070], dtype='int64'),\n",
" 550100.0: Int64Index([3067], dtype='int64'),\n",
" 551000.0: Int64Index([3066], dtype='int64'),\n",
" 552300.0: Int64Index([3065], dtype='int64'),\n",
" 552500.0: Int64Index([3064], dtype='int64'),\n",
" 554800.0: Int64Index([3063], dtype='int64'),\n",
" 555100.0: Int64Index([3062], dtype='int64'),\n",
" 555500.0: Int64Index([3061], dtype='int64'),\n",
" 557700.0: Int64Index([3060], dtype='int64'),\n",
" 558000.0: Int64Index([3059], dtype='int64'),\n",
" 559700.0: Int64Index([3058], dtype='int64'),\n",
" 560000.0: Int64Index([3056, 3057], dtype='int64'),\n",
" 560300.0: Int64Index([3055], dtype='int64'),\n",
" 560800.0: Int64Index([3054], dtype='int64'),\n",
" 561000.0: Int64Index([3053], dtype='int64'),\n",
" 562100.0: Int64Index([3052], dtype='int64'),\n",
" 562300.0: Int64Index([3051], dtype='int64'),\n",
" 562500.0: Int64Index([3050], dtype='int64'),\n",
" 563100.0: Int64Index([3049], dtype='int64'),\n",
" 563500.0: Int64Index([3048], dtype='int64'),\n",
" 563600.0: Int64Index([3047], dtype='int64'),\n",
" 564000.0: Int64Index([3046], dtype='int64'),\n",
" 565300.0: Int64Index([3045], dtype='int64'),\n",
" 565900.0: Int64Index([3043, 3044], dtype='int64'),\n",
" 566000.0: Int64Index([3042], dtype='int64'),\n",
" 566500.0: Int64Index([3041], dtype='int64'),\n",
" 567000.0: Int64Index([3040], dtype='int64'),\n",
" 570000.0: Int64Index([3037, 3038, 3039], dtype='int64'),\n",
" 571000.0: Int64Index([3036], dtype='int64'),\n",
" 572500.0: Int64Index([3035], dtype='int64'),\n",
" 574900.0: Int64Index([3034], dtype='int64'),\n",
" 575000.0: Int64Index([3033], dtype='int64'),\n",
" 575500.0: Int64Index([3032], dtype='int64'),\n",
" 575600.0: Int64Index([3031], dtype='int64'),\n",
" 576000.0: Int64Index([3030], dtype='int64'),\n",
" 578000.0: Int64Index([3029], dtype='int64'),\n",
" 578900.0: Int64Index([3028], dtype='int64'),\n",
" 580000.0: Int64Index([3026, 3027], dtype='int64'),\n",
" 580100.0: Int64Index([3025], dtype='int64'),\n",
" 581000.0: Int64Index([3024], dtype='int64'),\n",
" 581400.0: Int64Index([3023], dtype='int64'),\n",
" 582500.0: Int64Index([3022], dtype='int64'),\n",
" 582800.0: Int64Index([3021], dtype='int64'),\n",
" 585000.0: Int64Index([3018, 3019, 3020], dtype='int64'),\n",
" 585800.0: Int64Index([3017], dtype='int64'),\n",
" 586300.0: Int64Index([3016], dtype='int64'),\n",
" 587100.0: Int64Index([3015], dtype='int64'),\n",
" 589000.0: Int64Index([3014], dtype='int64'),\n",
" 589600.0: Int64Index([3013], dtype='int64'),\n",
" 590000.0: Int64Index([3010, 3011, 3012], dtype='int64'),\n",
" 590300.0: Int64Index([3009], dtype='int64'),\n",
" 590800.0: Int64Index([3008], dtype='int64'),\n",
" 591000.0: Int64Index([3007], dtype='int64'),\n",
" 592500.0: Int64Index([3006], dtype='int64'),\n",
" 592700.0: Int64Index([3005], dtype='int64'),\n",
" 597200.0: Int64Index([3004], dtype='int64'),\n",
" 599500.0: Int64Index([3003], dtype='int64'),\n",
" 599800.0: Int64Index([3002], dtype='int64'),\n",
" 599900.0: Int64Index([3001], dtype='int64'),\n",
" 600000.0: Int64Index([2997, 2998, 2999, 3000], dtype='int64'),\n",
" 600100.0: Int64Index([2995, 2996], dtype='int64'),\n",
" 600500.0: Int64Index([2994], dtype='int64'),\n",
" 601000.0: Int64Index([2993], dtype='int64'),\n",
" 601200.0: Int64Index([2991, 2992], dtype='int64'),\n",
" 602000.0: Int64Index([2990], dtype='int64'),\n",
" 602500.0: Int64Index([2989], dtype='int64'),\n",
" 603500.0: Int64Index([2988], dtype='int64'),\n",
" 604000.0: Int64Index([2987], dtype='int64'),\n",
" 605000.0: Int64Index([2985, 2986], dtype='int64'),\n",
" 605600.0: Int64Index([2984], dtype='int64'),\n",
" 605800.0: Int64Index([2983], dtype='int64'),\n",
" 606000.0: Int64Index([2981, 2982], dtype='int64'),\n",
" 607000.0: Int64Index([2980], dtype='int64'),\n",
" 608000.0: Int64Index([2979], dtype='int64'),\n",
" 608800.0: Int64Index([2978], dtype='int64'),\n",
" 610000.0: Int64Index([2975, 2976, 2977], dtype='int64'),\n",
" 610500.0: Int64Index([2974], dtype='int64'),\n",
" 611000.0: Int64Index([2973], dtype='int64'),\n",
" 611100.0: Int64Index([2972], dtype='int64'),\n",
" 611700.0: Int64Index([2971], dtype='int64'),\n",
" 612300.0: Int64Index([2969, 2970], dtype='int64'),\n",
" 612500.0: Int64Index([2967, 2968], dtype='int64'),\n",
" 613000.0: Int64Index([2966], dtype='int64'),\n",
" 615000.0: Int64Index([2965], dtype='int64'),\n",
" 615100.0: Int64Index([2964], dtype='int64'),\n",
" 615500.0: Int64Index([2963], dtype='int64'),\n",
" 616000.0: Int64Index([2962], dtype='int64'),\n",
" 616500.0: Int64Index([2961], dtype='int64'),\n",
" 617500.0: Int64Index([2960], dtype='int64'),\n",
" 617700.0: Int64Index([2959], dtype='int64'),\n",
" 618000.0: Int64Index([2958], dtype='int64'),\n",
" 618800.0: Int64Index([2957], dtype='int64'),\n",
" 620000.0: Int64Index([2955, 2956], dtype='int64'),\n",
" 620800.0: Int64Index([2954], dtype='int64'),\n",
" 621000.0: Int64Index([2953], dtype='int64'),\n",
" 622000.0: Int64Index([2952], dtype='int64'),\n",
" 622500.0: Int64Index([2950, 2951], dtype='int64'),\n",
" 623000.0: Int64Index([2949], dtype='int64'),\n",
" 623400.0: Int64Index([2948], dtype='int64'),\n",
" 623500.0: Int64Index([2947], dtype='int64'),\n",
" 624200.0: Int64Index([2946], dtype='int64'),\n",
" 624500.0: Int64Index([2945], dtype='int64'),\n",
" 625000.0: Int64Index([2943, 2944], dtype='int64'),\n",
" 625600.0: Int64Index([2942], dtype='int64'),\n",
" 625700.0: Int64Index([2941], dtype='int64'),\n",
" 625800.0: Int64Index([2940], dtype='int64'),\n",
" 625900.0: Int64Index([2939], dtype='int64'),\n",
" 626000.0: Int64Index([2938], dtype='int64'),\n",
" 626500.0: Int64Index([2937], dtype='int64'),\n",
" 627000.0: Int64Index([2936], dtype='int64'),\n",
" 627500.0: Int64Index([2935], dtype='int64'),\n",
" 627600.0: Int64Index([2934], dtype='int64'),\n",
" 627700.0: Int64Index([2933], dtype='int64'),\n",
" 628000.0: Int64Index([2932], dtype='int64'),\n",
" 628100.0: Int64Index([2931], dtype='int64'),\n",
" 628400.0: Int64Index([2930], dtype='int64'),\n",
" 628500.0: Int64Index([2929], dtype='int64'),\n",
" 629400.0: Int64Index([2928], dtype='int64'),\n",
" 629500.0: Int64Index([2926, 2927], dtype='int64'),\n",
" 630000.0: Int64Index([2920, 2921, 2922, 2923, 2924, 2925], dtype='int64'),\n",
" 630300.0: Int64Index([2919], dtype='int64'),\n",
" 630500.0: Int64Index([2917, 2918], dtype='int64'),\n",
" 630600.0: Int64Index([2916], dtype='int64'),\n",
" 630800.0: Int64Index([2915], dtype='int64'),\n",
" 631000.0: Int64Index([2913, 2914], dtype='int64'),\n",
" 631500.0: Int64Index([2912], dtype='int64'),\n",
" 632000.0: Int64Index([2911], dtype='int64'),\n",
" 632100.0: Int64Index([2910], dtype='int64'),\n",
" 632500.0: Int64Index([2908, 2909], dtype='int64'),\n",
" 632800.0: Int64Index([2907], dtype='int64'),\n",
" 633000.0: Int64Index([2906], dtype='int64'),\n",
" 633300.0: Int64Index([2905], dtype='int64'),\n",
" 634000.0: Int64Index([2903, 2904], dtype='int64'),\n",
" 635000.0: Int64Index([2902], dtype='int64'),\n",
" 636000.0: Int64Index([2901], dtype='int64'),\n",
" 636500.0: Int64Index([2900], dtype='int64'),\n",
" 636800.0: Int64Index([2899], dtype='int64'),\n",
" 637500.0: Int64Index([2898], dtype='int64'),\n",
" 637700.0: Int64Index([2896, 2897], dtype='int64'),\n",
" 637900.0: Int64Index([2895], dtype='int64'),\n",
" 638000.0: Int64Index([2894], dtype='int64'),\n",
" 638700.0: Int64Index([2893], dtype='int64'),\n",
" 638800.0: Int64Index([2892], dtype='int64'),\n",
" 639000.0: Int64Index([2891], dtype='int64'),\n",
" 640000.0: Int64Index([2888, 2889, 2890], dtype='int64'),\n",
" 640100.0: Int64Index([2887], dtype='int64'),\n",
" 641000.0: Int64Index([2886], dtype='int64'),\n",
" 641200.0: Int64Index([2885], dtype='int64'),\n",
" 641900.0: Int64Index([2884], dtype='int64'),\n",
" 642000.0: Int64Index([2882, 2883], dtype='int64'),\n",
" 642500.0: Int64Index([2879, 2880, 2881], dtype='int64'),\n",
" 643000.0: Int64Index([2878], dtype='int64'),\n",
" 643200.0: Int64Index([2877], dtype='int64'),\n",
" 643500.0: Int64Index([2876], dtype='int64'),\n",
" 644000.0: Int64Index([2875], dtype='int64'),\n",
" 644200.0: Int64Index([2874], dtype='int64'),\n",
" 644600.0: Int64Index([2873], dtype='int64'),\n",
" 645000.0: Int64Index([2871, 2872], dtype='int64'),\n",
" 645300.0: Int64Index([2870], dtype='int64'),\n",
" 645600.0: Int64Index([2869], dtype='int64'),\n",
" 646000.0: Int64Index([2867, 2868], dtype='int64'),\n",
" 646500.0: Int64Index([2866], dtype='int64'),\n",
" 647000.0: Int64Index([2863, 2864, 2865], dtype='int64'),\n",
" 647500.0: Int64Index([2862], dtype='int64'),\n",
" 647700.0: Int64Index([2861], dtype='int64'),\n",
" 647800.0: Int64Index([2860], dtype='int64'),\n",
" 648000.0: Int64Index([2859], dtype='int64'),\n",
" 648300.0: Int64Index([2858], dtype='int64'),\n",
" 649000.0: Int64Index([2857], dtype='int64'),\n",
" 649200.0: Int64Index([2856], dtype='int64'),\n",
" 649300.0: Int64Index([2855], dtype='int64'),\n",
" 649700.0: Int64Index([2854], dtype='int64'),\n",
" 649800.0: Int64Index([2853], dtype='int64'),\n",
" 649900.0: Int64Index([2852], dtype='int64'),\n",
" 650000.0: Int64Index([2846, 2847, 2848, 2849, 2850, 2851], dtype='int64'),\n",
" 650100.0: Int64Index([2840, 2841, 2842, 2843, 2844, 2845], dtype='int64'),\n",
" 650200.0: Int64Index([2839], dtype='int64'),\n",
" 650400.0: Int64Index([2838], dtype='int64'),\n",
" 650500.0: Int64Index([2837], dtype='int64'),\n",
" 651000.0: Int64Index([2835, 2836], dtype='int64'),\n",
" 651100.0: Int64Index([2834], dtype='int64'),\n",
" 651200.0: Int64Index([2831, 2832, 2833], dtype='int64'),\n",
" 651500.0: Int64Index([2829, 2830], dtype='int64'),\n",
" 651900.0: Int64Index([2827, 2828], dtype='int64'),\n",
" 652000.0: Int64Index([2825, 2826], dtype='int64'),\n",
" 652100.0: Int64Index([2824], dtype='int64'),\n",
" 652200.0: Int64Index([2823], dtype='int64'),\n",
" 652300.0: Int64Index([2822], dtype='int64'),\n",
" 652400.0: Int64Index([2821], dtype='int64'),\n",
" 652500.0: Int64Index([2820], dtype='int64'),\n",
" 652800.0: Int64Index([2818, 2819], dtype='int64'),\n",
" 653000.0: Int64Index([2814, 2815, 2816, 2817], dtype='int64'),\n",
" 653100.0: Int64Index([2813], dtype='int64'),\n",
" 653500.0: Int64Index([2812], dtype='int64'),\n",
" 653800.0: Int64Index([2810, 2811], dtype='int64'),\n",
" 654000.0: Int64Index([2809], dtype='int64'),\n",
" 654100.0: Int64Index([2808], dtype='int64'),\n",
" 654300.0: Int64Index([2806, 2807], dtype='int64'),\n",
" 654400.0: Int64Index([2805], dtype='int64'),\n",
" 654500.0: Int64Index([2804], dtype='int64'),\n",
" 655000.0: Int64Index([2799, 2800, 2801, 2802, 2803], dtype='int64'),\n",
" 655100.0: Int64Index([2795, 2796, 2797, 2798], dtype='int64'),\n",
" 655400.0: Int64Index([2794], dtype='int64'),\n",
" 655500.0: Int64Index([2788, 2789, 2790, 2791, 2792, 2793], dtype='int64'),\n",
" 655600.0: Int64Index([2787], dtype='int64'),\n",
" 655700.0: Int64Index([2785, 2786], dtype='int64'),\n",
" 655800.0: Int64Index([2783, 2784], dtype='int64'),\n",
" 655900.0: Int64Index([2782], dtype='int64'),\n",
" 656000.0: Int64Index([2780, 2781], dtype='int64'),\n",
" 656200.0: Int64Index([2779], dtype='int64'),\n",
" 656300.0: Int64Index([2778], dtype='int64'),\n",
" 656500.0: Int64Index([2776, 2777], dtype='int64'),\n",
" 656700.0: Int64Index([2775], dtype='int64'),\n",
" 657000.0: Int64Index([2774], dtype='int64'),\n",
" 657100.0: Int64Index([2772, 2773], dtype='int64'),\n",
" 657300.0: Int64Index([2771], dtype='int64'),\n",
" 657400.0: Int64Index([2770], dtype='int64'),\n",
" 657500.0: Int64Index([2767, 2768, 2769], dtype='int64'),\n",
" 657700.0: Int64Index([2766], dtype='int64'),\n",
" 657800.0: Int64Index([2765], dtype='int64'),\n",
" 657900.0: Int64Index([2764], dtype='int64'),\n",
" 658000.0: Int64Index([2760, 2761, 2762, 2763], dtype='int64'),\n",
" 658400.0: Int64Index([2759], dtype='int64'),\n",
" 658600.0: Int64Index([2758], dtype='int64'),\n",
" 658800.0: Int64Index([2757], dtype='int64'),\n",
" 659000.0: Int64Index([2756], dtype='int64'),\n",
" 659100.0: Int64Index([2755], dtype='int64'),\n",
" 659200.0: Int64Index([2753, 2754], dtype='int64'),\n",
" 659400.0: Int64Index([2751, 2752], dtype='int64'),\n",
" 659500.0: Int64Index([2750], dtype='int64'),\n",
" 659600.0: Int64Index([2749], dtype='int64'),\n",
" 659700.0: Int64Index([2748], dtype='int64'),\n",
" 659800.0: Int64Index([2747], dtype='int64'),\n",
" 659900.0: Int64Index([2746], dtype='int64'),\n",
" 660000.0: Int64Index([2738, 2739, 2740, 2741, 2742, 2743, 2744, 2745], dtype='int64'),\n",
" 660100.0: Int64Index([2733, 2734, 2735, 2736, 2737], dtype='int64'),\n",
" 660500.0: Int64Index([2732], dtype='int64'),\n",
" 660600.0: Int64Index([2731], dtype='int64'),\n",
" 660700.0: Int64Index([2730], dtype='int64'),\n",
" 660800.0: Int64Index([2729], dtype='int64'),\n",
" 661000.0: Int64Index([2727, 2728], dtype='int64'),\n",
" 661200.0: Int64Index([2726], dtype='int64'),\n",
" 661300.0: Int64Index([2725], dtype='int64'),\n",
" 661500.0: Int64Index([2723, 2724], dtype='int64'),\n",
" 661600.0: Int64Index([2722], dtype='int64'),\n",
" 661900.0: Int64Index([2721], dtype='int64'),\n",
" 662000.0: Int64Index([2718, 2719, 2720], dtype='int64'),\n",
" 662100.0: Int64Index([2717], dtype='int64'),\n",
" 662200.0: Int64Index([2715, 2716], dtype='int64'),\n",
" 662300.0: Int64Index([2713, 2714], dtype='int64'),\n",
" 662500.0: Int64Index([2712], dtype='int64'),\n",
" 663000.0: Int64Index([2711], dtype='int64'),\n",
" 663100.0: Int64Index([2710], dtype='int64'),\n",
" 663600.0: Int64Index([2709], dtype='int64'),\n",
" 663900.0: Int64Index([2708], dtype='int64'),\n",
" 664000.0: Int64Index([2705, 2706, 2707], dtype='int64'),\n",
" 664100.0: Int64Index([2704], dtype='int64'),\n",
" 664200.0: Int64Index([2703], dtype='int64'),\n",
" 664400.0: Int64Index([2702], dtype='int64'),\n",
" 664500.0: Int64Index([2699, 2700, 2701], dtype='int64'),\n",
" 664600.0: Int64Index([2698], dtype='int64'),\n",
" 665000.0: Int64Index([2695, 2696, 2697], dtype='int64'),\n",
" 665300.0: Int64Index([2694], dtype='int64'),\n",
" 665500.0: Int64Index([2690, 2691, 2692, 2693], dtype='int64'),\n",
" 665600.0: Int64Index([2688, 2689], dtype='int64'),\n",
" 665700.0: Int64Index([2687], dtype='int64'),\n",
" 666000.0: Int64Index([2684, 2685, 2686], dtype='int64'),\n",
" 666200.0: Int64Index([2683], dtype='int64'),\n",
" 666300.0: Int64Index([2682], dtype='int64'),\n",
" 666500.0: Int64Index([2680, 2681], dtype='int64'),\n",
" 666600.0: Int64Index([2678, 2679], dtype='int64'),\n",
" 666700.0: Int64Index([2676, 2677], dtype='int64'),\n",
" 667000.0: Int64Index([2675], dtype='int64'),\n",
" 667100.0: Int64Index([2674], dtype='int64'),\n",
" 667500.0: Int64Index([2672, 2673], dtype='int64'),\n",
" 667600.0: Int64Index([2671], dtype='int64'),\n",
" 667700.0: Int64Index([2669, 2670], dtype='int64'),\n",
" 668000.0: Int64Index([2666, 2667, 2668], dtype='int64'),\n",
" 668100.0: Int64Index([2664, 2665], dtype='int64'),\n",
" 668300.0: Int64Index([2661, 2662, 2663], dtype='int64'),\n",
" 668500.0: Int64Index([2660], dtype='int64'),\n",
" 668600.0: Int64Index([2659], dtype='int64'),\n",
" 668700.0: Int64Index([2658], dtype='int64'),\n",
" 668800.0: Int64Index([2657], dtype='int64'),\n",
" 669000.0: Int64Index([2655, 2656], dtype='int64'),\n",
" 669200.0: Int64Index([2654], dtype='int64'),\n",
" 669700.0: Int64Index([2653], dtype='int64'),\n",
" 669800.0: Int64Index([2652], dtype='int64'),\n",
" 669900.0: Int64Index([2651], dtype='int64'),\n",
" 670000.0: Int64Index([2645, 2646, 2647, 2648, 2649, 2650], dtype='int64'),\n",
" 670100.0: Int64Index([2642, 2643, 2644], dtype='int64'),\n",
" 670200.0: Int64Index([2641], dtype='int64'),\n",
" 670500.0: Int64Index([2639, 2640], dtype='int64'),\n",
" 670600.0: Int64Index([2638], dtype='int64'),\n",
" 670800.0: Int64Index([2637], dtype='int64'),\n",
" 670900.0: Int64Index([2636], dtype='int64'),\n",
" 671000.0: Int64Index([2635], dtype='int64'),\n",
" 671200.0: Int64Index([2634], dtype='int64'),\n",
" 671300.0: Int64Index([2632, 2633], dtype='int64'),\n",
" 671500.0: Int64Index([2629, 2630, 2631], dtype='int64'),\n",
" 671700.0: Int64Index([2628], dtype='int64'),\n",
" 672000.0: Int64Index([2625, 2626, 2627], dtype='int64'),\n",
" 672100.0: Int64Index([2624], dtype='int64'),\n",
" 672200.0: Int64Index([2621, 2622, 2623], dtype='int64'),\n",
" 672300.0: Int64Index([2620], dtype='int64'),\n",
" 672500.0: Int64Index([2617, 2618, 2619], dtype='int64'),\n",
" 673000.0: Int64Index([2614, 2615, 2616], dtype='int64'),\n",
" 673100.0: Int64Index([2612, 2613], dtype='int64'),\n",
" 673200.0: Int64Index([2611], dtype='int64'),\n",
" 673300.0: Int64Index([2610], dtype='int64'),\n",
" 673500.0: Int64Index([2608, 2609], dtype='int64'),\n",
" 673700.0: Int64Index([2606, 2607], dtype='int64'),\n",
" 674000.0: Int64Index([2603, 2604, 2605], dtype='int64'),\n",
" 674200.0: Int64Index([2602], dtype='int64'),\n",
" 674300.0: Int64Index([2601], dtype='int64'),\n",
" 674400.0: Int64Index([2598, 2599, 2600], dtype='int64'),\n",
" 674500.0: Int64Index([2597], dtype='int64'),\n",
" 674600.0: Int64Index([2596], dtype='int64'),\n",
" 674800.0: Int64Index([2595], dtype='int64'),\n",
" 675000.0: Int64Index([2590, 2591, 2592, 2593, 2594], dtype='int64'),\n",
" 675100.0: Int64Index([2588, 2589], dtype='int64'),\n",
" 675200.0: Int64Index([2587], dtype='int64'),\n",
" 675500.0: Int64Index([2584, 2585, 2586], dtype='int64'),\n",
" 675600.0: Int64Index([2581, 2582, 2583], dtype='int64'),\n",
" 675700.0: Int64Index([2579, 2580], dtype='int64'),\n",
" 675800.0: Int64Index([2578], dtype='int64'),\n",
" 676000.0: Int64Index([2574, 2575, 2576, 2577], dtype='int64'),\n",
" 676100.0: Int64Index([2572, 2573], dtype='int64'),\n",
" 676200.0: Int64Index([2570, 2571], dtype='int64'),\n",
" 676300.0: Int64Index([2569], dtype='int64'),\n",
" 676500.0: Int64Index([2568], dtype='int64'),\n",
" 676600.0: Int64Index([2567], dtype='int64'),\n",
" 676700.0: Int64Index([2566], dtype='int64'),\n",
" 676800.0: Int64Index([2564, 2565], dtype='int64'),\n",
" 677000.0: Int64Index([2560, 2561, 2562, 2563], dtype='int64'),\n",
" 677100.0: Int64Index([2558, 2559], dtype='int64'),\n",
" 677200.0: Int64Index([2557], dtype='int64'),\n",
" 677300.0: Int64Index([2556], dtype='int64'),\n",
" 677400.0: Int64Index([2555], dtype='int64'),\n",
" 677500.0: Int64Index([2552, 2553, 2554], dtype='int64'),\n",
" 677700.0: Int64Index([2551], dtype='int64'),\n",
" 677800.0: Int64Index([2550], dtype='int64'),\n",
" 678000.0: Int64Index([2546, 2547, 2548, 2549], dtype='int64'),\n",
" 678100.0: Int64Index([2543, 2544, 2545], dtype='int64'),\n",
" 678200.0: Int64Index([2541, 2542], dtype='int64'),\n",
" 678300.0: Int64Index([2539, 2540], dtype='int64'),\n",
" 678500.0: Int64Index([2537, 2538], dtype='int64'),\n",
" 678600.0: Int64Index([2534, 2535, 2536], dtype='int64'),\n",
" 678700.0: Int64Index([2533], dtype='int64'),\n",
" 678800.0: Int64Index([2532], dtype='int64'),\n",
" 678900.0: Int64Index([2531], dtype='int64'),\n",
" 679000.0: Int64Index([2530], dtype='int64'),\n",
" 679100.0: Int64Index([2528, 2529], dtype='int64'),\n",
" 679200.0: Int64Index([2527], dtype='int64'),\n",
" 679300.0: Int64Index([2526], dtype='int64'),\n",
" 679400.0: Int64Index([2525], dtype='int64'),\n",
" 679500.0: Int64Index([2523, 2524], dtype='int64'),\n",
" 679600.0: Int64Index([2522], dtype='int64'),\n",
" 679700.0: Int64Index([2521], dtype='int64'),\n",
" 679900.0: Int64Index([2520], dtype='int64'),\n",
" 680000.0: Int64Index([2513, 2514, 2515, 2516, 2517, 2518, 2519], dtype='int64'),\n",
" 680100.0: Int64Index([2509, 2510, 2511, 2512], dtype='int64'),\n",
" 680200.0: Int64Index([2506, 2507, 2508], dtype='int64'),\n",
" 680300.0: Int64Index([2505], dtype='int64'),\n",
" 680400.0: Int64Index([2504], dtype='int64'),\n",
" 680500.0: Int64Index([2502, 2503], dtype='int64'),\n",
" 680600.0: Int64Index([2501], dtype='int64'),\n",
" 680800.0: Int64Index([2499, 2500], dtype='int64'),\n",
" 681000.0: Int64Index([2497, 2498], dtype='int64'),\n",
" 681100.0: Int64Index([2494, 2495, 2496], dtype='int64'),\n",
" 681200.0: Int64Index([2491, 2492, 2493], dtype='int64'),\n",
" 681300.0: Int64Index([2488, 2489, 2490], dtype='int64'),\n",
" 681400.0: Int64Index([2487], dtype='int64'),\n",
" 681500.0: Int64Index([2483, 2484, 2485, 2486], dtype='int64'),\n",
" 681600.0: Int64Index([2482], dtype='int64'),\n",
" 681700.0: Int64Index([2479, 2480, 2481], dtype='int64'),\n",
" 681800.0: Int64Index([2478], dtype='int64'),\n",
" 682000.0: Int64Index([2475, 2476, 2477], dtype='int64'),\n",
" 682100.0: Int64Index([2472, 2473, 2474], dtype='int64'),\n",
" 682200.0: Int64Index([2470, 2471], dtype='int64'),\n",
" 682400.0: Int64Index([2469], dtype='int64'),\n",
" 682500.0: Int64Index([2467, 2468], dtype='int64'),\n",
" 682800.0: Int64Index([2465, 2466], dtype='int64'),\n",
" 682900.0: Int64Index([2463, 2464], dtype='int64'),\n",
" 683000.0: Int64Index([2459, 2460, 2461, 2462], dtype='int64'),\n",
" 683100.0: Int64Index([2457, 2458], dtype='int64'),\n",
" 683400.0: Int64Index([2456], dtype='int64'),\n",
" 683500.0: Int64Index([2455], dtype='int64'),\n",
" 683600.0: Int64Index([2454], dtype='int64'),\n",
" 683700.0: Int64Index([2452, 2453], dtype='int64'),\n",
" 683800.0: Int64Index([2451], dtype='int64'),\n",
" 684000.0: Int64Index([2449, 2450], dtype='int64'),\n",
" 684100.0: Int64Index([2448], dtype='int64'),\n",
" 684500.0: Int64Index([2447], dtype='int64'),\n",
" 684600.0: Int64Index([2444, 2445, 2446], dtype='int64'),\n",
" 684800.0: Int64Index([2443], dtype='int64'),\n",
" 684900.0: Int64Index([2442], dtype='int64'),\n",
" 685000.0: Int64Index([2437, 2438, 2439, 2440, 2441], dtype='int64'),\n",
" 685100.0: Int64Index([2436], dtype='int64'),\n",
" 685500.0: Int64Index([2434, 2435], dtype='int64'),\n",
" 685600.0: Int64Index([2432, 2433], dtype='int64'),\n",
" 685700.0: Int64Index([2430, 2431], dtype='int64'),\n",
" 685800.0: Int64Index([2427, 2428, 2429], dtype='int64'),\n",
" 685900.0: Int64Index([2425, 2426], dtype='int64'),\n",
" 686000.0: Int64Index([2421, 2422, 2423, 2424], dtype='int64'),\n",
" 686100.0: Int64Index([2420], dtype='int64'),\n",
" 686200.0: Int64Index([2419], dtype='int64'),\n",
" 686300.0: Int64Index([2418], dtype='int64'),\n",
" 686400.0: Int64Index([2417], dtype='int64'),\n",
" 686500.0: Int64Index([2414, 2415, 2416], dtype='int64'),\n",
" 686600.0: Int64Index([2411, 2412, 2413], dtype='int64'),\n",
" 686800.0: Int64Index([2408, 2409, 2410], dtype='int64'),\n",
" 687000.0: Int64Index([2406, 2407], dtype='int64'),\n",
" 687100.0: Int64Index([2405], dtype='int64'),\n",
" 687200.0: Int64Index([2402, 2403, 2404], dtype='int64'),\n",
" 687300.0: Int64Index([2400, 2401], dtype='int64'),\n",
" 687500.0: Int64Index([2395, 2396, 2397, 2398, 2399], dtype='int64'),\n",
" 687600.0: Int64Index([2393, 2394], dtype='int64'),\n",
" 687700.0: Int64Index([2390, 2391, 2392], dtype='int64'),\n",
" 687800.0: Int64Index([2389], dtype='int64'),\n",
" 687900.0: Int64Index([2388], dtype='int64'),\n",
" 688000.0: Int64Index([2385, 2386, 2387], dtype='int64'),\n",
" 688100.0: Int64Index([2384], dtype='int64'),\n",
" 688400.0: Int64Index([2383], dtype='int64'),\n",
" 688500.0: Int64Index([2381, 2382], dtype='int64'),\n",
" 688600.0: Int64Index([2377, 2378, 2379, 2380], dtype='int64'),\n",
" 688700.0: Int64Index([2374, 2375, 2376], dtype='int64'),\n",
" 688800.0: Int64Index([2373], dtype='int64'),\n",
" 688900.0: Int64Index([2372], dtype='int64'),\n",
" 689000.0: Int64Index([2370, 2371], dtype='int64'),\n",
" 689100.0: Int64Index([2368, 2369], dtype='int64'),\n",
" 689200.0: Int64Index([2367], dtype='int64'),\n",
" 689300.0: Int64Index([2366], dtype='int64'),\n",
" 689500.0: Int64Index([2365], dtype='int64'),\n",
" 689600.0: Int64Index([2363, 2364], dtype='int64'),\n",
" 689700.0: Int64Index([2362], dtype='int64'),\n",
" 689800.0: Int64Index([2360, 2361], dtype='int64'),\n",
" 689900.0: Int64Index([2358, 2359], dtype='int64'),\n",
" 690000.0: Int64Index([2352, 2353, 2354, 2355, 2356, 2357], dtype='int64'),\n",
" 690100.0: Int64Index([2348, 2349, 2350, 2351], dtype='int64'),\n",
" 690300.0: Int64Index([2347], dtype='int64'),\n",
" 690500.0: Int64Index([2346], dtype='int64'),\n",
" 690700.0: Int64Index([2345], dtype='int64'),\n",
" 690800.0: Int64Index([2344], dtype='int64'),\n",
" 691000.0: Int64Index([2337, 2338, 2339, 2340, 2341, 2342, 2343], dtype='int64'),\n",
" 691100.0: Int64Index([2334, 2335, 2336], dtype='int64'),\n",
" 691200.0: Int64Index([2330, 2331, 2332, 2333], dtype='int64'),\n",
" 691300.0: Int64Index([2328, 2329], dtype='int64'),\n",
" 691400.0: Int64Index([2326, 2327], dtype='int64'),\n",
" 691500.0: Int64Index([2320, 2321, 2322, 2323, 2324, 2325], dtype='int64'),\n",
" 691600.0: Int64Index([2318, 2319], dtype='int64'),\n",
" 691800.0: Int64Index([2317], dtype='int64'),\n",
" 691900.0: Int64Index([2316], dtype='int64'),\n",
" 692000.0: Int64Index([2314, 2315], dtype='int64'),\n",
" 692100.0: Int64Index([2313], dtype='int64'),\n",
" 692300.0: Int64Index([2312], dtype='int64'),\n",
" 692400.0: Int64Index([2310, 2311], dtype='int64'),\n",
" 692500.0: Int64Index([2307, 2308, 2309], dtype='int64'),\n",
" 692600.0: Int64Index([2305, 2306], dtype='int64'),\n",
" 692900.0: Int64Index([2304], dtype='int64'),\n",
" 693000.0: Int64Index([2301, 2302, 2303], dtype='int64'),\n",
" 693100.0: Int64Index([2300], dtype='int64'),\n",
" 693200.0: Int64Index([2299], dtype='int64'),\n",
" 693300.0: Int64Index([2298], dtype='int64'),\n",
" 693700.0: Int64Index([2295, 2296, 2297], dtype='int64'),\n",
" 693800.0: Int64Index([2294], dtype='int64'),\n",
" 694000.0: Int64Index([2291, 2292, 2293], dtype='int64'),\n",
" 694100.0: Int64Index([2287, 2288, 2289, 2290], dtype='int64'),\n",
" 694200.0: Int64Index([2286], dtype='int64'),\n",
" 694300.0: Int64Index([2283, 2284, 2285], dtype='int64'),\n",
" 694400.0: Int64Index([2282], dtype='int64'),\n",
" 694500.0: Int64Index([2279, 2280, 2281], dtype='int64'),\n",
" 694600.0: Int64Index([2277, 2278], dtype='int64'),\n",
" 694700.0: Int64Index([2276], dtype='int64'),\n",
" 694800.0: Int64Index([2275], dtype='int64'),\n",
" 694900.0: Int64Index([2272, 2273, 2274], dtype='int64'),\n",
" 695000.0: Int64Index([2269, 2270, 2271], dtype='int64'),\n",
" 695100.0: Int64Index([2267, 2268], dtype='int64'),\n",
" 695200.0: Int64Index([2265, 2266], dtype='int64'),\n",
" 695300.0: Int64Index([2264], dtype='int64'),\n",
" 695500.0: Int64Index([2262, 2263], dtype='int64'),\n",
" 695600.0: Int64Index([2259, 2260, 2261], dtype='int64'),\n",
" 695700.0: Int64Index([2256, 2257, 2258], dtype='int64'),\n",
" 695800.0: Int64Index([2254, 2255], dtype='int64'),\n",
" 695900.0: Int64Index([2253], dtype='int64'),\n",
" 696000.0: Int64Index([2248, 2249, 2250, 2251, 2252], dtype='int64'),\n",
" 696200.0: Int64Index([2247], dtype='int64'),\n",
" 696300.0: Int64Index([2246], dtype='int64'),\n",
" 696400.0: Int64Index([2245], dtype='int64'),\n",
" 696500.0: Int64Index([2243, 2244], dtype='int64'),\n",
" 696600.0: Int64Index([2242], dtype='int64'),\n",
" 696900.0: Int64Index([2241], dtype='int64'),\n",
" 697000.0: Int64Index([2239, 2240], dtype='int64'),\n",
" 697400.0: Int64Index([2238], dtype='int64'),\n",
" 697500.0: Int64Index([2236, 2237], dtype='int64'),\n",
" 697600.0: Int64Index([2234, 2235], dtype='int64'),\n",
" 697700.0: Int64Index([2232, 2233], dtype='int64'),\n",
" 698000.0: Int64Index([2229, 2230, 2231], dtype='int64'),\n",
" 698100.0: Int64Index([2226, 2227, 2228], dtype='int64'),\n",
" 698200.0: Int64Index([2224, 2225], dtype='int64'),\n",
" 698500.0: Int64Index([2220, 2221, 2222, 2223], dtype='int64'),\n",
" 698600.0: Int64Index([2217, 2218, 2219], dtype='int64'),\n",
" 698700.0: Int64Index([2215, 2216], dtype='int64'),\n",
" 698900.0: Int64Index([2212, 2213, 2214], dtype='int64'),\n",
" 699000.0: Int64Index([2210, 2211], dtype='int64'),\n",
" 699200.0: Int64Index([2208, 2209], dtype='int64'),\n",
" 699400.0: Int64Index([2207], dtype='int64'),\n",
" 699700.0: Int64Index([2203, 2204, 2205, 2206], dtype='int64'),\n",
" 699800.0: Int64Index([2202], dtype='int64'),\n",
" 699900.0: Int64Index([2200, 2201], dtype='int64'),\n",
" 700000.0: Int64Index([2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199], dtype='int64'),\n",
" 700100.0: Int64Index([2185, 2186, 2187, 2188], dtype='int64'),\n",
" 700200.0: Int64Index([2182, 2183, 2184], dtype='int64'),\n",
" 700300.0: Int64Index([2179, 2180, 2181], dtype='int64'),\n",
" 700400.0: Int64Index([2178], dtype='int64'),\n",
" 700500.0: Int64Index([2174, 2175, 2176, 2177], dtype='int64'),\n",
" 700600.0: Int64Index([2172, 2173], dtype='int64'),\n",
" 700800.0: Int64Index([2167, 2168, 2169, 2170, 2171], dtype='int64'),\n",
" 700900.0: Int64Index([2166], dtype='int64'),\n",
" 701000.0: Int64Index([2163, 2164, 2165], dtype='int64'),\n",
" 701100.0: Int64Index([2158, 2159, 2160, 2161, 2162], dtype='int64'),\n",
" 701200.0: Int64Index([2154, 2155, 2156, 2157], dtype='int64'),\n",
" 701300.0: Int64Index([2153], dtype='int64'),\n",
" 701400.0: Int64Index([2152], dtype='int64'),\n",
" 701500.0: Int64Index([2147, 2148, 2149, 2150, 2151], dtype='int64'),\n",
" 701600.0: Int64Index([2145, 2146], dtype='int64'),\n",
" 701700.0: Int64Index([2144], dtype='int64'),\n",
" 701800.0: Int64Index([2142, 2143], dtype='int64'),\n",
" 701900.0: Int64Index([2141], dtype='int64'),\n",
" 702000.0: Int64Index([2137, 2138, 2139, 2140], dtype='int64'),\n",
" 702100.0: Int64Index([2135, 2136], dtype='int64'),\n",
" 702200.0: Int64Index([2132, 2133, 2134], dtype='int64'),\n",
" 702300.0: Int64Index([2131], dtype='int64'),\n",
" 702400.0: Int64Index([2127, 2128, 2129, 2130], dtype='int64'),\n",
" 702500.0: Int64Index([2124, 2125, 2126], dtype='int64'),\n",
" 702700.0: Int64Index([2123], dtype='int64'),\n",
" 702800.0: Int64Index([2121, 2122], dtype='int64'),\n",
" 702900.0: Int64Index([2120], dtype='int64'),\n",
" 703000.0: Int64Index([2118, 2119], dtype='int64'),\n",
" 703100.0: Int64Index([2114, 2115, 2116, 2117], dtype='int64'),\n",
" 703200.0: Int64Index([2112, 2113], dtype='int64'),\n",
" 703400.0: Int64Index([2110, 2111], dtype='int64'),\n",
" 703500.0: Int64Index([2109], dtype='int64'),\n",
" 703700.0: Int64Index([2105, 2106, 2107, 2108], dtype='int64'),\n",
" 703800.0: Int64Index([2102, 2103, 2104], dtype='int64'),\n",
" 703900.0: Int64Index([2100, 2101], dtype='int64'),\n",
" 704000.0: Int64Index([2097, 2098, 2099], dtype='int64'),\n",
" 704100.0: Int64Index([2095, 2096], dtype='int64'),\n",
" 704200.0: Int64Index([2093, 2094], dtype='int64'),\n",
" 704300.0: Int64Index([2092], dtype='int64'),\n",
" 704400.0: Int64Index([2091], dtype='int64'),\n",
" 704500.0: Int64Index([2088, 2089, 2090], dtype='int64'),\n",
" 704600.0: Int64Index([2084, 2085, 2086, 2087], dtype='int64'),\n",
" 704700.0: Int64Index([2083], dtype='int64'),\n",
" 704900.0: Int64Index([2080, 2081, 2082], dtype='int64'),\n",
" 705000.0: Int64Index([2074, 2075, 2076, 2077, 2078, 2079], dtype='int64'),\n",
" 705100.0: Int64Index([2071, 2072, 2073], dtype='int64'),\n",
" 705200.0: Int64Index([2069, 2070], dtype='int64'),\n",
" 705300.0: Int64Index([2068], dtype='int64'),\n",
" 705400.0: Int64Index([2067], dtype='int64'),\n",
" 705500.0: Int64Index([2064, 2065, 2066], dtype='int64'),\n",
" 705600.0: Int64Index([2060, 2061, 2062, 2063], dtype='int64'),\n",
" 705700.0: Int64Index([2057, 2058, 2059], dtype='int64'),\n",
" 705800.0: Int64Index([2056], dtype='int64'),\n",
" 705900.0: Int64Index([2054, 2055], dtype='int64'),\n",
" 706000.0: Int64Index([2050, 2051, 2052, 2053], dtype='int64'),\n",
" 706100.0: Int64Index([2049], dtype='int64'),\n",
" 706200.0: Int64Index([2047, 2048], dtype='int64'),\n",
" 706300.0: Int64Index([2046], dtype='int64'),\n",
" 706400.0: Int64Index([2044, 2045], dtype='int64'),\n",
" 706500.0: Int64Index([2041, 2042, 2043], dtype='int64'),\n",
" 706600.0: Int64Index([2038, 2039, 2040], dtype='int64'),\n",
" 706700.0: Int64Index([2036, 2037], dtype='int64'),\n",
" 706800.0: Int64Index([2034, 2035], dtype='int64'),\n",
" 706900.0: Int64Index([2032, 2033], dtype='int64'),\n",
" 707000.0: Int64Index([2029, 2030, 2031], dtype='int64'),\n",
" 707100.0: Int64Index([2028], dtype='int64'),\n",
" 707200.0: Int64Index([2027], dtype='int64'),\n",
" 707400.0: Int64Index([2024, 2025, 2026], dtype='int64'),\n",
" 707500.0: Int64Index([2023], dtype='int64'),\n",
" 707700.0: Int64Index([2021, 2022], dtype='int64'),\n",
" 707900.0: Int64Index([2020], dtype='int64'),\n",
" 708000.0: Int64Index([2017, 2018, 2019], dtype='int64'),\n",
" 708100.0: Int64Index([2015, 2016], dtype='int64'),\n",
" 708200.0: Int64Index([2013, 2014], dtype='int64'),\n",
" 708300.0: Int64Index([2012], dtype='int64'),\n",
" 708400.0: Int64Index([2011], dtype='int64'),\n",
" 708500.0: Int64Index([2009, 2010], dtype='int64'),\n",
" 708600.0: Int64Index([2008], dtype='int64'),\n",
" 708700.0: Int64Index([2007], dtype='int64'),\n",
" 708800.0: Int64Index([2005, 2006], dtype='int64'),\n",
" 708900.0: Int64Index([2003, 2004], dtype='int64'),\n",
" 709000.0: Int64Index([2001, 2002], dtype='int64'),\n",
" 709100.0: Int64Index([2000], dtype='int64'),\n",
" 709200.0: Int64Index([1999], dtype='int64'),\n",
" 709300.0: Int64Index([1998], dtype='int64'),\n",
" 709400.0: Int64Index([1997], dtype='int64'),\n",
" 709500.0: Int64Index([1996], dtype='int64'),\n",
" 709600.0: Int64Index([1995], dtype='int64'),\n",
" 709700.0: Int64Index([1993, 1994], dtype='int64'),\n",
" 709800.0: Int64Index([1990, 1991, 1992], dtype='int64'),\n",
" 709900.0: Int64Index([1989], dtype='int64'),\n",
" 710000.0: Int64Index([1983, 1984, 1985, 1986, 1987, 1988], dtype='int64'),\n",
" 710100.0: Int64Index([1981, 1982], dtype='int64'),\n",
" 710200.0: Int64Index([1980], dtype='int64'),\n",
" 710300.0: Int64Index([1979], dtype='int64'),\n",
" 710400.0: Int64Index([1978], dtype='int64'),\n",
" 710500.0: Int64Index([1975, 1976, 1977], dtype='int64'),\n",
" 710600.0: Int64Index([1974], dtype='int64'),\n",
" 710800.0: Int64Index([1968, 1969, 1970, 1971, 1972, 1973], dtype='int64'),\n",
" 710900.0: Int64Index([1966, 1967], dtype='int64'),\n",
" 711000.0: Int64Index([1960, 1961, 1962, 1963, 1964, 1965], dtype='int64'),\n",
" 711100.0: Int64Index([1953, 1954, 1955, 1956, 1957, 1958, 1959], dtype='int64'),\n",
" 711200.0: Int64Index([1949, 1950, 1951, 1952], dtype='int64'),\n",
" 711300.0: Int64Index([1948], dtype='int64'),\n",
" 711400.0: Int64Index([1947], dtype='int64'),\n",
" 711500.0: Int64Index([1940, 1941, 1942, 1943, 1944, 1945, 1946], dtype='int64'),\n",
" 711600.0: Int64Index([1937, 1938, 1939], dtype='int64'),\n",
" 711800.0: Int64Index([1934, 1935, 1936], dtype='int64'),\n",
" 711900.0: Int64Index([1931, 1932, 1933], dtype='int64'),\n",
" 712000.0: Int64Index([1929, 1930], dtype='int64'),\n",
" 712100.0: Int64Index([1927, 1928], dtype='int64'),\n",
" 712300.0: Int64Index([1925, 1926], dtype='int64'),\n",
" 712400.0: Int64Index([1923, 1924], dtype='int64'),\n",
" 712500.0: Int64Index([1920, 1921, 1922], dtype='int64'),\n",
" 712600.0: Int64Index([1918, 1919], dtype='int64'),\n",
" 712700.0: Int64Index([1917], dtype='int64'),\n",
" 712800.0: Int64Index([1914, 1915, 1916], dtype='int64'),\n",
" 712900.0: Int64Index([1913], dtype='int64'),\n",
" 713000.0: Int64Index([1910, 1911, 1912], dtype='int64'),\n",
" 713200.0: Int64Index([1909], dtype='int64'),\n",
" 713400.0: Int64Index([1907, 1908], dtype='int64'),\n",
" 713500.0: Int64Index([1904, 1905, 1906], dtype='int64'),\n",
" 713600.0: Int64Index([1902, 1903], dtype='int64'),\n",
" 713700.0: Int64Index([1900, 1901], dtype='int64'),\n",
" 713800.0: Int64Index([1899], dtype='int64'),\n",
" 713900.0: Int64Index([1898], dtype='int64'),\n",
" 714000.0: Int64Index([1896, 1897], dtype='int64'),\n",
" 714100.0: Int64Index([1895], dtype='int64'),\n",
" 714200.0: Int64Index([1894], dtype='int64'),\n",
" 714300.0: Int64Index([1893], dtype='int64'),\n",
" 714400.0: Int64Index([1888, 1889, 1890, 1891, 1892], dtype='int64'),\n",
" 714600.0: Int64Index([1886, 1887], dtype='int64'),\n",
" 714800.0: Int64Index([1885], dtype='int64'),\n",
" 714900.0: Int64Index([1884], dtype='int64'),\n",
" 715000.0: Int64Index([1878, 1879, 1880, 1881, 1882, 1883], dtype='int64'),\n",
" 715100.0: Int64Index([1873, 1874, 1875, 1876, 1877], dtype='int64'),\n",
" 715200.0: Int64Index([1870, 1871, 1872], dtype='int64'),\n",
" 715300.0: Int64Index([1869], dtype='int64'),\n",
" 715400.0: Int64Index([1868], dtype='int64'),\n",
" 715500.0: Int64Index([1865, 1866, 1867], dtype='int64'),\n",
" 715600.0: Int64Index([1863, 1864], dtype='int64'),\n",
" 715700.0: Int64Index([1857, 1858, 1859, 1860, 1861, 1862], dtype='int64'),\n",
" 715800.0: Int64Index([1853, 1854, 1855, 1856], dtype='int64'),\n",
" 715900.0: Int64Index([1850, 1851, 1852], dtype='int64'),\n",
" 716000.0: Int64Index([1847, 1848, 1849], dtype='int64'),\n",
" 716100.0: Int64Index([1846], dtype='int64'),\n",
" 716200.0: Int64Index([1845], dtype='int64'),\n",
" 716300.0: Int64Index([1844], dtype='int64'),\n",
" 716400.0: Int64Index([1843], dtype='int64'),\n",
" 716600.0: Int64Index([1842], dtype='int64'),\n",
" 716700.0: Int64Index([1840, 1841], dtype='int64'),\n",
" 716800.0: Int64Index([1839], dtype='int64'),\n",
" 716900.0: Int64Index([1838], dtype='int64'),\n",
" 717000.0: Int64Index([1834, 1835, 1836, 1837], dtype='int64'),\n",
" 717300.0: Int64Index([1833], dtype='int64'),\n",
" 717400.0: Int64Index([1831, 1832], dtype='int64'),\n",
" 717500.0: Int64Index([1828, 1829, 1830], dtype='int64'),\n",
" 717700.0: Int64Index([1826, 1827], dtype='int64'),\n",
" 717800.0: Int64Index([1823, 1824, 1825], dtype='int64'),\n",
" 717900.0: Int64Index([1821, 1822], dtype='int64'),\n",
" 718000.0: Int64Index([1817, 1818, 1819, 1820], dtype='int64'),\n",
" 718200.0: Int64Index([1816], dtype='int64'),\n",
" 718300.0: Int64Index([1812, 1813, 1814, 1815], dtype='int64'),\n",
" 718400.0: Int64Index([1809, 1810, 1811], dtype='int64'),\n",
" 718500.0: Int64Index([1805, 1806, 1807, 1808], dtype='int64'),\n",
" 718600.0: Int64Index([1804], dtype='int64'),\n",
" 718700.0: Int64Index([1803], dtype='int64'),\n",
" 718800.0: Int64Index([1801, 1802], dtype='int64'),\n",
" 718900.0: Int64Index([1799, 1800], dtype='int64'),\n",
" 719000.0: Int64Index([1795, 1796, 1797, 1798], dtype='int64'),\n",
" 719100.0: Int64Index([1792, 1793, 1794], dtype='int64'),\n",
" 719400.0: Int64Index([1790, 1791], dtype='int64'),\n",
" 719500.0: Int64Index([1788, 1789], dtype='int64'),\n",
" 719600.0: Int64Index([1787], dtype='int64'),\n",
" 719700.0: Int64Index([1785, 1786], dtype='int64'),\n",
" 719900.0: Int64Index([1781, 1782, 1783, 1784], dtype='int64'),\n",
" 720000.0: Int64Index([1774, 1775, 1776, 1777, 1778, 1779, 1780], dtype='int64'),\n",
" 720100.0: Int64Index([1770, 1771, 1772, 1773], dtype='int64'),\n",
" 720200.0: Int64Index([1768, 1769], dtype='int64'),\n",
" 720300.0: Int64Index([1767], dtype='int64'),\n",
" 720400.0: Int64Index([1764, 1765, 1766], dtype='int64'),\n",
" 720500.0: Int64Index([1758, 1759, 1760, 1761, 1762, 1763], dtype='int64'),\n",
" 720600.0: Int64Index([1757], dtype='int64'),\n",
" 720700.0: Int64Index([1752, 1753, 1754, 1755, 1756], dtype='int64'),\n",
" 720800.0: Int64Index([1748, 1749, 1750, 1751], dtype='int64'),\n",
" 720900.0: Int64Index([1743, 1744, 1745, 1746, 1747], dtype='int64'),\n",
" 721000.0: Int64Index([1741, 1742], dtype='int64'),\n",
" 721100.0: Int64Index([1737, 1738, 1739, 1740], dtype='int64'),\n",
" 721200.0: Int64Index([1732, 1733, 1734, 1735, 1736], dtype='int64'),\n",
" 721300.0: Int64Index([1731], dtype='int64'),\n",
" 721400.0: Int64Index([1728, 1729, 1730], dtype='int64'),\n",
" 721500.0: Int64Index([1722, 1723, 1724, 1725, 1726, 1727], dtype='int64'),\n",
" 721600.0: Int64Index([1720, 1721], dtype='int64'),\n",
" 721700.0: Int64Index([1718, 1719], dtype='int64'),\n",
" 721900.0: Int64Index([1714, 1715, 1716, 1717], dtype='int64'),\n",
" 722000.0: Int64Index([1710, 1711, 1712, 1713], dtype='int64'),\n",
" 722100.0: Int64Index([1704, 1705, 1706, 1707, 1708, 1709], dtype='int64'),\n",
" 722200.0: Int64Index([1702, 1703], dtype='int64'),\n",
" 722300.0: Int64Index([1700, 1701], dtype='int64'),\n",
" 722400.0: Int64Index([1695, 1696, 1697, 1698, 1699], dtype='int64'),\n",
" 722500.0: Int64Index([1691, 1692, 1693, 1694], dtype='int64'),\n",
" 722600.0: Int64Index([1688, 1689, 1690], dtype='int64'),\n",
" 722800.0: Int64Index([1685, 1686, 1687], dtype='int64'),\n",
" 722900.0: Int64Index([1682, 1683, 1684], dtype='int64'),\n",
" 723000.0: Int64Index([1678, 1679, 1680, 1681], dtype='int64'),\n",
" 723100.0: Int64Index([1676, 1677], dtype='int64'),\n",
" 723200.0: Int64Index([1672, 1673, 1674, 1675], dtype='int64'),\n",
" 723300.0: Int64Index([1671], dtype='int64'),\n",
" 723400.0: Int64Index([1666, 1667, 1668, 1669, 1670], dtype='int64'),\n",
" 723500.0: Int64Index([1661, 1662, 1663, 1664, 1665], dtype='int64'),\n",
" 723600.0: Int64Index([1657, 1658, 1659, 1660], dtype='int64'),\n",
" 723700.0: Int64Index([1655, 1656], dtype='int64'),\n",
" 723800.0: Int64Index([1654], dtype='int64'),\n",
" 723900.0: Int64Index([1650, 1651, 1652, 1653], dtype='int64'),\n",
" 724000.0: Int64Index([1646, 1647, 1648, 1649], dtype='int64'),\n",
" 724100.0: Int64Index([1644, 1645], dtype='int64'),\n",
" 724200.0: Int64Index([1643], dtype='int64'),\n",
" 724300.0: Int64Index([1642], dtype='int64'),\n",
" 724400.0: Int64Index([1633, 1634, 1635, 1636, 1637, 1638, 1639, 1640, 1641], dtype='int64'),\n",
" 724500.0: Int64Index([1629, 1630, 1631, 1632], dtype='int64'),\n",
" 724600.0: Int64Index([1628], dtype='int64'),\n",
" 724700.0: Int64Index([1627], dtype='int64'),\n",
" 724800.0: Int64Index([1625, 1626], dtype='int64'),\n",
" 724900.0: Int64Index([1623, 1624], dtype='int64'),\n",
" 725000.0: Int64Index([1617, 1618, 1619, 1620, 1621, 1622], dtype='int64'),\n",
" 725100.0: Int64Index([1613, 1614, 1615, 1616], dtype='int64'),\n",
" 725200.0: Int64Index([1610, 1611, 1612], dtype='int64'),\n",
" 725300.0: Int64Index([1606, 1607, 1608, 1609], dtype='int64'),\n",
" 725400.0: Int64Index([1602, 1603, 1604, 1605], dtype='int64'),\n",
" 725500.0: Int64Index([1597, 1598, 1599, 1600, 1601], dtype='int64'),\n",
" 725600.0: Int64Index([1591, 1592, 1593, 1594, 1595, 1596], dtype='int64'),\n",
" 725700.0: Int64Index([1590], dtype='int64'),\n",
" 725800.0: Int64Index([1586, 1587, 1588, 1589], dtype='int64'),\n",
" 725900.0: Int64Index([1582, 1583, 1584, 1585], dtype='int64'),\n",
" 726000.0: Int64Index([1579, 1580, 1581], dtype='int64'),\n",
" 726100.0: Int64Index([1578], dtype='int64'),\n",
" 726200.0: Int64Index([1576, 1577], dtype='int64'),\n",
" 726300.0: Int64Index([1573, 1574, 1575], dtype='int64'),\n",
" 726400.0: Int64Index([1570, 1571, 1572], dtype='int64'),\n",
" 726500.0: Int64Index([1569], dtype='int64'),\n",
" 726600.0: Int64Index([1564, 1565, 1566, 1567, 1568], dtype='int64'),\n",
" 726700.0: Int64Index([1563], dtype='int64'),\n",
" 726800.0: Int64Index([1561, 1562], dtype='int64'),\n",
" 726900.0: Int64Index([1559, 1560], dtype='int64'),\n",
" 727000.0: Int64Index([1555, 1556, 1557, 1558], dtype='int64'),\n",
" 727100.0: Int64Index([1552, 1553, 1554], dtype='int64'),\n",
" 727200.0: Int64Index([1549, 1550, 1551], dtype='int64'),\n",
" 727300.0: Int64Index([1548], dtype='int64'),\n",
" 727400.0: Int64Index([1543, 1544, 1545, 1546, 1547], dtype='int64'),\n",
" 727500.0: Int64Index([1540, 1541, 1542], dtype='int64'),\n",
" 727600.0: Int64Index([1537, 1538, 1539], dtype='int64'),\n",
" 727700.0: Int64Index([1535, 1536], dtype='int64'),\n",
" 727900.0: Int64Index([1533, 1534], dtype='int64'),\n",
" 728000.0: Int64Index([1531, 1532], dtype='int64'),\n",
" 728100.0: Int64Index([1527, 1528, 1529, 1530], dtype='int64'),\n",
" 728200.0: Int64Index([1524, 1525, 1526], dtype='int64'),\n",
" 728300.0: Int64Index([1522, 1523], dtype='int64'),\n",
" 728400.0: Int64Index([1520, 1521], dtype='int64'),\n",
" 728500.0: Int64Index([1513, 1514, 1515, 1516, 1517, 1518, 1519], dtype='int64'),\n",
" 728600.0: Int64Index([1511, 1512], dtype='int64'),\n",
" 728700.0: Int64Index([1509, 1510], dtype='int64'),\n",
" 728800.0: Int64Index([1505, 1506, 1507, 1508], dtype='int64'),\n",
" 728900.0: Int64Index([1502, 1503, 1504], dtype='int64'),\n",
" 729000.0: Int64Index([1499, 1500, 1501], dtype='int64'),\n",
" 729100.0: Int64Index([1497, 1498], dtype='int64'),\n",
" 729200.0: Int64Index([1496], dtype='int64'),\n",
" 729300.0: Int64Index([1494, 1495], dtype='int64'),\n",
" 729400.0: Int64Index([1491, 1492, 1493], dtype='int64'),\n",
" 729500.0: Int64Index([1487, 1488, 1489, 1490], dtype='int64'),\n",
" 729600.0: Int64Index([1484, 1485, 1486], dtype='int64'),\n",
" 729700.0: Int64Index([1483], dtype='int64'),\n",
" 729800.0: Int64Index([1480, 1481, 1482], dtype='int64'),\n",
" 729900.0: Int64Index([1476, 1477, 1478, 1479], dtype='int64'),\n",
" 730000.0: Int64Index([1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475], dtype='int64'),\n",
" 730100.0: Int64Index([1461, 1462, 1463, 1464, 1465], dtype='int64'),\n",
" 730200.0: Int64Index([1458, 1459, 1460], dtype='int64'),\n",
" 730300.0: Int64Index([1453, 1454, 1455, 1456, 1457], dtype='int64'),\n",
" 730400.0: Int64Index([1449, 1450, 1451, 1452], dtype='int64'),\n",
" 730500.0: Int64Index([1446, 1447, 1448], dtype='int64'),\n",
" 730600.0: Int64Index([1444, 1445], dtype='int64'),\n",
" 730800.0: Int64Index([1438, 1439, 1440, 1441, 1442, 1443], dtype='int64'),\n",
" 730900.0: Int64Index([1434, 1435, 1436, 1437], dtype='int64'),\n",
" 731000.0: Int64Index([1428, 1429, 1430, 1431, 1432, 1433], dtype='int64'),\n",
" 731100.0: Int64Index([1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427], dtype='int64'),\n",
" 731200.0: Int64Index([1413, 1414, 1415, 1416, 1417, 1418, 1419], dtype='int64'),\n",
" 731300.0: Int64Index([1409, 1410, 1411, 1412], dtype='int64'),\n",
" 731400.0: Int64Index([1406, 1407, 1408], dtype='int64'),\n",
" 731500.0: Int64Index([1401, 1402, 1403, 1404, 1405], dtype='int64'),\n",
" 731600.0: Int64Index([1398, 1399, 1400], dtype='int64'),\n",
" 731800.0: Int64Index([1395, 1396, 1397], dtype='int64'),\n",
" 731900.0: Int64Index([1391, 1392, 1393, 1394], dtype='int64'),\n",
" 732000.0: Int64Index([1386, 1387, 1388, 1389, 1390], dtype='int64'),\n",
" 732100.0: Int64Index([1381, 1382, 1383, 1384, 1385], dtype='int64'),\n",
" 732200.0: Int64Index([1380], dtype='int64'),\n",
" 732300.0: Int64Index([1377, 1378, 1379], dtype='int64'),\n",
" 732400.0: Int64Index([1371, 1372, 1373, 1374, 1375, 1376], dtype='int64'),\n",
" 732500.0: Int64Index([1369, 1370], dtype='int64'),\n",
" 732600.0: Int64Index([1366, 1367, 1368], dtype='int64'),\n",
" 732700.0: Int64Index([1365], dtype='int64'),\n",
" 732800.0: Int64Index([1360, 1361, 1362, 1363, 1364], dtype='int64'),\n",
" 732900.0: Int64Index([1358, 1359], dtype='int64'),\n",
" 733000.0: Int64Index([1353, 1354, 1355, 1356, 1357], dtype='int64'),\n",
" 733100.0: Int64Index([1351, 1352], dtype='int64'),\n",
" 733200.0: Int64Index([1349, 1350], dtype='int64'),\n",
" 733300.0: Int64Index([1346, 1347, 1348], dtype='int64'),\n",
" 733400.0: Int64Index([1342, 1343, 1344, 1345], dtype='int64'),\n",
" 733500.0: Int64Index([1338, 1339, 1340, 1341], dtype='int64'),\n",
" 733600.0: Int64Index([1334, 1335, 1336, 1337], dtype='int64'),\n",
" 733700.0: Int64Index([1331, 1332, 1333], dtype='int64'),\n",
" 733800.0: Int64Index([1328, 1329, 1330], dtype='int64'),\n",
" 733900.0: Int64Index([1326, 1327], dtype='int64'),\n",
" 734000.0: Int64Index([1321, 1322, 1323, 1324, 1325], dtype='int64'),\n",
" 734100.0: Int64Index([1317, 1318, 1319, 1320], dtype='int64'),\n",
" 734200.0: Int64Index([1314, 1315, 1316], dtype='int64'),\n",
" 734300.0: Int64Index([1310, 1311, 1312, 1313], dtype='int64'),\n",
" 734400.0: Int64Index([1306, 1307, 1308, 1309], dtype='int64'),\n",
" 734500.0: Int64Index([1303, 1304, 1305], dtype='int64'),\n",
" 734600.0: Int64Index([1300, 1301, 1302], dtype='int64'),\n",
" 734900.0: Int64Index([1297, 1298, 1299], dtype='int64'),\n",
" 735000.0: Int64Index([1292, 1293, 1294, 1295, 1296], dtype='int64'),\n",
" 735100.0: Int64Index([1287, 1288, 1289, 1290, 1291], dtype='int64'),\n",
" 735200.0: Int64Index([1282, 1283, 1284, 1285, 1286], dtype='int64'),\n",
" 735300.0: Int64Index([1278, 1279, 1280, 1281], dtype='int64'),\n",
" 735400.0: Int64Index([1274, 1275, 1276, 1277], dtype='int64'),\n",
" 735500.0: Int64Index([1269, 1270, 1271, 1272, 1273], dtype='int64'),\n",
" 735600.0: Int64Index([1263, 1264, 1265, 1266, 1267, 1268], dtype='int64'),\n",
" 735800.0: Int64Index([1259, 1260, 1261, 1262], dtype='int64'),\n",
" 735900.0: Int64Index([1255, 1256, 1257, 1258], dtype='int64'),\n",
" 736000.0: Int64Index([1253, 1254], dtype='int64'),\n",
" 736100.0: Int64Index([1247, 1248, 1249, 1250, 1251, 1252], dtype='int64'),\n",
" 736200.0: Int64Index([1243, 1244, 1245, 1246], dtype='int64'),\n",
" 736300.0: Int64Index([1241, 1242], dtype='int64'),\n",
" 736400.0: Int64Index([1238, 1239, 1240], dtype='int64'),\n",
" 736500.0: Int64Index([1235, 1236, 1237], dtype='int64'),\n",
" 736600.0: Int64Index([1229, 1230, 1231, 1232, 1233, 1234], dtype='int64'),\n",
" 736700.0: Int64Index([1223, 1224, 1225, 1226, 1227, 1228], dtype='int64'),\n",
" 736800.0: Int64Index([1219, 1220, 1221, 1222], dtype='int64'),\n",
" 736900.0: Int64Index([1214, 1215, 1216, 1217, 1218], dtype='int64'),\n",
" 737000.0: Int64Index([1208, 1209, 1210, 1211, 1212, 1213], dtype='int64'),\n",
" 737100.0: Int64Index([1203, 1204, 1205, 1206, 1207], dtype='int64'),\n",
" 737200.0: Int64Index([1200, 1201, 1202], dtype='int64'),\n",
" 737300.0: Int64Index([1197, 1198, 1199], dtype='int64'),\n",
" 737400.0: Int64Index([1192, 1193, 1194, 1195, 1196], dtype='int64'),\n",
" 737500.0: Int64Index([1189, 1190, 1191], dtype='int64'),\n",
" 737600.0: Int64Index([1184, 1185, 1186, 1187, 1188], dtype='int64'),\n",
" 737700.0: Int64Index([1179, 1180, 1181, 1182, 1183], dtype='int64'),\n",
" 737800.0: Int64Index([1176, 1177, 1178], dtype='int64'),\n",
" 737900.0: Int64Index([1170, 1171, 1172, 1173, 1174, 1175], dtype='int64'),\n",
" 738000.0: Int64Index([1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169], dtype='int64'),\n",
" 738100.0: Int64Index([1157, 1158, 1159, 1160], dtype='int64'),\n",
" 738200.0: Int64Index([1153, 1154, 1155, 1156], dtype='int64'),\n",
" 738300.0: Int64Index([1149, 1150, 1151, 1152], dtype='int64'),\n",
" 738400.0: Int64Index([1142, 1143, 1144, 1145, 1146, 1147, 1148], dtype='int64'),\n",
" 738500.0: Int64Index([1136, 1137, 1138, 1139, 1140, 1141], dtype='int64'),\n",
" 738600.0: Int64Index([1130, 1131, 1132, 1133, 1134, 1135], dtype='int64'),\n",
" 738700.0: Int64Index([1126, 1127, 1128, 1129], dtype='int64'),\n",
" 738800.0: Int64Index([1121, 1122, 1123, 1124, 1125], dtype='int64'),\n",
" 738900.0: Int64Index([1117, 1118, 1119, 1120], dtype='int64'),\n",
" 739000.0: Int64Index([1114, 1115, 1116], dtype='int64'),\n",
" 739100.0: Int64Index([1111, 1112, 1113], dtype='int64'),\n",
" 739200.0: Int64Index([1108, 1109, 1110], dtype='int64'),\n",
" 739300.0: Int64Index([1106, 1107], dtype='int64'),\n",
" 739400.0: Int64Index([1104, 1105], dtype='int64'),\n",
" 739500.0: Int64Index([1099, 1100, 1101, 1102, 1103], dtype='int64'),\n",
" 739600.0: Int64Index([1093, 1094, 1095, 1096, 1097, 1098], dtype='int64'),\n",
" 739700.0: Int64Index([1089, 1090, 1091, 1092], dtype='int64'),\n",
" 739800.0: Int64Index([1087, 1088], dtype='int64'),\n",
" 739900.0: Int64Index([1081, 1082, 1083, 1084, 1085, 1086], dtype='int64'),\n",
" 740000.0: Int64Index([1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080], dtype='int64'),\n",
" 740100.0: Int64Index([1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071], dtype='int64'),\n",
" 740200.0: Int64Index([1058, 1059, 1060, 1061], dtype='int64'),\n",
" 740300.0: Int64Index([1051, 1052, 1053, 1054, 1055, 1056, 1057], dtype='int64'),\n",
" 740400.0: Int64Index([1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050], dtype='int64'),\n",
" 740500.0: Int64Index([1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042], dtype='int64'),\n",
" 740600.0: Int64Index([1021, 1022, 1023, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031,\n",
" 1032, 1033],\n",
" dtype='int64'),\n",
" 740700.0: Int64Index([1016, 1017, 1018, 1019, 1020], dtype='int64'),\n",
" 740800.0: Int64Index([1009, 1010, 1011, 1012, 1013, 1014, 1015], dtype='int64'),\n",
" 740900.0: Int64Index([1002, 1003, 1004, 1005, 1006, 1007, 1008], dtype='int64'),\n",
" 741000.0: Int64Index([988, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000,\n",
" 1001],\n",
" dtype='int64'),\n",
" 741100.0: Int64Index([977, 978, 979, 980, 981, 982, 983, 984, 985, 986, 987], dtype='int64'),\n",
" 741200.0: Int64Index([964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976], dtype='int64'),\n",
" 741300.0: Int64Index([961, 962, 963], dtype='int64'),\n",
" 741400.0: Int64Index([951, 952, 953, 954, 955, 956, 957, 958, 959, 960], dtype='int64'),\n",
" 741500.0: Int64Index([943, 944, 945, 946, 947, 948, 949, 950], dtype='int64'),\n",
" 741600.0: Int64Index([936, 937, 938, 939, 940, 941, 942], dtype='int64'),\n",
" 741700.0: Int64Index([932, 933, 934, 935], dtype='int64'),\n",
" 741800.0: Int64Index([926, 927, 928, 929, 930, 931], dtype='int64'),\n",
" 741900.0: Int64Index([918, 919, 920, 921, 922, 923, 924, 925], dtype='int64'),\n",
" 742000.0: Int64Index([901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913,\n",
" 914, 915, 916, 917],\n",
" dtype='int64'),\n",
" ...}"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"{749900.0: Int64Index([0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18,\n",
" 19],\n",
" dtype='int64'),\n",
" 750000.0: Int64Index([20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36,\n",
" 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50],\n",
" dtype='int64'),\n",
" 750100.0: Int64Index([51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67,\n",
" 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82],\n",
" dtype='int64'),\n",
" 750200.0: Int64Index([ 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95,\n",
" 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108,\n",
" 109, 110, 111, 112, 113, 114, 115, 116, 117],\n",
" dtype='int64'),\n",
" 750300.0: Int64Index([118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130,\n",
" 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143,\n",
" 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156],\n",
" dtype='int64'),\n",
" 750400.0: Int64Index([157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169,\n",
" 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182,\n",
" 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195,\n",
" 196, 197, 198, 199, 200, 201],\n",
" dtype='int64'),\n",
" 750500.0: Int64Index([202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214,\n",
" 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227,\n",
" 228, 229, 230, 231, 232, 233, 234, 235, 236, 237],\n",
" dtype='int64'),\n",
" 750600.0: Int64Index([238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250,\n",
" 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263,\n",
" 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276,\n",
" 277],\n",
" dtype='int64'),\n",
" 750700.0: Int64Index([278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290,\n",
" 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303,\n",
" 304, 305, 306, 307, 308, 309, 310, 311, 312],\n",
" dtype='int64'),\n",
" 750800.0: Int64Index([313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325,\n",
" 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338,\n",
" 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351,\n",
" 352, 353, 354, 355, 356],\n",
" dtype='int64'),\n",
" 750900.0: Int64Index([357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369,\n",
" 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382,\n",
" 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393],\n",
" dtype='int64'),\n",
" 751000.0: Int64Index([394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406,\n",
" 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419,\n",
" 420, 421, 422, 423, 424, 425, 426, 427],\n",
" dtype='int64'),\n",
" 751100.0: Int64Index([428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440,\n",
" 441, 442, 443, 444, 445, 446, 447, 448],\n",
" dtype='int64'),\n",
" 751200.0: Int64Index([449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461,\n",
" 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473],\n",
" dtype='int64'),\n",
" 751300.0: Int64Index([474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486,\n",
" 487, 488, 489, 490, 491, 492, 493],\n",
" dtype='int64'),\n",
" 751400.0: Int64Index([494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506,\n",
" 507, 508, 509],\n",
" dtype='int64'),\n",
" 751500.0: Int64Index([510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522,\n",
" 523, 524, 525, 526, 527, 528],\n",
" dtype='int64'),\n",
" 751600.0: Int64Index([529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539], dtype='int64'),\n",
" 751700.0: Int64Index([540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552,\n",
" 553, 554, 555, 556, 557, 558],\n",
" dtype='int64'),\n",
" 751800.0: Int64Index([559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571,\n",
" 572, 573, 574, 575, 576, 577, 578],\n",
" dtype='int64'),\n",
" 751900.0: Int64Index([579, 580, 581, 582, 583, 584, 585, 586, 587, 588], dtype='int64'),\n",
" 752000.0: Int64Index([589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601], dtype='int64'),\n",
" 752100.0: Int64Index([602, 603, 604, 605, 606, 607, 608, 609], dtype='int64'),\n",
" 752200.0: Int64Index([610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 620, 621, 622,\n",
" 623, 624, 625, 626, 627, 628, 629, 630],\n",
" dtype='int64'),\n",
" 752300.0: Int64Index([631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641], dtype='int64'),\n",
" 752400.0: Int64Index([642, 643, 644, 645, 646, 647, 648, 649], dtype='int64'),\n",
" 752500.0: Int64Index([650, 651, 652, 653, 654, 655, 656, 657, 658, 659, 660, 661], dtype='int64'),\n",
" 752600.0: Int64Index([662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 673, 674,\n",
" 675, 676, 677],\n",
" dtype='int64'),\n",
" 752700.0: Int64Index([678, 679, 680, 681, 682, 683, 684, 685, 686, 687, 688, 689, 690,\n",
" 691, 692, 693],\n",
" dtype='int64'),\n",
" 752800.0: Int64Index([694, 695, 696, 697, 698, 699, 700, 701, 702, 703, 704, 705, 706,\n",
" 707, 708],\n",
" dtype='int64'),\n",
" 752900.0: Int64Index([709, 710, 711, 712, 713, 714, 715, 716, 717, 718, 719, 720, 721,\n",
" 722],\n",
" dtype='int64'),\n",
" 753000.0: Int64Index([723, 724, 725, 726, 727, 728, 729, 730, 731, 732], dtype='int64'),\n",
" 753100.0: Int64Index([733, 734, 735, 736, 737, 738, 739, 740, 741, 742], dtype='int64'),\n",
" 753200.0: Int64Index([743, 744, 745, 746, 747, 748, 749, 750], dtype='int64'),\n",
" 753300.0: Int64Index([751, 752, 753, 754, 755, 756, 757, 758, 759, 760], dtype='int64'),\n",
" 753400.0: Int64Index([761, 762, 763, 764, 765], dtype='int64'),\n",
" 753500.0: Int64Index([766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776], dtype='int64'),\n",
" 753600.0: Int64Index([777, 778, 779, 780, 781, 782, 783, 784, 785], dtype='int64'),\n",
" 753700.0: Int64Index([786, 787, 788, 789, 790, 791], dtype='int64'),\n",
" 753800.0: Int64Index([792, 793, 794, 795, 796, 797, 798, 799, 800], dtype='int64'),\n",
" 753900.0: Int64Index([801, 802, 803, 804, 805, 806, 807, 808, 809], dtype='int64'),\n",
" 754000.0: Int64Index([810, 811, 812, 813, 814, 815, 816, 817, 818, 819], dtype='int64'),\n",
" 754100.0: Int64Index([820, 821, 822, 823, 824, 825], dtype='int64'),\n",
" 754200.0: Int64Index([826, 827, 828, 829, 830, 831, 832, 833, 834, 835], dtype='int64'),\n",
" 754300.0: Int64Index([836, 837, 838, 839, 840, 841, 842, 843], dtype='int64'),\n",
" 754400.0: Int64Index([844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855], dtype='int64'),\n",
" 754500.0: Int64Index([856, 857, 858, 859, 860, 861, 862], dtype='int64'),\n",
" 754600.0: Int64Index([863, 864, 865, 866, 867], dtype='int64'),\n",
" 754700.0: Int64Index([868, 869, 870, 871, 872, 873], dtype='int64'),\n",
" 754800.0: Int64Index([874, 875, 876, 877, 878, 879, 880, 881, 882], dtype='int64'),\n",
" 754900.0: Int64Index([883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893], dtype='int64'),\n",
" 755000.0: Int64Index([894, 895, 896, 897, 898, 899, 900, 901, 902], dtype='int64'),\n",
" 755100.0: Int64Index([903, 904, 905, 906, 907, 908, 909, 910, 911], dtype='int64'),\n",
" 755200.0: Int64Index([912, 913, 914, 915, 916, 917, 918, 919], dtype='int64'),\n",
" 755300.0: Int64Index([920, 921, 922, 923, 924, 925, 926, 927], dtype='int64'),\n",
" 755400.0: Int64Index([928, 929, 930, 931, 932, 933, 934], dtype='int64'),\n",
" 755500.0: Int64Index([935, 936, 937, 938, 939], dtype='int64'),\n",
" 755600.0: Int64Index([940, 941, 942, 943], dtype='int64'),\n",
" 755700.0: Int64Index([944, 945, 946], dtype='int64'),\n",
" 755800.0: Int64Index([947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 957], dtype='int64'),\n",
" 755900.0: Int64Index([958, 959, 960, 961, 962, 963, 964, 965], dtype='int64'),\n",
" 756000.0: Int64Index([966, 967, 968, 969, 970, 971, 972, 973], dtype='int64'),\n",
" 756100.0: Int64Index([974, 975, 976], dtype='int64'),\n",
" 756200.0: Int64Index([977, 978, 979, 980, 981, 982], dtype='int64'),\n",
" 756300.0: Int64Index([983, 984, 985, 986, 987, 988, 989, 990, 991, 992, 993, 994], dtype='int64'),\n",
" 756400.0: Int64Index([995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005], dtype='int64'),\n",
" 756500.0: Int64Index([1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014], dtype='int64'),\n",
" 756600.0: Int64Index([1015, 1016, 1017, 1018, 1019], dtype='int64'),\n",
" 756700.0: Int64Index([1020, 1021, 1022, 1023, 1024, 1025, 1026], dtype='int64'),\n",
" 756800.0: Int64Index([1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037], dtype='int64'),\n",
" 756900.0: Int64Index([1038, 1039, 1040, 1041, 1042, 1043], dtype='int64'),\n",
" 757000.0: Int64Index([1044, 1045, 1046, 1047, 1048, 1049], dtype='int64'),\n",
" 757100.0: Int64Index([1050, 1051, 1052, 1053, 1054, 1055, 1056, 1057, 1058], dtype='int64'),\n",
" 757200.0: Int64Index([1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067], dtype='int64'),\n",
" 757300.0: Int64Index([1068, 1069, 1070, 1071, 1072, 1073], dtype='int64'),\n",
" 757400.0: Int64Index([1074, 1075, 1076, 1077, 1078, 1079, 1080], dtype='int64'),\n",
" 757500.0: Int64Index([1081, 1082, 1083, 1084, 1085], dtype='int64'),\n",
" 757600.0: Int64Index([1086, 1087, 1088, 1089, 1090, 1091, 1092, 1093], dtype='int64'),\n",
" 757700.0: Int64Index([1094, 1095, 1096], dtype='int64'),\n",
" 757800.0: Int64Index([1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1105, 1106, 1107], dtype='int64'),\n",
" 757900.0: Int64Index([1108, 1109, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117], dtype='int64'),\n",
" 758000.0: Int64Index([1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128,\n",
" 1129, 1130, 1131, 1132],\n",
" dtype='int64'),\n",
" 758100.0: Int64Index([1133, 1134, 1135, 1136, 1137], dtype='int64'),\n",
" 758200.0: Int64Index([1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146], dtype='int64'),\n",
" 758300.0: Int64Index([1147, 1148, 1149, 1150, 1151, 1152], dtype='int64'),\n",
" 758400.0: Int64Index([1153, 1154, 1155, 1156, 1157, 1158], dtype='int64'),\n",
" 758500.0: Int64Index([1159, 1160, 1161], dtype='int64'),\n",
" 758600.0: Int64Index([1162, 1163, 1164], dtype='int64'),\n",
" 758700.0: Int64Index([1165, 1166, 1167, 1168, 1169], dtype='int64'),\n",
" 758800.0: Int64Index([1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177], dtype='int64'),\n",
" 758900.0: Int64Index([1178, 1179, 1180, 1181, 1182, 1183], dtype='int64'),\n",
" 759000.0: Int64Index([1184, 1185, 1186, 1187, 1188], dtype='int64'),\n",
" 759100.0: Int64Index([1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196], dtype='int64'),\n",
" 759200.0: Int64Index([1197, 1198, 1199, 1200, 1201, 1202, 1203], dtype='int64'),\n",
" 759300.0: Int64Index([1204, 1205, 1206, 1207, 1208], dtype='int64'),\n",
" 759400.0: Int64Index([1209, 1210, 1211, 1212, 1213, 1214], dtype='int64'),\n",
" 759500.0: Int64Index([1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223], dtype='int64'),\n",
" 759600.0: Int64Index([1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232], dtype='int64'),\n",
" 759700.0: Int64Index([1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241], dtype='int64'),\n",
" 759800.0: Int64Index([1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250], dtype='int64'),\n",
" 759900.0: Int64Index([1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261], dtype='int64'),\n",
" 760000.0: Int64Index([1262, 1263, 1264], dtype='int64'),\n",
" 760100.0: Int64Index([1265, 1266, 1267, 1268, 1269, 1270], dtype='int64'),\n",
" 760200.0: Int64Index([1271, 1272, 1273, 1274, 1275, 1276], dtype='int64'),\n",
" 760300.0: Int64Index([1277, 1278, 1279, 1280, 1281], dtype='int64'),\n",
" 760400.0: Int64Index([1282, 1283, 1284, 1285, 1286, 1287, 1288, 1289], dtype='int64'),\n",
" 760500.0: Int64Index([1290, 1291, 1292, 1293], dtype='int64'),\n",
" 760600.0: Int64Index([1294, 1295, 1296, 1297, 1298], dtype='int64'),\n",
" 760700.0: Int64Index([1299, 1300, 1301, 1302, 1303, 1304], dtype='int64'),\n",
" 760800.0: Int64Index([1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312], dtype='int64'),\n",
" 760900.0: Int64Index([1313, 1314, 1315, 1316, 1317, 1318, 1319, 1320], dtype='int64'),\n",
" 761000.0: Int64Index([1321, 1322, 1323, 1324, 1325, 1326, 1327], dtype='int64'),\n",
" 761100.0: Int64Index([1328, 1329, 1330, 1331], dtype='int64'),\n",
" 761200.0: Int64Index([1332, 1333, 1334, 1335, 1336, 1337], dtype='int64'),\n",
" 761300.0: Int64Index([1338, 1339, 1340, 1341, 1342], dtype='int64'),\n",
" 761400.0: Int64Index([1343, 1344, 1345, 1346, 1347, 1348, 1349, 1350, 1351], dtype='int64'),\n",
" 761500.0: Int64Index([1352, 1353, 1354, 1355, 1356], dtype='int64'),\n",
" 761600.0: Int64Index([1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364], dtype='int64'),\n",
" 761700.0: Int64Index([1365, 1366, 1367, 1368, 1369], dtype='int64'),\n",
" 761800.0: Int64Index([1370, 1371, 1372, 1373, 1374], dtype='int64'),\n",
" 761900.0: Int64Index([1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383], dtype='int64'),\n",
" 762000.0: Int64Index([1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392], dtype='int64'),\n",
" 762100.0: Int64Index([1393, 1394, 1395, 1396, 1397, 1398], dtype='int64'),\n",
" 762200.0: Int64Index([1399, 1400, 1401, 1402, 1403], dtype='int64'),\n",
" 762300.0: Int64Index([1404, 1405, 1406, 1407, 1408, 1409], dtype='int64'),\n",
" 762400.0: Int64Index([1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418], dtype='int64'),\n",
" 762500.0: Int64Index([1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426], dtype='int64'),\n",
" 762600.0: Int64Index([1427, 1428, 1429, 1430], dtype='int64'),\n",
" 762700.0: Int64Index([1431, 1432, 1433, 1434], dtype='int64'),\n",
" 762800.0: Int64Index([1435, 1436, 1437, 1438], dtype='int64'),\n",
" 762900.0: Int64Index([1439, 1440, 1441, 1442, 1443, 1444, 1445, 1446], dtype='int64'),\n",
" 763000.0: Int64Index([1447, 1448, 1449, 1450, 1451, 1452, 1453, 1454, 1455, 1456], dtype='int64'),\n",
" 763100.0: Int64Index([1457, 1458, 1459, 1460], dtype='int64'),\n",
" 763200.0: Int64Index([1461, 1462, 1463], dtype='int64'),\n",
" 763300.0: Int64Index([1464, 1465, 1466, 1467], dtype='int64'),\n",
" 763400.0: Int64Index([1468, 1469, 1470, 1471, 1472, 1473, 1474], dtype='int64'),\n",
" 763500.0: Int64Index([1475, 1476, 1477, 1478, 1479, 1480, 1481, 1482, 1483, 1484], dtype='int64'),\n",
" 763600.0: Int64Index([1485, 1486, 1487], dtype='int64'),\n",
" 763700.0: Int64Index([1488, 1489, 1490, 1491], dtype='int64'),\n",
" 763800.0: Int64Index([1492, 1493, 1494, 1495], dtype='int64'),\n",
" 763900.0: Int64Index([1496, 1497, 1498, 1499, 1500, 1501], dtype='int64'),\n",
" 764000.0: Int64Index([1502, 1503, 1504, 1505, 1506, 1507, 1508], dtype='int64'),\n",
" 764100.0: Int64Index([1509, 1510, 1511], dtype='int64'),\n",
" 764200.0: Int64Index([1512, 1513, 1514, 1515], dtype='int64'),\n",
" 764300.0: Int64Index([1516, 1517, 1518], dtype='int64'),\n",
" 764400.0: Int64Index([1519, 1520, 1521, 1522, 1523, 1524], dtype='int64'),\n",
" 764500.0: Int64Index([1525, 1526, 1527, 1528, 1529, 1530, 1531], dtype='int64'),\n",
" 764600.0: Int64Index([1532, 1533, 1534, 1535], dtype='int64'),\n",
" 764700.0: Int64Index([1536, 1537, 1538, 1539], dtype='int64'),\n",
" 764800.0: Int64Index([1540, 1541], dtype='int64'),\n",
" 764900.0: Int64Index([1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549], dtype='int64'),\n",
" 765000.0: Int64Index([1550, 1551, 1552, 1553, 1554, 1555], dtype='int64'),\n",
" 765100.0: Int64Index([1556, 1557, 1558, 1559], dtype='int64'),\n",
" 765200.0: Int64Index([1560, 1561, 1562, 1563, 1564, 1565, 1566], dtype='int64'),\n",
" 765300.0: Int64Index([1567, 1568, 1569, 1570, 1571], dtype='int64'),\n",
" 765400.0: Int64Index([1572, 1573, 1574, 1575, 1576, 1577], dtype='int64'),\n",
" 765500.0: Int64Index([1578, 1579, 1580], dtype='int64'),\n",
" 765600.0: Int64Index([1581, 1582, 1583, 1584, 1585], dtype='int64'),\n",
" 765700.0: Int64Index([1586, 1587, 1588], dtype='int64'),\n",
" 765800.0: Int64Index([1589, 1590, 1591, 1592, 1593, 1594, 1595, 1596], dtype='int64'),\n",
" 765900.0: Int64Index([1597, 1598, 1599, 1600, 1601, 1602], dtype='int64'),\n",
" 766000.0: Int64Index([1603, 1604, 1605, 1606, 1607], dtype='int64'),\n",
" 766100.0: Int64Index([1608, 1609, 1610], dtype='int64'),\n",
" 766200.0: Int64Index([1611, 1612, 1613], dtype='int64'),\n",
" 766300.0: Int64Index([1614, 1615, 1616, 1617], dtype='int64'),\n",
" 766400.0: Int64Index([1618, 1619], dtype='int64'),\n",
" 766500.0: Int64Index([1620, 1621, 1622, 1623], dtype='int64'),\n",
" 766600.0: Int64Index([1624, 1625, 1626, 1627], dtype='int64'),\n",
" 766700.0: Int64Index([1628, 1629, 1630], dtype='int64'),\n",
" 766800.0: Int64Index([1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638], dtype='int64'),\n",
" 766900.0: Int64Index([1639, 1640, 1641, 1642], dtype='int64'),\n",
" 767000.0: Int64Index([1643, 1644, 1645, 1646], dtype='int64'),\n",
" 767100.0: Int64Index([1647, 1648], dtype='int64'),\n",
" 767200.0: Int64Index([1649, 1650], dtype='int64'),\n",
" 767300.0: Int64Index([1651], dtype='int64'),\n",
" 767400.0: Int64Index([1652, 1653], dtype='int64'),\n",
" 767500.0: Int64Index([1654, 1655, 1656, 1657, 1658, 1659, 1660, 1661], dtype='int64'),\n",
" 767600.0: Int64Index([1662], dtype='int64'),\n",
" 767700.0: Int64Index([1663, 1664], dtype='int64'),\n",
" 767800.0: Int64Index([1665, 1666, 1667], dtype='int64'),\n",
" 767900.0: Int64Index([1668, 1669, 1670, 1671, 1672], dtype='int64'),\n",
" 768000.0: Int64Index([1673, 1674, 1675, 1676], dtype='int64'),\n",
" 768100.0: Int64Index([1677], dtype='int64'),\n",
" 768200.0: Int64Index([1678, 1679, 1680, 1681, 1682, 1683, 1684], dtype='int64'),\n",
" 768300.0: Int64Index([1685, 1686, 1687, 1688, 1689], dtype='int64'),\n",
" 768400.0: Int64Index([1690, 1691, 1692, 1693], dtype='int64'),\n",
" 768500.0: Int64Index([1694, 1695, 1696, 1697, 1698, 1699, 1700, 1701], dtype='int64'),\n",
" 768600.0: Int64Index([1702, 1703], dtype='int64'),\n",
" 768700.0: Int64Index([1704, 1705, 1706, 1707], dtype='int64'),\n",
" 768800.0: Int64Index([1708, 1709, 1710], dtype='int64'),\n",
" 768900.0: Int64Index([1711, 1712, 1713, 1714, 1715, 1716, 1717], dtype='int64'),\n",
" 769000.0: Int64Index([1718, 1719, 1720, 1721, 1722, 1723], dtype='int64'),\n",
" 769100.0: Int64Index([1724, 1725, 1726, 1727], dtype='int64'),\n",
" 769200.0: Int64Index([1728, 1729, 1730, 1731], dtype='int64'),\n",
" 769300.0: Int64Index([1732, 1733, 1734], dtype='int64'),\n",
" 769400.0: Int64Index([1735, 1736, 1737, 1738], dtype='int64'),\n",
" 769500.0: Int64Index([1739, 1740, 1741, 1742, 1743, 1744], dtype='int64'),\n",
" 769600.0: Int64Index([1745, 1746, 1747, 1748], dtype='int64'),\n",
" 769700.0: Int64Index([1749, 1750, 1751, 1752], dtype='int64'),\n",
" 769800.0: Int64Index([1753, 1754, 1755, 1756], dtype='int64'),\n",
" 769900.0: Int64Index([1757, 1758, 1759, 1760, 1761, 1762, 1763, 1764, 1765, 1766, 1767,\n",
" 1768, 1769, 1770, 1771, 1772],\n",
" dtype='int64'),\n",
" 770000.0: Int64Index([1773, 1774, 1775, 1776, 1777, 1778], dtype='int64'),\n",
" 770100.0: Int64Index([1779, 1780], dtype='int64'),\n",
" 770200.0: Int64Index([1781, 1782, 1783], dtype='int64'),\n",
" 770300.0: Int64Index([1784, 1785], dtype='int64'),\n",
" 770400.0: Int64Index([1786], dtype='int64'),\n",
" 770500.0: Int64Index([1787, 1788, 1789, 1790], dtype='int64'),\n",
" 770600.0: Int64Index([1791, 1792, 1793], dtype='int64'),\n",
" 770700.0: Int64Index([1794, 1795, 1796], dtype='int64'),\n",
" 770800.0: Int64Index([1797], dtype='int64'),\n",
" 770900.0: Int64Index([1798, 1799, 1800, 1801, 1802], dtype='int64'),\n",
" 771000.0: Int64Index([1803, 1804, 1805], dtype='int64'),\n",
" 771100.0: Int64Index([1806, 1807, 1808], dtype='int64'),\n",
" 771200.0: Int64Index([1809, 1810], dtype='int64'),\n",
" 771400.0: Int64Index([1811, 1812, 1813, 1814], dtype='int64'),\n",
" 771500.0: Int64Index([1815, 1816, 1817], dtype='int64'),\n",
" 771600.0: Int64Index([1818, 1819, 1820, 1821], dtype='int64'),\n",
" 771700.0: Int64Index([1822], dtype='int64'),\n",
" 771800.0: Int64Index([1823, 1824], dtype='int64'),\n",
" 771900.0: Int64Index([1825, 1826], dtype='int64'),\n",
" 772000.0: Int64Index([1827, 1828, 1829, 1830, 1831], dtype='int64'),\n",
" 772100.0: Int64Index([1832, 1833, 1834], dtype='int64'),\n",
" 772200.0: Int64Index([1835, 1836, 1837, 1838, 1839], dtype='int64'),\n",
" 772300.0: Int64Index([1840], dtype='int64'),\n",
" 772400.0: Int64Index([1841], dtype='int64'),\n",
" 772500.0: Int64Index([1842, 1843, 1844, 1845], dtype='int64'),\n",
" 772600.0: Int64Index([1846, 1847, 1848, 1849, 1850, 1851], dtype='int64'),\n",
" 772800.0: Int64Index([1852], dtype='int64'),\n",
" 772900.0: Int64Index([1853, 1854], dtype='int64'),\n",
" 773000.0: Int64Index([1855, 1856, 1857, 1858], dtype='int64'),\n",
" 773100.0: Int64Index([1859], dtype='int64'),\n",
" 773200.0: Int64Index([1860, 1861], dtype='int64'),\n",
" 773400.0: Int64Index([1862, 1863, 1864], dtype='int64'),\n",
" 773500.0: Int64Index([1865, 1866, 1867, 1868], dtype='int64'),\n",
" 773600.0: Int64Index([1869, 1870, 1871, 1872], dtype='int64'),\n",
" 773700.0: Int64Index([1873, 1874], dtype='int64'),\n",
" 773800.0: Int64Index([1875, 1876], dtype='int64'),\n",
" 773900.0: Int64Index([1877, 1878, 1879], dtype='int64'),\n",
" 774000.0: Int64Index([1880], dtype='int64'),\n",
" 774100.0: Int64Index([1881, 1882, 1883], dtype='int64'),\n",
" 774200.0: Int64Index([1884, 1885], dtype='int64'),\n",
" 774300.0: Int64Index([1886, 1887], dtype='int64'),\n",
" 774400.0: Int64Index([1888, 1889], dtype='int64'),\n",
" 774500.0: Int64Index([1890, 1891, 1892, 1893], dtype='int64'),\n",
" 774600.0: Int64Index([1894, 1895, 1896, 1897, 1898], dtype='int64'),\n",
" 774700.0: Int64Index([1899, 1900], dtype='int64'),\n",
" 774800.0: Int64Index([1901, 1902, 1903, 1904, 1905], dtype='int64'),\n",
" 774900.0: Int64Index([1906, 1907, 1908, 1909, 1910], dtype='int64'),\n",
" 775000.0: Int64Index([1911, 1912, 1913, 1914, 1915], dtype='int64'),\n",
" 775100.0: Int64Index([1916, 1917, 1918, 1919], dtype='int64'),\n",
" 775200.0: Int64Index([1920], dtype='int64'),\n",
" 775300.0: Int64Index([1921], dtype='int64'),\n",
" 775400.0: Int64Index([1922, 1923], dtype='int64'),\n",
" 775500.0: Int64Index([1924, 1925, 1926, 1927], dtype='int64'),\n",
" 775600.0: Int64Index([1928, 1929, 1930], dtype='int64'),\n",
" 775700.0: Int64Index([1931, 1932, 1933], dtype='int64'),\n",
" 775800.0: Int64Index([1934, 1935], dtype='int64'),\n",
" 775900.0: Int64Index([1936, 1937, 1938, 1939, 1940, 1941, 1942], dtype='int64'),\n",
" 776000.0: Int64Index([1943, 1944], dtype='int64'),\n",
" 776100.0: Int64Index([1945, 1946, 1947, 1948], dtype='int64'),\n",
" 776200.0: Int64Index([1949, 1950, 1951], dtype='int64'),\n",
" 776300.0: Int64Index([1952, 1953], dtype='int64'),\n",
" 776400.0: Int64Index([1954, 1955], dtype='int64'),\n",
" 776500.0: Int64Index([1956, 1957, 1958], dtype='int64'),\n",
" 776600.0: Int64Index([1959, 1960, 1961, 1962], dtype='int64'),\n",
" 776700.0: Int64Index([1963, 1964, 1965], dtype='int64'),\n",
" 776800.0: Int64Index([1966, 1967, 1968], dtype='int64'),\n",
" 776900.0: Int64Index([1969, 1970, 1971, 1972], dtype='int64'),\n",
" 777000.0: Int64Index([1973, 1974, 1975], dtype='int64'),\n",
" 777100.0: Int64Index([1976, 1977, 1978], dtype='int64'),\n",
" 777200.0: Int64Index([1979, 1980, 1981], dtype='int64'),\n",
" 777300.0: Int64Index([1982, 1983], dtype='int64'),\n",
" 777400.0: Int64Index([1984], dtype='int64'),\n",
" 777500.0: Int64Index([1985, 1986, 1987, 1988, 1989, 1990], dtype='int64'),\n",
" 777600.0: Int64Index([1991, 1992, 1993], dtype='int64'),\n",
" 777700.0: Int64Index([1994, 1995, 1996, 1997, 1998, 1999, 2000], dtype='int64'),\n",
" 777800.0: Int64Index([2001, 2002, 2003], dtype='int64'),\n",
" 777900.0: Int64Index([2004, 2005, 2006, 2007], dtype='int64'),\n",
" 778000.0: Int64Index([2008, 2009, 2010], dtype='int64'),\n",
" 778100.0: Int64Index([2011, 2012], dtype='int64'),\n",
" 778200.0: Int64Index([2013, 2014, 2015], dtype='int64'),\n",
" 778300.0: Int64Index([2016, 2017, 2018], dtype='int64'),\n",
" 778400.0: Int64Index([2019, 2020, 2021], dtype='int64'),\n",
" 778500.0: Int64Index([2022, 2023, 2024], dtype='int64'),\n",
" 778600.0: Int64Index([2025, 2026, 2027, 2028, 2029, 2030], dtype='int64'),\n",
" 778700.0: Int64Index([2031, 2032, 2033, 2034], dtype='int64'),\n",
" 778800.0: Int64Index([2035, 2036], dtype='int64'),\n",
" 778900.0: Int64Index([2037, 2038, 2039, 2040, 2041, 2042], dtype='int64'),\n",
" 779000.0: Int64Index([2043], dtype='int64'),\n",
" 779100.0: Int64Index([2044, 2045, 2046], dtype='int64'),\n",
" 779200.0: Int64Index([2047, 2048], dtype='int64'),\n",
" 779300.0: Int64Index([2049, 2050, 2051, 2052], dtype='int64'),\n",
" 779400.0: Int64Index([2053, 2054, 2055], dtype='int64'),\n",
" 779500.0: Int64Index([2056, 2057, 2058, 2059, 2060, 2061], dtype='int64'),\n",
" 779600.0: Int64Index([2062, 2063, 2064, 2065, 2066, 2067, 2068], dtype='int64'),\n",
" 779700.0: Int64Index([2069, 2070, 2071, 2072], dtype='int64'),\n",
" 779800.0: Int64Index([2073, 2074, 2075, 2076, 2077], dtype='int64'),\n",
" 779900.0: Int64Index([2078, 2079, 2080, 2081, 2082, 2083, 2084, 2085], dtype='int64'),\n",
" 780000.0: Int64Index([2086, 2087, 2088, 2089, 2090, 2091], dtype='int64'),\n",
" 780100.0: Int64Index([2092], dtype='int64'),\n",
" 780200.0: Int64Index([2093, 2094], dtype='int64'),\n",
" 780300.0: Int64Index([2095, 2096], dtype='int64'),\n",
" 780400.0: Int64Index([2097, 2098, 2099], dtype='int64'),\n",
" 780500.0: Int64Index([2100, 2101, 2102], dtype='int64'),\n",
" 780600.0: Int64Index([2103], dtype='int64'),\n",
" 780700.0: Int64Index([2104, 2105, 2106], dtype='int64'),\n",
" 780800.0: Int64Index([2107, 2108, 2109], dtype='int64'),\n",
" 780900.0: Int64Index([2110, 2111], dtype='int64'),\n",
" 781000.0: Int64Index([2112, 2113], dtype='int64'),\n",
" 781100.0: Int64Index([2114, 2115, 2116, 2117], dtype='int64'),\n",
" 781200.0: Int64Index([2118, 2119], dtype='int64'),\n",
" 781300.0: Int64Index([2120], dtype='int64'),\n",
" 781400.0: Int64Index([2121], dtype='int64'),\n",
" 781500.0: Int64Index([2122, 2123, 2124, 2125, 2126], dtype='int64'),\n",
" 781700.0: Int64Index([2127, 2128], dtype='int64'),\n",
" 781800.0: Int64Index([2129, 2130], dtype='int64'),\n",
" 781900.0: Int64Index([2131, 2132, 2133, 2134], dtype='int64'),\n",
" 782000.0: Int64Index([2135, 2136, 2137, 2138], dtype='int64'),\n",
" 782200.0: Int64Index([2139, 2140, 2141], dtype='int64'),\n",
" 782300.0: Int64Index([2142, 2143, 2144, 2145], dtype='int64'),\n",
" 782400.0: Int64Index([2146, 2147], dtype='int64'),\n",
" 782500.0: Int64Index([2148, 2149, 2150, 2151], dtype='int64'),\n",
" 782600.0: Int64Index([2152, 2153, 2154], dtype='int64'),\n",
" 782700.0: Int64Index([2155], dtype='int64'),\n",
" 782800.0: Int64Index([2156, 2157], dtype='int64'),\n",
" 782900.0: Int64Index([2158, 2159], dtype='int64'),\n",
" 783000.0: Int64Index([2160, 2161], dtype='int64'),\n",
" 783100.0: Int64Index([2162, 2163], dtype='int64'),\n",
" 783200.0: Int64Index([2164], dtype='int64'),\n",
" 783300.0: Int64Index([2165, 2166, 2167, 2168], dtype='int64'),\n",
" 783500.0: Int64Index([2169, 2170, 2171], dtype='int64'),\n",
" 783700.0: Int64Index([2172, 2173, 2174], dtype='int64'),\n",
" 783800.0: Int64Index([2175, 2176], dtype='int64'),\n",
" 783900.0: Int64Index([2177, 2178, 2179, 2180, 2181, 2182], dtype='int64'),\n",
" 784000.0: Int64Index([2183, 2184], dtype='int64'),\n",
" 784100.0: Int64Index([2185, 2186, 2187], dtype='int64'),\n",
" 784200.0: Int64Index([2188, 2189, 2190], dtype='int64'),\n",
" 784300.0: Int64Index([2191, 2192, 2193, 2194, 2195, 2196, 2197], dtype='int64'),\n",
" 784400.0: Int64Index([2198, 2199, 2200, 2201, 2202], dtype='int64'),\n",
" 784500.0: Int64Index([2203, 2204], dtype='int64'),\n",
" 784600.0: Int64Index([2205], dtype='int64'),\n",
" 784700.0: Int64Index([2206, 2207, 2208, 2209], dtype='int64'),\n",
" 784800.0: Int64Index([2210, 2211, 2212], dtype='int64'),\n",
" 784900.0: Int64Index([2213, 2214, 2215, 2216, 2217], dtype='int64'),\n",
" 785000.0: Int64Index([2218, 2219, 2220, 2221, 2222, 2223], dtype='int64'),\n",
" 785100.0: Int64Index([2224, 2225, 2226], dtype='int64'),\n",
" 785200.0: Int64Index([2227, 2228, 2229], dtype='int64'),\n",
" 785300.0: Int64Index([2230, 2231, 2232], dtype='int64'),\n",
" 785500.0: Int64Index([2233, 2234, 2235, 2236], dtype='int64'),\n",
" 785600.0: Int64Index([2237, 2238, 2239, 2240, 2241], dtype='int64'),\n",
" 785700.0: Int64Index([2242, 2243, 2244, 2245, 2246], dtype='int64'),\n",
" 785800.0: Int64Index([2247, 2248], dtype='int64'),\n",
" 785900.0: Int64Index([2249], dtype='int64'),\n",
" 786000.0: Int64Index([2250, 2251, 2252], dtype='int64'),\n",
" 786100.0: Int64Index([2253], dtype='int64'),\n",
" 786200.0: Int64Index([2254, 2255], dtype='int64'),\n",
" 786300.0: Int64Index([2256, 2257, 2258, 2259, 2260], dtype='int64'),\n",
" 786400.0: Int64Index([2261, 2262], dtype='int64'),\n",
" 786500.0: Int64Index([2263, 2264, 2265], dtype='int64'),\n",
" 786600.0: Int64Index([2266], dtype='int64'),\n",
" 786700.0: Int64Index([2267, 2268], dtype='int64'),\n",
" 786800.0: Int64Index([2269, 2270, 2271, 2272], dtype='int64'),\n",
" 786900.0: Int64Index([2273, 2274], dtype='int64'),\n",
" 787000.0: Int64Index([2275, 2276, 2277], dtype='int64'),\n",
" 787100.0: Int64Index([2278, 2279, 2280, 2281], dtype='int64'),\n",
" 787200.0: Int64Index([2282, 2283], dtype='int64'),\n",
" 787300.0: Int64Index([2284, 2285, 2286], dtype='int64'),\n",
" 787400.0: Int64Index([2287, 2288], dtype='int64'),\n",
" 787500.0: Int64Index([2289, 2290, 2291, 2292], dtype='int64'),\n",
" 787600.0: Int64Index([2293, 2294], dtype='int64'),\n",
" 787700.0: Int64Index([2295, 2296, 2297, 2298], dtype='int64'),\n",
" 787800.0: Int64Index([2299, 2300, 2301, 2302], dtype='int64'),\n",
" 787900.0: Int64Index([2303, 2304, 2305, 2306, 2307], dtype='int64'),\n",
" 788000.0: Int64Index([2308, 2309, 2310, 2311], dtype='int64'),\n",
" 788100.0: Int64Index([2312, 2313], dtype='int64'),\n",
" 788200.0: Int64Index([2314, 2315], dtype='int64'),\n",
" 788300.0: Int64Index([2316, 2317, 2318, 2319], dtype='int64'),\n",
" 788400.0: Int64Index([2320, 2321], dtype='int64'),\n",
" 788500.0: Int64Index([2322, 2323], dtype='int64'),\n",
" 788600.0: Int64Index([2324], dtype='int64'),\n",
" 788700.0: Int64Index([2325, 2326, 2327], dtype='int64'),\n",
" 788800.0: Int64Index([2328, 2329, 2330, 2331, 2332], dtype='int64'),\n",
" 788900.0: Int64Index([2333, 2334], dtype='int64'),\n",
" 789000.0: Int64Index([2335], dtype='int64'),\n",
" 789200.0: Int64Index([2336, 2337, 2338], dtype='int64'),\n",
" 789300.0: Int64Index([2339, 2340], dtype='int64'),\n",
" 789400.0: Int64Index([2341, 2342, 2343], dtype='int64'),\n",
" 789500.0: Int64Index([2344, 2345], dtype='int64'),\n",
" 789600.0: Int64Index([2346, 2347, 2348, 2349], dtype='int64'),\n",
" 789700.0: Int64Index([2350, 2351, 2352, 2353, 2354, 2355], dtype='int64'),\n",
" 789800.0: Int64Index([2356, 2357, 2358, 2359], dtype='int64'),\n",
" 789900.0: Int64Index([2360, 2361, 2362, 2363, 2364, 2365], dtype='int64'),\n",
" 790000.0: Int64Index([2366, 2367], dtype='int64'),\n",
" 790200.0: Int64Index([2368], dtype='int64'),\n",
" 790300.0: Int64Index([2369, 2370, 2371, 2372], dtype='int64'),\n",
" 790400.0: Int64Index([2373, 2374, 2375], dtype='int64'),\n",
" 790500.0: Int64Index([2376], dtype='int64'),\n",
" 790600.0: Int64Index([2377, 2378], dtype='int64'),\n",
" 790700.0: Int64Index([2379, 2380], dtype='int64'),\n",
" 790800.0: Int64Index([2381, 2382], dtype='int64'),\n",
" 790900.0: Int64Index([2383], dtype='int64'),\n",
" 791000.0: Int64Index([2384], dtype='int64'),\n",
" 791100.0: Int64Index([2385, 2386, 2387], dtype='int64'),\n",
" 791200.0: Int64Index([2388, 2389, 2390, 2391, 2392, 2393, 2394], dtype='int64'),\n",
" 791300.0: Int64Index([2395], dtype='int64'),\n",
" 791400.0: Int64Index([2396, 2397], dtype='int64'),\n",
" 791600.0: Int64Index([2398], dtype='int64'),\n",
" 791700.0: Int64Index([2399, 2400, 2401], dtype='int64'),\n",
" 791900.0: Int64Index([2402, 2403, 2404, 2405], dtype='int64'),\n",
" 792000.0: Int64Index([2406, 2407, 2408, 2409], dtype='int64'),\n",
" 792100.0: Int64Index([2410, 2411], dtype='int64'),\n",
" 792400.0: Int64Index([2412], dtype='int64'),\n",
" 792500.0: Int64Index([2413, 2414, 2415, 2416], dtype='int64'),\n",
" 792600.0: Int64Index([2417, 2418], dtype='int64'),\n",
" 792700.0: Int64Index([2419, 2420], dtype='int64'),\n",
" 792800.0: Int64Index([2421, 2422], dtype='int64'),\n",
" 792900.0: Int64Index([2423, 2424, 2425], dtype='int64'),\n",
" 793000.0: Int64Index([2426, 2427], dtype='int64'),\n",
" 793100.0: Int64Index([2428], dtype='int64'),\n",
" 793200.0: Int64Index([2429, 2430, 2431], dtype='int64'),\n",
" 793300.0: Int64Index([2432], dtype='int64'),\n",
" 793400.0: Int64Index([2433, 2434], dtype='int64'),\n",
" 793500.0: Int64Index([2435, 2436, 2437], dtype='int64'),\n",
" 793600.0: Int64Index([2438, 2439, 2440], dtype='int64'),\n",
" 793700.0: Int64Index([2441, 2442, 2443], dtype='int64'),\n",
" 793900.0: Int64Index([2444, 2445], dtype='int64'),\n",
" 794000.0: Int64Index([2446, 2447], dtype='int64'),\n",
" 794100.0: Int64Index([2448], dtype='int64'),\n",
" 794200.0: Int64Index([2449], dtype='int64'),\n",
" 794300.0: Int64Index([2450, 2451], dtype='int64'),\n",
" 794400.0: Int64Index([2452, 2453, 2454, 2455, 2456], dtype='int64'),\n",
" 794500.0: Int64Index([2457, 2458], dtype='int64'),\n",
" 794700.0: Int64Index([2459], dtype='int64'),\n",
" 794800.0: Int64Index([2460, 2461, 2462], dtype='int64'),\n",
" 794900.0: Int64Index([2463, 2464, 2465], dtype='int64'),\n",
" 795000.0: Int64Index([2466], dtype='int64'),\n",
" 795100.0: Int64Index([2467, 2468, 2469, 2470, 2471], dtype='int64'),\n",
" 795200.0: Int64Index([2472, 2473], dtype='int64'),\n",
" 795300.0: Int64Index([2474, 2475, 2476], dtype='int64'),\n",
" 795400.0: Int64Index([2477, 2478], dtype='int64'),\n",
" 795500.0: Int64Index([2479], dtype='int64'),\n",
" 795600.0: Int64Index([2480], dtype='int64'),\n",
" 795700.0: Int64Index([2481, 2482], dtype='int64'),\n",
" 795900.0: Int64Index([2483, 2484], dtype='int64'),\n",
" 796000.0: Int64Index([2485], dtype='int64'),\n",
" 796100.0: Int64Index([2486, 2487], dtype='int64'),\n",
" 796200.0: Int64Index([2488], dtype='int64'),\n",
" 796300.0: Int64Index([2489], dtype='int64'),\n",
" 796400.0: Int64Index([2490, 2491], dtype='int64'),\n",
" 796500.0: Int64Index([2492, 2493, 2494], dtype='int64'),\n",
" 796700.0: Int64Index([2495], dtype='int64'),\n",
" 796800.0: Int64Index([2496, 2497, 2498, 2499], dtype='int64'),\n",
" 796900.0: Int64Index([2500, 2501, 2502], dtype='int64'),\n",
" 797000.0: Int64Index([2503], dtype='int64'),\n",
" 797200.0: Int64Index([2504, 2505], dtype='int64'),\n",
" 797300.0: Int64Index([2506, 2507], dtype='int64'),\n",
" 797400.0: Int64Index([2508], dtype='int64'),\n",
" 797500.0: Int64Index([2509, 2510, 2511], dtype='int64'),\n",
" 797600.0: Int64Index([2512], dtype='int64'),\n",
" 797700.0: Int64Index([2513, 2514, 2515, 2516], dtype='int64'),\n",
" 797800.0: Int64Index([2517], dtype='int64'),\n",
" 797900.0: Int64Index([2518, 2519, 2520, 2521], dtype='int64'),\n",
" 798000.0: Int64Index([2522, 2523, 2524, 2525, 2526], dtype='int64'),\n",
" 798100.0: Int64Index([2527], dtype='int64'),\n",
" 798200.0: Int64Index([2528, 2529, 2530], dtype='int64'),\n",
" 798300.0: Int64Index([2531], dtype='int64'),\n",
" 798400.0: Int64Index([2532, 2533, 2534], dtype='int64'),\n",
" 798500.0: Int64Index([2535, 2536], dtype='int64'),\n",
" 798700.0: Int64Index([2537, 2538, 2539], dtype='int64'),\n",
" 798800.0: Int64Index([2540], dtype='int64'),\n",
" 798900.0: Int64Index([2541, 2542, 2543, 2544, 2545, 2546, 2547], dtype='int64'),\n",
" 799000.0: Int64Index([2548, 2549], dtype='int64'),\n",
" 799200.0: Int64Index([2550], dtype='int64'),\n",
" 799300.0: Int64Index([2551, 2552], dtype='int64'),\n",
" 799400.0: Int64Index([2553, 2554, 2555, 2556], dtype='int64'),\n",
" 799500.0: Int64Index([2557, 2558], dtype='int64'),\n",
" 799600.0: Int64Index([2559, 2560, 2561, 2562], dtype='int64'),\n",
" 799700.0: Int64Index([2563, 2564], dtype='int64'),\n",
" 799800.0: Int64Index([2565, 2566, 2567, 2568], dtype='int64'),\n",
" 799900.0: Int64Index([2569, 2570, 2571, 2572, 2573, 2574, 2575, 2576], dtype='int64'),\n",
" 800000.0: Int64Index([2577, 2578, 2579, 2580, 2581], dtype='int64'),\n",
" 800100.0: Int64Index([2582], dtype='int64'),\n",
" 800400.0: Int64Index([2583], dtype='int64'),\n",
" 800500.0: Int64Index([2584, 2585], dtype='int64'),\n",
" 800800.0: Int64Index([2586, 2587, 2588], dtype='int64'),\n",
" 800900.0: Int64Index([2589, 2590, 2591, 2592], dtype='int64'),\n",
" 801000.0: Int64Index([2593, 2594, 2595], dtype='int64'),\n",
" 801200.0: Int64Index([2596], dtype='int64'),\n",
" 801300.0: Int64Index([2597], dtype='int64'),\n",
" 801500.0: Int64Index([2598], dtype='int64'),\n",
" 801600.0: Int64Index([2599, 2600], dtype='int64'),\n",
" 801700.0: Int64Index([2601, 2602], dtype='int64'),\n",
" 801900.0: Int64Index([2603, 2604], dtype='int64'),\n",
" 802000.0: Int64Index([2605], dtype='int64'),\n",
" 802100.0: Int64Index([2606], dtype='int64'),\n",
" 802200.0: Int64Index([2607], dtype='int64'),\n",
" 802300.0: Int64Index([2608, 2609], dtype='int64'),\n",
" 802400.0: Int64Index([2610, 2611], dtype='int64'),\n",
" 802500.0: Int64Index([2612, 2613, 2614, 2615, 2616], dtype='int64'),\n",
" 802700.0: Int64Index([2617, 2618], dtype='int64'),\n",
" 802800.0: Int64Index([2619, 2620, 2621], dtype='int64'),\n",
" 802900.0: Int64Index([2622], dtype='int64'),\n",
" 803000.0: Int64Index([2623, 2624], dtype='int64'),\n",
" 803200.0: Int64Index([2625], dtype='int64'),\n",
" 803300.0: Int64Index([2626], dtype='int64'),\n",
" 803500.0: Int64Index([2627, 2628], dtype='int64'),\n",
" 803600.0: Int64Index([2629, 2630], dtype='int64'),\n",
" 803700.0: Int64Index([2631, 2632, 2633], dtype='int64'),\n",
" 803800.0: Int64Index([2634, 2635], dtype='int64'),\n",
" 803900.0: Int64Index([2636, 2637], dtype='int64'),\n",
" 804000.0: Int64Index([2638, 2639], dtype='int64'),\n",
" 804100.0: Int64Index([2640], dtype='int64'),\n",
" 804200.0: Int64Index([2641, 2642], dtype='int64'),\n",
" 804400.0: Int64Index([2643], dtype='int64'),\n",
" 804500.0: Int64Index([2644, 2645], dtype='int64'),\n",
" 804800.0: Int64Index([2646, 2647], dtype='int64'),\n",
" 804900.0: Int64Index([2648], dtype='int64'),\n",
" 805000.0: Int64Index([2649], dtype='int64'),\n",
" 805300.0: Int64Index([2650, 2651], dtype='int64'),\n",
" 805500.0: Int64Index([2652], dtype='int64'),\n",
" 805600.0: Int64Index([2653, 2654], dtype='int64'),\n",
" 805700.0: Int64Index([2655], dtype='int64'),\n",
" 805900.0: Int64Index([2656], dtype='int64'),\n",
" 806000.0: Int64Index([2657], dtype='int64'),\n",
" 806100.0: Int64Index([2658, 2659], dtype='int64'),\n",
" 806200.0: Int64Index([2660], dtype='int64'),\n",
" 806300.0: Int64Index([2661, 2662], dtype='int64'),\n",
" 806600.0: Int64Index([2663], dtype='int64'),\n",
" 806800.0: Int64Index([2664], dtype='int64'),\n",
" 806900.0: Int64Index([2665], dtype='int64'),\n",
" 807000.0: Int64Index([2666, 2667], dtype='int64'),\n",
" 807300.0: Int64Index([2668, 2669], dtype='int64'),\n",
" 807400.0: Int64Index([2670], dtype='int64'),\n",
" 807500.0: Int64Index([2671, 2672], dtype='int64'),\n",
" 807900.0: Int64Index([2673], dtype='int64'),\n",
" 808000.0: Int64Index([2674, 2675], dtype='int64'),\n",
" 808200.0: Int64Index([2676, 2677], dtype='int64'),\n",
" 808300.0: Int64Index([2678], dtype='int64'),\n",
" 808500.0: Int64Index([2679], dtype='int64'),\n",
" 808700.0: Int64Index([2680], dtype='int64'),\n",
" 808800.0: Int64Index([2681], dtype='int64'),\n",
" 809000.0: Int64Index([2682, 2683], dtype='int64'),\n",
" 809300.0: Int64Index([2684], dtype='int64'),\n",
" 809400.0: Int64Index([2685, 2686], dtype='int64'),\n",
" 809500.0: Int64Index([2687], dtype='int64'),\n",
" 809600.0: Int64Index([2688], dtype='int64'),\n",
" 809700.0: Int64Index([2689], dtype='int64'),\n",
" 809800.0: Int64Index([2690], dtype='int64'),\n",
" 809900.0: Int64Index([2691, 2692], dtype='int64'),\n",
" 810000.0: Int64Index([2693], dtype='int64'),\n",
" 810200.0: Int64Index([2694], dtype='int64'),\n",
" 810300.0: Int64Index([2695], dtype='int64'),\n",
" 810800.0: Int64Index([2696], dtype='int64'),\n",
" 811000.0: Int64Index([2697], dtype='int64'),\n",
" 811100.0: Int64Index([2698], dtype='int64'),\n",
" 811200.0: Int64Index([2699], dtype='int64'),\n",
" 811300.0: Int64Index([2700], dtype='int64'),\n",
" 811500.0: Int64Index([2701], dtype='int64'),\n",
" 811900.0: Int64Index([2702, 2703], dtype='int64'),\n",
" 812000.0: Int64Index([2704], dtype='int64'),\n",
" 812100.0: Int64Index([2705], dtype='int64'),\n",
" 812200.0: Int64Index([2706], dtype='int64'),\n",
" 812300.0: Int64Index([2707], dtype='int64'),\n",
" 812500.0: Int64Index([2708], dtype='int64'),\n",
" 812700.0: Int64Index([2709], dtype='int64'),\n",
" 812800.0: Int64Index([2710, 2711], dtype='int64'),\n",
" 812900.0: Int64Index([2712], dtype='int64'),\n",
" 813000.0: Int64Index([2713], dtype='int64'),\n",
" 813700.0: Int64Index([2714, 2715], dtype='int64'),\n",
" 813800.0: Int64Index([2716], dtype='int64'),\n",
" 813900.0: Int64Index([2717], dtype='int64'),\n",
" 814000.0: Int64Index([2718], dtype='int64'),\n",
" 814200.0: Int64Index([2719], dtype='int64'),\n",
" 814300.0: Int64Index([2720], dtype='int64'),\n",
" 814400.0: Int64Index([2721, 2722], dtype='int64'),\n",
" 814700.0: Int64Index([2723], dtype='int64'),\n",
" 814800.0: Int64Index([2724, 2725], dtype='int64'),\n",
" 814900.0: Int64Index([2726], dtype='int64'),\n",
" 815000.0: Int64Index([2727], dtype='int64'),\n",
" 815200.0: Int64Index([2728], dtype='int64'),\n",
" 815300.0: Int64Index([2729], dtype='int64'),\n",
" 815500.0: Int64Index([2730], dtype='int64'),\n",
" 815600.0: Int64Index([2731, 2732, 2733], dtype='int64'),\n",
" 815800.0: Int64Index([2734, 2735], dtype='int64'),\n",
" 815900.0: Int64Index([2736], dtype='int64'),\n",
" 816000.0: Int64Index([2737], dtype='int64'),\n",
" 816200.0: Int64Index([2738], dtype='int64'),\n",
" 816300.0: Int64Index([2739], dtype='int64'),\n",
" 816500.0: Int64Index([2740], dtype='int64'),\n",
" 816800.0: Int64Index([2741], dtype='int64'),\n",
" 816900.0: Int64Index([2742], dtype='int64'),\n",
" 817000.0: Int64Index([2743], dtype='int64'),\n",
" 817200.0: Int64Index([2744], dtype='int64'),\n",
" 817400.0: Int64Index([2745], dtype='int64'),\n",
" 817500.0: Int64Index([2746], dtype='int64'),\n",
" 817800.0: Int64Index([2747], dtype='int64'),\n",
" 817900.0: Int64Index([2748, 2749], dtype='int64'),\n",
" 818000.0: Int64Index([2750], dtype='int64'),\n",
" 818200.0: Int64Index([2751, 2752], dtype='int64'),\n",
" 818600.0: Int64Index([2753], dtype='int64'),\n",
" 818700.0: Int64Index([2754], dtype='int64'),\n",
" 818800.0: Int64Index([2755, 2756], dtype='int64'),\n",
" 819000.0: Int64Index([2757, 2758], dtype='int64'),\n",
" 819300.0: Int64Index([2759], dtype='int64'),\n",
" 819400.0: Int64Index([2760, 2761], dtype='int64'),\n",
" 819500.0: Int64Index([2762], dtype='int64'),\n",
" 819600.0: Int64Index([2763], dtype='int64'),\n",
" 819900.0: Int64Index([2764, 2765], dtype='int64'),\n",
" 820000.0: Int64Index([2766, 2767], dtype='int64'),\n",
" 820200.0: Int64Index([2768], dtype='int64'),\n",
" 820700.0: Int64Index([2769], dtype='int64'),\n",
" 820800.0: Int64Index([2770], dtype='int64'),\n",
" 820900.0: Int64Index([2771], dtype='int64'),\n",
" 821000.0: Int64Index([2772], dtype='int64'),\n",
" 821200.0: Int64Index([2773, 2774], dtype='int64'),\n",
" 821300.0: Int64Index([2775], dtype='int64'),\n",
" 821700.0: Int64Index([2776, 2777], dtype='int64'),\n",
" 821900.0: Int64Index([2778, 2779], dtype='int64'),\n",
" 822000.0: Int64Index([2780], dtype='int64'),\n",
" 822200.0: Int64Index([2781], dtype='int64'),\n",
" 822300.0: Int64Index([2782], dtype='int64'),\n",
" 822700.0: Int64Index([2783], dtype='int64'),\n",
" 822800.0: Int64Index([2784], dtype='int64'),\n",
" 822900.0: Int64Index([2785], dtype='int64'),\n",
" 823000.0: Int64Index([2786], dtype='int64'),\n",
" 823100.0: Int64Index([2787], dtype='int64'),\n",
" 823200.0: Int64Index([2788], dtype='int64'),\n",
" 823300.0: Int64Index([2789], dtype='int64'),\n",
" 823500.0: Int64Index([2790], dtype='int64'),\n",
" 823600.0: Int64Index([2791], dtype='int64'),\n",
" 823800.0: Int64Index([2792, 2793], dtype='int64'),\n",
" 823900.0: Int64Index([2794, 2795], dtype='int64'),\n",
" 824000.0: Int64Index([2796], dtype='int64'),\n",
" 824200.0: Int64Index([2797], dtype='int64'),\n",
" 824300.0: Int64Index([2798], dtype='int64'),\n",
" 824900.0: Int64Index([2799, 2800], dtype='int64'),\n",
" 825000.0: Int64Index([2801], dtype='int64'),\n",
" 825400.0: Int64Index([2802], dtype='int64'),\n",
" 825700.0: Int64Index([2803], dtype='int64'),\n",
" 825900.0: Int64Index([2804], dtype='int64'),\n",
" 826000.0: Int64Index([2805], dtype='int64'),\n",
" 826300.0: Int64Index([2806], dtype='int64'),\n",
" 826800.0: Int64Index([2807], dtype='int64'),\n",
" 826900.0: Int64Index([2808, 2809], dtype='int64'),\n",
" 827000.0: Int64Index([2810], dtype='int64'),\n",
" 827500.0: Int64Index([2811], dtype='int64'),\n",
" 827600.0: Int64Index([2812], dtype='int64'),\n",
" 827700.0: Int64Index([2813], dtype='int64'),\n",
" 827900.0: Int64Index([2814], dtype='int64'),\n",
" 828000.0: Int64Index([2815, 2816], dtype='int64'),\n",
" 828200.0: Int64Index([2817], dtype='int64'),\n",
" 828300.0: Int64Index([2818], dtype='int64'),\n",
" 829000.0: Int64Index([2819, 2820], dtype='int64'),\n",
" 829700.0: Int64Index([2821], dtype='int64'),\n",
" 829900.0: Int64Index([2822, 2823], dtype='int64'),\n",
" 830000.0: Int64Index([2824], dtype='int64'),\n",
" 830200.0: Int64Index([2825, 2826], dtype='int64'),\n",
" 830500.0: Int64Index([2827], dtype='int64'),\n",
" 831000.0: Int64Index([2828], dtype='int64'),\n",
" 831200.0: Int64Index([2829], dtype='int64'),\n",
" 831900.0: Int64Index([2830, 2831], dtype='int64'),\n",
" 832000.0: Int64Index([2832], dtype='int64'),\n",
" 832100.0: Int64Index([2833], dtype='int64'),\n",
" 832200.0: Int64Index([2834, 2835], dtype='int64'),\n",
" 832700.0: Int64Index([2836, 2837], dtype='int64'),\n",
" 832800.0: Int64Index([2838], dtype='int64'),\n",
" 833000.0: Int64Index([2839, 2840], dtype='int64'),\n",
" 833100.0: Int64Index([2841], dtype='int64'),\n",
" 833200.0: Int64Index([2842], dtype='int64'),\n",
" 833300.0: Int64Index([2843], dtype='int64'),\n",
" 833600.0: Int64Index([2844], dtype='int64'),\n",
" 833800.0: Int64Index([2845], dtype='int64'),\n",
" 833900.0: Int64Index([2846, 2847], dtype='int64'),\n",
" 834000.0: Int64Index([2848], dtype='int64'),\n",
" 834200.0: Int64Index([2849], dtype='int64'),\n",
" 834400.0: Int64Index([2850], dtype='int64'),\n",
" 835000.0: Int64Index([2851], dtype='int64'),\n",
" 835200.0: Int64Index([2852], dtype='int64'),\n",
" 835500.0: Int64Index([2853, 2854], dtype='int64'),\n",
" 835900.0: Int64Index([2855], dtype='int64'),\n",
" 836000.0: Int64Index([2856], dtype='int64'),\n",
" 836500.0: Int64Index([2857], dtype='int64'),\n",
" 836700.0: Int64Index([2858], dtype='int64'),\n",
" 836900.0: Int64Index([2859, 2860], dtype='int64'),\n",
" 837000.0: Int64Index([2861], dtype='int64'),\n",
" 837500.0: Int64Index([2862], dtype='int64'),\n",
" 837700.0: Int64Index([2863], dtype='int64'),\n",
" 837900.0: Int64Index([2864], dtype='int64'),\n",
" 838000.0: Int64Index([2865], dtype='int64'),\n",
" 838100.0: Int64Index([2866, 2867], dtype='int64'),\n",
" 838400.0: Int64Index([2868, 2869], dtype='int64'),\n",
" 838600.0: Int64Index([2870], dtype='int64'),\n",
" 838700.0: Int64Index([2871, 2872], dtype='int64'),\n",
" 838800.0: Int64Index([2873, 2874, 2875], dtype='int64'),\n",
" 839000.0: Int64Index([2876], dtype='int64'),\n",
" 839500.0: Int64Index([2877, 2878], dtype='int64'),\n",
" 839600.0: Int64Index([2879, 2880, 2881, 2882, 2883], dtype='int64'),\n",
" 839800.0: Int64Index([2884, 2885], dtype='int64'),\n",
" 839900.0: Int64Index([2886], dtype='int64'),\n",
" 840000.0: Int64Index([2887], dtype='int64'),\n",
" 840300.0: Int64Index([2888], dtype='int64'),\n",
" 840800.0: Int64Index([2889], dtype='int64'),\n",
" 841000.0: Int64Index([2890], dtype='int64'),\n",
" 841100.0: Int64Index([2891], dtype='int64'),\n",
" 841200.0: Int64Index([2892], dtype='int64'),\n",
" 841300.0: Int64Index([2893], dtype='int64'),\n",
" 841500.0: Int64Index([2894], dtype='int64'),\n",
" 841600.0: Int64Index([2895], dtype='int64'),\n",
" 841700.0: Int64Index([2896, 2897], dtype='int64'),\n",
" 841800.0: Int64Index([2898], dtype='int64'),\n",
" 841900.0: Int64Index([2899, 2900], dtype='int64'),\n",
" 842000.0: Int64Index([2901, 2902], dtype='int64'),\n",
" 842200.0: Int64Index([2903], dtype='int64'),\n",
" 842500.0: Int64Index([2904], dtype='int64'),\n",
" 842700.0: Int64Index([2905, 2906, 2907], dtype='int64'),\n",
" 842800.0: Int64Index([2908], dtype='int64'),\n",
" 843000.0: Int64Index([2909, 2910], dtype='int64'),\n",
" 843600.0: Int64Index([2911], dtype='int64'),\n",
" 843700.0: Int64Index([2912, 2913], dtype='int64'),\n",
" 843800.0: Int64Index([2914, 2915], dtype='int64'),\n",
" 843900.0: Int64Index([2916, 2917, 2918, 2919], dtype='int64'),\n",
" 844000.0: Int64Index([2920], dtype='int64'),\n",
" 844200.0: Int64Index([2921, 2922], dtype='int64'),\n",
" 844400.0: Int64Index([2923], dtype='int64'),\n",
" 844500.0: Int64Index([2924, 2925, 2926], dtype='int64'),\n",
" 844700.0: Int64Index([2927], dtype='int64'),\n",
" 844800.0: Int64Index([2928], dtype='int64'),\n",
" 845000.0: Int64Index([2929], dtype='int64'),\n",
" 845200.0: Int64Index([2930], dtype='int64'),\n",
" 845500.0: Int64Index([2931, 2932], dtype='int64'),\n",
" 845700.0: Int64Index([2933], dtype='int64'),\n",
" 845800.0: Int64Index([2934, 2935], dtype='int64'),\n",
" 845900.0: Int64Index([2936, 2937], dtype='int64'),\n",
" 846000.0: Int64Index([2938], dtype='int64'),\n",
" 846200.0: Int64Index([2939], dtype='int64'),\n",
" 846600.0: Int64Index([2940], dtype='int64'),\n",
" 846700.0: Int64Index([2941], dtype='int64'),\n",
" 846900.0: Int64Index([2942], dtype='int64'),\n",
" 847000.0: Int64Index([2943], dtype='int64'),\n",
" 847200.0: Int64Index([2944], dtype='int64'),\n",
" 847300.0: Int64Index([2945], dtype='int64'),\n",
" 847500.0: Int64Index([2946], dtype='int64'),\n",
" 847800.0: Int64Index([2947], dtype='int64'),\n",
" 847900.0: Int64Index([2948], dtype='int64'),\n",
" 848000.0: Int64Index([2949], dtype='int64'),\n",
" 848400.0: Int64Index([2950], dtype='int64'),\n",
" 848600.0: Int64Index([2951, 2952], dtype='int64'),\n",
" 848900.0: Int64Index([2953], dtype='int64'),\n",
" 849000.0: Int64Index([2954], dtype='int64'),\n",
" 849300.0: Int64Index([2955], dtype='int64'),\n",
" 849400.0: Int64Index([2956], dtype='int64'),\n",
" 849500.0: Int64Index([2957], dtype='int64'),\n",
" 849700.0: Int64Index([2958], dtype='int64'),\n",
" 849800.0: Int64Index([2959, 2960], dtype='int64'),\n",
" 849900.0: Int64Index([2961, 2962], dtype='int64'),\n",
" 850000.0: Int64Index([2963], dtype='int64'),\n",
" 850500.0: Int64Index([2964], dtype='int64'),\n",
" 850600.0: Int64Index([2965], dtype='int64'),\n",
" 851000.0: Int64Index([2966], dtype='int64'),\n",
" 851100.0: Int64Index([2967], dtype='int64'),\n",
" 851500.0: Int64Index([2968], dtype='int64'),\n",
" 851700.0: Int64Index([2969], dtype='int64'),\n",
" 851900.0: Int64Index([2970], dtype='int64'),\n",
" 852000.0: Int64Index([2971], dtype='int64'),\n",
" 852200.0: Int64Index([2972], dtype='int64'),\n",
" 852700.0: Int64Index([2973], dtype='int64'),\n",
" 853000.0: Int64Index([2974], dtype='int64'),\n",
" 853200.0: Int64Index([2975], dtype='int64'),\n",
" 853400.0: Int64Index([2976], dtype='int64'),\n",
" 853600.0: Int64Index([2977], dtype='int64'),\n",
" 853700.0: Int64Index([2978], dtype='int64'),\n",
" 853900.0: Int64Index([2979], dtype='int64'),\n",
" 854000.0: Int64Index([2980], dtype='int64'),\n",
" 854200.0: Int64Index([2981], dtype='int64'),\n",
" 854800.0: Int64Index([2982], dtype='int64'),\n",
" 855000.0: Int64Index([2983], dtype='int64'),\n",
" 855200.0: Int64Index([2984], dtype='int64'),\n",
" 855500.0: Int64Index([2985], dtype='int64'),\n",
" 855900.0: Int64Index([2986], dtype='int64'),\n",
" 856000.0: Int64Index([2987], dtype='int64'),\n",
" 856200.0: Int64Index([2988], dtype='int64'),\n",
" 856600.0: Int64Index([2989], dtype='int64'),\n",
" 857000.0: Int64Index([2990], dtype='int64'),\n",
" 857900.0: Int64Index([2991], dtype='int64'),\n",
" 858000.0: Int64Index([2992], dtype='int64'),\n",
" 858500.0: Int64Index([2993, 2994, 2995], dtype='int64'),\n",
" 858800.0: Int64Index([2996], dtype='int64'),\n",
" 859000.0: Int64Index([2997], dtype='int64'),\n",
" 860000.0: Int64Index([2998], dtype='int64'),\n",
" 861000.0: Int64Index([2999], dtype='int64'),\n",
" 861200.0: Int64Index([3000], dtype='int64'),\n",
" 861300.0: Int64Index([3001], dtype='int64'),\n",
" 861600.0: Int64Index([3002], dtype='int64'),\n",
" 862000.0: Int64Index([3003], dtype='int64'),\n",
" 862200.0: Int64Index([3004, 3005], dtype='int64'),\n",
" 862800.0: Int64Index([3006], dtype='int64'),\n",
" 863000.0: Int64Index([3007], dtype='int64'),\n",
" 863200.0: Int64Index([3008], dtype='int64'),\n",
" 863700.0: Int64Index([3009], dtype='int64'),\n",
" 864000.0: Int64Index([3010], dtype='int64'),\n",
" 864100.0: Int64Index([3011], dtype='int64'),\n",
" 865000.0: Int64Index([3012], dtype='int64'),\n",
" 865500.0: Int64Index([3013], dtype='int64'),\n",
" 866000.0: Int64Index([3014], dtype='int64'),\n",
" 867000.0: Int64Index([3015], dtype='int64'),\n",
" 867100.0: Int64Index([3016], dtype='int64'),\n",
" 867800.0: Int64Index([3017], dtype='int64'),\n",
" 868000.0: Int64Index([3018], dtype='int64'),\n",
" 868500.0: Int64Index([3019, 3020], dtype='int64'),\n",
" 868700.0: Int64Index([3021], dtype='int64'),\n",
" 869000.0: Int64Index([3022], dtype='int64'),\n",
" 869800.0: Int64Index([3023], dtype='int64'),\n",
" 870000.0: Int64Index([3024], dtype='int64'),\n",
" 871000.0: Int64Index([3025], dtype='int64'),\n",
" 872000.0: Int64Index([3026], dtype='int64'),\n",
" 872500.0: Int64Index([3027], dtype='int64'),\n",
" 873000.0: Int64Index([3028], dtype='int64'),\n",
" 873100.0: Int64Index([3029], dtype='int64'),\n",
" 873400.0: Int64Index([3030], dtype='int64'),\n",
" 873600.0: Int64Index([3031], dtype='int64'),\n",
" 874000.0: Int64Index([3032], dtype='int64'),\n",
" 874800.0: Int64Index([3033], dtype='int64'),\n",
" 875000.0: Int64Index([3034], dtype='int64'),\n",
" 875100.0: Int64Index([3035], dtype='int64'),\n",
" 875400.0: Int64Index([3036], dtype='int64'),\n",
" 876000.0: Int64Index([3037], dtype='int64'),\n",
" 876300.0: Int64Index([3038], dtype='int64'),\n",
" 877000.0: Int64Index([3039], dtype='int64'),\n",
" 877500.0: Int64Index([3040], dtype='int64'),\n",
" 878000.0: Int64Index([3041], dtype='int64'),\n",
" 878900.0: Int64Index([3042], dtype='int64'),\n",
" 879000.0: Int64Index([3043], dtype='int64'),\n",
" 879500.0: Int64Index([3044], dtype='int64'),\n",
" 880000.0: Int64Index([3045], dtype='int64'),\n",
" 880200.0: Int64Index([3046], dtype='int64'),\n",
" 881000.0: Int64Index([3047], dtype='int64'),\n",
" 881400.0: Int64Index([3048], dtype='int64'),\n",
" 882000.0: Int64Index([3049], dtype='int64'),\n",
" 882200.0: Int64Index([3050], dtype='int64'),\n",
" 882300.0: Int64Index([3051], dtype='int64'),\n",
" 883000.0: Int64Index([3052], dtype='int64'),\n",
" 883900.0: Int64Index([3053], dtype='int64'),\n",
" 884000.0: Int64Index([3054], dtype='int64'),\n",
" 885000.0: Int64Index([3055], dtype='int64'),\n",
" 885300.0: Int64Index([3056], dtype='int64'),\n",
" 886000.0: Int64Index([3057], dtype='int64'),\n",
" 886300.0: Int64Index([3058], dtype='int64'),\n",
" 886500.0: Int64Index([3059], dtype='int64'),\n",
" 887000.0: Int64Index([3060], dtype='int64'),\n",
" 887300.0: Int64Index([3061], dtype='int64'),\n",
" 887700.0: Int64Index([3062], dtype='int64'),\n",
" 888000.0: Int64Index([3063], dtype='int64'),\n",
" 888800.0: Int64Index([3064], dtype='int64'),\n",
" 889000.0: Int64Index([3065], dtype='int64'),\n",
" 889300.0: Int64Index([3066], dtype='int64'),\n",
" 889800.0: Int64Index([3067], dtype='int64'),\n",
" 890000.0: Int64Index([3068], dtype='int64'),\n",
" 891000.0: Int64Index([3069], dtype='int64'),\n",
" 891800.0: Int64Index([3070], dtype='int64'),\n",
" 892000.0: Int64Index([3071], dtype='int64'),\n",
" 893000.0: Int64Index([3072], dtype='int64'),\n",
" 893100.0: Int64Index([3073], dtype='int64'),\n",
" 893300.0: Int64Index([3074], dtype='int64'),\n",
" 893500.0: Int64Index([3075], dtype='int64'),\n",
" 894000.0: Int64Index([3076], dtype='int64'),\n",
" 895000.0: Int64Index([3077], dtype='int64'),\n",
" 896000.0: Int64Index([3078], dtype='int64'),\n",
" 897000.0: Int64Index([3079], dtype='int64'),\n",
" 897400.0: Int64Index([3080], dtype='int64'),\n",
" 897500.0: Int64Index([3081], dtype='int64'),\n",
" 897600.0: Int64Index([3082], dtype='int64'),\n",
" 897800.0: Int64Index([3083], dtype='int64'),\n",
" 898000.0: Int64Index([3084], dtype='int64'),\n",
" 898900.0: Int64Index([3085], dtype='int64'),\n",
" 899000.0: Int64Index([3086], dtype='int64'),\n",
" 899500.0: Int64Index([3087], dtype='int64'),\n",
" 899900.0: Int64Index([3088, 3089], dtype='int64'),\n",
" 900000.0: Int64Index([3090], dtype='int64'),\n",
" 900500.0: Int64Index([3091], dtype='int64'),\n",
" 901000.0: Int64Index([3092], dtype='int64'),\n",
" 901500.0: Int64Index([3093], dtype='int64'),\n",
" 901900.0: Int64Index([3094], dtype='int64'),\n",
" 903000.0: Int64Index([3095], dtype='int64'),\n",
" 903400.0: Int64Index([3096], dtype='int64'),\n",
" 905000.0: Int64Index([3097], dtype='int64'),\n",
" 905600.0: Int64Index([3098], dtype='int64'),\n",
" 907000.0: Int64Index([3099], dtype='int64'),\n",
" 907500.0: Int64Index([3100], dtype='int64'),\n",
" 907700.0: Int64Index([3101], dtype='int64'),\n",
" 908900.0: Int64Index([3102], dtype='int64'),\n",
" 909000.0: Int64Index([3103], dtype='int64'),\n",
" 909700.0: Int64Index([3104], dtype='int64'),\n",
" 910000.0: Int64Index([3105], dtype='int64'),\n",
" 911000.0: Int64Index([3106], dtype='int64'),\n",
" 912600.0: Int64Index([3107], dtype='int64'),\n",
" 913000.0: Int64Index([3108], dtype='int64'),\n",
" 913900.0: Int64Index([3109], dtype='int64'),\n",
" 914500.0: Int64Index([3110], dtype='int64'),\n",
" 915000.0: Int64Index([3111], dtype='int64'),\n",
" 916400.0: Int64Index([3112], dtype='int64'),\n",
" 916600.0: Int64Index([3113], dtype='int64'),\n",
" 917000.0: Int64Index([3114], dtype='int64'),\n",
" 918200.0: Int64Index([3115, 3116], dtype='int64'),\n",
" 919000.0: Int64Index([3117], dtype='int64'),\n",
" 920000.0: Int64Index([3118], dtype='int64'),\n",
" 921000.0: Int64Index([3119], dtype='int64'),\n",
" 921500.0: Int64Index([3120], dtype='int64'),\n",
" 922000.0: Int64Index([3121], dtype='int64'),\n",
" 922500.0: Int64Index([3122], dtype='int64'),\n",
" 923000.0: Int64Index([3123], dtype='int64'),\n",
" 923500.0: Int64Index([3124], dtype='int64'),\n",
" 923600.0: Int64Index([3125], dtype='int64'),\n",
" 925000.0: Int64Index([3126], dtype='int64'),\n",
" 926800.0: Int64Index([3127], dtype='int64'),\n",
" 927000.0: Int64Index([3128], dtype='int64'),\n",
" 927700.0: Int64Index([3129], dtype='int64'),\n",
" 928500.0: Int64Index([3130], dtype='int64'),\n",
" 929000.0: Int64Index([3131], dtype='int64'),\n",
" 929500.0: Int64Index([3132], dtype='int64'),\n",
" 930000.0: Int64Index([3133], dtype='int64'),\n",
" 931000.0: Int64Index([3134], dtype='int64'),\n",
" 931100.0: Int64Index([3135], dtype='int64'),\n",
" 933000.0: Int64Index([3136], dtype='int64'),\n",
" 935000.0: Int64Index([3137], dtype='int64'),\n",
" 935500.0: Int64Index([3138, 3139], dtype='int64'),\n",
" 937000.0: Int64Index([3140], dtype='int64'),\n",
" 939000.0: Int64Index([3141], dtype='int64'),\n",
" 939700.0: Int64Index([3142], dtype='int64'),\n",
" 940000.0: Int64Index([3143, 3144], dtype='int64'),\n",
" 941000.0: Int64Index([3145], dtype='int64'),\n",
" 942000.0: Int64Index([3146], dtype='int64'),\n",
" 942500.0: Int64Index([3147], dtype='int64'),\n",
" 942900.0: Int64Index([3148], dtype='int64'),\n",
" 943000.0: Int64Index([3149], dtype='int64'),\n",
" 944400.0: Int64Index([3150], dtype='int64'),\n",
" 945000.0: Int64Index([3151], dtype='int64'),\n",
" 947000.0: Int64Index([3152], dtype='int64'),\n",
" 948400.0: Int64Index([3153], dtype='int64'),\n",
" 949000.0: Int64Index([3154], dtype='int64'),\n",
" 949400.0: Int64Index([3155], dtype='int64'),\n",
" 949500.0: Int64Index([3156], dtype='int64'),\n",
" 950000.0: Int64Index([3157, 3158], dtype='int64'),\n",
" 951000.0: Int64Index([3159], dtype='int64'),\n",
" 953000.0: Int64Index([3160], dtype='int64'),\n",
" 953500.0: Int64Index([3161], dtype='int64'),\n",
" 955000.0: Int64Index([3162], dtype='int64'),\n",
" 955400.0: Int64Index([3163], dtype='int64'),\n",
" 955800.0: Int64Index([3164], dtype='int64'),\n",
" 956500.0: Int64Index([3165], dtype='int64'),\n",
" 957000.0: Int64Index([3166], dtype='int64'),\n",
" 958200.0: Int64Index([3167], dtype='int64'),\n",
" 958800.0: Int64Index([3168], dtype='int64'),\n",
" 959000.0: Int64Index([3169], dtype='int64'),\n",
" 959200.0: Int64Index([3170], dtype='int64'),\n",
" 959700.0: Int64Index([3171], dtype='int64'),\n",
" 960000.0: Int64Index([3172], dtype='int64'),\n",
" 961000.0: Int64Index([3173], dtype='int64'),\n",
" 962200.0: Int64Index([3174], dtype='int64'),\n",
" 962400.0: Int64Index([3175], dtype='int64'),\n",
" 962800.0: Int64Index([3176], dtype='int64'),\n",
" 963000.0: Int64Index([3177], dtype='int64'),\n",
" 963500.0: Int64Index([3178], dtype='int64'),\n",
" 964000.0: Int64Index([3179], dtype='int64'),\n",
" 965000.0: Int64Index([3180], dtype='int64'),\n",
" 966400.0: Int64Index([3181], dtype='int64'),\n",
" 966500.0: Int64Index([3182], dtype='int64'),\n",
" 967000.0: Int64Index([3183], dtype='int64'),\n",
" 967500.0: Int64Index([3184], dtype='int64'),\n",
" 969000.0: Int64Index([3185], dtype='int64'),\n",
" 970500.0: Int64Index([3186], dtype='int64'),\n",
" 971000.0: Int64Index([3187], dtype='int64'),\n",
" 972300.0: Int64Index([3188], dtype='int64'),\n",
" 973000.0: Int64Index([3189], dtype='int64'),\n",
" 973700.0: Int64Index([3190], dtype='int64'),\n",
" 974200.0: Int64Index([3191], dtype='int64'),\n",
" 975000.0: Int64Index([3192], dtype='int64'),\n",
" 977000.0: Int64Index([3193], dtype='int64'),\n",
" 977100.0: Int64Index([3194], dtype='int64'),\n",
" 977500.0: Int64Index([3195], dtype='int64'),\n",
" 979000.0: Int64Index([3196], dtype='int64'),\n",
" 979200.0: Int64Index([3197], dtype='int64'),\n",
" 979400.0: Int64Index([3198], dtype='int64'),\n",
" 980000.0: Int64Index([3199], dtype='int64'),\n",
" 981000.0: Int64Index([3200, 3201], dtype='int64'),\n",
" 981900.0: Int64Index([3202], dtype='int64'),\n",
" 983000.0: Int64Index([3203], dtype='int64'),\n",
" 984500.0: Int64Index([3204], dtype='int64'),\n",
" 985000.0: Int64Index([3205], dtype='int64'),\n",
" 986400.0: Int64Index([3206], dtype='int64'),\n",
" 986800.0: Int64Index([3207], dtype='int64'),\n",
" 987000.0: Int64Index([3208], dtype='int64'),\n",
" 989000.0: Int64Index([3209], dtype='int64'),\n",
" 989500.0: Int64Index([3210], dtype='int64'),\n",
" 990000.0: Int64Index([3211], dtype='int64'),\n",
" 990900.0: Int64Index([3212], dtype='int64'),\n",
" 991000.0: Int64Index([3213], dtype='int64'),\n",
" 991500.0: Int64Index([3214], dtype='int64'),\n",
" 991700.0: Int64Index([3215], dtype='int64'),\n",
" 993000.0: Int64Index([3216], dtype='int64'),\n",
" 995000.0: Int64Index([3217], dtype='int64'),\n",
" ...}"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"グループ毎のsizeを集計\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>351200.0</th>\n",
" <td>0.02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352000.0</th>\n",
" <td>0.01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353100.0</th>\n",
" <td>0.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353200.0</th>\n",
" <td>10.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>354200.0</th>\n",
" <td>0.50</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size\n",
"unit_price \n",
"351200.0 0.02\n",
"352000.0 0.01\n",
"353100.0 0.30\n",
"353200.0 10.00\n",
"354200.0 0.50"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size\n",
"unit_price \n",
"749900.0 14.511181\n",
"750000.0 5.877415\n",
"750100.0 6.004910\n",
"750200.0 8.195254\n",
"750300.0 10.068697"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"unit_priceでグループ化\")\n",
"dfgb_bids = df_bids.groupby(\"unit_price\")\n",
"dfgb_asks = df_asks.groupby(\"unit_price\")\n",
"print(\"groupbyオブジェクトはそのまま参照はできない\")\n",
"display(dfgb_bids)\n",
"display(dfgb_asks)\n",
"print(\"group情報表示\")\n",
"display(dfgb_bids.groups)\n",
"display(dfgb_asks.groups)\n",
"\n",
"print(\"グループ毎のsizeを集計\")\n",
"df_unit_bids = dfgb_bids.agg({\"order_size\": \"sum\"})\n",
"df_unit_asks = dfgb_asks.agg({\"order_size\": \"sum\"})\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 220,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"集計結果を並び替え\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749800.0</th>\n",
" <td>10.496053</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749700.0</th>\n",
" <td>5.740088</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749600.0</th>\n",
" <td>12.318400</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749500.0</th>\n",
" <td>26.524551</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749400.0</th>\n",
" <td>8.272000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size\n",
"unit_price \n",
"749800.0 10.496053\n",
"749700.0 5.740088\n",
"749600.0 12.318400\n",
"749500.0 26.524551\n",
"749400.0 8.272000"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size\n",
"unit_price \n",
"749900.0 14.511181\n",
"750000.0 5.877415\n",
"750100.0 6.004910\n",
"750200.0 8.195254\n",
"750300.0 10.068697"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"集計結果を並び替え\")\n",
"df_unit_bids.sort_index(ascending=False, inplace=True) # index(unit_price)降順ソート\n",
"df_unit_asks.sort_index(ascending=True, inplace=True) # index(unit_price)昇順ソート\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 221,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"ここまでの処理をまとめた記述方法\n",
"1.groupby (unit単位にグループ化)\n",
"2.agg (グループ毎にorder_size集計)\n",
"3.sort_index (index(unit_price)でソート)\n",
"df_unit_bids = df_bids.groupby((df_bids['price'] // unit) * unit).agg({'order_size': 'sum'}).sort_index(ascending=False)\n",
"df_unit_asks = df_asks.groupby((df_asks['price'] // unit) * unit).agg({'order_size': 'sum'}).sort_index(ascending=True)\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>price</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749800.0</th>\n",
" <td>10.496053</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749700.0</th>\n",
" <td>5.740088</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749600.0</th>\n",
" <td>12.318400</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749500.0</th>\n",
" <td>26.524551</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749400.0</th>\n",
" <td>8.272000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size\n",
"price \n",
"749800.0 10.496053\n",
"749700.0 5.740088\n",
"749600.0 12.318400\n",
"749500.0 26.524551\n",
"749400.0 8.272000"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>price</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size\n",
"price \n",
"749900.0 14.511181\n",
"750000.0 5.877415\n",
"750100.0 6.004910\n",
"750200.0 8.195254\n",
"750300.0 10.068697"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"ここまでの処理をまとめた記述方法\")\n",
"print(\"1.groupby (unit単位にグループ化)\")\n",
"print(\"2.agg (グループ毎にorder_size集計)\")\n",
"print(\"3.sort_index (index(unit_price)でソート)\")\n",
"df_unit_bids = df_bids.groupby((df_bids[\"price\"] // unit) * unit) \\\n",
" .agg({\"order_size\": \"sum\"}) \\\n",
" .sort_index(ascending=False)\n",
"print(\"df_unit_bids = df_bids.groupby((df_bids['price'] // unit) * unit).agg({'order_size': 'sum'}).sort_index(ascending=False)\")\n",
"\n",
"df_unit_asks = df_asks.groupby((df_asks[\"price\"] // unit) * unit) \\\n",
" .agg({\"order_size\": \"sum\"}) \\\n",
" .sort_index(ascending=True)\n",
"print(\"df_unit_asks = df_asks.groupby((df_asks['price'] // unit) * unit).agg({'order_size': 'sum'}).sort_index(ascending=True)\")\n",
"\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 222,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"unit_priceで集計した様々な値を取得(合計, カウント, 最大値, 最小値, 平均)\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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 tr th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe thead tr:last-of-type th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th colspan=\"5\" halign=\"left\">order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th>sum</th>\n",
" <th>size</th>\n",
" <th>mean</th>\n",
" <th>max</th>\n",
" <th>min</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>351200.0</th>\n",
" <td>0.02</td>\n",
" <td>1</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352000.0</th>\n",
" <td>0.01</td>\n",
" <td>1</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353100.0</th>\n",
" <td>0.30</td>\n",
" <td>1</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353200.0</th>\n",
" <td>10.00</td>\n",
" <td>1</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>354200.0</th>\n",
" <td>0.50</td>\n",
" <td>1</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size \n",
" sum size mean max min\n",
"unit_price \n",
"351200.0 0.02 1 0.02 0.02 0.02\n",
"352000.0 0.01 1 0.01 0.01 0.01\n",
"353100.0 0.30 1 0.30 0.30 0.30\n",
"353200.0 10.00 1 10.00 10.00 10.00\n",
"354200.0 0.50 1 0.50 0.50 0.50"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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 tr th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe thead tr:last-of-type th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th colspan=\"5\" halign=\"left\">order_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th>sum</th>\n",
" <th>size</th>\n",
" <th>mean</th>\n",
" <th>max</th>\n",
" <th>min</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" <td>20</td>\n",
" <td>0.725559</td>\n",
" <td>5.000000</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" <td>31</td>\n",
" <td>0.189594</td>\n",
" <td>2.116697</td>\n",
" <td>0.000606</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" <td>32</td>\n",
" <td>0.187653</td>\n",
" <td>1.000000</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" <td>35</td>\n",
" <td>0.234150</td>\n",
" <td>1.000000</td>\n",
" <td>0.005000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" <td>39</td>\n",
" <td>0.258172</td>\n",
" <td>3.600000</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" order_size \n",
" sum size mean max min\n",
"unit_price \n",
"749900.0 14.511181 20 0.725559 5.000000 0.010000\n",
"750000.0 5.877415 31 0.189594 2.116697 0.000606\n",
"750100.0 6.004910 32 0.187653 1.000000 0.010000\n",
"750200.0 8.195254 35 0.234150 1.000000 0.005000\n",
"750300.0 10.068697 39 0.258172 3.600000 0.010000"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"列名変換\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>min_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>351200.0</th>\n",
" <td>0.02</td>\n",
" <td>1</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352000.0</th>\n",
" <td>0.01</td>\n",
" <td>1</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353100.0</th>\n",
" <td>0.30</td>\n",
" <td>1</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353200.0</th>\n",
" <td>10.00</td>\n",
" <td>1</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>354200.0</th>\n",
" <td>0.50</td>\n",
" <td>1</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size min_size\n",
"unit_price \n",
"351200.0 0.02 1 0.02 0.02 0.02\n",
"352000.0 0.01 1 0.01 0.01 0.01\n",
"353100.0 0.30 1 0.30 0.30 0.30\n",
"353200.0 10.00 1 10.00 10.00 10.00\n",
"354200.0 0.50 1 0.50 0.50 0.50"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>min_size</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" <td>20</td>\n",
" <td>0.725559</td>\n",
" <td>5.000000</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" <td>31</td>\n",
" <td>0.189594</td>\n",
" <td>2.116697</td>\n",
" <td>0.000606</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" <td>32</td>\n",
" <td>0.187653</td>\n",
" <td>1.000000</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" <td>35</td>\n",
" <td>0.234150</td>\n",
" <td>1.000000</td>\n",
" <td>0.005000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" <td>39</td>\n",
" <td>0.258172</td>\n",
" <td>3.600000</td>\n",
" <td>0.010000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size min_size\n",
"unit_price \n",
"749900.0 14.511181 20 0.725559 5.000000 0.010000\n",
"750000.0 5.877415 31 0.189594 2.116697 0.000606\n",
"750100.0 6.004910 32 0.187653 1.000000 0.010000\n",
"750200.0 8.195254 35 0.234150 1.000000 0.005000\n",
"750300.0 10.068697 39 0.258172 3.600000 0.010000"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"unit_priceで集計した様々な値を取得(合計, カウント, 最大値, 最小値, 平均)\")\n",
"df_unit_bids = dfgb_bids.agg({\"order_size\": [\"sum\", \"size\", \"mean\", \"max\", \"min\"]})\n",
"df_unit_asks = dfgb_asks.agg({\"order_size\": [\"sum\", \"size\", \"mean\", \"max\", \"min\"]})\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())\n",
"\n",
"print(\"列名変換\")\n",
"df_unit_bids.columns = [\"sum_size\", \"count\", \"mean_size\", \"max_size\", \"min_size\"]\n",
"df_unit_asks.columns = [\"sum_size\", \"count\", \"mean_size\", \"max_size\", \"min_size\"]\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 223,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"各集計内のorder_sizeの最大値(max_size), 最小値(min_size)のpriceを取得\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>min_size</th>\n",
" <th>max_size_price</th>\n",
" <th>min_size_price</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>351200.0</th>\n",
" <td>0.02</td>\n",
" <td>1</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" <td>351200.0</td>\n",
" <td>351200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352000.0</th>\n",
" <td>0.01</td>\n",
" <td>1</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" <td>352000.0</td>\n",
" <td>352000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353100.0</th>\n",
" <td>0.30</td>\n",
" <td>1</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" <td>353123.0</td>\n",
" <td>353123.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353200.0</th>\n",
" <td>10.00</td>\n",
" <td>1</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" <td>353200.0</td>\n",
" <td>353200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>354200.0</th>\n",
" <td>0.50</td>\n",
" <td>1</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" <td>354246.0</td>\n",
" <td>354246.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size min_size max_size_price \\\n",
"unit_price \n",
"351200.0 0.02 1 0.02 0.02 0.02 351200.0 \n",
"352000.0 0.01 1 0.01 0.01 0.01 352000.0 \n",
"353100.0 0.30 1 0.30 0.30 0.30 353123.0 \n",
"353200.0 10.00 1 10.00 10.00 10.00 353200.0 \n",
"354200.0 0.50 1 0.50 0.50 0.50 354246.0 \n",
"\n",
" min_size_price \n",
"unit_price \n",
"351200.0 351200.0 \n",
"352000.0 352000.0 \n",
"353100.0 353123.0 \n",
"353200.0 353200.0 \n",
"354200.0 354246.0 "
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>min_size</th>\n",
" <th>max_size_price</th>\n",
" <th>min_size_price</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" <td>20</td>\n",
" <td>0.725559</td>\n",
" <td>5.000000</td>\n",
" <td>0.010000</td>\n",
" <td>749941.0</td>\n",
" <td>749916.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" <td>31</td>\n",
" <td>0.189594</td>\n",
" <td>2.116697</td>\n",
" <td>0.000606</td>\n",
" <td>750000.0</td>\n",
" <td>750011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" <td>32</td>\n",
" <td>0.187653</td>\n",
" <td>1.000000</td>\n",
" <td>0.010000</td>\n",
" <td>750189.0</td>\n",
" <td>750125.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" <td>35</td>\n",
" <td>0.234150</td>\n",
" <td>1.000000</td>\n",
" <td>0.005000</td>\n",
" <td>750265.0</td>\n",
" <td>750252.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" <td>39</td>\n",
" <td>0.258172</td>\n",
" <td>3.600000</td>\n",
" <td>0.010000</td>\n",
" <td>750327.0</td>\n",
" <td>750309.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size min_size max_size_price \\\n",
"unit_price \n",
"749900.0 14.511181 20 0.725559 5.000000 0.010000 749941.0 \n",
"750000.0 5.877415 31 0.189594 2.116697 0.000606 750000.0 \n",
"750100.0 6.004910 32 0.187653 1.000000 0.010000 750189.0 \n",
"750200.0 8.195254 35 0.234150 1.000000 0.005000 750265.0 \n",
"750300.0 10.068697 39 0.258172 3.600000 0.010000 750327.0 \n",
"\n",
" min_size_price \n",
"unit_price \n",
"749900.0 749916.0 \n",
"750000.0 750011.0 \n",
"750100.0 750125.0 \n",
"750200.0 750252.0 \n",
"750300.0 750309.0 "
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"列の並び替え\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>max_size_price</th>\n",
" <th>min_size</th>\n",
" <th>min_size_price</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>351200.0</th>\n",
" <td>0.02</td>\n",
" <td>1</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" <td>351200.0</td>\n",
" <td>0.02</td>\n",
" <td>351200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352000.0</th>\n",
" <td>0.01</td>\n",
" <td>1</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" <td>352000.0</td>\n",
" <td>0.01</td>\n",
" <td>352000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353100.0</th>\n",
" <td>0.30</td>\n",
" <td>1</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" <td>353123.0</td>\n",
" <td>0.30</td>\n",
" <td>353123.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353200.0</th>\n",
" <td>10.00</td>\n",
" <td>1</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" <td>353200.0</td>\n",
" <td>10.00</td>\n",
" <td>353200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>354200.0</th>\n",
" <td>0.50</td>\n",
" <td>1</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" <td>354246.0</td>\n",
" <td>0.50</td>\n",
" <td>354246.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size max_size_price min_size \\\n",
"unit_price \n",
"351200.0 0.02 1 0.02 0.02 351200.0 0.02 \n",
"352000.0 0.01 1 0.01 0.01 352000.0 0.01 \n",
"353100.0 0.30 1 0.30 0.30 353123.0 0.30 \n",
"353200.0 10.00 1 10.00 10.00 353200.0 10.00 \n",
"354200.0 0.50 1 0.50 0.50 354246.0 0.50 \n",
"\n",
" min_size_price \n",
"unit_price \n",
"351200.0 351200.0 \n",
"352000.0 352000.0 \n",
"353100.0 353123.0 \n",
"353200.0 353200.0 \n",
"354200.0 354246.0 "
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>max_size_price</th>\n",
" <th>min_size</th>\n",
" <th>min_size_price</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" <td>20</td>\n",
" <td>0.725559</td>\n",
" <td>5.000000</td>\n",
" <td>749941.0</td>\n",
" <td>0.010000</td>\n",
" <td>749916.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" <td>31</td>\n",
" <td>0.189594</td>\n",
" <td>2.116697</td>\n",
" <td>750000.0</td>\n",
" <td>0.000606</td>\n",
" <td>750011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" <td>32</td>\n",
" <td>0.187653</td>\n",
" <td>1.000000</td>\n",
" <td>750189.0</td>\n",
" <td>0.010000</td>\n",
" <td>750125.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" <td>35</td>\n",
" <td>0.234150</td>\n",
" <td>1.000000</td>\n",
" <td>750265.0</td>\n",
" <td>0.005000</td>\n",
" <td>750252.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" <td>39</td>\n",
" <td>0.258172</td>\n",
" <td>3.600000</td>\n",
" <td>750327.0</td>\n",
" <td>0.010000</td>\n",
" <td>750309.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size max_size_price min_size \\\n",
"unit_price \n",
"749900.0 14.511181 20 0.725559 5.000000 749941.0 0.010000 \n",
"750000.0 5.877415 31 0.189594 2.116697 750000.0 0.000606 \n",
"750100.0 6.004910 32 0.187653 1.000000 750189.0 0.010000 \n",
"750200.0 8.195254 35 0.234150 1.000000 750265.0 0.005000 \n",
"750300.0 10.068697 39 0.258172 3.600000 750327.0 0.010000 \n",
"\n",
" min_size_price \n",
"unit_price \n",
"749900.0 749916.0 \n",
"750000.0 750011.0 \n",
"750100.0 750125.0 \n",
"750200.0 750252.0 \n",
"750300.0 750309.0 "
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"各集計内のorder_sizeの最大値(max_size), 最小値(min_size)のpriceを取得\")\n",
"df_unit_bids[\"max_size_price\"] = dfgb_bids.apply(lambda x: x.price[x.order_size.idxmax()])\n",
"df_unit_bids[\"min_size_price\"] = dfgb_bids.apply(lambda x: x.price[x.order_size.idxmin()])\n",
"df_unit_asks[\"max_size_price\"] = dfgb_asks.apply(lambda x: x.price[x.order_size.idxmax()])\n",
"df_unit_asks[\"min_size_price\"] = dfgb_asks.apply(lambda x: x.price[x.order_size.idxmin()])\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())\n",
"\n",
"print(\"列の並び替え\")\n",
"cols = [\"sum_size\", \"count\", \"mean_size\", \"max_size\", \"max_size_price\", \"min_size\", \"min_size_price\"]\n",
"df_unit_bids = df_unit_bids[cols]\n",
"df_unit_asks = df_unit_asks[cols]\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 224,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"各集計毎にpriceとsizeで重み付けした平均価格を取得\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>max_size_price</th>\n",
" <th>min_size</th>\n",
" <th>min_size_price</th>\n",
" <th>average_price</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>351200.0</th>\n",
" <td>0.02</td>\n",
" <td>1</td>\n",
" <td>0.02</td>\n",
" <td>0.02</td>\n",
" <td>351200.0</td>\n",
" <td>0.02</td>\n",
" <td>351200.0</td>\n",
" <td>351200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>352000.0</th>\n",
" <td>0.01</td>\n",
" <td>1</td>\n",
" <td>0.01</td>\n",
" <td>0.01</td>\n",
" <td>352000.0</td>\n",
" <td>0.01</td>\n",
" <td>352000.0</td>\n",
" <td>352000.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353100.0</th>\n",
" <td>0.30</td>\n",
" <td>1</td>\n",
" <td>0.30</td>\n",
" <td>0.30</td>\n",
" <td>353123.0</td>\n",
" <td>0.30</td>\n",
" <td>353123.0</td>\n",
" <td>353123.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>353200.0</th>\n",
" <td>10.00</td>\n",
" <td>1</td>\n",
" <td>10.00</td>\n",
" <td>10.00</td>\n",
" <td>353200.0</td>\n",
" <td>10.00</td>\n",
" <td>353200.0</td>\n",
" <td>353200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>354200.0</th>\n",
" <td>0.50</td>\n",
" <td>1</td>\n",
" <td>0.50</td>\n",
" <td>0.50</td>\n",
" <td>354246.0</td>\n",
" <td>0.50</td>\n",
" <td>354246.0</td>\n",
" <td>354246.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size max_size_price min_size \\\n",
"unit_price \n",
"351200.0 0.02 1 0.02 0.02 351200.0 0.02 \n",
"352000.0 0.01 1 0.01 0.01 352000.0 0.01 \n",
"353100.0 0.30 1 0.30 0.30 353123.0 0.30 \n",
"353200.0 10.00 1 10.00 10.00 353200.0 10.00 \n",
"354200.0 0.50 1 0.50 0.50 354246.0 0.50 \n",
"\n",
" min_size_price average_price \n",
"unit_price \n",
"351200.0 351200.0 351200.0 \n",
"352000.0 352000.0 352000.0 \n",
"353100.0 353123.0 353123.0 \n",
"353200.0 353200.0 353200.0 \n",
"354200.0 354246.0 354246.0 "
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>sum_size</th>\n",
" <th>count</th>\n",
" <th>mean_size</th>\n",
" <th>max_size</th>\n",
" <th>max_size_price</th>\n",
" <th>min_size</th>\n",
" <th>min_size_price</th>\n",
" <th>average_price</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" <td>20</td>\n",
" <td>0.725559</td>\n",
" <td>5.000000</td>\n",
" <td>749941.0</td>\n",
" <td>0.010000</td>\n",
" <td>749916.0</td>\n",
" <td>749952.034856</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" <td>31</td>\n",
" <td>0.189594</td>\n",
" <td>2.116697</td>\n",
" <td>750000.0</td>\n",
" <td>0.000606</td>\n",
" <td>750011.0</td>\n",
" <td>750024.383889</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" <td>32</td>\n",
" <td>0.187653</td>\n",
" <td>1.000000</td>\n",
" <td>750189.0</td>\n",
" <td>0.010000</td>\n",
" <td>750125.0</td>\n",
" <td>750172.262015</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" <td>35</td>\n",
" <td>0.234150</td>\n",
" <td>1.000000</td>\n",
" <td>750265.0</td>\n",
" <td>0.005000</td>\n",
" <td>750252.0</td>\n",
" <td>750262.572683</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" <td>39</td>\n",
" <td>0.258172</td>\n",
" <td>3.600000</td>\n",
" <td>750327.0</td>\n",
" <td>0.010000</td>\n",
" <td>750309.0</td>\n",
" <td>750338.375084</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" sum_size count mean_size max_size max_size_price min_size \\\n",
"unit_price \n",
"749900.0 14.511181 20 0.725559 5.000000 749941.0 0.010000 \n",
"750000.0 5.877415 31 0.189594 2.116697 750000.0 0.000606 \n",
"750100.0 6.004910 32 0.187653 1.000000 750189.0 0.010000 \n",
"750200.0 8.195254 35 0.234150 1.000000 750265.0 0.005000 \n",
"750300.0 10.068697 39 0.258172 3.600000 750327.0 0.010000 \n",
"\n",
" min_size_price average_price \n",
"unit_price \n",
"749900.0 749916.0 749952.034856 \n",
"750000.0 750011.0 750024.383889 \n",
"750100.0 750125.0 750172.262015 \n",
"750200.0 750252.0 750262.572683 \n",
"750300.0 750309.0 750338.375084 "
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"各集計毎にpriceとsizeで重み付けした平均価格を取得\")\n",
"df_unit_bids[\"average_price\"] = \\\n",
" dfgb_bids.apply(lambda x: (x.price * x.order_size).sum() / x.order_size.sum())\n",
"df_unit_asks[\"average_price\"] = \\\n",
" dfgb_asks.apply(lambda x: (x.price * x.order_size).sum() / x.order_size.sum())\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
},
{
"cell_type": "code",
"execution_count": 225,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"レイアウト整形(並び替え＆列名編集)\n"
]
},
{
"data": {
"text/plain": [
"'【unit_bids】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>合計枚数</th>\n",
" <th>件数</th>\n",
" <th>平均枚数</th>\n",
" <th>最大枚数</th>\n",
" <th>最大枚数の価格</th>\n",
" <th>最小枚数</th>\n",
" <th>最小枚数の価格</th>\n",
" <th>価格と枚数から算出した平均価格</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749800.0</th>\n",
" <td>10.496053</td>\n",
" <td>11</td>\n",
" <td>0.954187</td>\n",
" <td>5.420000</td>\n",
" <td>749800.0</td>\n",
" <td>0.010000</td>\n",
" <td>749812.0</td>\n",
" <td>749806.715843</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749700.0</th>\n",
" <td>5.740088</td>\n",
" <td>26</td>\n",
" <td>0.220773</td>\n",
" <td>1.000000</td>\n",
" <td>749777.0</td>\n",
" <td>0.010000</td>\n",
" <td>749799.0</td>\n",
" <td>749744.280983</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749600.0</th>\n",
" <td>12.318400</td>\n",
" <td>33</td>\n",
" <td>0.373285</td>\n",
" <td>5.872752</td>\n",
" <td>749600.0</td>\n",
" <td>0.010000</td>\n",
" <td>749699.0</td>\n",
" <td>749620.738186</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749500.0</th>\n",
" <td>26.524551</td>\n",
" <td>37</td>\n",
" <td>0.716880</td>\n",
" <td>16.933232</td>\n",
" <td>749500.0</td>\n",
" <td>0.000319</td>\n",
" <td>749523.0</td>\n",
" <td>749519.778594</td>\n",
" </tr>\n",
" <tr>\n",
" <th>749400.0</th>\n",
" <td>8.272000</td>\n",
" <td>36</td>\n",
" <td>0.229778</td>\n",
" <td>1.500000</td>\n",
" <td>749400.0</td>\n",
" <td>0.010000</td>\n",
" <td>749486.0</td>\n",
" <td>749436.869439</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 合計枚数 件数 平均枚数 最大枚数 最大枚数の価格 最小枚数 最小枚数の価格 \\\n",
"unit_price \n",
"749800.0 10.496053 11 0.954187 5.420000 749800.0 0.010000 749812.0 \n",
"749700.0 5.740088 26 0.220773 1.000000 749777.0 0.010000 749799.0 \n",
"749600.0 12.318400 33 0.373285 5.872752 749600.0 0.010000 749699.0 \n",
"749500.0 26.524551 37 0.716880 16.933232 749500.0 0.000319 749523.0 \n",
"749400.0 8.272000 36 0.229778 1.500000 749400.0 0.010000 749486.0 \n",
"\n",
" 価格と枚数から算出した平均価格 \n",
"unit_price \n",
"749800.0 749806.715843 \n",
"749700.0 749744.280983 \n",
"749600.0 749620.738186 \n",
"749500.0 749519.778594 \n",
"749400.0 749436.869439 "
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"'【unit_asks】'"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"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>合計枚数</th>\n",
" <th>件数</th>\n",
" <th>平均枚数</th>\n",
" <th>最大枚数</th>\n",
" <th>最大枚数の価格</th>\n",
" <th>最小枚数</th>\n",
" <th>最小枚数の価格</th>\n",
" <th>価格と枚数から算出した平均価格</th>\n",
" </tr>\n",
" <tr>\n",
" <th>unit_price</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>749900.0</th>\n",
" <td>14.511181</td>\n",
" <td>20</td>\n",
" <td>0.725559</td>\n",
" <td>5.000000</td>\n",
" <td>749941.0</td>\n",
" <td>0.010000</td>\n",
" <td>749916.0</td>\n",
" <td>749952.034856</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750000.0</th>\n",
" <td>5.877415</td>\n",
" <td>31</td>\n",
" <td>0.189594</td>\n",
" <td>2.116697</td>\n",
" <td>750000.0</td>\n",
" <td>0.000606</td>\n",
" <td>750011.0</td>\n",
" <td>750024.383889</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750100.0</th>\n",
" <td>6.004910</td>\n",
" <td>32</td>\n",
" <td>0.187653</td>\n",
" <td>1.000000</td>\n",
" <td>750189.0</td>\n",
" <td>0.010000</td>\n",
" <td>750125.0</td>\n",
" <td>750172.262015</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750200.0</th>\n",
" <td>8.195254</td>\n",
" <td>35</td>\n",
" <td>0.234150</td>\n",
" <td>1.000000</td>\n",
" <td>750265.0</td>\n",
" <td>0.005000</td>\n",
" <td>750252.0</td>\n",
" <td>750262.572683</td>\n",
" </tr>\n",
" <tr>\n",
" <th>750300.0</th>\n",
" <td>10.068697</td>\n",
" <td>39</td>\n",
" <td>0.258172</td>\n",
" <td>3.600000</td>\n",
" <td>750327.0</td>\n",
" <td>0.010000</td>\n",
" <td>750309.0</td>\n",
" <td>750338.375084</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 合計枚数 件数 平均枚数 最大枚数 最大枚数の価格 最小枚数 最小枚数の価格 \\\n",
"unit_price \n",
"749900.0 14.511181 20 0.725559 5.000000 749941.0 0.010000 749916.0 \n",
"750000.0 5.877415 31 0.189594 2.116697 750000.0 0.000606 750011.0 \n",
"750100.0 6.004910 32 0.187653 1.000000 750189.0 0.010000 750125.0 \n",
"750200.0 8.195254 35 0.234150 1.000000 750265.0 0.005000 750252.0 \n",
"750300.0 10.068697 39 0.258172 3.600000 750327.0 0.010000 750309.0 \n",
"\n",
" 価格と枚数から算出した平均価格 \n",
"unit_price \n",
"749900.0 749952.034856 \n",
"750000.0 750024.383889 \n",
"750100.0 750172.262015 \n",
"750200.0 750262.572683 \n",
"750300.0 750338.375084 "
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"print(\"レイアウト整形(並び替え＆列名編集)\")\n",
"df_unit_bids.sort_index(ascending=False, inplace=True) # index(unit_price)降順ソート\n",
"df_unit_asks.sort_index(ascending=True, inplace=True) # index(unit_price)昇順ソート\n",
"\n",
"cols = [\"合計枚数\", \"件数\", \"平均枚数\", \"最大枚数\", \"最大枚数の価格\", \"最小枚数\", \"最小枚数の価格\", \"価格と枚数から算出した平均価格\"]\n",
"df_unit_bids.columns = cols\n",
"df_unit_asks.columns = cols\n",
"\n",
"display(\"【unit_bids】\", df_unit_bids.head())\n",
"display(\"【unit_asks】\", df_unit_asks.head())"
]
}
],
"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.6.2"
},
"toc": {
"nav_menu": {},
"number_sections": true,
"sideBar": true,
"skip_h1_title": false,
"title_cell": "Table of Contents",
"title_sidebar": "Contents",
"toc_cell": false,
"toc_position": {},
"toc_section_display": true,
"toc_window_display": false
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment