In [1]:
import pandas as pd
import numpy as np
import pylab as plt
# Set the global default size of figures
plt.rc('figure', figsize = (10,5))
# figure size with subplots
figsize_with_subplots = (10, 10)
# bin size
bin_size = 10
In [6]:
/Users/martiom/kaggle
In [2]:
train = pd.read_csv('train.csv')
test = pd.read_csv('test.csv')ex
In [22]:
pd.get_dummies?
In [3]:
test_column = 'PersonalField16'
trainc = train[test_column]
testc = test[test_column]
In [27]:
import xgboost as xgb
In [28]:
clf = xgb.XGBClassifier()
In [30]:
ic = np.eye(len(trainc.unique()))
In [45]:
c2i= dict((v,i) for i, v in enumerate(trainc.unique(), start=0))
In [49]:
ti = map(lambda x: c2i[x], trainc)
In [50]:
tia = np.asarray(ti)
In [64]:
sa = ic[ti]
Counter({'ZA': 124015, 'XR': 15051, 'XJ': 10153, 'XM': 9767, 'XD': 8143, 'XH': 7899, 'XX': 7646, 'XO': 6971, 'XB': 6919, 'YH': 6625, 'ZH': 5545, 'ZT': 5536, 'ZF': 4853, 'ZR': 4639, 'XS': 4411, 'ZN': 4399, 'YF': 3643, 'YE': 2910, 'ZG': 2906, 'XW': 2644, 'XQ': 2429, 'ZW': 2298, 'XE': 2290, 'ZC': 1920, 'XC': 1270, 'ZK': 899, 'XI': 850, 'ZD': 811, 'ZE': 669, 'XZ': 652, 'ZJ': 604, 'XL': 450, 'XP': 286, 'ZU': 254, 'YI': 226, 'XK': 132, 'XF': 12, 'ZB': 10, 'XN': 3, 'ZI': 2, 'XT': 2, 'ZO': 1, 'ZV': 1, 'XV': 1, 'ZQ': 1, 'XU': 1, 'XY': 1, 'ZP': 1, 'ZS': 1, 'ZL': 1})
In [60]:
sorted(sa.sum(axis = 0))
Out[60]:
array([ 1.24015000e+05, 6.91900000e+03, 5.54500000e+03,
6.97100000e+03, 2.91000000e+03, 1.50510000e+04,
2.90600000e+03, 4.85300000e+03, 2.64400000e+03,
4.41100000e+03, 5.53600000e+03, 8.14300000e+03,
7.89900000e+03, 9.76700000e+03, 6.62500000e+03,
8.11000000e+02, 1.01530000e+04, 4.39900000e+03,
3.64300000e+03, 7.64600000e+03, 4.50000000e+02,
2.42900000e+03, 6.04000000e+02, 4.63900000e+03,
2.29800000e+03, 2.29000000e+03, 1.27000000e+03,
8.99000000e+02, 1.32000000e+02, 1.92000000e+03,
6.52000000e+02, 8.50000000e+02, 6.69000000e+02,
2.54000000e+02, 2.26000000e+02, 2.86000000e+02,
1.00000000e+00, 1.00000000e+00, 1.00000000e+01,
1.20000000e+01, 1.00000000e+00, 2.00000000e+00,
1.00000000e+00, 1.00000000e+00, 2.00000000e+00,
1.00000000e+00, 1.00000000e+00, 3.00000000e+00,
1.00000000e+00, 1.00000000e+00])
In [55]:
%%timeit
tia = np.asarray(ti)
ic[tia].shape
10 loops, best of 3: 26 ms per loop
In [4]:
print trainc.unique()
print testc.unique()
['ZA' 'XB' 'ZH' 'XO' 'YE' 'XR' 'ZG' 'ZF' 'XW' 'XS' 'ZT' 'XD' 'XH' 'XM' 'YH'
'ZD' 'XJ' 'ZN' 'YF' 'XX' 'XL' 'XQ' 'ZJ' 'ZR' 'ZW' 'XE' 'XC' 'ZK' 'XK' 'ZC'
'XZ' 'XI' 'ZE' 'ZU' 'YI' 'XP' 'ZO' 'ZP' 'ZB' 'XF' 'ZS' 'XT' 'XY' 'ZQ' 'ZI'
'XV' 'XU' 'XN' 'ZV' 'ZL']
['YH' 'YF' 'XE' 'XR' 'ZA' 'XD' 'ZF' 'ZT' 'XC' 'XX' 'ZW' 'XM' 'XH' 'ZK' 'XW'
'ZR' 'XB' 'XO' 'XJ' 'ZH' 'YE' 'ZG' 'XS' 'XZ' 'ZC' 'XQ' 'XL' 'ZN' 'ZJ' 'ZE'
'XP' 'XI' 'ZD' 'ZU' 'YI' 'XK' 'XF' 'XT' 'XV' 'ZI' 'XG' 'ZB' 'ZM' 'YG']
In [21]:
from collections import Counter
testc = test[test_column]
tk = Counter(trainc)
bk = Counter(testc)
dk = set(bk).difference(tk)
testc = testc.replace(list(dk), np.nan)
ak = Counter(testc)
print set(ak).difference(tk)
set([nan])
In [8]:
df.describe()
Out[8]:
QuoteNumber
QuoteConversion_Flag
Field7
Field8
Field9
Field11
CoverageField1A
CoverageField1B
CoverageField2A
CoverageField2B
...
GeographicField58A
GeographicField58B
GeographicField59A
GeographicField59B
GeographicField60A
GeographicField60B
GeographicField61A
GeographicField61B
GeographicField62A
GeographicField62B
count
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
...
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
260753.000000
mean
217201.246011
0.187511
18.293339
0.938346
0.001451
1.162718
9.012533
13.000403
9.054005
13.015240
...
11.567756
12.985695
11.694903
13.049882
-0.350481
12.994362
-0.343601
13.042734
-0.341009
14.122948
std
125478.522633
0.390322
7.382803
0.037086
0.001486
0.116833
5.576509
7.219264
5.560521
7.211717
...
5.448425
7.216091
5.626092
7.213636
4.057792
7.219943
4.078673
7.145248
4.086511
5.829091
min
1.000000
0.000000
1.000000
0.874600
0.000400
1.000000
-1.000000
-1.000000
1.000000
1.000000
...
-1.000000
-1.000000
-1.000000
-1.000000
-1.000000
-1.000000
-1.000000
-1.000000
-1.000000
-1.000000
25%
108517.000000
0.000000
11.000000
0.915300
0.000600
1.020000
5.000000
7.000000
5.000000
7.000000
...
8.000000
7.000000
7.000000
7.000000
-1.000000
7.000000
-1.000000
7.000000
-1.000000
8.000000
50%
217012.000000
0.000000
23.000000
0.940300
0.000600
1.188600
8.000000
13.000000
8.000000
13.000000
...
11.000000
13.000000
11.000000
13.000000
-1.000000
13.000000
-1.000000
13.000000
-1.000000
13.000000
75%
325905.000000
0.000000
24.000000
0.968500
0.003800
1.266500
12.000000
19.000000
12.000000
19.000000
...
15.000000
19.000000
15.000000
19.000000
-1.000000
19.000000
-1.000000
19.000000
-1.000000
19.000000
max
434588.000000
1.000000
28.000000
1.010100
0.004000
1.304500
25.000000
25.000000
25.000000
25.000000
...
25.000000
25.000000
25.000000
25.000000
25.000000
25.000000
25.000000
25.000000
25.000000
25.000000
8 rows × 271 columns
In [1]:
df.describe()
---------------------------------------------------------------------------
NameError Traceback (most recent call last)
<ipython-input-1-1df40f932c9d> in <module>()
----> 1 df.describe()
NameError: name 'df' is not defined
In [16]:
for c in df.columns:
print c, df[c].dtype, df[c].unique()
QuoteNumber int64 [ 1 2 4 ..., 434586 434587 434588]
Original_Quote_Date object ['2013-08-16' '2014-04-22' '2014-08-25' '2013-04-15' '2014-01-25'
'2014-01-18' '2013-11-01' '2014-05-14' '2013-06-19' '2013-06-18'
'2013-09-24' '2013-06-11' '2013-10-22' '2013-08-20' '2015-02-24'
'2014-10-27' '2015-02-06' '2013-10-02' '2014-09-15' '2014-03-18'
'2014-10-15' '2014-04-03' '2015-03-31' '2013-05-30' '2015-03-30'
'2013-09-17' '2015-03-07' '2013-06-06' '2013-01-22' '2013-04-16'
'2014-03-04' '2014-02-24' '2015-05-12' '2014-02-01' '2013-08-12'
'2015-05-13' '2014-04-13' '2014-05-02' '2015-05-18' '2015-01-28'
'2013-12-30' '2014-06-20' '2014-01-08' '2014-10-08' '2013-07-26'
'2013-07-11' '2014-12-15' '2014-12-08' '2015-02-22' '2013-09-19'
'2015-05-07' '2015-01-14' '2013-04-22' '2014-05-29' '2014-02-12'
'2014-06-02' '2014-05-18' '2014-01-20' '2013-07-16' '2013-02-15'
'2015-03-11' '2015-03-12' '2014-07-30' '2013-08-23' '2013-08-30'
'2013-04-03' '2013-06-20' '2015-01-25' '2013-12-10' '2015-01-05'
'2013-12-03' '2014-11-18' '2013-07-29' '2013-12-25' '2015-01-16'
'2015-03-05' '2015-05-09' '2013-08-09' '2015-04-09' '2013-02-07'
'2015-01-07' '2015-01-02' '2013-05-24' '2014-12-31' '2014-12-04'
'2015-02-05' '2013-05-13' '2013-11-19' '2014-08-27' '2013-05-05'
'2014-06-26' '2013-06-04' '2013-01-14' '2014-06-28' '2014-02-05'
'2014-10-30' '2013-10-06' '2014-05-16' '2015-03-29' '2013-10-08'
'2015-03-21' '2014-07-15' '2014-04-02' '2013-04-02' '2014-01-13'
'2013-08-29' '2014-07-21' '2013-10-17' '2014-08-09' '2014-04-15'
'2014-07-18' '2013-01-21' '2015-05-05' '2013-11-02' '2014-03-06'
'2013-12-31' '2015-01-03' '2013-11-13' '2015-03-09' '2013-01-11'
'2013-09-15' '2014-01-06' '2013-04-06' '2013-10-23' '2013-10-03'
'2013-10-19' '2014-02-03' '2014-12-03' '2013-04-25' '2014-05-08'
'2013-02-11' '2014-12-19' '2014-08-13' '2014-11-11' '2015-04-27'
'2015-02-20' '2015-05-06' '2013-02-13' '2015-04-20' '2014-05-23'
'2014-03-26' '2013-09-07' '2013-11-10' '2014-02-11' '2013-09-30'
'2014-08-29' '2014-05-20' '2013-04-10' '2015-02-21' '2014-01-07'
'2014-06-13' '2015-03-25' '2015-04-15' '2014-09-09' '2014-01-23'
'2014-03-09' '2013-04-27' '2013-10-14' '2014-03-25' '2014-05-30'
'2013-10-18' '2013-10-26' '2014-07-29' '2013-10-21' '2015-02-13'
'2014-06-19' '2014-02-21' '2013-01-30' '2013-03-05' '2015-02-23'
'2014-02-13' '2013-05-21' '2014-03-14' '2013-03-26' '2014-04-09'
'2015-02-08' '2014-04-04' '2015-05-03' '2013-03-15' '2015-02-19'
'2014-06-18' '2013-02-16' '2013-06-05' '2013-09-29' '2013-02-18'
'2013-03-23' '2014-11-17' '2015-01-09' '2015-03-10' '2015-03-27'
'2014-02-17' '2014-08-02' '2014-08-10' '2014-01-02' '2013-10-10'
'2013-10-04' '2013-11-12' '2014-07-31' '2014-01-30' '2013-06-25'
'2014-02-19' '2014-01-14' '2013-11-27' '2015-04-08' '2014-10-02'
'2014-12-09' '2014-07-05' '2014-03-05' '2014-06-09' '2013-12-06'
'2014-09-25' '2013-08-06' '2013-09-13' '2013-09-20' '2014-09-18'
'2015-02-04' '2013-09-03' '2015-04-01' '2013-05-27' '2013-10-16'
'2014-09-06' '2014-12-18' '2014-09-05' '2013-07-09' '2015-02-27'
'2014-02-04' '2014-05-15' '2014-09-17' '2014-03-19' '2013-10-31'
'2013-12-27' '2013-07-02' '2014-07-16' '2014-06-11' '2013-01-18'
'2013-05-01' '2014-06-17' '2013-05-22' '2014-04-01' '2013-07-12'
'2013-10-25' '2014-08-18' '2014-01-22' '2013-08-22' '2013-02-08'
'2014-11-19' '2014-03-20' '2015-01-29' '2013-06-17' '2013-08-13'
'2013-07-25' '2014-04-14' '2014-10-31' '2015-03-17' '2013-10-29'
'2014-01-10' '2014-01-11' '2013-01-28' '2015-02-12' '2013-07-15'
'2014-08-08' '2013-05-03' '2013-01-26' '2013-01-03' '2014-07-24'
'2014-08-23' '2013-06-26' '2015-01-27' '2013-05-19' '2015-04-19'
'2014-06-30' '2014-02-14' '2013-10-15' '2015-04-25' '2013-06-09'
'2013-04-17' '2014-07-02' '2014-09-08' '2014-01-15' '2015-04-07'
'2014-03-12' '2014-01-17' '2015-04-21' '2013-08-01' '2013-07-08'
'2014-09-22' '2014-07-17' '2014-10-29' '2014-12-07' '2014-08-04'
'2014-03-21' '2014-03-08' '2014-04-30' '2013-05-14' '2014-09-19'
'2013-03-21' '2013-04-30' '2014-12-26' '2014-08-03' '2014-09-14'
'2014-11-22' '2015-02-17' '2013-03-19' '2015-04-13' '2014-06-25'
'2013-05-17' '2014-01-28' '2013-09-25' '2014-05-21' '2013-11-08'
'2013-12-28' '2015-03-18' '2013-04-19' '2014-11-06' '2014-03-15'
'2014-12-23' '2013-10-07' '2013-05-15' '2015-02-26' '2013-09-10'
'2013-08-07' '2015-04-28' '2014-10-17' '2013-02-05' '2013-05-07'
'2014-07-08' '2013-10-24' '2015-03-08' '2013-08-14' '2015-01-13'
'2014-03-31' '2015-04-14' '2015-01-17' '2014-09-11' '2013-01-19'
'2014-11-24' '2013-03-13' '2013-02-26' '2014-05-13' '2014-09-03'
'2013-05-20' '2013-08-11' '2014-12-12' '2013-03-27' '2014-09-29'
'2013-09-11' '2015-02-15' '2014-03-27' '2013-12-24' '2014-11-03'
'2015-03-16' '2013-12-14' '2014-06-12' '2014-07-14' '2014-07-28'
'2013-01-20' '2014-05-03' '2014-10-28' '2014-05-06' '2015-04-10'
'2013-05-11' '2013-05-28' '2013-02-27' '2015-02-09' '2015-03-26'
'2015-03-15' '2013-04-12' '2013-03-06' '2015-01-26' '2014-06-24'
'2013-01-29' '2014-04-05' '2013-03-04' '2013-07-14' '2013-04-11'
'2014-06-04' '2013-06-10' '2014-06-06' '2014-12-01' '2014-03-11'
'2014-11-15' '2014-02-16' '2013-12-04' '2013-02-04' '2015-02-18'
'2013-11-26' '2015-04-26' '2014-02-22' '2013-11-11' '2014-05-12'
'2014-06-14' '2013-01-05' '2014-09-13' '2013-12-05' '2014-06-22'
'2015-04-03' '2013-07-31' '2014-12-10' '2013-11-25' '2013-03-07'
'2013-08-05' '2014-06-27' '2013-07-22' '2014-02-20' '2013-04-26'
'2014-12-02' '2013-03-28' '2013-08-25' '2014-10-11' '2015-04-02'
'2015-04-06' '2014-10-01' '2014-11-21' '2014-11-12' '2014-05-19'
'2014-12-16' '2013-09-06' '2015-04-29' '2014-05-09' '2014-05-25'
'2013-12-09' '2014-11-30' '2014-10-06' '2013-03-12' '2013-04-05'
'2013-06-03' '2014-08-11' '2014-10-12' '2015-02-11' '2013-09-04'
'2015-05-14' '2013-01-04' '2014-04-07' '2014-03-07' '2014-03-13'
'2014-05-22' '2013-01-17' '2013-11-14' '2014-04-18' '2013-05-02'
'2014-01-29' '2015-03-02' '2013-09-12' '2013-01-25' '2014-07-11'
'2014-01-05' '2013-08-31' '2014-04-16' '2014-10-09' '2013-06-29'
'2014-06-29' '2014-03-10' '2013-07-05' '2013-09-16' '2013-05-25'
'2013-03-11' '2014-10-20' '2014-07-19' '2013-01-31' '2015-04-11'
'2014-12-13' '2014-08-17' '2014-09-28' '2015-01-23' '2014-02-26'
'2013-04-08' '2014-11-13' '2015-01-21' '2013-11-18' '2013-12-20'
'2013-11-07' '2014-03-23' '2015-02-03' '2015-01-30' '2013-03-25'
'2013-06-23' '2013-04-09' '2014-06-08' '2013-04-13' '2014-03-17'
'2013-06-02' '2013-10-11' '2013-09-09' '2013-07-18' '2015-01-15'
'2013-06-13' '2015-04-17' '2013-08-08' '2014-10-04' '2014-02-25'
'2013-09-27' '2014-06-03' '2014-10-03' '2013-01-02' '2013-07-03'
'2013-06-12' '2013-10-01' '2014-09-16' '2013-08-27' '2013-11-06'
'2013-11-09' '2015-01-01' '2014-04-19' '2013-07-23' '2013-02-06'
'2014-05-01' '2014-06-21' '2014-01-31' '2013-04-28' '2014-04-06'
'2013-09-26' '2015-02-07' '2013-11-05' '2014-11-04' '2014-06-10'
'2013-11-23' '2014-08-21' '2014-11-07' '2013-12-15' '2014-01-21'
'2013-11-20' '2014-11-14' '2014-05-05' '2015-04-24' '2014-08-19'
'2014-11-26' '2014-03-29' '2013-02-02' '2013-11-15' '2014-09-21'
'2014-02-15' '2014-10-16' '2014-08-26' '2013-12-19' '2015-01-04'
'2015-01-08' '2014-08-06' '2015-04-22' '2014-12-22' '2013-06-07'
'2014-02-08' '2013-02-25' '2013-09-28' '2013-03-09' '2013-09-18'
'2013-02-12' '2013-03-18' '2014-04-08' '2013-01-08' '2014-04-29'
'2013-05-06' '2013-07-10' '2013-07-17' '2013-05-16' '2014-09-23'
'2014-04-28' '2013-07-28' '2014-11-01' '2014-02-06' '2013-09-22'
'2013-01-06' '2013-06-28' '2013-08-10' '2014-10-25' '2014-01-16'
'2013-09-02' '2013-06-21' '2013-03-01' '2015-05-15' '2014-08-12'
'2014-06-23' '2014-02-23' '2013-10-05' '2013-02-23' '2013-12-17'
'2014-04-10' '2014-01-09' '2014-07-27' '2013-10-30' '2014-04-12'
'2014-05-26' '2014-04-23' '2013-12-02' '2014-06-01' '2013-08-15'
'2013-06-15' '2014-08-14' '2014-04-24' '2013-07-04' '2014-08-07'
'2013-08-24' '2014-03-16' '2015-03-20' '2014-07-25' '2013-05-26'
'2014-03-24' '2013-02-03' '2014-04-17' '2014-07-01' '2015-05-11'
'2013-01-23' '2015-03-19' '2015-03-28' '2015-03-04' '2014-11-02'
'2014-09-04' '2014-04-11' '2014-11-25' '2013-06-22' '2013-03-22'
'2013-10-27' '2015-01-12' '2014-03-03' '2013-11-22' '2013-06-08'
'2013-09-23' '2014-09-02' '2014-09-12' '2015-01-10' '2014-05-11'
'2014-05-27' '2014-07-20' '2013-12-13' '2015-01-22' '2013-03-17'
'2013-01-09' '2013-08-26' '2014-07-22' '2013-07-19' '2014-04-25'
'2013-06-16' '2014-01-04' '2014-07-23' '2014-07-13' '2013-04-20'
'2013-12-18' '2014-03-01' '2013-02-19' '2013-02-20' '2013-11-21'
'2013-03-10' '2014-02-10' '2013-04-23' '2014-05-28' '2013-08-18'
'2014-01-27' '2013-07-20' '2013-10-28' '2015-03-23' '2014-11-29'
'2013-05-10' '2013-04-01' '2013-09-14' '2014-10-14' '2014-11-10'
'2013-03-30' '2014-12-28' '2014-11-28' '2015-04-16' '2014-01-01'
'2014-12-05' '2014-12-14' '2014-04-21' '2013-03-14' '2013-05-18'
'2013-04-24' '2015-02-01' '2013-04-29' '2015-04-18' '2014-10-21'
'2013-09-21' '2013-11-04' '2014-12-11' '2014-07-09' '2014-07-07'
'2015-01-11' '2015-05-02' '2013-08-21' '2013-02-21' '2013-12-08'
'2013-02-09' '2013-12-01' '2013-06-14' '2013-02-10' '2014-10-22'
'2013-07-27' '2014-08-22' '2013-03-20' '2014-11-05' '2014-06-05'
'2014-02-18' '2014-08-24' '2013-01-16' '2014-12-29' '2013-01-15'
'2015-04-23' '2013-07-21' '2013-03-08' '2014-10-10' '2014-01-03'
'2013-05-23' '2014-08-15' '2014-12-24' '2014-03-22' '2014-08-28'
'2015-03-13' '2013-05-29' '2014-08-20' '2015-03-03' '2015-02-25'
'2013-12-22' '2014-10-13' '2013-12-29' '2014-02-27' '2014-04-20'
'2013-07-24' '2014-02-07' '2014-12-30' '2015-01-24' '2014-09-20'
'2014-11-20' '2015-01-19' '2014-12-17' '2014-08-05' '2014-05-31'
'2014-06-16' '2013-07-01' '2013-12-11' '2013-11-30' '2015-01-18'
'2013-08-03' '2015-05-10' '2013-01-27' '2015-02-02' '2014-01-19'
'2013-08-28' '2014-10-23' '2015-05-04' '2015-02-10' '2015-03-14'
'2013-11-29' '2013-05-08' '2014-10-26' '2014-03-30' '2014-11-16'
'2014-05-04' '2013-11-24' '2013-06-30' '2013-11-16' '2014-09-24'
'2013-12-23' '2013-01-24' '2014-12-27' '2015-03-24' '2013-02-17'
'2013-06-27' '2014-03-02' '2015-01-20' '2014-09-07' '2014-09-01'
'2015-05-01' '2013-11-03' '2014-07-03' '2013-01-01' '2013-10-13'
'2013-08-17' '2015-01-31' '2013-07-13' '2013-06-24' '2014-11-08'
'2013-05-09' '2013-03-02' '2014-10-05' '2013-04-21' '2015-05-17'
'2013-01-07' '2015-01-06' '2014-10-24' '2014-05-07' '2014-05-24'
'2013-02-28' '2013-07-30' '2015-04-30' '2013-02-01' '2013-08-19'
'2015-02-16' '2015-03-22' '2015-03-06' '2014-08-30' '2014-12-06'
'2013-08-02' '2014-09-30' '2014-10-07' '2014-06-15' '2013-03-16'
'2013-03-29' '2014-07-10' '2014-01-12' '2014-09-10' '2013-12-26'
'2014-03-28' '2015-02-28' '2014-07-26' '2014-06-07' '2013-09-05'
'2014-04-26' '2013-03-03' '2013-10-09' '2013-06-01' '2015-05-08'
'2014-07-06' '2013-02-22' '2013-01-10' '2013-10-12' '2014-01-24'
'2013-08-04' '2013-05-04' '2014-05-10' '2013-05-31' '2015-03-01'
'2013-04-07' '2013-09-01' '2013-04-18' '2014-08-16' '2013-12-12'
'2013-04-04' '2014-08-01' '2013-02-24' '2014-12-25' '2014-10-19'
'2013-12-07' '2013-12-16' '2015-04-05' '2013-04-14' '2014-02-02'
'2014-09-26' '2014-07-12' '2015-02-14' '2015-05-16' '2013-07-06'
'2015-04-12' '2014-12-21' '2014-11-23' '2014-10-18' '2013-01-12'
'2014-11-27' '2013-01-13' '2014-02-09' '2014-05-17' '2013-09-08'
'2014-07-04' '2013-07-07' '2014-02-28' '2013-11-17' '2013-10-20'
'2014-11-09' '2013-02-14' '2014-04-27' '2014-01-26' '2014-09-27'
'2013-03-24' '2013-03-31' '2015-04-04' '2014-08-31' '2013-05-12'
'2014-12-20' '2013-12-21' '2013-11-28']
QuoteConversion_Flag int64 [0 1]
Field6 object ['B' 'F' 'J' 'E' 'C' 'K' 'A' 'D']
Field7 int64 [23 7 10 14 25 11 20 24 22 26 19 17 6 4 21 2 1 15 3 16 8 12 27 28 13
9 5 18]
Field8 float64 [ 0.9403 1.0006 0.9769 0.9472 0.9258 0.9153 0.9691 0.9919 0.9497
0.9893 0.8793 0.9485 0.8922 1.0101 0.893 0.9219 0.9392 0.9685
0.887 0.8746 0.8928 0.9838 1.0005 0.9487 0.9313 0.9525 0.9559
0.9482 0.9223 0.9566 0.9108 0.8945 0.9023 0.9489 0.9194 0.9364
0.9368 0.9375]
Field9 float64 [ 0.0006 0.004 0.0004 0.0007 0.0038]
Field10 object ['965' '548' '1,165' '1,487' '935' '564' '1,113' '1,480']
Field11 float64 [ 1.02 1.2433 1.2665 1.3045 1.1886 1.2694 1. 1.1161 1.2392
1.067 1.2714]
Field12 object ['N' 'Y']
CoverageField1A int64 [17 6 7 3 8 13 16 5 11 4 18 10 12 14 1 9 23 19 2 21 -1 15 20 25 22
24]
CoverageField1B int64 [23 8 12 2 13 20 19 4 14 6 17 7 22 1 15 25 11 9 3 16 24 10 5 18 -1
21]
CoverageField2A int64 [17 6 7 3 8 13 5 11 4 9 18 10 12 15 1 23 19 2 21 16 14 20 25 22 24]
CoverageField2B int64 [23 8 12 2 13 20 19 5 15 24 6 17 14 4 7 22 1 25 11 9 16 10 3 18 21]
CoverageField3A int64 [15 5 6 2 7 17 8 4 16 14 11 13 1 10 12 25 9 3 19 20 18 23 22 21 24]
CoverageField3B int64 [22 7 10 2 11 23 6 14 4 12 5 21 9 18 20 1 17 25 15 3 13 24 19 16 8]
CoverageField4A int64 [16 5 7 3 12 11 4 8 17 10 14 1 9 22 6 15 18 2 20 13 25 19 21 24 23]
CoverageField4B int64 [22 8 11 2 13 20 7 18 4 14 23 6 17 19 21 1 15 24 10 9 3 12 5 25 16]
CoverageField5A int64 [13 25 1]
CoverageField5B int64 [22 25 2 1]
CoverageField6A int64 [13 1 25]
CoverageField6B int64 [23 6 25 1]
CoverageField8 object ['T' 'Y' 'X' 'W' 'V' 'U' 'Z']
CoverageField9 object ['D' 'E' 'J' 'F' 'A' 'G' 'K' 'C' 'L' 'B' 'I' 'H']
CoverageField11A int64 [ 2 5 4 15 25 6 3 11 8 10 20 13 9 7 12 19 1 18 14 -1 22 23 17 16 21
24]
CoverageField11B int64 [ 1 9 6 23 10 2 25 12 5 20 13 15 19 11 24 3 4 7 22 18 14 21 17 16 -1
8]
SalesField1A int64 [ 7 5 3 8 25 15 1 4 10 2 16 6 12 13 11 9 14 24 17 18 21 22 20 19 23]
SalesField1B int64 [18 14 10 19 6 25 24 1 20 13 9 15 21 3 7 17 5 11 16 8 23 4 22 2 12]
SalesField2A int64 [ 3 6 4 14 25 7 2 10 5 9 12 11 1 13 21 8 24 -1 17 18 15 16 20 22 23
19]
SalesField2B int64 [ 8 18 11 24 6 25 20 3 22 17 14 19 12 21 7 4 13 15 1 9 10 23 2 16 -1
5]
SalesField3 int64 [0 1]
SalesField4 int64 [5 4 1 3 2]
SalesField5 int64 [5 3 2 4 1]
SalesField6 int64 [24 11 23 7 20 1 17 21 10 4 15 8 3 16 14 22 18 12 13 9 2 6 5 19]
SalesField7 object ['V' 'P' 'K' 'R' 'T' 'Q' 'M']
SalesField8 int64 [48649 26778 8751 ..., 9716 61320 28442]
SalesField9 int64 [0 1]
SalesField10 int64 [ 0 1 4 2 3 10 7 5 6 8 9 13 17 12 11 14 15 21 16]
SalesField11 int64 [ 0 1 2 4 3 5 10 7 6 11 8 9 13 15 21 14 12 16 32 20]
SalesField12 int64 [ 0 1 2 4 3 5 10 7 6 11 8 9 13 15 29 21 14 12 16 32 19 20]
SalesField13 int64 [0 4 1 3 2 6 5 7]
SalesField14 int64 [ 0 4 1 3 2 6 5 9 8 7 11 14]
SalesField15 int64 [ 0 4 1 3 2 6 5 9 8 7 11 14]
PersonalField1 int64 [0 1]
PersonalField2 int64 [0 1]
PersonalField4A int64 [-1 14 16 2 20 9 8 25 4 1 13 7 11 22 6 18 5 15 12 10 19 17 24 23 3
21]
PersonalField4B int64 [-1 19 21 2 24 12 10 25 4 1 16 8 17 14 18 15 7 22 6 20 13 23 9 11 5
3]
PersonalField5 int64 [ 7 6 10 9 1 2 3 4 5]
PersonalField6 int64 [0 1]
PersonalField7 object ['N' 'Y' nan]
PersonalField8 int64 [1 2 3]
PersonalField9 int64 [2 3 1]
PersonalField10A int64 [ 5 24 7 -1 4 20 21 25 6 13 8 18 19 23 9 14 10 15 17 22 11 12 1 16 2
3]
PersonalField10B int64 [ 7 25 16 -1 8 3 23 2 11 5 20 17 22 15 24 18 12 21 9 19 6 14 13 4 10
1]
PersonalField11 int64 [0 1 2 3 4]
PersonalField12 int64 [1 5 3 4 2]
PersonalField13 int64 [2 1 4 3]
PersonalField14 int64 [ 2 5 3 1 4 6 7 11 8 10 9 12 13 32 22 15 19 35 18 25 52 14 54 20 47
30 23 21 50 16]
PersonalField15 int64 [24 19 7 13 6 5 10 17 12 1 11 8 14 9 4 3 16 18 22 20 15 21]
PersonalField16 object ['ZA' 'XB' 'ZH' 'XO' 'YE' 'XR' 'ZG' 'ZF' 'XW' 'XS' 'ZT' 'XD' 'XH' 'XM' 'YH'
'ZD' 'XJ' 'ZN' 'YF' 'XX' 'XL' 'XQ' 'ZJ' 'ZR' 'ZW' 'XE' 'XC' 'ZK' 'XK' 'ZC'
'XZ' 'XI' 'ZE' 'ZU' 'YI' 'XP' 'ZO' 'ZP' 'ZB' 'XF' 'ZS' 'XT' 'XY' 'ZQ' 'ZI'
'XV' 'XU' 'XN' 'ZV' 'ZL']
PersonalField17 object ['ZE' 'YJ' 'XS' 'XE' 'XU' 'ZQ' 'YY' 'XV' 'ZF' 'XK' 'YS' 'ZK' 'YF' 'YV' 'XG'
'ZL' 'ZH' 'ZW' 'XH' 'ZU' 'YH' 'XC' 'ZV' 'XR' 'ZI' 'XX' 'YR' 'XW' 'ZC' 'YZ'
'YU' 'YX' 'ZA' 'ZP' 'XI' 'YN' 'YL' 'YK' 'ZN' 'XT' 'ZT' 'XQ' 'XB' 'YI' 'YM'
'XL' 'YQ' 'ZG' 'ZS' 'YT' 'ZO' 'YE' 'XN' 'ZM' 'XM' 'YG' 'YP' 'XD' 'ZD' 'YW'
'XJ' 'ZB' 'XP' 'XO' 'ZR' 'XY']
PersonalField18 object ['XR' 'YE' 'YP' 'YI' 'XQ' 'ZW' 'XT' 'XF' 'XS' 'YG' 'ZF' 'XZ' 'XI' 'XK' 'YF'
'ZE' 'YQ' 'ZP' 'YL' 'ZD' 'XW' 'YN' 'YK' 'ZJ' 'ZK' 'ZC' 'XU' 'ZN' 'XP' 'XL'
'XM' 'ZL' 'XC' 'ZH' 'XG' 'XN' 'XY' 'ZQ' 'XO' 'ZT' 'XJ' 'ZA' 'ZU' 'XE' 'ZV'
'ZS' 'YR' 'YH' 'YJ' 'ZR' 'ZO' 'YO' 'ZM' 'XD' 'YM' 'XX' 'ZB' 'XH' 'XV' 'ZG'
'ZI']
PersonalField19 object ['XD' 'XT' 'XC' 'XX' 'ZQ' 'ZT' 'ZO' 'YJ' 'ZN' 'YH' 'ZI' 'YN' 'YF' 'YK' 'XY'
'XI' 'ZA' 'ZW' 'ZV' 'XU' 'ZL' 'XK' 'XW' 'XF' 'ZK' 'YE' 'XB' 'XZ' 'XP' 'ZJ'
'YM' 'XO' 'YG' 'XN' 'ZR' 'ZE' 'ZB' 'ZG' 'YL' 'ZF' 'XR' 'XJ' 'XM' 'ZP' 'XQ'
'XV' 'ZH' 'XE' 'ZU' 'ZM' 'XG' 'ZD' 'XH' 'XL' 'YI' 'XS' 'ZC']
PersonalField22 int64 [1 3 4 2 5 6 7]
PersonalField23 int64 [ 0 1 2 3 4 8 5 6 10 12 7 14 11]
PersonalField24 int64 [ 0 1 2 3 4 8 5 6 10 9 12 7 14 11]
PersonalField25 int64 [ 0 1 2 3 6 4 8 5 10 9 12 7 14 11]
PersonalField26 int64 [ 0 1 2 3 6 4 9 8 5 10 12 7 14 11]
PersonalField27 int64 [ 1 0 2 3 4 7 10 5 9 6 11 13 15 23 14 8 12]
PersonalField28 int64 [2 1 3 4 5 6 7]
PersonalField29 int64 [2 1 3 6 4 5 7]
PersonalField30 int64 [ 0 1 4 2 3 14 22 6 10 5 7 8]
PersonalField31 int64 [ 1 0 2 4 3 15 5 23 6 11 7 9]
PersonalField32 int64 [ 1 0 2 4 3 15 5 6 23 11 7 9]
PersonalField33 int64 [ 1 0 2 4 3 15 5 6 23 7 11 9]
PersonalField34 int64 [1 2 3 4 7 6 5]
PersonalField35 int64 [0 1 2 5 4 3]
PersonalField36 int64 [0 1 2 3 5 4]
PersonalField37 int64 [0 1 2 3 5 4]
PersonalField38 int64 [0 2 1 3 4 5]
PersonalField39 int64 [0 1 2 4 3 6 8 5 7]
PersonalField40 int64 [0 1 4 2 9 3 6 8 5 7]
PersonalField41 int64 [0 1 4 2 9 3 6 5 8 7]
PersonalField42 int64 [0 1 2 4 9 3 6 5 8 7]
PersonalField43 int64 [1 2 3 4 6 5 7]
PersonalField44 int64 [ 0 1 4 2 3 14 22 6 5 10 7 8]
PersonalField45 int64 [ 1 0 2 4 3 15 5 23 6 11 7 9]
PersonalField46 int64 [ 1 0 2 4 3 15 5 6 23 11 7 9]
PersonalField47 int64 [ 1 0 2 4 3 15 5 6 23 7 11 9]
PersonalField48 int64 [2 1 3 6 4 5 7]
PersonalField49 int64 [0 1 4 2 3 6 7]
PersonalField50 int64 [0 1 4 2 3 6 7]
PersonalField51 int64 [0 1 4 2 3 6 7]
PersonalField52 int64 [0 1 2 4 3 6 7]
PersonalField53 int64 [1 3 6 4 2 5 7]
PersonalField54 int64 [ 0 1 4 5 2 3 10 6 8 7 12]
PersonalField55 int64 [ 0 1 4 5 2 6 3 10 8 7 12]
PersonalField56 int64 [ 0 1 2 4 3 5 6 10 8 7 14 12]
PersonalField57 int64 [ 0 1 2 4 3 5 6 10 9 8 7 14 12]
PersonalField58 int64 [1 2 3 6 7 4 5]
PersonalField59 int64 [0 1 2 4 3 6 5]
PersonalField60 int64 [0 1 2 4 3 6 5]
PersonalField61 int64 [0 1 2 4 3 6 5]
PersonalField62 int64 [0 1 2 4 3 6 5]
PersonalField63 int64 [1 3 2 4 6 5 7]
PersonalField64 int64 [0 1 2]
PersonalField65 int64 [0 1 2]
PersonalField66 int64 [0 1 2]
PersonalField67 int64 [0 1 2]
PersonalField68 int64 [1 2 3 4]
PersonalField69 int64 [0 1 5 2 3 4]
PersonalField70 int64 [0 1 5 2 3 4 7]
PersonalField71 int64 [0 1 3 5 2 4 7]
PersonalField72 int64 [0 1 2 3 5 4 6 7]
PersonalField73 int64 [1 3 2 7 4 5 6]
PersonalField74 int64 [ 0 1 2 3 7 4 22 5]
PersonalField75 int64 [ 1 0 2 4 3 8 6 5 23]
PersonalField76 int64 [ 1 0 2 3 4 8 6 5 23 7]
PersonalField77 int64 [ 1 0 2 3 4 8 6 5 23 7 9]
PersonalField78 int64 [2 1 3 4 5 7 6]
PersonalField79 int64 [ 0 1 2 3 4 8 5 10 6 7 12 14 11]
PersonalField80 int64 [ 0 1 2 3 4 8 5 6 10 9 7 12 14 11]
PersonalField81 int64 [ 0 1 2 3 6 4 8 5 10 9 7 12 14 11]
PersonalField82 int64 [ 0 1 2 3 9 4 8 5 6 10 12 7 11 14]
PersonalField83 int64 [1 3 2 4 5 6 7]
PersonalField84 float64 [ 2. nan 1. 5. 4. 7. 8. 3.]
PropertyField1A int64 [ 5 17 12 1 10 8 7 13 4 19 16 3 14 23 22 11 6 25 9 15 18 24 2 21 20
-1]
PropertyField1B int64 [ 7 21 16 1 13 12 11 17 5 23 20 3 14 15 19 22 24 18 9 25 4 6 10 2 8
-1]
PropertyField2A int64 [-1 25]
PropertyField2B int64 [19 22 13 2 3 9 24 21 16 5 15 10 8 6 18 23 12 4 20 25 17]
PropertyField3 object ['N' 'Y' nan]
PropertyField4 object ['N' 'Y' nan]
PropertyField5 object ['Y' 'N']
PropertyField6 int64 [0]
PropertyField7 object ['O' 'N' 'R' 'D' 'S' 'J' 'I' 'Q' 'A' 'K' 'G' 'F' 'H' 'E' 'L' 'C' 'P' 'M'
'B']
PropertyField8 int64 [0 1]
PropertyField9 int64 [0 2 1]
PropertyField10 int64 [1 4 2 3 0]
PropertyField11A int64 [-1 25]
PropertyField11B int64 [21 23 24 22 25]
PropertyField12 int64 [4 3 1 2 5 7 6]
PropertyField13 int64 [2 0 1 3]
PropertyField14 object ['C' 'B' 'A' 'D']
PropertyField15 int64 [ 4 1 2 5 10 8 9 11 15 14 6 13 12 7 3]
PropertyField16A int64 [14 7 9 3 5 4 6 17 22 1 25 18 2 10 8 11 19 16 12 13 15 21 24 23 20
-1]
PropertyField16B int64 [22 15 17 6 11 8 14 18 23 25 5 7 12 24 4 1 13 10 3 2 19 16 20 9 21
-1]
PropertyField17 int64 [0 1 2 3 5 4 6 7]
PropertyField18 int64 [3 1 2 0 4 5 6 9 8 7]
PropertyField19 int64 [0 1 2 7 3 5 4 9 8 6]
PropertyField20 int64 [0 1 2]
PropertyField21A int64 [17 6 7 3 8 13 16 5 11 4 9 18 10 12 14 1 23 19 2 21 15 24 20 25 22
-1]
PropertyField21B int64 [23 8 12 2 13 20 19 4 14 24 6 17 7 22 1 15 25 11 9 3 16 10 5 18 21
-1]
PropertyField22 int64 [2 4 3 5 1]
PropertyField23 int64 [ 4 1 2 13 10 3 14 11 9 8 7 5 6]
PropertyField24A int64 [15 6 7 13 11 5 14 4 3 23 12 17 8 20 10 19 9 16 1 25 18 2 21 24 22
-1]
PropertyField24B int64 [21 8 9 19 16 6 20 5 3 25 18 22 7 11 24 15 17 4 12 23 14 13 2 10 1
-1]
PropertyField25 float64 [ 3. 2. 1.5 1. 2.5 5. 4. 3.5 7. 6. 0. ]
PropertyField26A int64 [ 5 4 14 13 15 18 11 22 8 9 16 12 7 2 19 6 21 3 23 20 25 10 1 17 24
-1]
PropertyField26B int64 [ 5 3 20 18 4 23 15 25 11 13 10 21 16 9 1 24 8 12 6 22 7 19 2 17 14
-1]
PropertyField27 int64 [ 6 3 10 4 7 13 19 1 14 15 17 12 11 9 8 18 2]
PropertyField28 object ['B' 'D' 'A' 'C']
PropertyField29 float64 [ 0. nan 1.]
PropertyField30 object ['N' 'Y']
PropertyField31 object ['N' 'O' 'K' 'M']
PropertyField32 object ['Y' 'N' nan]
PropertyField33 object ['G' 'H' 'E' 'F']
PropertyField34 object ['Y' 'N' nan]
PropertyField35 int64 [2 0 1]
PropertyField36 object ['N' 'Y' nan]
PropertyField37 object ['N' 'Y']
PropertyField38 object ['N' 'Y' nan]
PropertyField39A int64 [ 7 11 23 24 18 3 10 25 12 2 15 21 14 13 8 4 5 9 19 17 6 16 1 20 22
-1]
PropertyField39B int64 [ 5 12 24 25 22 13 2 11 14 1 15 18 6 7 3 4 8 17 9 21 20 23 19 10 16
-1]
GeographicField1A int64 [ 3 8 2 7 5 17 10 1 4 6 15 14 9 13 12 22 25 11 18 19 16 20 21 23 24
-1]
GeographicField1B int64 [ 6 17 4 3 2 15 11 24 10 20 16 5 1 9 12 13 7 23 19 18 22 25 8 14 21
-1]
GeographicField2A int64 [15 19 20 10 17 6 18 7 16 12 22 8 4 14 3 23 9 13 11 5 1 21 25 2 24
-1]
GeographicField2B int64 [14 20 22 8 18 4 19 16 11 23 5 21 2 13 17 24 7 6 12 9 3 1 10 25 15
-1]
GeographicField3A int64 [12 18 8 13 15 19 2 9 7 11 17 10 14 16 4 1 25 6 3 20 5 21 23 24 22]
GeographicField3B int64 [13 14 20 9 15 18 21 1 10 6 19 11 16 3 7 25 5 8 2 23 12 17 22 4 24]
GeographicField4A int64 [20 16 21 9 13 18 11 14 15 10 17 19 1 8 12 7 5 25 6 24 23 2 3 4 22]
GeographicField4B int64 [22 18 23 7 13 20 10 15 16 14 9 19 21 1 6 12 5 3 25 4 2 17 8 24 11]
GeographicField5A int64 [-1 25]
GeographicField5B int64 [13 19 21 23 24 25 18 15 22 14 17 16 20 -1]
GeographicField6A int64 [ 2 4 13 9 10 24 1 12 5 23 11 18 21 22 14 25 20 15 16 19 7 17 3 8 6
-1]
GeographicField6B int64 [ 5 13 12 21 18 25 1 22 10 2 20 16 24 19 7 14 9 17 4 15 23 3 8 6 11
-1]
GeographicField7A int64 [ 1 9 10 22 11 12 24 8 2 23 21 7 6 13 25 4 3 5 14 15 20 16 19 18 -1]
GeographicField7B int64 [ 1 13 14 22 16 18 25 9 3 23 10 2 17 21 8 7 19 15 5 4 6 24 20 -1]
GeographicField8A int64 [ 1 5 14 9 10 24 2 13 6 23 12 15 11 18 21 22 19 25 20 17 8 4 16 7 3
-1]
GeographicField8B int64 [ 1 13 21 17 18 25 8 22 11 3 20 16 24 9 2 19 15 10 7 14 23 5 4 6 -1]
GeographicField9A int64 [ 2 5 6 18 12 16 25 23 1 15 7 24 13 14 20 19 22 21 17 4 3 8 11 9 10
-1]
GeographicField9B int64 [ 9 12 14 21 17 19 25 6 24 13 2 16 7 3 10 5 18 15 22 8 20 1 23 4 11
-1]
GeographicField10A int64 [-1]
GeographicField10B int64 [25 -1]
GeographicField11A int64 [ 1 4 15 9 24 2 14 12 11 18 13 23 25 19 10 22 17 7 6 20 5 21 3 8 16
-1]
GeographicField11B int64 [ 1 15 11 22 17 18 25 2 21 10 5 20 13 4 7 16 9 19 23 6 8 12 24 3 -1]
GeographicField12A int64 [ 1 8 9 21 12 13 25 6 10 2 22 23 20 7 4 14 5 24 3 15 19 16 17 18 11
-1]
GeographicField12B int64 [ 1 13 15 22 16 18 25 9 4 23 2 20 10 7 19 8 17 14 6 24 3 5 21 -1]
GeographicField13A int64 [ 1 5 15 9 10 24 2 14 12 16 11 19 23 4 25 22 13 18 8 7 21 17 20 6 -1]
GeographicField13B int64 [ 1 14 12 22 17 18 25 9 21 10 3 20 15 24 8 2 7 23 19 16 6 4 11 5 -1]
GeographicField14A int64 [-1 25]
GeographicField14B int64 [ 7 13 12 15 22 20 25 18 11 16 24 8 19 10 9 21 14 23 17 -1]
GeographicField15A int64 [ 1 9 10 24 23 11 3 2 7 8 25 5 22 12 4 6 13 14 20 15 17 18 16 19 21
-1]
GeographicField15B int64 [ 2 11 16 23 8 13 24 15 22 18 3 20 17 12 7 19 25 5 14 4 6 9 1 -1]
GeographicField16A int64 [ 1 5 6 9 10 24 3 2 8 21 11 4 12 17 15 19 7 13 16 23 22 25 20 14 18
-1]
GeographicField16B int64 [ 2 12 14 18 20 25 9 13 3 17 24 21 10 7 8 19 22 15 23 5 4 6 16 1 11
-1]
GeographicField17A int64 [13 2 3 15 7 6 18 4 12 5 16 9 21 14 8 11 19 17 1 25 10 22 24 23 20
-1]
GeographicField17B int64 [22 16 13 3 6 8 2 18 5 10 23 11 12 20 7 17 9 15 24 4 19 14 21 25 1
-1]
GeographicField18A int64 [-1 25]
GeographicField18B int64 [12 22 17 6 4 7 15 14 24 25 16 13 21 2 10 8 18 20 11 23 5 9 3 19 -1]
GeographicField19A int64 [ 3 23 21 10 17 19 13 9 1 4 11 2 7 25 20 22 14 12 8 24 18 16 15 5 6
-1]
GeographicField19B int64 [ 6 24 21 13 16 18 15 5 11 1 8 23 7 20 4 9 10 25 19 22 12 14 2 3 17
-1]
GeographicField20A int64 [ 4 20 2 5 9 3 21 1 23 19 25 17 7 18 6 22 24 12 15 14 8 16 13 10 11
-1]
GeographicField20B int64 [12 22 21 3 13 14 18 10 8 23 1 6 24 7 15 4 25 20 2 16 11 17 5 19 9
-1]
GeographicField21A int64 [-1 25]
GeographicField21B int64 [10 22 19 8 24 14 13 7 17 11 6 5 15 12 23 4 21 25 18 16 9 20 -1]
GeographicField22A int64 [-1 25]
GeographicField22B int64 [15 22 19 25 24 16 18 21 20 23 17 -1]
GeographicField23A int64 [-1 25]
GeographicField23B int64 [ 5 13 10 24 15 22 9 18 3 6 21 17 23 8 2 19 20 11 7 1 12 16 14 25 4
-1]
GeographicField24A int64 [14 10 18 19 17 16 24 15 21 11 20 22 9 2 5 25 13 23 1 12 7 8 4 -1 3]
GeographicField24B int64 [ 9 4 17 20 16 15 25 14 11 22 5 21 8 23 13 3 2 24 6 18 1 7 10 12 -1]
GeographicField25A int64 [16 10 12 13 17 19 24 14 18 23 5 2 8 25 11 1 20 22 15 9 6 21 4 7 -1]
GeographicField25B int64 [16 5 8 10 17 21 24 13 20 19 4 12 11 2 14 6 3 25 18 7 15 23 22 1 -1]
GeographicField26A int64 [15 5 7 10 21 20 13 24 6 8 3 16 2 4 25 11 19 9 22 18 1 12 14 17 23
-1]
GeographicField26B int64 [18 5 8 10 13 14 23 22 17 4 25 7 11 2 21 1 3 16 20 6 24 12 15 19 -1]
GeographicField27A int64 [17 13 15 16 21 24 19 22 12 14 6 2 11 25 23 10 18 9 20 1 8 5 7 -1 3]
GeographicField27B int64 [16 6 11 14 20 25 24 18 21 5 22 4 9 8 2 10 7 3 23 17 12 1 19 -1]
GeographicField28A int64 [11 7 6 3 9 23 21 12 5 10 14 4 17 8 13 16 2 15 25 1 20 18 24 19 22
-1]
GeographicField28B int64 [18 10 9 3 14 25 19 24 5 16 8 15 21 4 23 13 2 17 22 1 20 6 11 12 7
-1]
GeographicField29A int64 [24 21 8 11 5 13 6 9 4 15 12 7 18 3 1 19 20 2 10 25 16 14 23 22 17
-1]
GeographicField29B int64 [25 24 11 16 4 20 7 13 3 22 18 19 2 10 8 6 9 1 12 17 5 14 15 23 21
-1]
GeographicField30A int64 [ 5 10 7 2 11 8 12 13 25 9 4 19 6 20 3 16 17 18 1 14 15 22 23 21 24
-1]
GeographicField30B int64 [ 4 19 12 1 18 20 14 21 23 15 25 13 3 16 11 5 22 24 8 10 2 17 6 7 9
-1]
GeographicField31A int64 [ 7 13 10 8 15 6 5 1 14 12 16 9 4 17 18 3 2 24 25 11 21 20 22 19 23
-1]
GeographicField31B int64 [10 21 15 11 20 22 7 5 1 16 19 17 23 13 3 24 14 4 8 12 2 6 9 18 25
-1]
GeographicField32A int64 [13 9 11 3 6 19 4 12 5 7 14 1 10 25 8 2 20 22 23 15 17 16 18 24 21
-1]
GeographicField32B int64 [20 15 18 3 8 24 4 21 19 6 12 11 1 17 25 10 13 5 2 14 16 7 22 9 23
-1]
GeographicField33A int64 [14 4 12 11 8 6 10 2 5 23 1 7 13 19 3 21 9 25 15 17 20 16 18 22 24
-1]
GeographicField33B int64 [21 3 19 17 11 8 16 1 6 18 7 25 20 24 9 2 5 12 10 14 13 15 22 23 4
-1]
GeographicField34A int64 [12 13 15 1 16 14 17 9 8 6 10 4 19 3 25 22 11 7 5 18 20 2 23 21 24
-1]
GeographicField34B int64 [14 17 20 1 21 19 22 10 7 5 12 2 11 24 25 23 9 4 3 6 16 8 13 15 18
-1]
GeographicField35A int64 [14 6 10 9 7 12 4 17 11 13 3 18 5 8 1 2 15 21 20 25 22 16 23 19 24
-1]
GeographicField35B int64 [22 9 17 16 11 20 5 8 3 24 19 18 21 2 10 6 7 13 1 23 12 15 4 14 25
-1]
GeographicField36A int64 [ 3 17 9 8 10 15 13 12 4 5 6 21 11 7 16 20 18 14 1 24 2 22 23 25 19
-1]
GeographicField36B int64 [ 2 23 13 11 15 12 22 21 20 18 3 19 14 5 25 9 17 4 10 8 6 24 16 7 1
-1]
GeographicField37A int64 [15 11 4 3 2 7 6 5 1 14 8 10 22 12 -1 13 9 16 25 23 18 21 24 17 20
19]
GeographicField37B int64 [24 21 10 8 6 2 16 15 11 1 23 18 20 25 9 12 22 -1 7 4 5 19 3 13 14
17]
GeographicField38A int64 [ 2 13 14 4 12 9 7 8 15 25 10 5 6 16 11 3 20 23 1 18 19 17 24 22 21
-1]
GeographicField38B int64 [ 2 21 22 3 19 14 9 12 25 17 10 15 5 6 23 8 13 11 18 20 16 4 24 1 7
-1]
GeographicField39A int64 [15 9 17 4 6 8 5 7 2 21 23 11 10 16 13 25 1 3 18 12 20 14 19 22 24
-1]
GeographicField39B int64 [23 17 24 18 6 11 16 9 12 13 2 25 20 19 5 22 15 1 3 7 14 4 21 8 10
-1]
GeographicField40A int64 [ 1 12 10 2 6 21 8 25 3 5 13 7 11 4 9 19 16 14 22 20 18 15 17 23 24
-1]
GeographicField40B int64 [ 1 21 16 15 10 24 13 25 2 5 12 4 22 11 19 8 7 9 14 17 6 20 18 23 3
-1]
GeographicField41A int64 [15 25 24 13 18 23 4 21 16 14 3 19 1 2 9 12 7 11 22 17 10 20 5 8 6
-1]
GeographicField41B int64 [13 25 22 9 17 16 18 20 6 19 14 11 4 10 24 1 23 12 7 3 21 2 8 5 15
-1]
GeographicField42A int64 [ 9 15 12 7 24 17 10 16 11 8 5 14 6 19 18 4 13 22 2 3 1 21 23 25 20
-1]
GeographicField42B int64 [10 21 15 7 25 22 12 13 8 3 19 9 6 18 5 24 23 16 17 14 4 1 2 11 20
-1]
GeographicField43A int64 [ 2 10 12 25 11 4 23 9 22 3 15 5 1 14 7 20 8 21 6 24 18 19 13 16 17
-1]
GeographicField43B int64 [ 2 13 20 25 12 16 4 24 11 9 22 5 15 17 19 1 6 23 14 7 8 10 3 18 21
-1]
GeographicField44A int64 [ 8 23 21 3 24 17 11 12 14 9 19 4 10 15 25 18 20 22 13 7 1 16 5 6 2
-1]
GeographicField44B int64 [ 4 24 22 1 25 19 11 12 5 15 7 20 2 8 18 16 9 21 23 6 3 17 13 14 10
-1]
GeographicField45A int64 [20 11 24 14 9 25 7 3 22 8 23 2 12 10 13 19 5 1 21 6 18 4 15 17 16
-1]
GeographicField45B int64 [22 15 25 11 12 18 7 5 24 8 10 16 3 9 20 14 1 21 6 4 13 2 19 17 23
-1]
GeographicField46A int64 [10 21 20 6 25 14 16 15 13 9 4 19 22 12 18 8 11 17 7 1 2 5 23 3 24
-1]
GeographicField46B int64 [ 8 24 22 2 25 16 17 11 15 7 5 9 1 20 4 14 19 10 3 23 13 21 12 6 18
-1]
GeographicField47A int64 [ 6 7 5 13 8 21 12 25 1 19 10 2 9 22 24 4 11 3 14 15 23 18 20 16 17
-1]
GeographicField47B int64 [ 5 11 13 14 3 6 21 10 16 7 24 19 25 15 12 1 8 9 23 18 17 20 2 4 -1]
GeographicField48A int64 [15 21 23 11 22 6 20 7 12 19 24 9 18 17 1 8 10 16 13 5 14 4 25 2 3
-1]
GeographicField48B int64 [13 21 23 8 22 3 20 4 9 19 24 6 17 18 15 1 5 7 10 12 2 11 25 14 16
-1]
GeographicField49A int64 [19 18 20 21 4 22 14 1 16 25 12 17 15 10 11 6 8 7 13 5 23 24 9 -1 3
2]
GeographicField49B int64 [18 15 19 21 2 23 7 1 11 25 5 13 9 4 20 14 12 22 17 16 10 8 6 3 24
-1]
GeographicField50A int64 [16 20 18 17 4 9 21 2 25 23 3 22 11 15 13 19 8 14 10 1 7 12 6 24 5
-1]
GeographicField50B int64 [14 20 16 15 2 17 4 22 1 25 24 7 12 9 19 21 23 11 18 10 6 5 8 13 3
-1]
GeographicField51A int64 [21 13 18 25 9 4 11 12 14 16 20 22 15 17 1 10 8 2 3 19 6 5 7 24 -1
23]
GeographicField51B int64 [23 12 20 25 7 2 10 15 17 9 24 16 18 1 8 6 5 13 11 21 19 4 22 14 3
-1]
GeographicField52A int64 [21 12 19 13 25 7 20 8 5 10 11 14 17 16 18 15 1 2 9 3 22 6 23 4 -1
24]
GeographicField52B int64 [23 12 21 25 5 22 6 3 8 10 15 19 17 20 16 1 14 11 9 13 18 2 7 24 4
-1]
GeographicField53A int64 [16 15 20 17 1 24 8 21 6 14 25 11 19 22 18 12 13 3 4 23 9 5 7 2 10
-1]
GeographicField53B int64 [11 9 19 13 1 24 3 20 2 8 12 25 5 15 21 18 22 14 10 6 16 7 23 4 17
-1]
GeographicField54A int64 [22 13 11 5 16 7 21 17 24 18 9 19 14 8 3 15 1 20 12 10 23 6 -1 25 4
2]
GeographicField54B int64 [24 11 8 2 17 4 23 18 25 20 6 13 9 5 19 21 14 1 15 22 10 16 12 3 7
-1]
GeographicField55A int64 [ 7 11 3 20 2 16 4 12 10 9 1 5 25 6 8 13 17 19 15 14 22 18 23 -1 24
21]
GeographicField55B int64 [14 20 3 4 24 1 23 6 18 17 21 9 2 25 12 11 15 16 13 19 7 22 10 8 5
-1]
GeographicField56A int64 [-1 25]
GeographicField56B int64 [17 9 5 7 25 20 11 22 3 15 8 16 6 2 18 21 4 12 24 14 13 10 23 19 -1]
GeographicField57A int64 [15 18 21 14 11 8 7 16 12 9 25 10 17 3 22 6 4 20 19 1 13 23 5 2 24
-1]
GeographicField57B int64 [17 21 24 14 9 5 3 22 15 19 11 10 25 7 20 6 1 18 4 2 8 16 23 13 12
-1]
GeographicField58A int64 [14 8 12 10 11 3 19 9 22 5 20 7 15 13 18 23 1 6 17 16 25 2 4 24 21
-1]
GeographicField58B int64 [18 7 15 10 12 2 23 9 24 4 13 6 19 8 16 22 5 11 14 25 1 17 3 21 20
-1]
GeographicField59A int64 [ 9 10 15 6 18 2 16 13 8 25 7 20 19 11 14 4 12 5 3 17 1 21 22 24 23
-1]
GeographicField59B int64 [ 9 10 18 5 22 11 1 20 16 8 25 6 24 23 13 12 17 3 15 14 4 2 21 7 19
-1]
GeographicField60A int64 [-1 25]
GeographicField60B int64 [ 8 11 21 10 23 19 3 9 14 24 17 7 18 16 22 1 2 12 25 20 6 4 5 15 13
-1]
GeographicField61A int64 [-1 25]
GeographicField61B int64 [18 17 11 9 25 13 12 2 22 14 7 8 21 6 20 5 19 4 23 3 16 10 15 24 -1]
GeographicField62A int64 [-1 25]
GeographicField62B int64 [10 20 8 21 12 14 13 18 19 9 17 25 22 24 23 11 16 15 -1]
GeographicField63 object ['N' 'Y' ' ']
GeographicField64 object ['CA' 'NJ' 'TX' 'IL']
In [ ]:
Content source: artiomka/kaggle
Similar notebooks: