Strayer Univeristy Write a Data Analysis Code Data Cleansing Strategy Essay

write data analysis code to apply the methods you learned last week to check for data quality and write an essay to answer the questions presented. You will use statistical software to test the data cleansing plan you created last week on real data in this week’s assignment. Include both your data analysis code and your essay in your assignment submission.

Instructions

Data Analysis Programming

For this assignment, you will use the data set cf_ANLT5010_W4_Airbnb.csv found in the course files.

Using the cf_ANLT5010_W4_Airbnb.csv data set, complete the data analysis programming steps as listed in the table.

For each issue that you found in the data, use the data step as appropriate to fix the data issues. Save your code to include in the data cleansing strategy in your assignment and also for your own future reference.

Data Analysis Programming StepsIf you are using SASIf you are using R

Print the first five observations using PROC Print, and note if anything looks out of place.

Print the first five observations using the head function, and note if anything looks out of place.

Run a PROC Frequency (PROC Freq) on at least one of the qualitative variables.

Run the frequency (freq() function) on at least one of the qualitative variables.

Run a PROC Univariate or a PROC Means on the quantitative variable and summarize your findings

Run the univariate (univariate() function) on the quantitative variable and summarize your findings.

Essay

Write a 3–5 page summary paper that discusses how you applied your data cleansing strategy or plan, what types of data issues your cleansing strategy identified, and the gaps in your current strategy. Include a section on what you feel are your strengths and where you feel you have an opportunity to learn using data analytical tools to import and work with multiple data sources.

Include as an appendix of your essay the results of your data cleansing reports in whatever format you detailed in your Week 3 plan, for example an output or a summary table, your code, and your written evaluation.

cf_ANLT5010_W4_AirBNB
id
name
2539
Clean & quiet apt home by the park
host_id host_name
2787
John
neighbourhood_group neighbourhood
Brooklyn
latitude
Kensington
40.6475
2595
Skylit Midtown Castle
2845
Jennifer
Manhattan
Midtown
40.7536
3647
THE VILLAGE OF HARLEM….NEW YORK !
4632
Elisabeth
Manhattan
Harlem
longitude room_type
-73.9724
Private room
price minimum_nights number_of_reviews last_review reviews_per_month calculated_host_listings_count availability_365
149
1
9
10/19/2018
0.21
5/21/2019
0.38
2
355
1
365
7/5/2019
4.64
1
194
0.1
1
Entire home/apt
225
-73.9419
Private room
150
3
0
Cozy Entire Floor of Brownstone
4869
LisaRoxanne
Brooklyn
Clinton Hill
40.6851
-73.9598
Entire home/apt
89
1
270
Entire Apt: Spacious Studio/Loft by central park
7192
Laura
Manhattan
East Harlem
40.7985
-73.944
Entire home/apt
80
10
Entire home/apt
5099
Large Cozy 1 BR Apartment In Midtown East
7322
Chris
Manhattan
Murray Hill
40.7477
-73.975
1
45
-73.9838
40.809
3831
5022
9
74
11/19/2018
6/22/2019
0.59
6
1
365
0
200
3
5121
BlissArtsSpace!
7356
Garon
Brooklyn
Bedford-Stuyvesant
40.6869
-73.956
Private room
60
45
49
10/5/2017
0.4
1
0
5178
Large Furnished Room Near B’way
8967
Shunichi
Manhattan
Hell’s Kitchen
40.7649
-73.9849
Private room
79
2
430
6/24/2019
3.47
1
220
129
5203
Cozy Clean Guest Room – Family Apt
7490
MaryEllen
Manhattan
Upper West Side
40.8018
-73.9672
Private room
79
2
118
7/21/2017
0.99
1
0
5238
Cute & Cozy Lower East Side 1 bdrm
7549
Ben
Manhattan
Chinatown
40.7134
-73.9904
Entire home/apt
150
1
160
6/9/2019
1.33
4
188
135
5
53
6/22/2019
0.43
1
6
85
2
188
6/23/2019
1.5
1
39
5295
Beautiful 1br on Upper West Side
7702
Lena
Manhattan
Upper West Side
40.8032
-73.9655
Entire home/apt
5441
Central Manhattan/near Broadway
7989
Kate
Manhattan
Hell’s Kitchen
40.7608
-73.9887
Private room
5803
Lovely Room 1, Garden, Best Area, Legal rental
6021
Wonderful Guest Bedroom in Manhattan for SINGLES
9744
11528
Laurie
Brooklyn
South Slope
40.6683
-73.9878
Private room
89
4
167
6/24/2019
1.34
3
314
Claudio
Manhattan
Upper West Side
40.7983
-73.9611
Private room
85
2
113
7/5/2019
0.91
1
333
6090
West Village Nest – Superhost
11975
Alina
Manhattan
West Village
40.7353
-74.0053
Entire home/apt
120
90
27
10/31/2018
0.22
1
0
6848
Only 2 stops to Manhattan studio
15991
Allen & Irina
Brooklyn
Williamsburg
40.7084
-73.9535
Entire home/apt
140
2
148
6/29/2019
1.2
1
46
7097
Perfect for Your Parents + Garden
17571
Jane
Brooklyn
Fort Greene
40.6917
-73.9719
7322
Chelsea Perfect
18946
Doti
Manhattan
Chelsea
40.7419
-73.995
Entire home/apt
215
2
198
6/28/2019
1.72
1
321
Private room
140
1
260
7/1/2019
2.12
1
12
53
6/22/2019
4.44
7726
Hip Historic Brownstone Apartment with Backyard
20950
Adam And Charity
Brooklyn
Crown Heights
40.6759
-73.9469
Entire home/apt
99
3
7750
Huge 2 BR Upper East Cental Park
17985
Sing
Manhattan
East Harlem
40.7969
-73.9487
Entire home/apt
190
7
0
7801
Sweet and Spacious Brooklyn Loft
21207
Chaya
Brooklyn
Williamsburg
40.7184
-73.9572
Entire home/apt
299
3
9
8024
CBG CtyBGd HelpsHaiti rm#1:1-4
22486
Lisel
Brooklyn
Park Slope
40.6807
-73.9771
Private room
130
2
130
40.6799
-73.978
40.68
-73.9787
8025
CBG Helps Haiti Room#2.5
22486
Lisel
Brooklyn
Park Slope
8110
CBG Helps Haiti Rm #2
22486
Lisel
Brooklyn
Park Slope
8490
MAISON DES SIRENES1,bohemian apartment
25183
Nathalie
Brooklyn
Bedford-Stuyvesant
8505
Sunny Bedroom Across Prospect Park
25326
Gregory
Brooklyn
Windsor Terrace
Private room
80
Private room
110
40.6837
-73.9403
Entire home/apt
120
40.656
-73.9752
Private room
8700
Magnifique Suite au N de Manhattan – vue Cloitres
26394
Claude & Sophie
Manhattan
Inwood
40.8675
-73.9264
Private room
9357
Midtown Pied-a-terre
30193
Tommi
Manhattan
Hell’s Kitchen
40.7672
-73.9853
Entire home/apt
9518
SPACIOUS, LOVELY FURNISHED MANHATTAN BEDROOM31374
Shon
Manhattan
Inwood
40.8648
-73.9211
Private room
9657
Modern 1 BR / NYC / EAST VILLAGE
Dana
Manhattan
East Village
40.7292
-73.9854
Entire home/apt
9668
front room/double bed
21904
32294
Ssameer Or Trip
Manhattan
Harlem
40.8225
-73.951
Private room
60
0
347
1
39
1/1/2019
0.37
2
6
364
6
304
2
88
6/19/2019
0.73
2
233
1
71
19
7/2/2019
6/23/2019
1.37
2
85
1
0
8/13/2017
0.61
0.49
1
75
1.11
3
311
0.24
1
4
0
10
58
44
3
108
6/15/2019
180
14
29
4/19/2019
50
Spacious 1 bedroom in luxe building
32045
Teri
Manhattan
Harlem
40.8131
-73.9547
Private room
52
Loft in Williamsburg Area w/ Roof
32169
Andrea
Brooklyn
Greenpoint
40.7222
-73.9376
Private room
55
9783
1
6
80
9704
21
249
0.07
1.09
150
9782
10452
1
2
12/28/2011
7/1/2019
3
242
6/1/2019
2.04
3
67
355
2
88
6/14/2019
1.42
1
255
4
197
6/15/2019
1.65
3
284
back room/bunk beds
32294
Ssameer Or Trip
Manhattan
Harlem
40.8213
-73.9532
Private room
50
3
273
7/1/2019
2.37
3
359
Large B&B Style rooms
35935
Angela
Brooklyn
Bedford-Stuyvesant
40.6831
-73.9547
Private room
70
1
74
5/12/2019
0.66
2
269
89
4
168
6/21/2019
1.41
35
6/22/2019
1.96
10962
Lovely room 2 & garden; Best area, Legal rental
11452
Clean and Quiet in Brooklyn
9744
Laurie
Brooklyn
South Slope
40.6687
-73.9878
Private room
7355
Vt
Brooklyn
Bedford-Stuyvesant
40.6888
-73.9431
Private room
Bushwick
40.7019
-73.9275
Entire home/apt
40.637
-73.9633
Private room
40.714
-73.9892
Shared room
-73.982
Private room
11708
Cute apt in artist’s home
44145
Tyrome
Brooklyn
11943
Country space in the city
45445
Harriet
Brooklyn
Flatbush
12048
LowerEastSide apt share shortterm 1
12192
ENJOY Downtown NYC!
7549
46978
Ben
Manhattan
Lower East Side
Edward
Manhattan
East Village
40.7229
60
0
85
2
231
150
1
3
340
1
365
2
22
1
365
40
1
214
7/5/2019
1.81
4
188
68
2
245
6/21/2019
2.08
2
0
96
12299
Beautiful Sunny Park Slope Brooklyn
47610
Abdul
Brooklyn
South Slope
40.6628
-73.9797
Entire home/apt
120
3
15
5/27/2019
0.39
1
345
12303
1bdr w private bath. in lofty apt
47618
Yolande
Brooklyn
Fort Greene
40.6967
-73.9758
Private room
120
7
25
9/30/2018
0.23
1
311
12318
West Side Retreat
16800
Cyn
Manhattan
Upper West Side
40.7901
-73.9793
Private room
135
4
81
6/16/2019
0.69
1
273
12343
BEST BET IN HARLEM
47727
Earl
Manhattan
Harlem
40.8118
-73.9448
Entire home/apt
150
7
97
6/13/2019
0.84
1
309
12627
Entire apartment in central Brooklyn neighborhood.
49670
Rana
Brooklyn
Prospect-Lefferts Gardens
40.6594
-73.9624
Entire home/apt
150
29
11
6/5/2019
0.49
1
95
12937
1 Stop fr. Manhattan! Private Suite,Landmark Block
50124
Orestes
Queens
Long Island City
40.7477
-73.9474
Private room
130
3
248
7/1/2019
2.25
1
215
61
5/25/2019
0.52
1
265
11
1/1/2017
0.1
1
12940
Charming Brownstone 3 – Near PRATT
50148
Adreinne
Brooklyn
Bedford-Stuyvesant
40.6811
-73.9559
Entire home/apt
110
7
13050
bright and stylish duplex
50846
Jennifer
Brooklyn
Bedford-Stuyvesant
40.6855
-73.9409
Entire home/apt
115
3
13394
Fort Greene brownstone
52335
Alexander
Brooklyn
Fort Greene
40.6914
-73.9738
Private room
13808
Blue Room for 2 in Brownstone for $1350 monthly
54275
JT And Tiziana
Brooklyn
Bedford-Stuyvesant
40.6804
-73.9393
Private room
0
80
3
135
6/17/2019
1.16
2
192
80
1
112
6/16/2019
1.01
3
251
7/7/2019
0.63
1
302
5/17/2019
0.7
1
140
14287
Cozy 1BD on Central Park West in New York City
56094
Joya
Manhattan
Upper West Side
40.7864
-73.9701
Entire home/apt
151
2
73
14290
* ORIGINAL BROOKLYN LOFT *
56104
James
Brooklyn
Williamsburg
40.7042
-73.9356
Entire home/apt
228
3
82
14314
Greenpoint Place…Has It All!
56246
Jeanne
Brooklyn
Greenpoint
40.7351
-73.9539
Entire home/apt
144
2
328
6/29/2019
2.82
1
234
14322
Beautiful Apartment in Manhattan!!!
56284
Francesca
Manhattan
Kips Bay
40.7396
-73.9807
Entire home/apt
200
7
19
3/25/2019
0.22
1
257
14377
Williamsburg 1 bedroom Apartment
56512
Joanna
Brooklyn
Williamsburg
14991
Great Location, Manhattan Bedroom!
59023
Bianca
Manhattan
Lower East Side
15220
Best Location in NYC! TIMES SQUARE!
59734
Luiz
Manhattan
Hell’s Kitchen
15338
Room in Greenpoint Loft w/ Roof
32169
Andrea
Brooklyn
Greenpoint
15341
**Bright Nolita Apt w Doorman/Elevators/Gym**
60049
Ted
Manhattan
SoHo
Entire home/apt
150
40.72
-73.991
Private room
110
40.7553
40.7088
-73.9929
-73.9593
Private room
40.724
-73.9379
Private room
40.7221
-73.9978
Entire home/apt
15385
Very, very cozy place
60252
Cristina
Brooklyn
Williamsburg
40.7119
-73.962
15396
Sunny & Spacious Chelsea Apartment
60278
Petra
Manhattan
Chelsea
40.7462
-73.9953
Private room
Entire home/apt
69
49
180
30
105
6/22/2019
0.9
1
30
5
19
5/18/2019
0.17
1
301
2
289
6/9/2019
2.49
2
294
4
138
6/4/2019
1.19
3
320
21
6/29/2019
0.3
1
154
30
80
2
375
180
42
6/30/2019
0.38
1
263
5
11/3/2018
0.12
1
180
15711
2 bedroom – Upper East Side-great for kids
61491
D
Manhattan
Upper East Side
40.7707
-73.9527
Entire home/apt
250
2
66
3/30/2019
0.57
2
231
16326
Comfortable 4-bedroom apt in family house.
63588
Dimitri
Brooklyn
Prospect Heights
40.6781
-73.9643
Entire home/apt
200
30
143
1/26/2019
1.33
2
297
16338
Double Room w Private Deck Clinton Hill Best Area
63613
Patricia
Brooklyn
Clinton Hill
16421
40.69
-73.9679
Private room
40.7598
-73.9912
Private room
Light-filled 2B duplex in the heart of Park Slope!
64056
Sara
Brooklyn
Park Slope
40.6734
-73.9834
Sunny, Modern room in East Village!
64442
Reka
Manhattan
East Village
40.7265
16595
*HAVEN LOFT – Entire Floor – Six Windows – Bricks*
64522
Daniel
Brooklyn
Williamsburg
40.7093
-73.9679
Entire home/apt
16821
Your Heaven in Hells Kitchen
Large Room in Amazing East Village Apt
63924
4396
Mark
Casey
Manhattan
Manhattan
Hell’s Kitchen
East Village
40.723
-73.9847
Private room
16458
16580
-73.979
Entire home/apt
Private room
55
7
27
9/30/2017
0.23
2
292
52
30
191
5/16/2019
1.65
1
191
225
3
4
80
1
338
9/24/2017
0.16
1
7/1/2019
4.72
2
0
72
275
1
148
6/23/2019
1.4
1
362
99
1
106
6/21/2019
1.26
2
336
4
190
6/23/2019
1.64
1
215
9
49
5/14/2018
0.43
1
116
16974
SpaHa Loft: Enormous and Bright
65837
Robin
Manhattan
East Harlem
40.8016
-73.9392
Entire home/apt
225
17037
Lovely EV Artist’s Home
66035
Anna
Manhattan
East Village
40.7216
-73.9801
Entire home/apt
230
17092
Cool Room in Hell’s Kitchen
66243
Enzo
Manhattan
Hell’s Kitchen
40.7634
-73.9887
Private room
51
7
23
6/1/2019
0.43
1
88
17693
HARLEM, NEW YORK WELCOMES YOU!!
68428
Tye And Etienne
Manhattan
Washington Heights
40.8314
-73.941
Private room
65
2
49
6/18/2019
1.6
2
336
-73.9637
2
0.92
1
304
0.2
1
224
17747
BLUE TRIM GUEST HOUSE
68599
George
Brooklyn
Clinton Hill
40.6835
18127
Private room
105
105
6/26/2019
Entire home/apt
190
5
21
1/2/2019
40.7687
-73.9506
Private room
200
1
142
7/6/2019
1.5
1
322
40.7504
-73.9033
Private room
70
30
25
5/31/2019
0.22
1
324
18590
Fort Greene Retreat on the Park
71512
Blaise
Brooklyn
Fort Greene
40.6932
-73.9727
Private room
95
18728
Charming East Village One Bedroom Flat
Beautiful Meatpacking District Loft
69829
71876
Josh
DAVID And RICK
Manhattan
Manhattan
East Village
Chelsea
40.7283
40.7414
-74.002
Private room
150
18152
Manhattan Room
69942
Victoria
Manhattan
Upper East Side
18198
Little King of Queens
70091
Justin
Queens
Woodside
18764
Cozy 2 BR in Williamsburg
72014
Lulú
Brooklyn
Williamsburg
143
6/16/2019
1.28
1
132
167
5/28/2019
1.65
1
295
3
Sybilla
Manhattan
Harlem
40.8292
-73.9514
Entire home/apt
110
31
54
3/23/2019
0.49
1
209
JoLynn
Manhattan
Lower East Side
40.7185
-73.9889
Entire home/apt
285
5
70
6/30/2019
0.62
1
328
130
6
16
6/15/2019
0.15
1
38
94
30
94
4/8/2019
0.84
1
188
Sunny, Spacious Top Floor Haven
73469
Gaia
Brooklyn
Flatbush
Private room Great Deal at Lower East Side
44263
Ana
Manhattan
Lower East Side
Private room
3
73051
73128
19282
-73.9611
3
145
Spacious luminous apt Upper West NYC
Entire 2 Bedroom – Large & Sunny
19319
40.7115
-73.988
19159
19169
40.654
-73.9632
Entire home/apt
40.7114
-73.9879
Private room
61
4/22/2019
0.54
4
238
19601
perfect for a family or small group
74303
Maggie
Brooklyn
Brooklyn Heights
40.6972
-73.9927
Entire home/apt
800
1
25
8/4/2016
0.24
1
7
19812
2 bedroom Williamsburg Apt – Bedford L stop
74857
Starlee
Brooklyn
Williamsburg
40.7183
-73.9575
Entire home/apt
105
3
61
8/9/2018
0.53
1
272
20299
Oh glorious spring!
62407
Edward
Manhattan
East Village
40.7233
-73.9844
Private room
60
3
194
6/30/2019
1.73
1
20300
Great Location for NYC
76627
Pas
Manhattan
East Village
40.7291
-73.9806
Private room
50
1
2
2/14/2016
0.05
1
20611
Cozy Bedroom in Williamsburg 3 BR
20724
Sunny room+Pvte office in huge loft
72014
961342
26
0
Lulú
Brooklyn
Williamsburg
40.7116
-73.9622
Private room
85
3
174
6/22/2019
1.54
4
288
Augustin
Brooklyn
Bushwick
40.7003
-73.9383
Private room
65
4
24
5/26/2019
0.28
1
317
131
4
166
6/27/2019
3.4
1
207
98
7
16
5/31/2019
0.2
6
185
158
20734
Spacious Prospect Heights Apartment
78460
Sean & Lynette
Brooklyn
Prospect Heights
40.6823
-73.9726
20755
Large Parlor Room, Landmark Home 1 block to PRATT
51038
Erica
Brooklyn
Clinton Hill
40.6863
-73.966
Entire home/apt
Private room
20853
2-bed brownstone duplex + garden
79070
Tracy
Brooklyn
Prospect Heights
40.6804
-73.9716
Entire home/apt
250
7
21
5/21/2019
0.3
1
20913
Charming 1 bed GR8 WBurg LOCATION!
79402
Christiana
Brooklyn
Williamsburg
40.7098
-73.9578
Entire home/apt
100
5
168
7/22/2018
1.57
1
3
118
6/18/2019
1.05
2
9
81
7/7/2019
0.71
1
198
21293
Sunny Apartment in Artist Home
44145
Tyrome
Brooklyn
Bushwick
40.7009
-73.9261
Entire home/apt
105
21456
Light-filled classic Central Park
42032
Dana
Manhattan
Upper West Side
40.7976
-73.9618
Entire home/apt
140
21644
Upper Manhattan, New York
82685
Elliott
Manhattan
Harlem
40.828
-73.9473
Private room
21794
COZY QUIET room 4 DOOGLERS!
83257
Olan
Manhattan
Chelsea
40.7401
-74.0027
Private room
22911
The Stuydio Modern and Light Filled
87773
Shelly
Brooklyn
Bedford-Stuyvesant
40.6841
-73.9236
Entire home/apt
22918
loft bed – near transportation-15min to times sq
32294
Ssameer Or Trip
Manhattan
Harlem
40.8228
-73.9514
Private room
23135
House On Henry (3rd FLR Suite)
11481
Annette
Brooklyn
Carroll Gardens
40.6797
-74.0015
Entire home/apt
23501
Monkey Retreat Manhattan
63318
Meka
Manhattan
Washington Heights
40.8393
-73.9428
Private room
23686
2000 SF 3br 2bath West Village private townhouse
24143
Williamsburg—Steps To Subway, Private Bath&Balcony
24285
Beautiful Duplex Apartment
1
10/9/2018
0.11
1
365
30
5/1/2019
0.27
2
364
7
139
3
11
175
2
65
2
93790
Ann
Manhattan
West Village
40.731
-74.0032
Entire home/apt
500
Seth
Brooklyn
Williamsburg
40.7133
-73.9418
Private room
101
97797
Large 2 Bedroom Great for Groups!
87773
Modern Brooklyn Apt., August sublet
105538
Brenda
Brooklyn
2
311
3
219
233
6/24/2019
2.09
3
342
68
11/1/2012
0.6
1
312
4
46
5/18/2019
0.55
2
243
3
335
5/29/2019
3.02
1
152
Entire home/apt
220
30
88
11/2/2018
0.79
Brooklyn
Bedford-Stuyvesant
40.6837
-73.9238
Entire home/apt
125
90
162
6/28/2019
1.46
2
137
Brooklyn
Williamsburg
40.7146
-73.9484
Entire home/apt
80
30
29
5/26/2018
0.4
1
222
2
170
6/23/2019
1.61
1
346
19
3/17/2017
0.2
1
208
107628
Dena
Manhattan
109589
Jessica
Brooklyn
-73.9811
1.23
0.87
Shelly
1,800 sq foot in luxury building
Sunny 2-story Brooklyn townhouse w deck and garden
40.6694
10/28/2018
1/3/2019
Erik
25696
26012
Park Slope
0
1
30
60
97219
25235
25406
3
89
98
125
Harlem
40.8092
-73.9442
Private room
100
Gowanus
40.6816
-73.9899
Entire home/apt
200
30
26362
Times Square, Safe, Clean and Cozy!
59734
Luiz
Manhattan
Hell’s Kitchen
40.7553
-73.9929
Private room
59
2
334
6/16/2019
26520
Cozy Room #3, Landmark Home 1 Block to PRATT
51038
Erica
Brooklyn
Clinton Hill
40.687
-73.9657
Private room
125
2
19
6/2/2019
1
9
3
2
279
0.2
6
250
26559
Beautiful Apartment East Village
112793
Sally
Manhattan
East Village
40.7288
-73.9819
Entire home/apt
140
7
12
12/11/2017
0.13
1
164
26785
Park Slope Green Guest House
42273
Dani
Brooklyn
South Slope
40.6685
-73.9891
Entire home/apt
120
30
467
12/30/2018
4.22
2
192
26933
2 BR / 2 Bath Duplex Apt with patio! East Village
26954
NYC fabulous views Manhattan’s eye
72062
Bruce
Manhattan
East Village
40.7254
-73.9816
Entire home/apt
350
2
115157
7
8/9/2017
0.06
4
298
5
38
12/2/2015
0.38
1
260
40.7194
-73.9575
Entire home/apt
325
3
324
6/23/2019
3.01
1
107
40.7782
-73.9764
Entire home/apt
235
6
27
4/27/2019
0.27
1
199
72062
Bruce
Manhattan
East Village
40.7256
-73.9797
Entire home/apt
225
1
115
6/7/2019
1.05
4
299
118971
Nimo
Evelyn
Manhattan
Brooklyn
Kips Bay
South Slope
40.6683
99
2
354
5/20/2019
3.2
3
Harlem
40.7429
40.8275
-73.9492
Entire home/apt
170
2
195
40.665
-73.9801
-73.9793
Entire home/apt
Entire home/apt
199
400
2
16
26969
2 story family home in Williamsburg
115307
Alexandra
Brooklyn
Williamsburg
27006
Comfortable UWS 2-BD Family-Friendly Brownstone
115560
Stacy
Manhattan
Upper West Side
27385
Great Large 1 BR apt in East Village!
27531
Eveland Private Bed & Living Room w/ Own Entrance
27644
Sugar Hill Rest Stop
119510
Emma
Manhattan
27659
3 Story Town House in Park Slope
119588
Vero
Brooklyn
South Slope
-73.986
Private room
20
7/1/2019
2.03
1
318
12/30/2018
0.24
2
216
224
27759
apartment next to Central park
119900
Sylvie
Manhattan
Upper West Side
40.7784
-73.9756
Entire home/apt
170
7
13
6/26/2019
0.12
1
27883
East Village Sanctuary
120223
Jen
Manhattan
East Village
40.7225
-73.9853
Entire home/apt
100
4
25
12/10/2011
0.23
1
0
28321
Large 1 BR in a 3 BR Brooklyn apt. next to Q Trn.
65091
Kay
Brooklyn
Prospect-Lefferts Gardens
40.6559
-73.9605
Private room
75
2
9
10/5/2018
0.08
1
324
28396
Modern Apt with Spectacular Views
6E+06
Jo
Brooklyn
Williamsburg
40.7192
-73.9647
Private room
90
1
9
9/18/2011
0.08
1
245
Manhattan
28907
Garden studio in the Upper East Sid
124352
Lisa
29012
Secluded Master Bedroom in Beautiful Huge Apt
124797
Fernando And Lenin Manhattan
29013
B & B Room 1
29455
ACCOMMODATIONS GALORE #1
29628
Sunny Room in New Condo
Upper East Side
Washington Heights
40.778
-73.9482
Entire home/apt
40.8588
-73.9313
Private room
35935
Angela
Brooklyn
Bedford-Stuyvesant
40.6833
-73.9547
Private room
126607
Laurine
Manhattan
Harlem
40.8162
-73.9489
Entire home/apt
127608
Chris
Brooklyn
Clinton Hill
29683
Stylish & Sleek Apartment Near SoHo!
125857
Uli
Manhattan
East Village
30031
NYC artists’ loft with roof deck
129352
Sol
Brooklyn
Greenpoint
40.6841
-73.9635
Private room
40.7239
-73.9914
Entire home/apt
40.7349
-73.9503
Private room
30927
Unique & Charming small 1br Apt. LES
120335
Cs
Manhattan
Lower East Side
40.7134
-73.9886
31130
Most Central Location!
117287
Lara
Manhattan
Hell’s Kitchen
40.7675
31555
Luminous Beautiful West Village Studio
135619
Tom
Manhattan
31902
Sanctuary in East Flatbush
137292
Sunder
Brooklyn
-73.984
150
5
85
15
2
310
3
213
89
185
50
1
278
5
73
6/25/2019
0.66
1
209
3
3
193
5/20/2019
1.86
1
105
2
115
29
77
2
Brooklyn
Clinton Hill
40.6873
-73.9634
Private room
Brooklyn
Bedford-Stuyvesant
40.683
-73.9366
Entire home/apt
Private room
189
307
0.58
1.42
130
Waldemar
Khem
1
1
5/14/2019
6/20/2019
Entire home/apt
-74.003
-73.9325
137814
137974
0.19
0.33
63
155
Entire home/apt
40.7344
40.6319
Room with En Suite Bathroom & Deck
FLAT MACDONOUGH
8/15/2017
8/17/2017
3
3
Private room
West Village
Flatlands
31994
32023
21
36
70
120
3
260
7/3/2019
2.35
0
32
6/14/2019
0.29
1
16
50
5/26/2019
0.45
3
234
26
7/1/2019
0.25
1
12
2
1/1/2019
0.02
1
178
76
2
426
6/24/2019
3.89
3
275
125
3
227
6/23/2019
2.09
2
163
365
32037
Huge Private Floor at The Waverly
116599
Sahr
Brooklyn
Clinton Hill
40.6863
-73.9677
Private room
135
4
32100
Modern Greenpoint, Brooklyn Apt
138579
Ali+Scott
Brooklyn
Greenpoint
40.7341
-73.9535
Entire home/apt
250
29
32289
Sun-drenched, artsy modernist 1 BDRM duplex
139612
Elisabeth
Brooklyn
Williamsburg
40.7156
-73.9484
Entire home/apt
199
3
32331
Sunny, Cobble Hill Apartment
139874
Sarah
Brooklyn
Cobble Hill
40.6857
-73.9918
Entire home/apt
140
2
84
7/1/2019
0.77
3
3
7/30/2017
0.03
1
34
10
6/11/2018
0.1
1
280
4
4/24/2016
0.04
1
0
32363
Fully Furnished Basement Apartment
140025
Fredah
Queens
Flushing
40.7403
-73.8317
Private room
140
2
1
9/19/2011
0.01
1
1
32965
FLAT MACDONOUGH GARDEN
137974
Khem
Brooklyn
Bedford-Stuyvesant
40.6828
-73.9352
Entire home/apt
115
3
124
6/20/2019
1.72
2
170
32969
Light filled Williamsburg Apartment
142833
Katherine
Brooklyn
Williamsburg
40.716
-73.9394
Entire home/apt
160
3
11
7/2/2019
0.11
1
188
33009
Retreat in Williamsburg
143027
Ming
Brooklyn
Williamsburg
40.7149
-73.9594
Entire home/apt
195
4
240
6/17/2019
2.19
1
214
33014
NYC Zen
143048
Entire home/apt
195
3
30
6/17/2019
0.28
1
248
33223
Cozy BR in Wiliamsburg 3 Bedroom
80
3
200
6/22/2019
1.86
4
262
72014
Paula
Manhattan
East Village
40.7235
-73.983
Lulú
Brooklyn
Williamsburg
40.7117
-73.9609
Private room
34760
Sunny Room in Old Historical Brooklyn Townhouse
149929
Obed
Brooklyn
Fort Greene
40.691
-73.9731
Private room
44
8
27
6/29/2019
1.05
5
280
35526
Sun Filled Classic West Village Apt
120291
Karen
Manhattan
West Village
40.7347
-74.001
Private room
156
4
79
6/22/2019
0.74
1
307
339
36121
Lg Rm in Historic Prospect Heights
36133
Classic Artist Loft Williamsburg
62165
142684
Michael
Brooklyn
Prospect Heights
40.6739
-73.9664
Private room
85
15
9
5/10/2013
0.09
1
White
Brooklyn
Williamsburg
40.7154
-73.9606
Private room
125
3
155
6/13/2019
1.61
Prospect Heights
40.6741
Entire home/apt
115
15
36442
Great location. Spacious on PROSPECT PARK
137432
Paz
Brooklyn
36647
Private Bdrm/Bathrm. New! Elevator!
157798
Irene
Manhattan
East Harlem
Sunny, clean 1 bdrm in W. Village
158284
36934
Great location in Williamsburg
159370
38638
36703
Light and Airy Upper East Side 1 BDR apartment
92788
Karene
Manhattan
West Village
40.793
40.7323
-73.966
-73.94
-74.004
Private room
Entire home/apt
69
2
225
45
1
1
4
8/27/2018
0.05
1
269
34
5/29/2017
0.32
1
134
3/31/2019
1.24
1
10
312
Viviana
Brooklyn
Williamsburg
40.7136
-73.964
Entire home/apt
125
6
27
12/27/2018
0.25
1
189
Sara
Manhattan
Upper East Side
40.7771
-73.9527
Entire home/apt
219
4
126
6/26/2019
1.16
2
290
Entire home/apt
475
3
23
12/31/2018
0.27
1
230
Entire home/apt
99
1
234
2.6
2
164
69
4
79
38663
Luxury Brownstone in Boerum Hill
165789
Sarah
Brooklyn
Boerum Hill
40.6856
-73.9809
39267
CENTRAL PARK LOFT all for YOU
168417
Marie
Manhattan
Upper East Side
40.7746
-73.9532
39282
Indie-Chic Share In Williamsburg
168525
Gus
Brooklyn
Williamsburg
40.7109
-73.9506
Private room
39593
A room w/ a Manhattan view, longer stay
110506
Myung
Queens
Sunnyside
40.7456
-73.9231
Private room
6/8/2019
202
5/28/2019
1.86
2
53
30
28
4/12/2019
0.26
1
126
39704
Private, Large & Sunny 1BR w/W&D
170510
Renée
Brooklyn
Bedford-Stuyvesant
40.6831
-73.9466
Entire home/apt
135
2
309
6/22/2019
2.86
40039
Luxurious Condo in DUBMO with View
171851
Henry
Brooklyn
DUMBO
40.7021
-73.9857
Private room
250
3
14
4/25/2011
0.13
40453
Charming & Cozy midtown loft any WEEK ENDS !!!
174025
Sylvia
Manhattan
Upper East Side
40.7612
-73.9642
Entire home/apt
250
3
41348
* Spacious GARDEN Park Slope Duplex* 6 people max
180083
Syl
Brooklyn
Gowanus
40.6686
-73.9908
Entire home/apt
250
2
41513
Convenient cozy cheap apt Manhattan
181167
Lorenzo
Manhattan
Harlem
42580
Parlor Room In Victorian Townhouse
137814
Waldemar
Brooklyn
Clinton Hill
Annette
Brooklyn
42729
House On Henry (2nd FLR Suite)
42882
New York room with a view
11481
185978
Newyorkroomwithaview
Staten Island
2
3
1
189
4
9/23/2016
0.08
1
365
80
7/6/2019
2.17
1
0
40.827
-73.9491
Entire home/apt
80
3
2
11/2/2015
0.04
1
0
40.6884
-73.9641
Private room
70
2
294
6/24/2019
3.47
3
336
Carroll Gardens
40.6783
-74.0014
Entire home/apt
St. George
40.6452
-74.0809
Private room
165
2
150
6/18/2019
1.4
3
342
70
2
166
6/13/2019
1.66
1
312
43957
Sunny cozy room in Brklyn townhouse
177536
Tessa
Brooklyn
Bushwick
40.7064
-73.9177
Private room
50
2
47
6/19/2019
0.94
1
37
44096
Room with a View
190409
Waundell
Bronx
Highbridge
40.8323
-73.9318
Private room
40
1
219
7/4/2019
2.04
3
353
44161
Light+Open+Airy+Rustic+Modern Loft
193360
Young
Brooklyn
Williamsburg
40.7105
-73.9677
Entire home/apt
150
2
193
7/6/2016
1.78
1
177
44212
West Inn 2 – East Village
72062
Bruce
Manhattan
East Village
40.7252
-73.9803
Private room
125
1
84
6/23/2019
0.78
4
310
40.7067
-74.0137
Entire home/apt
196
1.06
1
0
40.691
-73.9711
Private room
110
2
2
321
44221
Financial District Luxury Loft
193722
Coral
Manhattan
Financial District
44229
BROOKLYN VICTORIAN STYLE SUITE…..
181376
Carol
Brooklyn
Fort Greene
44288
Your own Lovely West Village Studio
193637
Sara
Manhattan
West Village
40.7376
-74.0041
Entire home/apt
170
44506
ACCOMMODATIONS GALORE#3. 1-5 GUESTS
126607
Laurine
Manhattan
Harlem
40.8153
-73.9479
Entire home/apt
3
114
6/20/2019
2
213
6/24/2019
3
165
3
45393
Greenwich Village Stylish Apartment
201297
Myrna
Manhattan
West Village
40.7342
-74.0046
Entire home/apt
150
26
45542
Clean and Cozy Harlem Apartment
202249
Campbell
Manhattan
Harlem
40.8237
-73.9373
Entire home/apt
100
2
45556
Fort Greene, Brooklyn: Center Bedroom
67778
Doug
Brooklyn
Fort Greene
40.6886
-73.9769
45910
Beautiful Queens Brownstone! – 5BR
204539
Mark
Queens
Ridgewood
40.7038
-73.898
45936
Couldn’t Be Closer To Columbia Uni
867225
Rahul
Manhattan
Morningside Heights
40.8055
-73.9592
45940
Bright Spacious Luxury Condo
204724
46544
Park Slope haven 15 mins from Soho
8198
Private room
Entire home/apt
Private room
65
2
86
6/1/2019
0.8
80
1
246
3
231
38
4/20/2016
0.36
1
225
18
5/26/2019
12/17/2018
0.75
1.79
1
206
6/30/2019
1.92
2
0
0
350
8
10
5/12/2019
0.11
5
365
99
4
122
5/14/2019
1.18
2
233
0.58
1
0.5
1
Miyoung
Brooklyn
Williamsburg
40.7163
-73.9587
Entire home/apt
200
4
33
4/8/2019
Monica
Brooklyn
Park Slope
40.6799
-73.9786
Entire home/apt
150
5
52
6/5/2019
3
126
5/19/2019
1.17
4
343
3
51
6/24/2019
0.48
3
250
1
18
46723
SAFE AND BEAUTIFUL ACCOMODATION
209460
Marylyn
Brooklyn
Bedford-Stuyvesant
40.6799
-73.9475
Private room
90
46911
Large Room in private Brownstone in Park Slope
210746
Kathleen R.
Brooklyn
Prospect Heights
40.6787
-73.9731
Private room
120
75
3
199
6/24/2019
1.85
1
326
175
26
30
9/3/2012
0.29
1
364
47199
NEW YORK CITY, 1 BDRM.(NEAR CENTRAL PARK & METRO)
212722
Teresa
Manhattan
Upper East Side
40.7683
-73.9533
Private room
47362
LARGE, COMFY 1BDR W/CHARACTER!!!
Robert
Brooklyn
Bedford-Stuyvesant
40.6824
-73.9415
Entire home/apt
214148
47370
Chelsea Studio sublet 1 – 2 months
214287
Alex
Manhattan
Chelsea
40.7403
-74
Entire home/apt
125
3
3
7/17/2015
0.03
1
0
47926
LUX APT IN TIMES SQUARE NEW BUILDING
218404
Claudia
Manhattan
Hell’s Kitchen
40.7631
-73.9967
Entire home/apt
275
1
41
6/26/2019
0.38
1
299
48719
Designer 1 BR Duplex w/ Terrace- Spectacular Views
221873
Shane
Manhattan
Lower East Side
40.7188
-73.9885
50447
Lovely Apt & Garden; Legal; Best Area; Amenities
9744
Laurie
Brooklyn
South Slope
40.6693
-73.988
51438
51485
Entire home/apt
299
2
109
6/15/2019
1.04
1
207
Entire home/apt
135
5
151
6/22/2019
1.43
3
162
-73.952
Private room
130
14
0
40.7232
-73.992
Private room
83
1
285
6/22/2019
2.69
1
Lee
Manhattan
Chelsea
40.7486
-73.9967
Private room
123
1
375
6/18/2019
3.52
1
328
Jullett
Queens
Jamaica
40.6725
-73.766
Private room
55
2
52
5/20/2019
0.49
2
365
-73.9927
1 Bedroom in 2 Bdrm Apt- Upper East
236421
Jessica
Manhattan
Upper East Side
40.7733
Lower East Side $57~/night
236655
Erina
Manhattan
Lower East Side
51572
Prime Location in Manhattan
237329
51850
( F) Excellent/Pvt Rm
27848
53137
Quiet, sunny Midtown Manhattan apt.
240360
Marlaine
Manhattan
Hell’s Kitchen
40.7624
53196
Big Room/Washer-Dryer/Wifi/AC/JMZ
247432
Charlotte
Brooklyn
Bedford-Stuyvesant
40.6955
-73.935
Entire home/apt
Private room
53469
cozy studio with parking spot
204539
Mark
Queens
Middle Village
40.7172
-73.8786
Entire home/apt
53470
Clean and convenient 2BR apartment
204539
Mark
Queens
Ridgewood
40.7023
-73.8982
Private room
53477
3 floors of luxury!
204539
Mark
Queens
Middle Village
54158
The Institute—Heart of Williamsburg
10889
Bob
Brooklyn
Williamsburg
195
2
0
7
5
10
7/1/2019
1.01
1
80
2
11
11/13/2017
0.48
1
98
30
33
5/9/2015
0.31
5
240
140
7
6
10/8/2015
0.06
5
365
0
0
40.7155
-73.8785
Entire home/apt
265
7
38
4/27/2019
0.38
5
365
40.7195
-73.9598
Entire home/apt
249
2
358
6/20/2019
3.44
2
164
54453
MIDTOWN WEST – Large alcove studio
255583
Anka
Manhattan
Hell’s Kitchen
40.7655
-73.9847
Shared room
105
6
10
1/7/2014
0.09
54466
Beautiful Uptown Manhattan apartmnt
253385
Douglas
Manhattan
Harlem
40.8023
-73.956
Private room
200
30
0
54508
Sml Rm in pr Brst Park Sl great for Med/students
210746
Kathleen R.
Brooklyn
Prospect Heights
40.6787
-73.9726
54544
City Room – Private Penthouse Apt.
256161
Wayne
Manhattan
Harlem
40.8104
-73.946
54626
Cozy bedroom by Yankee Stadium
190409
Waundell
Bronx
Highbridge
40.8308
-73.9306
54860
55467
226
6/6/2019
2.12
363
365
Private room
100
Entire home/apt
121
1
104
6/22/2019
1
5
247
45
1
138
6/30/2019
1.45
3
323
Private room
2
1
1
3
250
Great apartment with private bathroom and entrance
258164
Jenny
Manhattan
East Harlem
40.7996
-73.9428
Private room
100
5
204
6/23/2019
1.92
1
192
Private Garden Apt • New Renovation
260709
Paul
Brooklyn
Williamsburg
40.7163
-73.9385
Entire home/apt
140
2
253
7/2/2019
3.04
1
125
55498
Modern comfort in art infused landmark Brownstone
262138
Tami
Brooklyn
Bedford-Stuyvesant
40.6829
-73.9355
55668
NOHO/EAST VILLAGE, PRIVATE 1/2 BATH
88209
Jason
Manhattan
NoHo
40.7277
-73.9913
Private room
71
2
23
7/1/2019
0.22
1
Private room
130
2
115
12/5/2018
1.17
1
75
55737
Sleek & Comfortable Soho Apt
263414
Pete
Manhattan
West Village
40.7286
-74.0049
Entire home/apt
199
5
129
5/19/2019
1.22
1
286
55959
Spacious Williamsburg Share w/ LOFT BED
168525
Gus
Brooklyn
Williamsburg
40.7098
-73.9516
Private room
69
4
82
6/10/2019
1.13
2
91
60
55982
Cozy 2 br in sunny Fort Greene apt
264928
Sally
Brooklyn
Fort Greene
40.6866
-73.9753
Private room
68
3
37
56467
Cozy East Village Railroad 1 Bed!
267593
Leonardo
Manhattan
East Village
40.7275
-73.9843
Entire home/apt
130
1
204
40.729
-73.9583
Entire home/apt
195
2
69
6/13/2019
0.65
1
58
40.8122
-73.945
64
1
192
6/3/2019
1.84
5
245
56525
1 Bedroom Loft w/ Private Roof Deck
268014
Alex
Brooklyn
Greenpoint
56859
City Room – Private & Comfy Bedroom
256161
Wayne
Manhattan
Harlem
Private room
12/31/2018
0.35
1
0
7/1/2019
2.04
1
192
57166
Elegant NYC Pad
272006
Vasili
Queens
Ditmars Steinway
40.7719
-73.905
Entire home/apt
140
2
17
6/17/2019
0.16
1
292
57297
Clean & bright 1BR in Cobble Hill, GREAT location!
199392
S.M.
Brooklyn
Cobble Hill
40.6893
-73.9939
Entire home/apt
159
2
222
6/24/2019
2.12
1
279
57468
Modern, Large East Village Loft
239208
Ori
Manhattan
East Village
40.7282
-73.987
Entire home/apt
189
3
205
6/23/2019
1.96
1
57618
Great new apt, close to everything
274557
Ana
Manhattan
Hell’s Kitchen
40.7672
-73.9851
Entire home/apt
250
3
94
6/9/2019
0.96
1
-73.9905
-73.985
57740
Quiet & Clean Retreat in the City
275459
I
Manhattan
East Village
40.7301
57754
Stylish Large Gramercy Loft!
275578
R
Manhattan
Flatiron District
40.7403
0
3
Entire home/apt
239
3
7
5/24/2019
0.07
1
351
Entire home/apt
305
2
108
6/30/2019
1.09
1
201
57874
The Brownstone-Luxury 1 Bd Apt/NYC
276291
Simon
Manhattan
Harlem
40.8093
-73.9434
Entire home/apt
155
3
222
58059
PRIVATE Room on Historic Sugar Hill
277379
Agnes
Manhattan
Harlem
40.8251
-73.9429
Private room
60
1
458
6/26/2019
2.1
2
232
7/3/2019
4.58
2
258
58062
South Slope Green
277394
Linda
Brooklyn
Windsor Terrace
40.6585
-73.984
Private room
135
2
21
5/17/2019
0.26
1
272
58467
17 Flr. Manhattan Views, Nr. Subway
279797
Dave
Manhattan
Roosevelt Island
40.7619
-73.9501
Private room
120
7
17
5/8/2019
0.3
1
341
59014
Spacious 1BR, Adorable Clean Quiet
282927
Drica
Manhattan
Lower East Side
40.7205
-73.9859
Entire home/apt
150
3
59121
Nice, clean, safe, convenient 3BR
204539
Mark
Queens
Ridgewood
40.7041
-73.8993
Entire home/apt
140
14
59642
59709
59855
Franklin St Flat in Trendy Greenpoint Brooklyn
274782
Betty
Brooklyn
Greenpoint
40.734
-73.9597
Entire home/apt
135
2
Artistic, Cozy, and Spacious w/ Patio! Sleeps 5
186084
Ricardo & Ashlie
Manhattan
Chinatown
40.7176
-73.995
Entire home/apt
250
4
One bedroom Apt. in NYC
288031
Leslie
Manhattan
Midtown
40.7589
-73.9699
Entire home/apt
250
30
60164
Beautiful, elegant 3 bed SOHO loft
289653
Harrison
Manhattan
SoHo
60457
Spacious Greenwich Village Apt
99212
Jessica
Manhattan
Greenwich Village
4
41
1/2/2019
0.39
1
244
1
9/17/2012
0.01
5
365
69
1
12
7/1/2019
0.18
2
265
1/5/2016
0.78
1
0
94
6/23/2019
0.99
1
329
10
5/11/2019
0.1
1
18
82
5/19/2019
0.67
40.72
-74.0026
Entire home/apt
500
40.7319
-73.9947
Entire home/apt
225
5
Entire home/apt
125
28
183
9/29/2018
1.83
2
365
92
1
189
6/11/2019
1.82
5
253
91
60611
SpaHa Studio Monthly Rental
292204
Blanca
Manhattan
East Harlem
40.7916
-73.9457
60666
City Room – Private Luxury Suite
256161
Wayne
Manhattan
Harlem
40.8118
-73.9443
Private room
175
2
1
10/7/2018
0.11
1
365
99
2
127
6/20/2019
1.22
1
320
0.04
1
0
1.3
3
192
60673
Private Room/bath Luxurious Harlem
249372
Cynthia
Manhattan
Harlem
40.8158
-73.9471
Private room
60680
The gem of the East Village
292630
Mich
Manhattan
East Village
40.7265
-73.9805
Entire home/apt
60794
Bright and spacious, garden below!
293394
Rachel
Manhattan
Upper West Side
40.8002
-73.9607
Entire home/apt
195
60948
ACCOMMODATIONS GALORE #2
126607
Laurine
Manhattan
East Harlem
40.8094
-73.9394
Entire home/apt
140
61167
Colorful Private One Bedroom Apt
295760
Greta
Manhattan
Little Italy
40.7196
-73.9954
Entire home/apt
135
61224
Huge Chelsea Loft
291112
Frank
Manhattan
Chelsea
40.7436
-74.0003
Entire home/apt
500
61406
Great room in great location
297176
Bethania
Manhattan
Harlem
40.8034
-73.9575
61492
Exclusive Room with Private Bath in LES
297769
Tunji
Manhattan
Chinatown
40.7145
-73.9908
61509
Quiet, clean midtown apt w. elevato
23619
62095
BK Sweet Suite w/Kitchen&FullBath
281764
4
4
8/25/2017
3
135
6/20/2019
2
2
21
12/12/2015
0.2
1
0
35
7/27/2017
0.34
1
348
6/1/2019
2.21
2
0
6/23/2019
1.8
2
353
1
140
Private room
80
14
10
Private room
120
4
171
Anna/Fonzy
Manhattan
Midtown
40.7575
-73.969
Entire home/apt
110
200
92
4/30/2019
0.9
Colette&Sean
Brooklyn
East Flatbush
40.6445
-73.9503
Entire home/apt
65
3
238
6/14/2019
2.3
1
40.7268
-73.9908
Entire home/apt
130
50
56
5/26/2019
0.58
1
56
40.688
-73.9171
Entire home/apt
99
3
111
6/22/2019
2.13
1
68
360
62427
Great East Village Apartment Rental
303882
Brie
Manhattan
East Village
62430
BROWNSTONE SUNDRENCHED BEAUTY
197755
Sheila
Brooklyn
Bushwick
62452
A SpeciaL!! Private Room in NY
303939
Lissette
Staten Island
Tompkinsville
40.6354
-74.0854
Private room
36
2
193
6/25/2019
1.85
6
62461
B NYC Staten Alternative…
303939
Lissette
Staten Island
Tompkinsville
40.6363
-74.0854
Private room
37
2
147
6/10/2019
1.44
6
62787
C Private Room By The Ferry
303939
Lissette
Staten Island
Tompkinsville
40.6352
-74.0855
Private room
62891
Smallest House In The Village
306545
Olivia
Manhattan
East Village
40.7248
-73.9816
Entire home/apt
2
0
37
2
177
7/2/2019
1.71
6
320
175
3
185
5/24/2019
1.78
2
326
62903
Beautiful modern studio apartment in heart of NYC
306605
Daniel
Manhattan
Chelsea
40.7424
-73.9957
Entire home/apt
205
9
62
6/21/2019
0.7
2
76
62925
Beautiful Landmarked Duplex
306739
Maya
Brooklyn
Greenpoint
40.7295
-73.9551
Entire home/apt
285
3
124
6/16/2019
1.22
3
279
6/23/2019
1.77
63320
D Private Che@p Room 2 Explore NYC
303939
Lissette
Staten Island
Tompkinsville
40.6348
-74.0852
Private room
36
2
333
7/2/2019
3.19
6
340
63360
63299
Safe cute near subway& Manhattan NY NY retro style
BROOKLYN > Guest Room w/ Queen Bed in Williamsburg
307962
308875
Dennis & Naoko
Scott
Queens
Brooklyn
Astoria
Williamsburg
40.7538
40.7076
-73.9143
-73.9518
Entire home/apt
Private room
99
5
441
6/24/2019
4.5
1
226
2
365
63546
Large and Cozy Private Bedroom
308652
Antonín
Brooklyn
Kensington
40.6411
-73.9743
Private room
63573
Small tidy bedroom in duplex
310458
Emily
Brooklyn
Park Slope
40.6679
-73.9833
Private room
63588
LL3
295128
Carol Gloria
Bronx
Clason Point
40.8131
-73.8551
Private room
63610
DOMINIQUE’S NY mini efficiency* wifi*metro*quiet
310670
Vie
Bronx
Eastchester
40.8806
-73.8357
Entire home/apt
59
39
1
60
14
90
2
105
2
63657
Private, Large & Sunny Top Floor Apt w/W&D
170510
Renée
Brooklyn
Bedford-Stuyvesant
40.6824
-73.9431
Entire home/apt
135
63693
Cottage in the Village
306545
Olivia
Manhattan
East Village
40.7219
-73.9825
Entire home/apt
390
63719
BEDROOM1 FOR RENT 10min from Manhan
311286
Helene
Brooklyn
Bedford-Stuyvesant
63913
HOSTING YOUR SUNNY, SPACIOUS NYC ROOM
312288
Paula
Manhattan
Inwood
64000
Williamsburg near soho. / loftbed
312722
Kristian & Di
Brooklyn
Williamsburg
64015
Prime East Village 1 Bedroom
146944
David
Manhattan
East Village
60
17
40.7069
-73.9547
Private room
40.7281
-73.9859
Entire home/apt
200
Niya
Brooklyn
Crown Heights
40.6778
-73.9434
Private room
100
Helene
Brooklyn
Bedford-Stuyvesant
40.6832
-73.947
Private room
70
314256
Debbie
Brooklyn
Crown Heights
40.6761
-73.9529
Private room
110
Anthony
Brooklyn
Crown Heights
40.6759
-73.9516
Private room
Little Italy
14
1/7/2019
0.14
4
281
2
323
4
362
3
0
3
279
6/24/2019
2.69
1
301
18
1/2/2019
0.22
4
189
4
1
50
5/26/2019
3.55
1
0
2
227
6/27/2019
2.27
2
287
-73.9981
Entire home/apt
90
14
1
-73.9816
Private room
68
2
203
115
2
210
7/6/2019
75
5
64
1/5/2019
1
0
1/3/2019
0.15
1
231
152
65019
Charming UWS Treehouse Apt
317809
Claire
Manhattan
Upper West Side
40.7796
-73.981
Share a HOME – $75 for 1 bdrm/++ for 2 – Brooklyn
319092
Juhli
Brooklyn
Bedford-Stuyvesant
40.6828
-73.9526
Entire home/apt
Private room
1/2/2019
0.16
1
14
6/23/2019
1.96
2
86
2.1
1
261
0.67
1
65556
Room in S3rd/Bedford, Williamsburg
320422
Marlon
Brooklyn
Williamsburg
40.7137
-73.9626
Private room
60
3
0
65562
CHARMING EAST VILLAGE 2 (or 1) BR
320450
Mary D
Manhattan
East Village
40.7296
-73.9816
Entire home/apt
129
7
5
130
10
49
6/29/2019
0.48
1
4
132
7/7/2019
1.27
1
65615
Farmhouse Apartment in Williamsburg
320761
Valerie
Brooklyn
Williamsburg
40.7107
-73.9518
Entire home/apt
65660
Bright+Spacious Williamsburg Abode!
320538
Larissa
Brooklyn
Williamsburg
40.7086
-73.9464
Entire home/apt
65813
Suite Sugar Hill, Harlem, Private Rm in Hosted Apt
321756
Eric
Manhattan
Harlem
40.8289
-73.9431
Private room
65834
Beautiful 1 Bedroom Apt Park Slope
321934
Jessica
Brooklyn
Park Slope
40.6732
-73.9732
Entire home/apt
CHARMING CARROLL GARDENS APT.
322884
Melissa
Brooklyn
Carroll Gardens
40.6785
-73.9944
Entire home/apt
66026
Private Bedroom Brownstone Brooklyn
322716
Alex
Brooklyn
Crown Heights
40.6715
-73.9481
Private room
66251
East Village Loft with Piano & Patio
324460
Samir
Manhattan
East Village
40.7268
-73.9853
Entire home/apt
66275
Lower East Side Magic Room
314941
Tony
Manhattan
Lower East Side
66451
**Fantastic Williamsburg Apt**
325389
Luis Fernando
Brooklyn
Williamsburg
66718
West Harlem Home Base – Eco-Apt.
136227
Henning
Manhattan
66741
Charming Garden Apt in Park Slope
327673
Stefano
Brooklyn
0
6
60
40.717
40.7232
65268
66008
0
11
316
314582
East Village
349
365
2
2
0.41
313317
Manhattan
7
13
2.39
1.38
8/19/2018
0
311286
Manhattan
2
0.5
6/25/2019
6/19/2019
36
cozy bedroom in lovely garden apt
Tilly
0.09
6/27/2019
3
7
Crown Heights Garden Apt.
Edward
0.46
8/29/2016
0
70
75
BROOKLYN STUDIO APARTMENT
7310
5/16/2019
9
38
248
143
Private room
Private room
BEDROOM2 FOR RENT 10min from Manh
46978
45
2
5
-73.9539
64314
Amazing Sunny & Breezy Home In the Heart of NYC
15
-73.9263
64365
ENJOY Downtown NYC!!
2
40.685
64107
64707
181
40.8665
64277
64837
2
40.719
-73.9939
Private room
40.7103
-73.9583
Entire home/apt
95
75
175
68
46
3
20
1/2/2019
0.26
1
364
2
11
5/2/2013
0.11
1
246
190
3
1
288
49
21
15
6/30/2019
0.15
5
331
212
3
67
6/25/2019
1.31
1
51
1
109
6/23/2019
1.11
3
364
9
2/16/2019
0.11
1
254
95
140
Harlem
40.8132
-73.9531
Entire home/apt
135
Park Slope
40.6773
-73.9823
Entire home/apt
150
66974
Lovely, Modern, Garden Apartment
329436
Jana
Brooklyn
Gowanus
40.6808
-73.9896
Entire home/apt
67288
Central Park 1BR sunny condo
101597
Per
Manhattan
East Harlem
-73.949
Entire home/apt
2
51
7/1/2019
0.57
6
187
6/23/2019
1.87
1
189
2
214
6/23/2019
2.08
2
263
190
3
69
7/1/2019
0.79
2
258
124
28
22
6/15/2019
0.26
1
103
67299
Cozy Garden Apartment in Williamsburg
330347
Adrienne
Brooklyn
Williamsburg
40.7149
-73.9628
Entire home/apt
135
30
56
5/6/2019
0.56
1
42
67397
SoHa comfort-by NW Central Park!
332189
Elise
Manhattan
Morningside Heights
40.8039
-73.9584
Private room
122
3
93
6/22/2019
0.93
1
246
40.796
68099
Cozy room in Upper West Side
323517
Deda
Manhattan
Upper West Side
40.8008
-73.9652
Private room
109
1
104
6/25/2019
1.05
2
364
68305
Cozy Private Room in Apartment
338454
Share
Manhattan
Harlem
40.8298
-73.9487
Private room
85
30
64
7/6/2018
0.68
1
318
68403
The Cozy Brownstone Inn (discount)!
240427
Naimah
Brooklyn
Bedford-Stuyvesant
68735
Prewar Penthouse w Private Terrace
342054
Violetta
Manhattan
Upper West Side
40.683
-73.9198
Entire home/apt
145
3
127
6/24/2019
1.25
2
72
40.7897
-73.9729
Entire home/apt
195
11
30
6/13/2019
0.32
1
249
6/27/2019
1.34
3
272
11/13/2016
0.1
1
325
298
68765
Designer 2.5 BR Loft in Carroll Gardens by Subway
282655
Jenna
Brooklyn
Carroll Gardens
40.6782
-73.995
68900
Bright Beautiful Brooklyn
343250
Jason
Brooklyn
Greenpoint
40.7312
-73.9558
40.7194
-73.9963
Entire home/apt
40.78
-73.9825
Entire home/apt
68974
Unique spacious loft on the Bowery
281229
Alicia
Manhattan
Little Italy
69894
Nice renovated apt, prime location!
352168
Silvia
Manhattan
Upper West Side
Entire home/apt
250
2
106
Private room
125
3
6
575
2
191
6/20/2019
1.88
1
150
30
48
6/11/2019
0.55
1
35
69921
Brooklyn Writer’s Nook
155689
Joab
Brooklyn
Bushwick
40.7051
-73.9192
Private room
70
5
47
6/29/2019
0.49
1
203
70095
Private Bedroom in Large NYC Apartment
353965
Mary And Geoff
Manhattan
Inwood
40.8671
-73.9281
Private room
90
2
120
6/30/2019
1.27
1
132
70128
Large, Sunny Room East Village NYC
354330
70609
Great Large 3 BR/2 Bath Duplex with Private Patio!
72062
Eyal
Manhattan
East Village
40.732
-73.9888
Private room
Bruce
Manhattan
East Village
40.7254
-73.9799
Entire home/apt
65
500
3
52
1/10/2019
0.63
1
5
2
48
6/16/2019
0.48
4
297
71010
All That Jazz. Uptown style on Sugar Hill.
361855
Kurt
Manhattan
Washington Heights
40.8349
-73.9387
Entire home/apt
250
3
32
5/24/2019
0.43
2
276
71248
Bright and lovely 1 bdrm apt in LES
363834
Jennifer
Manhattan
Chinatown
40.7166
-73.9895
Entire home/apt
125
25
43
6/17/2019
0.42
1
102
71366
Beautiful One Bed West Village – 4 Month Special
364955
Ruperto
Manhattan
West Village
71384
Gigantic Private Brooklyn Loft!
365153
Ben
Brooklyn
Greenpoint
71812
Condo Apartment with laundry in unit
369015
Thai
Bronx
Kingsbridge
Entire home/apt
200
30
39
40.729
-73.9555
Entire home/apt
229
1
50
5/13/2014
0.5
1
188
40.8721
40.7297
-73.9019
-74.0024
Entire home/apt
90
30
4
1/2/2019
0.35
2
346
Entire home/apt
110
13
38
2/15/2019
0.39
1
0
59
3
29
6/16/2019
0.36
1
15
72190
1BR: See Central Park from Terrace!
373085
Hudson
Manhattan
Upper West Side
40.7773
-73.9782
72265
Private room in cozy Greenpoint
340692
Vanessa
Brooklyn
Greenpoint
40.7265
-73.9534
Private room
40.7102
-73.961
Entire home/apt
195
40.719
-73.9597
Entire home/apt
169
74073
Food & Music Dream Apartment in Williamsburg
211877
Daniel
Brooklyn
Williamsburg
74240
French Garden cottage off Bedford
389924
Patty
Brooklyn
Williamsburg
74333
Alcove Studio w/ outdoor Patio Deck
331328
Amir
Manhattan
East Harlem
40.8089
-73.9399
74404
Luxury 3 bed/ 2 bath apt in Harlem w/ terrace
391325
G&S
Manhattan
Harlem
40.8028
-73.9567
4
1
6/25/2019
0.44
1
251
59
6/23/2019
0.6
1
71
68
6/7/2019
0.67
2
215
3
253
Entire home/apt
113
14
26
11/25/2015
0.27
Entire home/apt
250
14
31
8/22/2012
0.31
1
78
74680
One Bedroom Mini studio – Free WIFI
265109
Nazleen
Queens
Astoria
40.7764
-73.9343
Entire home/apt
115
2
198
5/31/2019
2.01
1
257
74860
Sunlit and Cozy Williamsburg/Greenpoint, Brooklyn
394752
Allison
Brooklyn
Greenpoint
40.7249
-73.9502
Private room
55
2
1
3/28/2011
0.01
1
75193
BROOKLYN > Guest Room w/ King Bed in Williamsburg
308875
75635
Scott
Brooklyn
Williamsburg
Patricia
Manhattan
Lower East Side
76761
Eveland the Place to Stay & Enjoy a 5-⭐
️2bdrm
118971
Evelyn
Brooklyn
77765
Bright Cozy Chinatown Studio Apt.
Superior @ Box House
401696
417504
The Box House HotelBrooklyn
40.714
-73.9576
Private room
40.7188
-73.9839
Entire home/apt
0
69
2
220
6/22/2019
2.17
2
8
150
3
286
6/27/2019
2.81
1
191
2
398
6/28/2019
3.97
3
182
3
36
7/1/2019
0.36
28
79
6/14/2019
0.36
1
49
2/5/2016
0.1
1
South Slope
40.6655
-73.9902
Entire home/apt
169
Greenpoint
40.7375
-73.9529
Private room
179
3
36
4
6
77936
Hells Kitchen Garden of Eden
134355
Moss Owen
Manhattan
Hell’s Kitchen
40.7625
-73.9913
Private room
150
78919
Historic House Boerum Hill, BK, NYC
422561
Nancy
Brooklyn
Boerum Hill
40.6867
-73.9888
Entire home/apt
135
0
79067
Lovely 3 bedroom in Italianate Brownstone w/garden
425506
Bliss
Brooklyn
Clinton Hill
40.6848
-73.9622
Entire home/apt
350
6
14
4/20/2019
0.3
1
156
79782
Williamsburg HUGE, PRIVATE BATH – Next to Train!
430188
Pam
Brooklyn
Williamsburg
40.7052
-73.9546
Private room
120
14
76
3/31/2019
0.76
6
343
Manhattan
2
182
200
80493
Cozy room in East Village with AC
434987
Jennifer
80684
Duplex w/ Terrace @ Box House Hotel
417504
The Box House HotelBrooklyn
East Village
40.7233
-73.9849
Private room
71
Greenpoint
40.7378
-73.9533
Private room
349
3
8
7/4/2019
1.81
1
3/27/2016
0.09
28
0.07
28
60
0.51
2
189
80700
Loft w/ Terrace @ Box House Hotel
417504
The Box House HotelBrooklyn
Greenpoint
40.7374
-73.9548
Private room
349
3
7
5/24/2019
80924
Spacious 3 Bedroom Duplex in Park Slope
438133
Ellis
Park Slope
40.6754
-73.9814
Entire home/apt
165
30
34
9/25/2018
Brooklyn
81739
Loft w/ Terrace @ Box House Hotel
417504
The Box House HotelBrooklyn
82549
Greenpoint
40.7384
-73.9531
Private room
249
3
Brooklyn Heights
40.6926
-73.9983
Private room
100
3
82550
Columbia Castle 2 BR
448312
Christopher
Brooklyn
Brooklyn Heights
40.6944
-73.9977
Entire home/apt
200
3
80
82638
Columbia Castle in Brooklyn Heights
Charming Artist’s Flat, East Village
448312
449787
Christopher
Sarah
Manhattan
East Village
40.724
-73.9837
Entire home/apt
169
4
240
Brooklyn
60
2
5/12/2011
0.02
28
66
9/16/2016
0.68
2
6/30/2019
0.85
2
106
6/6/2019
2.4
1
276
60
0
1
12:58 1
Done
Data Cleansing Scoring…
CAPELLA UNIVERSITY
Scoring Guide
Data Cleansing Scoring Guide
Due Date: End of Week 4
Percentage of Course Grade: 8%.
CRITERIA
NON-PERFORMANCE
BASIC
PROFICIENT
DISTINGUISHED
Describe methods for
working with raw data of
different types.
30%
Does not describe Describes methods
methods for working for working with raw
with raw data of data of different
different types.
types, but methods
are inappropriate for
the tasks.
Describes methods
for working with raw
data of different
types.
Describes methods
for working with raw
data of different
types, and methods
contribute to
successful quality
control checks.
Apply integration of
different types of data
cleansing.
30%
Does not apply
integration of
different types of
data cleansing.
Applies integration
of different types of
data cleansing.
Applies integration
of different types of
data cleansing, but
application or
integration is
incomplete.
Applies integration
of different types of
data cleansing and
provides relevant
strategies for data
cleansing.
Discuss personal
strengths and
weaknesses in working
with data sources.
30%
Does not discuss
personal strengths
and weaknesses in
working with data
sources
Discusses personal
strengths and
weaknesses in
working with data
sources but does
not discuss.
Discusses personal
strengths and
weaknesses in
working with data
sources.
Discusses personal
strengths and
weaknesses in
working with data
sources, and
identifies potential
areas for growth.
Organize content so
ideas flow logically with
smooth transitions.
10%
Does not
communicate to
stakeholders clearly
and succinctly.
Communicates to
stakeholders clearly
and succinctly.
Communicates to
stakeholders
somewhat clearly
and succinctly;
grammatical or
mechanical errors
and inconsistencies
obscure meaning.
Communicates to
stakeholders clearly
and succinctly;
writing is structured
locally and is free
from major
grammatical or
mechanical errors.
C
1