Skip to content

Instantly share code, notes, and snippets.

@lemair lemair/dataframe.java Secret
Created Nov 8, 2019

Embed
What would you like to do?
Schema():
idx name type meta data
0 "Id" Integer IntegerMetaData(name="Id",)
1 "MSSubClass" Integer IntegerMetaData(name="MSSubClass",)
2 "LotFrontage" Integer IntegerMetaData(name="LotFrontage",)
3 "LotArea" Integer IntegerMetaData(name="LotArea",)
4 "OverallQual" Integer IntegerMetaData(name="OverallQual",)
5 "OverallCond" Integer IntegerMetaData(name="OverallCond",)
6 "YearBuilt" Integer IntegerMetaData(name="YearBuilt",)
7 "YearRemodAdd" Integer IntegerMetaData(name="YearRemodAdd",)
8 "BsmtFinSF1" Integer IntegerMetaData(name="BsmtFinSF1",)
9 "BsmtFinSF2" Integer IntegerMetaData(name="BsmtFinSF2",)
10 "BsmtUnfSF" Integer IntegerMetaData(name="BsmtUnfSF",)
11 "TotalBsmtSF" Integer IntegerMetaData(name="TotalBsmtSF",)
12 "1stFlrSF" Integer IntegerMetaData(name="1stFlrSF",)
13 "2ndFlrSF" Integer IntegerMetaData(name="2ndFlrSF",)
14 "LowQualFinSF" Integer IntegerMetaData(name="LowQualFinSF",)
15 "GrLivArea" Integer IntegerMetaData(name="GrLivArea",)
16 "BsmtFullBath" Integer IntegerMetaData(name="BsmtFullBath",)
17 "BsmtHalfBath" Integer IntegerMetaData(name="BsmtHalfBath",)
18 "FullBath" Integer IntegerMetaData(name="FullBath",)
19 "HalfBath" Integer IntegerMetaData(name="HalfBath",)
20 "BedroomAbvGr" Integer IntegerMetaData(name="BedroomAbvGr",)
21 "KitchenAbvGr" Integer IntegerMetaData(name="KitchenAbvGr",)
22 "TotRmsAbvGrd" Integer IntegerMetaData(name="TotRmsAbvGrd",)
23 "Fireplaces" Integer IntegerMetaData(name="Fireplaces",)
24 "GarageCars" Integer IntegerMetaData(name="GarageCars",)
25 "GarageArea" Integer IntegerMetaData(name="GarageArea",)
26 "WoodDeckSF" Integer IntegerMetaData(name="WoodDeckSF",)
27 "OpenPorchSF" Integer IntegerMetaData(name="OpenPorchSF",)
28 "EnclosedPorch" Integer IntegerMetaData(name="EnclosedPorch",)
29 "3SsnPorch" Integer IntegerMetaData(name="3SsnPorch",)
30 "ScreenPorch" Integer IntegerMetaData(name="ScreenPorch",)
31 "PoolArea" Integer IntegerMetaData(name="PoolArea",)
32 "MiscVal" Integer IntegerMetaData(name="MiscVal",)
33 "MoSold" Integer IntegerMetaData(name="MoSold",)
34 "YrSold" Integer IntegerMetaData(name="YrSold",)
35 "SalePrice" Integer IntegerMetaData(name="SalePrice",)
36 "LotFrontage" Categorical CategoricalMetaData(name="LotFrontage",stateNames=["NA"])
37 "MSZoning" Categorical CategoricalMetaData(name="MSZoning",stateNames=["FV","A","C","RH","I","RL","RM","RP"])
38 "Street" Categorical CategoricalMetaData(name="Street",stateNames=["Grvl","Pave"])
39 "Alley" Categorical CategoricalMetaData(name="Alley",stateNames=["Grvl","NA","Pave"])
40 "LotShape" Categorical CategoricalMetaData(name="LotShape",stateNames=[" IR3"," Reg"," IR2","IR1"])
41 "LandContour" Categorical CategoricalMetaData(name="LandContour",stateNames=[" Bnk","Lvl"," Low"," HLS"])
42 "Utilities" Categorical CategoricalMetaData(name="Utilities",stateNames=[" AllPub"," ELO"," NoSeWa"," NoSewr"])
43 "LandSlope" Categorical CategoricalMetaData(name="LandSlope",stateNames=[" Gtl","Mod","Sev"])
44 "Exterior1st" Integer IntegerMetaData(name="Exterior1st",minAllowed=0,maxAllowed=16)
45 "Exterior2nd" Integer IntegerMetaData(name="Exterior2nd",minAllowed=0,maxAllowed=16)
46 "BsmtExposure" Integer IntegerMetaData(name="BsmtExposure",minAllowed=0,maxAllowed=4)
47 "BsmtFinType1" Integer IntegerMetaData(name="BsmtFinType1",minAllowed=0,maxAllowed=6)
48 "BsmtFinType2" Integer IntegerMetaData(name="BsmtFinType2",minAllowed=0,maxAllowed=6)
49 "Heating" Categorical CategoricalMetaData(name="Heating",stateNames=["Floor","Grav","OthW","Wall","GasA","GasW"])
50 "KitchenQual" Integer IntegerMetaData(name="KitchenQual",minAllowed=0,maxAllowed=4)
51 "Functional" Integer IntegerMetaData(name="Functional",minAllowed=0,maxAllowed=7)
52 "GarageCond" Integer IntegerMetaData(name="GarageCond",minAllowed=0,maxAllowed=5)
53 "PavedDrive" Integer IntegerMetaData(name="PavedDrive",minAllowed=0,maxAllowed=2)
54 "PoolQC" Integer IntegerMetaData(name="PoolQC",minAllowed=0,maxAllowed=4)
55 "Fence" Integer IntegerMetaData(name="Fence",minAllowed=0,maxAllowed=4)
56 "SaleCondition" Integer IntegerMetaData(name="SaleCondition",minAllowed=0,maxAllowed=5)
57 "LotConfig" Integer IntegerMetaData(name="LotConfig",minAllowed=0,maxAllowed=4)
58 "LandSlope" Integer IntegerMetaData(name="LandSlope",minAllowed=0,maxAllowed=2)
59 "Neighborhood" Integer IntegerMetaData(name="Neighborhood",minAllowed=0,maxAllowed=24)
60 "Condition1" Integer IntegerMetaData(name="Condition1",minAllowed=0,maxAllowed=8)
61 "Condition2" Integer IntegerMetaData(name="Condition2",minAllowed=0,maxAllowed=8)
62 "BldgType" Integer IntegerMetaData(name="BldgType",minAllowed=0,maxAllowed=4)
63 "HouseStyle" Integer IntegerMetaData(name="HouseStyle",minAllowed=0,maxAllowed=6)
64 "RoofStyle" Integer IntegerMetaData(name="RoofStyle",minAllowed=0,maxAllowed=5)
65 "MasVnrType" Integer IntegerMetaData(name="MasVnrType",minAllowed=0,maxAllowed=4)
66 "ExterQual" Integer IntegerMetaData(name="ExterQual",minAllowed=0,maxAllowed=5)
67 "ExterCond" Integer IntegerMetaData(name="ExterCond",minAllowed=0,maxAllowed=5)
68 "Foundation" Integer IntegerMetaData(name="Foundation",minAllowed=0,maxAllowed=6)
69 "BsmtQual" Integer IntegerMetaData(name="BsmtQual",minAllowed=0,maxAllowed=5)
70 "BsmtCond" Categorical CategoricalMetaData(name="BsmtCond",stateNames=["Ex","NA","Fa","Gd","TA","Po"])
71 "Heating" Integer IntegerMetaData(name="Heating",minAllowed=0,maxAllowed=4)
72 "HeatingQC" Integer IntegerMetaData(name="HeatingQC",minAllowed=0,maxAllowed=4)
73 "CentralAir" Integer IntegerMetaData(name="CentralAir",minAllowed=0,maxAllowed=1)
74 "FireplaceQu" Integer IntegerMetaData(name="FireplaceQu",minAllowed=0,maxAllowed=5)
75 "GarageType" Integer IntegerMetaData(name="GarageType",minAllowed=0,maxAllowed=6)
76 "GarageFinish" Integer IntegerMetaData(name="GarageFinish",minAllowed=0,maxAllowed=3)
77 "GarageQual" Integer IntegerMetaData(name="GarageQual",minAllowed=0,maxAllowed=5)
78 "MiscFeature" Integer IntegerMetaData(name="MiscFeature",minAllowed=0,maxAllowed=5)
79 "SaleType" Integer IntegerMetaData(name="SaleType",minAllowed=0,maxAllowed=8)
IdMSSubClassLotFrontageLotAreaOverallQualOverallCondYearBuiltYearRemodAddBsmtFinSF1BsmtFinSF2BsmtUnfSFTotalBsmtSF1stFlrSF2ndFlrSFLowQualFinSFGrLivAreaBsmtFullBathBsmtHalfBathFullBathHalfBathBedroomAbvGrKitchenAbvGrTotRmsAbvGrdFireplacesGarageCarsGarageAreaWoodDeckSFOpenPorchSFEnclosedPorch3SsnPorchScreenPorchPoolAreaMiscValMoSoldYrSoldSalePriceLotFrontageMSZoningStreetAlleyLotShapeLandContourUtilitiesLandSlopeExterior1stExterior2ndBsmtExposureBsmtFinType1BsmtFinType2HeatingKitchenQualFunctionalGarageCondPavedDrivePoolQCFenceSaleConditionLotConfigLandSlopeNeighborhoodCondition1Condition2BldgTypeHouseStyleRoofStyleMasVnrTypeExterQualExterCondFoundationBsmtQualBsmtCondHeatingHeatingQCCentralAirFireplaceQuGarageTypeGarageFinishGarageQualMiscFeatureSaleType
160RL658450PaveNARegLvlAllPubInsideGtlCollgCrNormNorm1Fam2Story7520032003GableCompShgVinylSdVinylSdBrkFace196GdTAPConcGdTANoGLQ706Unf0150856GasAExYSBrkr85685401710102131Gd8Typ0NAAttchd2003RFn2548TATAY0610000NANANA022008WDNormal208500
220RL809600PaveNARegLvlAllPubFR2GtlVeenkerFeedrNorm1Fam1Story6819761976GableCompShgMetalSdMetalSdNone0TATACBlockGdTAGdALQ978Unf02841262GasAExYSBrkr1262001262012031TA6Typ1TAAttchd1976RFn2460TATAY29800000NANANA052007WDNormal181500
360RL6811250PaveNAIR1LvlAllPubInsideGtlCollgCrNormNorm1Fam2Story7520012002GableCompShgVinylSdVinylSdBrkFace162GdTAPConcGdTAMnGLQ486Unf0434920GasAExYSBrkr92086601786102131Gd6Typ1TAAttchd2001RFn2608TATAY0420000NANANA092008WDNormal223500
470RL609550PaveNAIR1LvlAllPubCornerGtlCrawforNormNorm1Fam2Story7519151970GableCompShgWd SdngWd ShngNone0TATABrkTilTAGdNoALQ216Unf0540756GasAGdYSBrkr96175601717101031Gd7Typ1GdDetchd1998Unf3642TATAY035272000NANANA022006WDAbnorml140000
560RL8414260PaveNAIR1LvlAllPubFR2GtlNoRidgeNormNorm1Fam2Story8520002000GableCompShgVinylSdVinylSdBrkFace350GdTAPConcGdTAAvGLQ655Unf04901145GasAExYSBrkr1145105302198102141Gd9Typ1TAAttchd2000RFn3836TATAY192840000NANANA0122008WDNormal250000
650RL8514115PaveNAIR1LvlAllPubInsideGtlMitchelNormNorm1Fam1.5Fin5519931995GableCompShgVinylSdVinylSdNone0TATAWoodGdTANoGLQ732Unf064796GasAExYSBrkr79656601362101111TA5Typ0NAAttchd1993Unf2480TATAY4030032000NAMnPrvShed700102009WDNormal143000
720RL7510084PaveNARegLvlAllPubInsideGtlSomerstNormNorm1Fam1Story8520042005GableCompShgVinylSdVinylSdStone186GdTAPConcExTAAvGLQ1369Unf03171686GasAExYSBrkr1694001694102031Gd7Typ1GdAttchd2004RFn2636TATAY255570000NANANA082007WDNormal307000
860RLNA10382PaveNAIR1LvlAllPubCornerGtlNWAmesPosNNorm1Fam2Story7619731973GableCompShgHdBoardHdBoardStone240TATACBlockGdTAMnALQ859BLQ322161107GasAExYSBrkr110798302090102131TA7Typ2TAAttchd1973RFn2484TATAY235204228000NANAShed350112009WDNormal200000
950RM516120PaveNARegLvlAllPubInsideGtlOldTownArteryNorm1Fam1.5Fin7519311950GableCompShgBrkFaceWd ShngNone0TATABrkTilTATANoUnf0Unf0952952GasAGdYFuseF102275201774002022TA8Min12TADetchd1931Unf2468FaTAY900205000NANANA042008WDAbnorml129900
10190RL507420PaveNARegLvlAllPubCornerGtlBrkSideArteryArtery2fmCon1.5Unf5619391950GableCompShgMetalSdMetalSdNone0TATABrkTilTATANoGLQ851Unf0140991GasAExYSBrkr1077001077101022TA5Typ2TAAttchd1939RFn1205GdTAY040000NANANA012008WDNormal118000
14:53:31,594 WARN ~ Filtered out 1460 values
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.rt.execution.CommandLineWrapper.main(CommandLineWrapper.java:66)
Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.rangeCheck(ArrayList.java:657)
at java.util.ArrayList.get(ArrayList.java:433)
at org.datavec.local.transforms.LocalTransformExecutor.execute(LocalTransformExecutor.java:312)
at org.datavec.local.transforms.LocalTransformExecutor.execute(LocalTransformExecutor.java:93)
at dataframe.main(dataframe.java:139)
... 5 more
Process finished with exit code 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.