In [2]:
import pandas as pd
import re
import numpy as np
import matplotlib.pyplot as plt
In [3]:
plt.style.use('ggplot')
%matplotlib inline
In [4]:
pd.set_option('display.max_columns',30)
pd.set_option('display.max_colwidth',100)
pd.set_option('display.precision',3)
In [5]:
CSV_PATH=r'./data/mahattan_proverty.csv'
In [6]:
df=pd.read_csv(CSV_PATH)
In [7]:
df
Out[7]:
url
type_of_property
propertyinfo_value
address
no_of_photoes
photo_link
New column (6)_alt
0
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,400/mo6 bds · 3 ba · -- sqft
1649 Fairchild Ave APT 1, Manhattan, KS
17 photos
https://photos.zillowstatic.com/p_e/ISmqymksq29w2h1000000000.jpg
NaN
1
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,100/mo6 bds · 2 ba · -- sqft
106 S Manhattan Ave # 1, Manhattan, KS
NaN
https://photos.zillowstatic.com/p_e/ISeovksdrez8ci0000000000.jpg
NaN
2
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
For Rent
3$1,600+
2709 Tobacco Rd, Manhattan, KS
NaN
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.210850,-96.650923/17?mapSize=596,446&...
NaN
3
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,575/mo4 bds · 2 ba · -- sqft
1520 Harry Rd # 1, Manhattan, KS
10 photos
https://photos.zillowstatic.com/p_e/ISmysbylskm4gj0000000000.jpg
NaN
4
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,756/mo4 bds · 2 ba · 1,200 sqft
2215 College Ave # 4X2, Manhattan, KS
3 photos
https://photos.zillowstatic.com/p_e/ISybz2us519esf1000000000.jpg
NaN
5
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
For Rent
5$1,795+
1218 Yuma St, Manhattan, KS
1 photo
https://photos.zillowstatic.com/p_e/ISekowtvq2b8g21000000000.jpg
NaN
6
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,775/mo4 bds · 2 ba · -- sqft
930 Laramie St APT 2E, Manhattan, KS
5 photos
https://photos.zillowstatic.com/p_e/ISynwoyw6us6oq0000000000.jpg
NaN
7
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
For Rent
4$1,700+
914 Vattier St, Manhattan, KS
21 photos
https://photos.zillowstatic.com/p_e/ISxn8ab6faypos0000000000.jpg
NaN
8
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,750/mo4 bds · 2 ba · -- sqft
1010 Ratone St # 1, Manhattan, KS
23 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
9
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,625/mo4 bds · 2 ba · -- sqft
614 Thurston St # 614, Manhattan, KS
11 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
10
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,100/mo4 bds · 3.5 ba · 2,668 sqft
715 Leavenworth St, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
11
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,370/mo6 bds · 2 ba · 2,656 sqft
1836 Todd Rd, Manhattan, KS
12 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
12
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,660/mo4 bds · 2 ba · 1,332 sqft
Laramie St, Manhattan, KS
2 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
13
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,700/mo4 bds · 2 ba · 3,240 sqft
913 Ratone St, Manhattan, KS
25 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
14
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,600/mo5 bds · 2 ba · -- sqft
715 Moro St, Manhattan, KS
7 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
15
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,075/mo5 bds · 2 ba · -- sqft
540 Westview Dr # 1, Manhattan, KS
22 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
16
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,600/mo4 bds · 2 ba · -- sqft
820 Moro, 03
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
17
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,900/mo4 bds · 2 ba · 1,909 sqft
831 Bluemont Ave # 1, Manhattan, KS
33 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
18
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,760/mo4 bds · 2 ba · 1,858 sqft
1420 Humboldt St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
19
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,500/mo4 bds · 2 ba · -- sqft
427 Leavenworth St, Manhattan, KS
3 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
20
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,800/mo5 bds · 2 ba · 2,064 sqft
1637 Fairview Ave # 1637, Manhattan, KS
29 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
21
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,975/mo5 bds · 2 ba · 1,936 sqft
812 Laramie St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
22
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,250/mo6 bds · 3 ba · 2,507 sqft
805 Bertrand St 01 # 02, Manhattan, KS
26 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
23
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,520/mo4 bds · 2 ba · 1,344 sqft
1001 Vattier St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
24
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,050/mo5 bds · 2 ba · 1,641 sqft
326 N 16th St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
25
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,640/mo4 bds · 1.5 ba · 1,792 sqft
801 Osage St # 801, Manhattan, KS
27 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
26
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
House For Rent
$1,000/mo3 bds · 1 ba · 1,092 sqft
204 Dix Dr, Manhattan, KS
12 photos
https://photos.zillowstatic.com/p_e/ISe019oynxo69o1000000000.jpg
NaN
27
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Pebblebrook Apartments & Townhomes
2$866+3$1,129+
625 Pebblebrook Cir, Manhattan, KS
NaN
https://photos.zillowstatic.com/p_e/ISp9w80mthwkuj1000000000.jpg
NaN
28
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$711/mo2 bds · 1 ba · -- sqft
3023 Sandstone Dr, Manhattan, KS
7 photos
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
NaN
29
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
House For Rent
$1,500/mo5 bds · 2 ba · 2,000 sqft
2028 Green Ave, Manhattan, KS
5 photos
https://photos.zillowstatic.com/p_e/ISq16bya4m4t611000000000.jpg
NaN
...
...
...
...
...
...
...
...
440
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Townhouse For Rent
$880/mo2 bds · 1 ba · -- sqft
818 Bluemont Ave APT B, Manhattan, KS
27 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
441
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
For Rent
3$1,050+
822 Fremont St, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
442
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Townhouse For Rent
$975/mo3 bds · 2 ba · 1,204 sqft
2437 Walden Ln, Manhattan, KS
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
443
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
For Rent
0$4951$600+2$700
510 N 8th Street # Main Floor, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
444
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
House For Rent
$1,000/mo3 bds · 1 ba · 1,092 sqft
204 Dix Dr, Manhattan, KS
12 photos
https://photos.zillowstatic.com/p_e/ISe019oynxo69o1000000000.jpg
NaN
445
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Pebblebrook Apartments & Townhomes
2$866+3$1,129+
625 Pebblebrook Cir, Manhattan, KS
NaN
https://photos.zillowstatic.com/p_e/ISxfykisxp4iuj1000000000.jpg
NaN
446
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$711/mo2 bds · 1 ba · -- sqft
3023 Sandstone Dr, Manhattan, KS
7 photos
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
NaN
447
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
House For Rent
$1,500/mo5 bds · 2 ba · 2,000 sqft
2028 Green Ave, Manhattan, KS
5 photos
https://photos.zillowstatic.com/p_e/ISq16bya4m4t611000000000.jpg
NaN
448
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,200/mo4 bds · 2 ba · 1,100 sqft
1401 Mccain Ln, Manhattan, KS
6 photos
https://photos.zillowstatic.com/p_e/ISyjtzxn47oxf51000000000.jpg
NaN
449
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Highland Ridge Apartments
2$860+3$960+
509 Stone Dr, Manhattan, KS
13 photos
https://photos.zillowstatic.com/p_e/IS2rdjxgzw7plf0000000000.jpg
NaN
450
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
For Rent
1$7502$980+
901 Kearney St, Manhattan, KS
NaN
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.188586,-96.570182/17?mapSize=596,446&...
NaN
451
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$650/moStudio · 1 ba · -- sqft
1222 Bertrand St APT B, Manhattan, KS
NaN
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.191000,-96.576000/17?mapSize=596,446&...
NaN
452
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
House For Rent
$1,625/mo5 bds · 2 ba · 2,024 sqft
1121 N Juliette Ave, Manhattan, KS
7 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
453
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
House For Rent
$1,200/mo4 bds · 2 ba · 1,380 sqft
2426 Lookout Dr, Manhattan, KS
NaN
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
454
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Founders Hill
1$750+2$980+3$1,230+4$1,480+
1401 College Ave, Manhattan, KS
48 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
455
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Chase Manhattan Apartments
1$670+2$770+3$975+4$1,250+
1409 Chase Pl, Manhattan, KS
34 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
456
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Stone Pointe Apartments
2$866+
525 Stone Pointe Dr, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
457
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$825/mo2 bds · 1 ba · 900 sqft
1114 Fremont St, Manhattan, KS
1 photo
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
458
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Campus East Apartments
0$525+1$610+2$735+3$1,085+
1422 Mccain Ln, Manhattan, KS
18 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
459
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Laramie Landing
2$1,100+
1001 Laramie St, Manhattan, KS
1 photo
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
460
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$731/mo2 bds · 1 ba · -- sqft
3314 Kennsington Ct, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
461
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$600/mo1 bd · 1 ba · 500 sqft
731 N 6th St APT 2, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
462
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$910/mo2 bds · 1 ba · 793 sqft
1435 Anderson Ave, Manhattan, KS
16 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
463
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$675/mo2 bds · 1 ba · 950 sqft
725 Griffith Dr APT 4, Manhattan, KS
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
464
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,050/mo3 bds · 2 ba · -- sqft
2055 Tecumseh Rd, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
465
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,460/mo4 bds · 2 ba · -- sqft
1000 Thurston St, Manhattan, KS
9 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
466
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Townhouse For Rent
$880/mo2 bds · 1 ba · -- sqft
818 Bluemont Ave APT B, Manhattan, KS
27 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
467
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
For Rent
3$1,050+
822 Fremont St, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
468
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Townhouse For Rent
$975/mo3 bds · 2 ba · 1,204 sqft
2437 Walden Ln, Manhattan, KS
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
469
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
For Rent
0$4951$600+2$700
510 N 8th Street # Main Floor, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
NaN
470 rows × 7 columns
In [8]:
df.columns
Out[8]:
Index(['url', 'type_of_property', 'propertyinfo_value', 'address',
'no_of_photoes', 'photo_link', 'New column (6)_alt'],
dtype='object')
In [9]:
type(df.columns)
Out[9]:
pandas.indexes.base.Index
In [10]:
df.columns.get_values()
Out[10]:
array(['url', 'type_of_property', 'propertyinfo_value', 'address',
'no_of_photoes', 'photo_link', 'New column (6)_alt'], dtype=object)
假如没有df.fillna('n/a',inplace=True)这句，会报错。因为在type_of_property这个column中，有空值，即N/A
In [11]:
df.fillna('n/a',inplace=True)
su=df[df['type_of_property'].str.contains('Apartment')]
mu=df[df['type_of_property'].str.contains('Apartments')]
In [12]:
print(len(mu))
print(len(su))
85
280
In [13]:
su['propertyinfo_value']
Out[13]:
0 $2,400/mo6 bds · 3 ba · -- sqft
1 $2,100/mo6 bds · 2 ba · -- sqft
3 $1,575/mo4 bds · 2 ba · -- sqft
4 $1,756/mo4 bds · 2 ba · 1,200 sqft
6 $1,775/mo4 bds · 2 ba · -- sqft
8 $1,750/mo4 bds · 2 ba · -- sqft
9 $1,625/mo4 bds · 2 ba · -- sqft
10 $2,100/mo4 bds · 3.5 ba · 2,668 sqft
11 $2,370/mo6 bds · 2 ba · 2,656 sqft
12 $1,660/mo4 bds · 2 ba · 1,332 sqft
13 $1,700/mo4 bds · 2 ba · 3,240 sqft
14 $1,600/mo5 bds · 2 ba · -- sqft
15 $2,075/mo5 bds · 2 ba · -- sqft
16 $1,600/mo4 bds · 2 ba · -- sqft
17 $1,900/mo4 bds · 2 ba · 1,909 sqft
18 $1,760/mo4 bds · 2 ba · 1,858 sqft
19 $1,500/mo4 bds · 2 ba · -- sqft
20 $1,800/mo5 bds · 2 ba · 2,064 sqft
21 $1,975/mo5 bds · 2 ba · 1,936 sqft
22 $2,250/mo6 bds · 3 ba · 2,507 sqft
23 $1,520/mo4 bds · 2 ba · 1,344 sqft
24 $2,050/mo5 bds · 2 ba · 1,641 sqft
25 $1,640/mo4 bds · 1.5 ba · 1,792 sqft
27 2$866+3$1,129+
28 $711/mo2 bds · 1 ba · -- sqft
30 $1,200/mo4 bds · 2 ba · 1,100 sqft
31 2$860+3$960+
32 $650/moStudio · 1 ba · -- sqft
37 1$670+2$770+3$975+4$1,250+
38 2$866+
...
419 2$866+3$1,129+
420 $711/mo2 bds · 1 ba · -- sqft
422 $1,200/mo4 bds · 2 ba · 1,100 sqft
423 2$860+3$960+
425 $650/moStudio · 1 ba · -- sqft
429 1$670+2$770+3$975+4$1,250+
430 2$866+
431 $825/mo2 bds · 1 ba · 900 sqft
432 0$525+1$610+2$735+3$1,085+
434 $731/mo2 bds · 1 ba · -- sqft
435 $600/mo1 bd · 1 ba · 500 sqft
436 $910/mo2 bds · 1 ba · 793 sqft
437 $675/mo2 bds · 1 ba · 950 sqft
438 $1,050/mo3 bds · 2 ba · -- sqft
439 $1,460/mo4 bds · 2 ba · -- sqft
445 2$866+3$1,129+
446 $711/mo2 bds · 1 ba · -- sqft
448 $1,200/mo4 bds · 2 ba · 1,100 sqft
449 2$860+3$960+
451 $650/moStudio · 1 ba · -- sqft
455 1$670+2$770+3$975+4$1,250+
456 2$866+
457 $825/mo2 bds · 1 ba · 900 sqft
458 0$525+1$610+2$735+3$1,085+
460 $731/mo2 bds · 1 ba · -- sqft
461 $600/mo1 bd · 1 ba · 500 sqft
462 $910/mo2 bds · 1 ba · 793 sqft
463 $675/mo2 bds · 1 ba · 950 sqft
464 $1,050/mo3 bds · 2 ba · -- sqft
465 $1,460/mo4 bds · 2 ba · -- sqft
Name: propertyinfo_value, dtype: object
In [14]:
len(su[~(su['propertyinfo_value'].str.contains('bd') | su['propertyinfo_value'].str.contains('Studio'))])
Out[14]:
85
带卧室但没厕所
In [15]:
len(su[su['propertyinfo_value'].str.contains('bd') & ~su['propertyinfo_value'].str.contains('ba')])
Out[15]:
0
In [16]:
no_baths=su[~su['propertyinfo_value'].str.contains('ba')]
sucln=su[~su.index.isin(no_baths.index)]
sucln
Out[16]:
url
type_of_property
propertyinfo_value
address
no_of_photoes
photo_link
New column (6)_alt
0
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,400/mo6 bds · 3 ba · -- sqft
1649 Fairchild Ave APT 1, Manhattan, KS
17 photos
https://photos.zillowstatic.com/p_e/ISmqymksq29w2h1000000000.jpg
n/a
1
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,100/mo6 bds · 2 ba · -- sqft
106 S Manhattan Ave # 1, Manhattan, KS
n/a
https://photos.zillowstatic.com/p_e/ISeovksdrez8ci0000000000.jpg
n/a
3
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,575/mo4 bds · 2 ba · -- sqft
1520 Harry Rd # 1, Manhattan, KS
10 photos
https://photos.zillowstatic.com/p_e/ISmysbylskm4gj0000000000.jpg
n/a
4
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,756/mo4 bds · 2 ba · 1,200 sqft
2215 College Ave # 4X2, Manhattan, KS
3 photos
https://photos.zillowstatic.com/p_e/ISybz2us519esf1000000000.jpg
n/a
6
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,775/mo4 bds · 2 ba · -- sqft
930 Laramie St APT 2E, Manhattan, KS
5 photos
https://photos.zillowstatic.com/p_e/ISynwoyw6us6oq0000000000.jpg
n/a
8
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,750/mo4 bds · 2 ba · -- sqft
1010 Ratone St # 1, Manhattan, KS
23 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
9
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,625/mo4 bds · 2 ba · -- sqft
614 Thurston St # 614, Manhattan, KS
11 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
10
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,100/mo4 bds · 3.5 ba · 2,668 sqft
715 Leavenworth St, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
11
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,370/mo6 bds · 2 ba · 2,656 sqft
1836 Todd Rd, Manhattan, KS
12 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
12
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,660/mo4 bds · 2 ba · 1,332 sqft
Laramie St, Manhattan, KS
2 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
13
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,700/mo4 bds · 2 ba · 3,240 sqft
913 Ratone St, Manhattan, KS
25 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
14
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,600/mo5 bds · 2 ba · -- sqft
715 Moro St, Manhattan, KS
7 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
15
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,075/mo5 bds · 2 ba · -- sqft
540 Westview Dr # 1, Manhattan, KS
22 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
16
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,600/mo4 bds · 2 ba · -- sqft
820 Moro, 03
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
17
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,900/mo4 bds · 2 ba · 1,909 sqft
831 Bluemont Ave # 1, Manhattan, KS
33 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
18
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,760/mo4 bds · 2 ba · 1,858 sqft
1420 Humboldt St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
19
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,500/mo4 bds · 2 ba · -- sqft
427 Leavenworth St, Manhattan, KS
3 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
20
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,800/mo5 bds · 2 ba · 2,064 sqft
1637 Fairview Ave # 1637, Manhattan, KS
29 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
21
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,975/mo5 bds · 2 ba · 1,936 sqft
812 Laramie St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
22
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,250/mo6 bds · 3 ba · 2,507 sqft
805 Bertrand St 01 # 02, Manhattan, KS
26 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
23
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,520/mo4 bds · 2 ba · 1,344 sqft
1001 Vattier St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
24
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$2,050/mo5 bds · 2 ba · 1,641 sqft
326 N 16th St, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
25
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
Apartment For Rent
$1,640/mo4 bds · 1.5 ba · 1,792 sqft
801 Osage St # 801, Manhattan, KS
27 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
28
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$711/mo2 bds · 1 ba · -- sqft
3023 Sandstone Dr, Manhattan, KS
7 photos
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
n/a
30
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,200/mo4 bds · 2 ba · 1,100 sqft
1401 Mccain Ln, Manhattan, KS
6 photos
https://photos.zillowstatic.com/p_e/ISyjtzxn47oxf51000000000.jpg
n/a
32
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$650/moStudio · 1 ba · -- sqft
1222 Bertrand St APT B, Manhattan, KS
n/a
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.191000,-96.576000/17?mapSize=596,446&...
n/a
39
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$825/mo2 bds · 1 ba · 900 sqft
1114 Fremont St, Manhattan, KS
1 photo
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
42
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$731/mo2 bds · 1 ba · -- sqft
3314 Kennsington Ct, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
43
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$600/mo1 bd · 1 ba · 500 sqft
731 N 6th St APT 2, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
44
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$910/mo2 bds · 1 ba · 793 sqft
1435 Anderson Ave, Manhattan, KS
16 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
...
...
...
...
...
...
...
...
394
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$711/mo2 bds · 1 ba · -- sqft
3023 Sandstone Dr, Manhattan, KS
7 photos
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
n/a
396
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,200/mo4 bds · 2 ba · 1,100 sqft
1401 Mccain Ln, Manhattan, KS
6 photos
https://photos.zillowstatic.com/p_e/ISyjtzxn47oxf51000000000.jpg
n/a
399
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$650/moStudio · 1 ba · -- sqft
1222 Bertrand St APT B, Manhattan, KS
n/a
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.191000,-96.576000/17?mapSize=596,446&...
n/a
405
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$825/mo2 bds · 1 ba · 900 sqft
1114 Fremont St, Manhattan, KS
1 photo
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
408
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$731/mo2 bds · 1 ba · -- sqft
3314 Kennsington Ct, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
409
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$600/mo1 bd · 1 ba · 500 sqft
731 N 6th St APT 2, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
410
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$910/mo2 bds · 1 ba · 793 sqft
1435 Anderson Ave, Manhattan, KS
16 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
411
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$675/mo2 bds · 1 ba · 950 sqft
725 Griffith Dr APT 4, Manhattan, KS
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
412
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,050/mo3 bds · 2 ba · -- sqft
2055 Tecumseh Rd, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
413
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,460/mo4 bds · 2 ba · -- sqft
1000 Thurston St, Manhattan, KS
9 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
420
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$711/mo2 bds · 1 ba · -- sqft
3023 Sandstone Dr, Manhattan, KS
7 photos
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
n/a
422
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,200/mo4 bds · 2 ba · 1,100 sqft
1401 Mccain Ln, Manhattan, KS
6 photos
https://photos.zillowstatic.com/p_e/ISyjtzxn47oxf51000000000.jpg
n/a
425
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$650/moStudio · 1 ba · -- sqft
1222 Bertrand St APT B, Manhattan, KS
n/a
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.191000,-96.576000/17?mapSize=596,446&...
n/a
431
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$825/mo2 bds · 1 ba · 900 sqft
1114 Fremont St, Manhattan, KS
1 photo
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
434
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$731/mo2 bds · 1 ba · -- sqft
3314 Kennsington Ct, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
435
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$600/mo1 bd · 1 ba · 500 sqft
731 N 6th St APT 2, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
436
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$910/mo2 bds · 1 ba · 793 sqft
1435 Anderson Ave, Manhattan, KS
16 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
437
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$675/mo2 bds · 1 ba · 950 sqft
725 Griffith Dr APT 4, Manhattan, KS
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
438
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,050/mo3 bds · 2 ba · -- sqft
2055 Tecumseh Rd, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
439
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,460/mo4 bds · 2 ba · -- sqft
1000 Thurston St, Manhattan, KS
9 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
446
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$711/mo2 bds · 1 ba · -- sqft
3023 Sandstone Dr, Manhattan, KS
7 photos
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
n/a
448
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,200/mo4 bds · 2 ba · 1,100 sqft
1401 Mccain Ln, Manhattan, KS
6 photos
https://photos.zillowstatic.com/p_e/ISyjtzxn47oxf51000000000.jpg
n/a
451
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$650/moStudio · 1 ba · -- sqft
1222 Bertrand St APT B, Manhattan, KS
n/a
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.191000,-96.576000/17?mapSize=596,446&...
n/a
457
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$825/mo2 bds · 1 ba · 900 sqft
1114 Fremont St, Manhattan, KS
1 photo
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
460
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$731/mo2 bds · 1 ba · -- sqft
3314 Kennsington Ct, Manhattan, KS
6 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
461
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$600/mo1 bd · 1 ba · 500 sqft
731 N 6th St APT 2, Manhattan, KS
8 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
462
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$910/mo2 bds · 1 ba · 793 sqft
1435 Anderson Ave, Manhattan, KS
16 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
463
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$675/mo2 bds · 1 ba · 950 sqft
725 Griffith Dr APT 4, Manhattan, KS
5 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
464
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,050/mo3 bds · 2 ba · -- sqft
2055 Tecumseh Rd, Manhattan, KS
13 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
465
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
Apartment For Rent
$1,460/mo4 bds · 2 ba · -- sqft
1000 Thurston St, Manhattan, KS
9 photos
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
n/a
195 rows × 7 columns
这里通过自定义函数来分类处理数据，从sucln['xxx']出来的是Series，parse_info中读入的row参数，是来自Series的一行文字 这里才是数据处理的精华
In [17]:
def parse_info(row):
print(row)
br,ba,sqft=row.split('·')[:3]
#_,br=br.split('mo')[:2]
rent,br=br.split('mo')[:2]
return pd.Series({'Beds':br,'Baths':ba,'Sqft':sqft,'Rent':rent+'mo'})
In [18]:
attr=sucln['propertyinfo_value'].apply(parse_info)
attr
$2,400/mo6 bds · 3 ba · -- sqft
$2,100/mo6 bds · 2 ba · -- sqft
$1,575/mo4 bds · 2 ba · -- sqft
$1,756/mo4 bds · 2 ba · 1,200 sqft
$1,775/mo4 bds · 2 ba · -- sqft
$1,750/mo4 bds · 2 ba · -- sqft
$1,625/mo4 bds · 2 ba · -- sqft
$2,100/mo4 bds · 3.5 ba · 2,668 sqft
$2,370/mo6 bds · 2 ba · 2,656 sqft
$1,660/mo4 bds · 2 ba · 1,332 sqft
$1,700/mo4 bds · 2 ba · 3,240 sqft
$1,600/mo5 bds · 2 ba · -- sqft
$2,075/mo5 bds · 2 ba · -- sqft
$1,600/mo4 bds · 2 ba · -- sqft
$1,900/mo4 bds · 2 ba · 1,909 sqft
$1,760/mo4 bds · 2 ba · 1,858 sqft
$1,500/mo4 bds · 2 ba · -- sqft
$1,800/mo5 bds · 2 ba · 2,064 sqft
$1,975/mo5 bds · 2 ba · 1,936 sqft
$2,250/mo6 bds · 3 ba · 2,507 sqft
$1,520/mo4 bds · 2 ba · 1,344 sqft
$2,050/mo5 bds · 2 ba · 1,641 sqft
$1,640/mo4 bds · 1.5 ba · 1,792 sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$650/mo1 bd · 1 ba · 630 sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$650/mo1 bd · 1 ba · 630 sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
Out[18]:
Baths
Beds
Rent
Sqft
0
3 ba
6 bds
$2,400/mo
-- sqft
1
2 ba
6 bds
$2,100/mo
-- sqft
3
2 ba
4 bds
$1,575/mo
-- sqft
4
2 ba
4 bds
$1,756/mo
1,200 sqft
6
2 ba
4 bds
$1,775/mo
-- sqft
8
2 ba
4 bds
$1,750/mo
-- sqft
9
2 ba
4 bds
$1,625/mo
-- sqft
10
3.5 ba
4 bds
$2,100/mo
2,668 sqft
11
2 ba
6 bds
$2,370/mo
2,656 sqft
12
2 ba
4 bds
$1,660/mo
1,332 sqft
13
2 ba
4 bds
$1,700/mo
3,240 sqft
14
2 ba
5 bds
$1,600/mo
-- sqft
15
2 ba
5 bds
$2,075/mo
-- sqft
16
2 ba
4 bds
$1,600/mo
-- sqft
17
2 ba
4 bds
$1,900/mo
1,909 sqft
18
2 ba
4 bds
$1,760/mo
1,858 sqft
19
2 ba
4 bds
$1,500/mo
-- sqft
20
2 ba
5 bds
$1,800/mo
2,064 sqft
21
2 ba
5 bds
$1,975/mo
1,936 sqft
22
3 ba
6 bds
$2,250/mo
2,507 sqft
23
2 ba
4 bds
$1,520/mo
1,344 sqft
24
2 ba
5 bds
$2,050/mo
1,641 sqft
25
1.5 ba
4 bds
$1,640/mo
1,792 sqft
28
1 ba
2 bds
$711/mo
-- sqft
30
2 ba
4 bds
$1,200/mo
1,100 sqft
32
1 ba
Studio
$650/mo
-- sqft
39
1 ba
2 bds
$825/mo
900 sqft
42
1 ba
2 bds
$731/mo
-- sqft
43
1 ba
1 bd
$600/mo
500 sqft
44
1 ba
2 bds
$910/mo
793 sqft
...
...
...
...
...
394
1 ba
2 bds
$711/mo
-- sqft
396
2 ba
4 bds
$1,200/mo
1,100 sqft
399
1 ba
Studio
$650/mo
-- sqft
405
1 ba
2 bds
$825/mo
900 sqft
408
1 ba
2 bds
$731/mo
-- sqft
409
1 ba
1 bd
$600/mo
500 sqft
410
1 ba
2 bds
$910/mo
793 sqft
411
1 ba
2 bds
$675/mo
950 sqft
412
2 ba
3 bds
$1,050/mo
-- sqft
413
2 ba
4 bds
$1,460/mo
-- sqft
420
1 ba
2 bds
$711/mo
-- sqft
422
2 ba
4 bds
$1,200/mo
1,100 sqft
425
1 ba
Studio
$650/mo
-- sqft
431
1 ba
2 bds
$825/mo
900 sqft
434
1 ba
2 bds
$731/mo
-- sqft
435
1 ba
1 bd
$600/mo
500 sqft
436
1 ba
2 bds
$910/mo
793 sqft
437
1 ba
2 bds
$675/mo
950 sqft
438
2 ba
3 bds
$1,050/mo
-- sqft
439
2 ba
4 bds
$1,460/mo
-- sqft
446
1 ba
2 bds
$711/mo
-- sqft
448
2 ba
4 bds
$1,200/mo
1,100 sqft
451
1 ba
Studio
$650/mo
-- sqft
457
1 ba
2 bds
$825/mo
900 sqft
460
1 ba
2 bds
$731/mo
-- sqft
461
1 ba
1 bd
$600/mo
500 sqft
462
1 ba
2 bds
$910/mo
793 sqft
463
1 ba
2 bds
$675/mo
950 sqft
464
2 ba
3 bds
$1,050/mo
-- sqft
465
2 ba
4 bds
$1,460/mo
-- sqft
195 rows × 4 columns
In [20]:
sujnd=sucln.join(attr)
sujnd.T
Out[20]:
0
1
3
4
6
8
9
10
11
12
13
14
15
16
17
...
435
436
437
438
439
446
448
451
457
460
461
462
463
464
465
url
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/apartment_duplex_type/53133_rid/396225-792449_...
...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
http://www.zillow.com/homes/for_rent/Manhattan-KS/house,condo,apartment_duplex,mobile,townhouse_...
type_of_property
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
...
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
Apartment For Rent
propertyinfo_value
$2,400/mo6 bds · 3 ba · -- sqft
$2,100/mo6 bds · 2 ba · -- sqft
$1,575/mo4 bds · 2 ba · -- sqft
$1,756/mo4 bds · 2 ba · 1,200 sqft
$1,775/mo4 bds · 2 ba · -- sqft
$1,750/mo4 bds · 2 ba · -- sqft
$1,625/mo4 bds · 2 ba · -- sqft
$2,100/mo4 bds · 3.5 ba · 2,668 sqft
$2,370/mo6 bds · 2 ba · 2,656 sqft
$1,660/mo4 bds · 2 ba · 1,332 sqft
$1,700/mo4 bds · 2 ba · 3,240 sqft
$1,600/mo5 bds · 2 ba · -- sqft
$2,075/mo5 bds · 2 ba · -- sqft
$1,600/mo4 bds · 2 ba · -- sqft
$1,900/mo4 bds · 2 ba · 1,909 sqft
...
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
$711/mo2 bds · 1 ba · -- sqft
$1,200/mo4 bds · 2 ba · 1,100 sqft
$650/moStudio · 1 ba · -- sqft
$825/mo2 bds · 1 ba · 900 sqft
$731/mo2 bds · 1 ba · -- sqft
$600/mo1 bd · 1 ba · 500 sqft
$910/mo2 bds · 1 ba · 793 sqft
$675/mo2 bds · 1 ba · 950 sqft
$1,050/mo3 bds · 2 ba · -- sqft
$1,460/mo4 bds · 2 ba · -- sqft
address
1649 Fairchild Ave APT 1, Manhattan, KS
106 S Manhattan Ave # 1, Manhattan, KS
1520 Harry Rd # 1, Manhattan, KS
2215 College Ave # 4X2, Manhattan, KS
930 Laramie St APT 2E, Manhattan, KS
1010 Ratone St # 1, Manhattan, KS
614 Thurston St # 614, Manhattan, KS
715 Leavenworth St, Manhattan, KS
1836 Todd Rd, Manhattan, KS
Laramie St, Manhattan, KS
913 Ratone St, Manhattan, KS
715 Moro St, Manhattan, KS
540 Westview Dr # 1, Manhattan, KS
820 Moro, 03
831 Bluemont Ave # 1, Manhattan, KS
...
731 N 6th St APT 2, Manhattan, KS
1435 Anderson Ave, Manhattan, KS
725 Griffith Dr APT 4, Manhattan, KS
2055 Tecumseh Rd, Manhattan, KS
1000 Thurston St, Manhattan, KS
3023 Sandstone Dr, Manhattan, KS
1401 Mccain Ln, Manhattan, KS
1222 Bertrand St APT B, Manhattan, KS
1114 Fremont St, Manhattan, KS
3314 Kennsington Ct, Manhattan, KS
731 N 6th St APT 2, Manhattan, KS
1435 Anderson Ave, Manhattan, KS
725 Griffith Dr APT 4, Manhattan, KS
2055 Tecumseh Rd, Manhattan, KS
1000 Thurston St, Manhattan, KS
no_of_photoes
17 photos
n/a
10 photos
3 photos
5 photos
23 photos
11 photos
6 photos
12 photos
2 photos
25 photos
7 photos
22 photos
5 photos
33 photos
...
8 photos
16 photos
5 photos
13 photos
9 photos
7 photos
6 photos
n/a
1 photo
6 photos
8 photos
16 photos
5 photos
13 photos
9 photos
photo_link
https://photos.zillowstatic.com/p_e/ISmqymksq29w2h1000000000.jpg
https://photos.zillowstatic.com/p_e/ISeovksdrez8ci0000000000.jpg
https://photos.zillowstatic.com/p_e/ISmysbylskm4gj0000000000.jpg
https://photos.zillowstatic.com/p_e/ISybz2us519esf1000000000.jpg
https://photos.zillowstatic.com/p_e/ISynwoyw6us6oq0000000000.jpg
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
...
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
https://photos.zillowstatic.com/p_e/ISl635mu1lbfxg1000000000.jpg
https://photos.zillowstatic.com/p_e/ISyjtzxn47oxf51000000000.jpg
https://dev.virtualearth.net/REST/v1/Imagery/Map/Aerial/39.191000,-96.576000/17?mapSize=596,446&...
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7
New column (6)_alt
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
...
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
Baths
3 ba
2 ba
2 ba
2 ba
2 ba
2 ba
2 ba
3.5 ba
2 ba
2 ba
2 ba
2 ba
2 ba
2 ba
2 ba
...
1 ba
1 ba
1 ba
2 ba
2 ba
1 ba
2 ba
1 ba
1 ba
1 ba
1 ba
1 ba
1 ba
2 ba
2 ba
Beds
6 bds
6 bds
4 bds
4 bds
4 bds
4 bds
4 bds
4 bds
6 bds
4 bds
4 bds
5 bds
5 bds
4 bds
4 bds
...
1 bd
2 bds
2 bds
3 bds
4 bds
2 bds
4 bds
Studio
2 bds
2 bds
1 bd
2 bds
2 bds
3 bds
4 bds
Rent
$2,400/mo
$2,100/mo
$1,575/mo
$1,756/mo
$1,775/mo
$1,750/mo
$1,625/mo
$2,100/mo
$2,370/mo
$1,660/mo
$1,700/mo
$1,600/mo
$2,075/mo
$1,600/mo
$1,900/mo
...
$600/mo
$910/mo
$675/mo
$1,050/mo
$1,460/mo
$711/mo
$1,200/mo
$650/mo
$825/mo
$731/mo
$600/mo
$910/mo
$675/mo
$1,050/mo
$1,460/mo
Sqft
-- sqft
-- sqft
-- sqft
1,200 sqft
-- sqft
-- sqft
-- sqft
2,668 sqft
2,656 sqft
1,332 sqft
3,240 sqft
-- sqft
-- sqft
-- sqft
1,909 sqft
...
500 sqft
793 sqft
950 sqft
-- sqft
-- sqft
-- sqft
1,100 sqft
-- sqft
900 sqft
-- sqft
500 sqft
793 sqft
950 sqft
-- sqft
-- sqft
11 rows × 195 columns
In [ ]: