In [5]:
import pandas as pd
import os
os.chdir('../raw_data')
os.listdir('.')
data = pd.read_excel('Hack4Cause_Housing_BP_Issued_Phased_and_NonPhased_1.1.015_12.31.15(FINAL).xlsx', 'BP_Issued_NonPh_clean')
In [7]:
data
Out[7]:
log_yy
log_number
log_sequence
issued_date
scope_of_work_desc
proposed_usc
bpr_use_desc
proposed_units
neighborhood
x_coordinate
...
current_units
application_received_date
multiple_use_code
bpr_multiple_use_desc
project_name
address
maplot
EE_year_issued
EE_housingtype
EE_housingmixtype
0
14
3653
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1132
Apartment 1-4 Units
3
Northeast Neighbors
4248352.0
...
0
2014-06-27 14:22:06.790
NaN
NaN
Crescent Village Apts
3055 MELVILLE WAY, BLDG KK
1703162403700
2015
Two to Four units
Multi-family
1
14
3654
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1132
Apartment 1-4 Units
4
Northeast Neighbors
4248502.0
...
0
2014-06-27 14:22:17.500
NaN
NaN
Crescent Village Apts
2835 LONGFELLOW PL, BLDG HH
1703162403700
2015
Two to Four units
Multi-family
2
14
3655
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1132
Apartment 1-4 Units
3
Northeast Neighbors
4248628.0
...
0
2014-06-27 14:22:26.810
NaN
NaN
Crescent Village Apts
3040 SHADOW VIEW DR, BLDG DD
1703162403700
2015
Two to Four units
Multi-family
3
15
1817
1
2015-08-12
New Apt Bldg (3+ units)
1133
Apartment 5-19 Units
12
Northeast Neighbors
4246569.0
...
0
2015-04-17 12:25:25.877
NaN
NaN
Heritage Meadows Apts Ph II Bl
2523 LAKEVIEW DR
1703084406100
2015
Five or more units
Multi-family
4
15
1812
1
2015-08-12
New Apt Bldg (3+ units)
1133
Apartment 5-19 Units
12
Northeast Neighbors
4246570.0
...
0
2015-04-17 12:16:33.693
NaN
NaN
Heritage Meadows Apts Ph II, B
2535 LAKEVIEW DR
1703084406100
2015
Five or more units
Multi-family
5
15
930
1
2015-06-26
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
8
Northeast Neighbors
4246696.0
...
0
2015-02-23 16:28:41.693
NaN
NaN
Bascom Village II
3071 MATT DR
1703171100801
2015
Five or more units
Multi-family
6
15
933
1
2015-06-26
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
7
Northeast Neighbors
4246647.0
...
0
2015-02-23 16:29:10.943
NaN
NaN
Bascom Village II
3073 MATT DR
1703171100801
2015
Five or more units
Multi-family
7
15
934
1
2015-06-26
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
7
Northeast Neighbors
4246539.0
...
0
2015-02-23 16:29:20.270
NaN
NaN
Bascom Village II
3079 MATT DR
1703171100801
2015
Five or more units
Multi-family
8
15
935
1
2015-06-26
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
7
Northeast Neighbors
4246408.0
...
0
2015-02-23 16:29:33.120
NaN
NaN
Bascom Village II
3059 MATT DR
1703171100801
2015
Five or more units
Multi-family
9
14
3649
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
6
Northeast Neighbors
4248626.0
...
0
2014-06-27 14:21:22.480
NaN
NaN
Crescent View Apts
3020 SHADOW VIEW DR, BLDG EE
1703162403700
2015
Five or more units
Multi-family
10
14
3639
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248334.0
...
0
2014-06-27 14:18:29.397
NaN
NaN
Crescent Viillage Apts
2865 MELVILLE WAY, BLDG A
1703162403700
2015
Five or more units
Multi-family
11
14
3663
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248727.0
...
0
2014-06-27 14:23:29.497
NaN
NaN
Crescent Viillage Apts
2993 SHADOW VIEW DR, BLDG T
1703162403700
2015
Five or more units
Multi-family
12
14
3665
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
8
Northeast Neighbors
4248912.0
...
0
2014-06-27 14:23:43.960
NaN
NaN
Crescent Viillage Apts
2990 LONGFELLOW PL, BLDG V
1703162403700
2015
Five or more units
Multi-family
13
14
3669
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
10
Northeast Neighbors
4248754.0
...
0
2014-06-27 14:24:13.607
NaN
NaN
Crescent Viillage Apts
2940 KIPLING WAY, BLDG N
1703162403700
2015
Five or more units
Multi-family
14
14
3637
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
8
Northeast Neighbors
4248335.0
...
0
2014-06-27 14:18:07.870
NaN
NaN
Crescent Village Apts
2845 MELVILLE WAY, BLDG C
1703162403700
2015
Five or more units
Multi-family
15
14
3638
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
6
Northeast Neighbors
4248332.0
...
0
2014-06-27 14:18:20.237
NaN
NaN
Crescent Village Apts
2815 MELVILLE WAY, BLDG B
1703162403700
2015
Five or more units
Multi-family
16
14
3640
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
8
Northeast Neighbors
4248555.0
...
0
2014-06-27 14:18:35.810
NaN
NaN
Crescent Village Apts
2870 SHADOW VIEW DR, BLDG D
1703162403700
2015
Five or more units
Multi-family
17
14
3641
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248566.0
...
0
2014-06-27 14:18:41.037
NaN
NaN
Crescent Village Apts
2924 SHADOW VIEW DR, BLDG F
1703162403700
2015
Five or more units
Multi-family
18
14
3642
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
11
Northeast Neighbors
4248560.0
...
0
2014-06-27 14:19:35.000
NaN
NaN
Crescent Village Apts
2910 SHADOW VIEW DR, BLDG E
1703162403700
2015
Five or more units
Multi-family
19
14
3643
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
8
Northeast Neighbors
4248337.0
...
0
2014-06-27 14:20:08.333
NaN
NaN
Crescent Village Apts
2935 MELVILLE WAY, BLDG M
1703162403700
2015
Five or more units
Multi-family
20
14
3644
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248349.0
...
0
2014-06-27 14:20:16.340
NaN
NaN
Crescent Village Apts
2965 MELVILLE WAY, BLDG L
1703162403700
2015
Five or more units
Multi-family
21
14
3646
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248567.0
...
0
2014-06-27 14:20:50.987
NaN
NaN
Crescent Village Apts
2962 SHADOW VIEW DR, BLDG G
1703162403700
2015
Five or more units
Multi-family
22
14
3647
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
11
Northeast Neighbors
4248558.0
...
0
2014-06-27 14:21:06.120
NaN
NaN
Crescent Village Apts
2876 LONGFELLOW PL, BLDG H
1703162403700
2015
Five or more units
Multi-family
23
14
3650
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
6
Northeast Neighbors
4248561.0
...
0
2014-06-27 14:21:36.207
NaN
NaN
Crescent Village Apts
2875 LONGFELLOW PL, BLDG FF
1703162403700
2015
Five or more units
Multi-family
24
14
3651
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248424.0
...
0
2014-06-27 14:21:45.040
NaN
NaN
Crescent Village Apts
2825 LONGFELLOW PL, BLDG GG
1703162403700
2015
Five or more units
Multi-family
25
14
3652
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
5
Northeast Neighbors
4248348.0
...
0
2014-06-27 14:21:54.340
NaN
NaN
Crescent Village Apts
3015 MELVILLE WAY, BLDG JJ
1703162403700
2015
Five or more units
Multi-family
26
14
3656
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
9
Northeast Neighbors
4248761.0
...
0
2014-06-27 14:22:37.033
NaN
NaN
Crescent Village Apts
2915 LONGFELLOW PL, BLDG Z
1703162403700
2015
Five or more units
Multi-family
27
14
3657
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
8
Northeast Neighbors
4248747.0
...
0
2014-06-27 14:22:46.610
NaN
NaN
Crescent Village Apts
3025 SHADOW VIEW DR, BLDG AA
1703162403700
2015
Five or more units
Multi-family
28
14
3658
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
6
Northeast Neighbors
4248903.0
...
0
2014-06-27 14:22:54.630
NaN
NaN
Crescent Village Apts
2975 LONGFELLOW PL, BLDG CC
1703162403700
2015
Five or more units
Multi-family
29
14
3659
1
2015-05-22
New Apt Bldg (3+ units) / Mixed Use
1133
Apartment 5-19 Units
6
Northeast Neighbors
4248880.0
...
0
2014-06-27 14:23:01.870
NaN
NaN
Crescent Village Apts
2955 LONGFELLOW PL, BLDG BB
1703162403700
2015
Five or more units
Multi-family
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
257
15
5607
1
2015-12-15
New Single Family Dwelling
1111
Single Family Dwelling
1
Laurel Hill Valley Citizens
4253250.0
...
0
2015-09-17 14:09:52.173
NaN
NaN
NaN
3655 SNOWBERRY RD
1803033103300
2015
Single Family Detached
Single Family
258
15
5612
1
2015-10-05
New Single Family Dwelling
1111
Single Family Dwelling
1
Unknown
NaN
...
0
2015-09-18 10:34:14.300
NaN
NaN
NaN
877 OAKWAY RD
1703204305802
2015
Single Family Detached
Single Family
259
15
5730
1
2015-11-04
New Single Family Dwelling
1111
Single Family Dwelling
1
Northeast Neighbors
4242909.0
...
0
2015-09-22 16:06:13.130
NaN
NaN
NaN
3857 NICOLE WAY
1703082306800
2015
Single Family Detached
Single Family
260
15
5831
1
2015-10-19
New Single Family Dwelling
1111
Single Family Dwelling
1
River Road Community Organization
4225164.0
...
0
2015-09-25 13:35:08.007
NaN
NaN
NaN
1910 DEBRA SUE CT
1704151414100
2015
Single Family Detached
Single Family
261
15
5868
1
2015-12-01
New Single Family Dwelling
1111
Single Family Dwelling
1
Laurel Hill Valley Citizens
4253150.0
...
0
2015-09-28 14:31:47.750
NaN
NaN
NaN
3635 SNOWBERRY RD
1803033103100
2015
Single Family Detached
Single Family
262
15
6014
1
2015-11-23
New Single Family Dwelling
1111
Single Family Dwelling
1
Cal Young Neighborhood Association
4245786.0
...
0
2015-10-02 14:06:32.847
NaN
NaN
NaN
2365 PIONEER PIKE
1703204406100
2015
Single Family Detached
Single Family
263
15
6031
1
2015-10-22
New Single Family Dwelling
1111
Single Family Dwelling
1
Northeast Neighbors
4246400.0
...
0
2015-10-05 10:02:01.223
NaN
NaN
NaN
3055 GUADALUPE WAY
1703171112100
2015
Single Family Detached
Single Family
264
15
6033
1
2015-10-22
New Single Family Dwelling
1111
Single Family Dwelling
1
Northeast Neighbors
4246442.0
...
0
2015-10-05 10:17:00.280
NaN
NaN
NaN
3059 GUADALUPE WAY
1703171112000
2015
Single Family Detached
Single Family
265
15
6089
1
2015-10-16
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4231356.0
...
0
2015-10-06 11:31:30.930
NaN
NaN
NaN
544 WEDGEWOOD DR
1704122016400
2015
Single Family Detached
Single Family
266
15
6090
1
2015-10-16
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4231454.0
...
0
2015-10-06 11:36:29.290
NaN
NaN
NaN
546 WEDGEWOOD DR
1704122016300
2015
Single Family Detached
Single Family
267
15
6216
1
2015-10-19
New Single Family Dwelling
1111
Single Family Dwelling
1
Friendly Area Neighbors
4236422.0
...
0
2015-10-12 11:07:39.770
NaN
NaN
NaN
2384 MONROE ST
1803062311300
2015
Single Family Detached
Single Family
268
15
6326
1
2015-11-24
New Single Family Dwelling
1111
Single Family Dwelling
1
Cal Young Neighborhood Association
4243703.0
...
0
2015-10-16 10:47:57.460
NaN
NaN
NaN
871 OAKWAY RD
1703204305803
2015
Single Family Detached
Single Family
269
15
6362
1
2015-11-12
New Single Family Dwelling
1111
Single Family Dwelling
1
River Road Community Organization
4225223.0
...
0
2015-10-19 13:35:28.900
NaN
NaN
NaN
1906 DEBRA SUE CT
1704151414200
2015
Single Family Detached
Single Family
270
15
6460
1
2015-12-11
New Single Family Dwelling
1111
Single Family Dwelling
1
Laurel Hill Valley Citizens
4253611.0
...
0
2015-10-22 13:50:13.907
NaN
NaN
NaN
2611 CASCARA DR
1803033104000
2015
Single Family Detached
Single Family
271
15
6468
1
2015-11-04
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4231923.0
...
0
2015-10-22 16:27:57.660
NaN
NaN
NaN
541 SILVER MEADOWS DR
1704122012500
2015
Single Family Detached
Single Family
272
15
6585
1
2015-12-04
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4225216.0
...
0
2015-10-27 12:13:28.197
NaN
NaN
NaN
4355 HYACINTH ST
1704031100238
2015
Single Family Detached
Single Family
273
15
6595
1
2015-11-16
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4231094.0
...
0
2015-10-27 14:50:06.063
NaN
NaN
NaN
514 WEDGEWOOD DR
1704111111900
2015
Single Family Detached
Single Family
274
15
6646
1
2015-11-19
New Single Family Dwelling
1111
Single Family Dwelling
1
Unknown
NaN
...
0
2015-10-28 16:45:26.980
NaN
NaN
NaN
3838 STERLING WOODS DR
1703082306700
2015
Single Family Detached
Single Family
275
15
6757
1
2015-12-10
New Single Family Dwelling
1111
Single Family Dwelling
1
Northeast Neighbors
4246547.0
...
0
2015-11-03 14:11:21.627
NaN
NaN
NaN
3071 GUADALUPE WAY
1703171111700
2015
Single Family Detached
Single Family
276
15
6818
1
2015-11-19
New Single Family Dwelling
1111
Single Family Dwelling
1
Southeast Neighbors
4240636.0
...
0
2015-11-05 12:03:36.680
NaN
NaN
NaN
474 E 53RD AVE
1803173303300
2015
Single Family Detached
Single Family
277
15
7076
1
2015-12-09
New Single Family Dwelling
1111
Single Family Dwelling
1
River Road Community Organization
4226090.0
...
0
2015-11-17 15:13:00.430
NaN
NaN
NaN
951 PENNINGTON CT
1704143208300
2015
Single Family Detached
Single Family
278
15
7077
1
2015-12-09
New Single Family Dwelling
1111
Single Family Dwelling
1
River Road Community Organization
4225994.0
...
0
2015-11-17 15:19:35.183
NaN
NaN
NaN
963 PENNINGTON CT
1704143208100
2015
Single Family Detached
Single Family
279
15
7097
1
2015-12-09
New Single Family Dwelling
1111
Single Family Dwelling
1
River Road Community Organization
4224497.0
...
0
2015-11-18 12:46:42.110
NaN
NaN
NaN
1891 ALLEA DR
1704154103000
2015
Single Family Detached
Single Family
280
15
7104
1
2015-12-11
New Single Family Dwelling
1111
Single Family Dwelling
1
Cal Young Neighborhood Association
4242902.0
...
0
2015-11-18 15:02:56.097
NaN
NaN
NaN
1934 LEMMING AVE
1703173414300
2015
Single Family Detached
Single Family
281
15
7138
1
2015-12-28
New Single Family Dwelling
1111
Single Family Dwelling
1
Laurel Hill Valley Citizens
4253199.0
...
0
2015-11-20 09:16:35.343
NaN
NaN
NaN
3645 SNOWBERRY RD
1803033103200
2015
Single Family Detached
Single Family
282
15
7190
1
2015-12-11
New Single Family Dwelling
1111
Single Family Dwelling
1
River Road Community Organization
4226473.0
...
0
2015-11-23 14:43:07.463
NaN
NaN
NaN
907 PENNINGTON CT
1704143205300
2015
Single Family Detached
Single Family
283
15
7208
1
2015-12-22
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4226759.0
...
0
2015-11-24 09:55:59.563
NaN
NaN
NaN
3740 PATRICIA ST
1704023210500
2015
Single Family Detached
Single Family
284
15
7210
1
2015-12-29
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4231375.0
...
0
2015-11-24 09:58:19.723
NaN
NaN
NaN
543 WEDGEWOOD DR
1704122015900
2015
Single Family Detached
Single Family
285
15
7284
1
2015-12-29
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4231265.0
...
0
2015-11-30 15:33:28.063
NaN
NaN
NaN
528 WEDGEWOOD DR
1704122016800
2015
Single Family Detached
Single Family
286
15
7368
1
2015-12-18
New Single Family Dwelling
1111
Single Family Dwelling
1
Santa Clara Community Organization
4222017.0
...
0
2015-12-03 11:06:47.243
NaN
NaN
NaN
3490 CABERNET LN
1704102111500
2015
Single Family Detached
Single Family
287 rows × 24 columns
In [ ]:
import sqlalchemy
engine = sqlalchemy
Content source: civiclee/Hack4Cause2017
Similar notebooks: