sacramento.py Use the sacramento.csv file to complete the following assignment. Create a file, sacramento.py, that loads the .csv file and runs a logistic regression. The regression should predict whether or not a house has 1 or more than one bathroom based on beds, sqft, and price, in that order. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it. You will need to create a new variable from baths, and it should make it such that those observations of 1 bath correspond to a value of 0, and those with more than 1 bath correspond to a 1. Make sure to add a constant using sm.add_constant(X) Your file should print the results in this way: print(mod.params.round(2)) print(mod.pvalues.round(2)) print('The smallest p-value is for sqft')
sacramento.py
Use the sacramento.csv file to complete the following assignment. Create a file, sacramento.py, that loads the .csv file and runs a logistic regression. The regression should predict whether or not a house has 1 or more than one bathroom based on beds, sqft, and price, in that order. Note: you will not need to upload the .csv to CodeGrade because I have pre-loaded it.
You will need to create a new variable from baths, and it should make it such that those observations of 1 bath correspond to a value of 0, and those with more than 1 bath correspond to a 1.
Make sure to add a constant using sm.add_constant(X)
Your file should print the results in this way:
print(mod.params.round(2))
print(mod.pvalues.round(2))
print('The smallest p-value is for sqft')
sacramento.csv
"","city","zip","beds","baths","sqft","type","price","latitude","longitude"
"1","SACRAMENTO","z95838",2,1,836,"Residential",59222,38.631913,-121.434879
"2","SACRAMENTO","z95823",3,1,1167,"Residential",68212,38.478902,-121.431028
"3","SACRAMENTO","z95815",2,1,796,"Residential",68880,38.618305,-121.443839
"4","SACRAMENTO","z95815",2,1,852,"Residential",69307,38.616835,-121.439146
"5","SACRAMENTO","z95824",2,1,797,"Residential",81900,38.51947,-121.435768
"6","SACRAMENTO","z95841",3,1,1122,"Condo",89921,38.662595,-121.327813
"7","SACRAMENTO","z95842",3,2,1104,"Residential",90895,38.681659,-121.351705
"8","SACRAMENTO","z95820",3,1,1177,"Residential",91002,38.535092,-121.481367
"9","RANCHO_CORDOVA","z95670",2,2,941,"Condo",94905,38.621188,-121.270555
"10","RIO_LINDA","z95673",3,2,1146,"Residential",98937,38.700909,-121.442979
"11","SACRAMENTO","z95838",3,2,909,"Residential",100309,38.637663,-121.45152
"12","SACRAMENTO","z95823",3,2,1289,"Residential",106250,38.470746,-121.458918
"13","SACRAMENTO","z95815",1,1,871,"Residential",106852,38.618698,-121.435833
"14","SACRAMENTO","z95822",3,1,1020,"Residential",107502,38.482215,-121.492603
"15","SACRAMENTO","z95842",2,2,1022,"Residential",108750,38.672914,-121.35934
"16","SACRAMENTO","z95842",2,2,1134,"Condo",110700,38.700051,-121.351278
"17","RIO_LINDA","z95673",2,1,844,"Residential",113263,38.689591,-121.452239
"18","CITRUS_HEIGHTS","z95621",2,1,795,"Condo",116250,38.679776,-121.314089
"19","SACRAMENTO","z95833",2,1,588,"Residential",120000,38.612099,-121.469095
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
