In [1]:
import numpy as np, pandas as pd
In [2]:
data14 = pd.read_csv("open_charters_merged_2014.csv", encoding = "latin1")
/Users/shiji/anaconda/lib/python3.5/site-packages/IPython/core/interactiveshell.py:2717: DtypeWarning: Columns (14,109,112,115,132,175) have mixed types. Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
In [3]:
dataUrl = pd.read_csv("charter_URLs_2014_rev.csv", encoding = "latin1")
In [4]:
dataUrl_nec = dataUrl[['TRUE_URL', 'CONFIRMED_CLOSED', 'SCH_NAME', 'OLD_URL', 'SHARED_URL']]
In [19]:
result1 = pd.merge(data14, dataUrl_nec, on = ["SCH_NAME"])
In [20]:
result1
Out[20]:
SURVYEAR
FIPST
STABR
STATENAME
SEANAME
LEAID
ST_LEAID
LEA_NAME
SCHID
ST_SCHID
...
LSTREET216
LSTREET316
LCITY16
LSTATE16
LZIP16
ADDRESS16
TRUE_URL
CONFIRMED_CLOSED
OLD_URL
SHARED_URL
0
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200001.0
31
Lower Kuskokwim School District
329.0
319010
...
NaN
NaN
Bethel
AK
99559.0
1010 Fourth Avenue, Bethel AK 99559
https://education.alaska.gov/DOE_Rolodex/Schoo...
0
http://sites.lksdonline.org/ayaprun/
0
1
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200150.0
25
Ketchikan Gateway Borough School District
306.0
259010
...
NaN
NaN
Ketchikan
AK
99901.0
410 Schoenbar, Ketchikan AK 99901
https://www.kgbsd.org/ketchikancharter
0
http://www.kgbsd.org/ketchikancharter
0
2
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200150.0
25
Ketchikan Gateway Borough School District
523.0
259020
...
NaN
NaN
Ketchikan
AK
99901.0
410 Schoenbar Road, Ketchikan AK 99901
http://www.tongassschool.org/
0
http://www.tongassschool.org/
0
3
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
172.0
59010
...
NaN
NaN
Anchorage
AK
99517.0
1705 W 32nd Ave, Anchorage AK 99517
https://aquarian.asdk12.org/
0
http://aquarian.asdk12.org
0
4
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
178.0
56010
...
NaN
NaN
Anchorage
AK
99503.0
401 E Fireweed Lane Suite 100, Anchorage AK 99503
https://education.alaska.gov/DOE_Rolodex/Schoo...
0
http://www.fpcs.net/
0
5
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
459.0
59070
...
NaN
NaN
Anchorage
AK
99508.0
4802 Bryn MAWR Court, Anchorage AK 99508
http://www.winterberrycharterschool.com/
0
http://www.winterberryschool.org/
0
6
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
460.0
59080
...
NaN
NaN
Eagle River
AK
99577.0
10901 Mausel St Suite 101, Eagle River AK 99577
http://www.asdk12.org/aboutschools/eagleacademy/
0
http://www.eagleacademycharterschool.com/
0
7
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
530.0
59050
...
NaN
NaN
Anchorage
AK
99503.0
400 W Northern Lights Blvd #9, Anchorage AK 99503
http://www.frontiercs.org/
0
http://www.frontierk12.org/
0
8
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
555.0
59060
...
NaN
NaN
Anchorage
AK
99504.0
5530 E Northern Lights Suite 1, Anchorage AK 9...
http://highlandacademy.asdk12.org/
0
http://www.highlandtech.org/
0
9
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
732.0
59090
...
NaN
NaN
Anchorage
AK
99507.0
650 W International Airport Rd, Anchorage AK 9...
https://education.alaska.gov/DOE_Rolodex/Schoo...
0
http://www.rilkeschule.org/
0
10
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200180.0
5
Anchorage School District
736.0
59100
...
NaN
NaN
Anchorage
AK
99504.0
550 Bragaw Street, Anchorage AK 99504
http://anccs.asdk12.org/
0
http://www.asdk12.org/schools/anccs/pages/
0
11
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200210.0
22
Juneau Borough School District
268.0
229010
...
NaN
NaN
Juneau
AK
99801.0
430 Fourth Street, Juneau AK 99801
http://juneaucharterschool.org/
0
http://www.jsd.k12.ak.us/jccs
0
12
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200390.0
24
Kenai Peninsula Borough School District
274.0
249010
...
NaN
NaN
Kenai
AK
99611.0
705 Frontage Rd Suite A, Kenai AK 99611
https://education.alaska.gov/DOE_Rolodex/Schoo...
0
http://auroraborealis.blogs.kpbsd.k12.ak.us/
0
13
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200390.0
24
Kenai Peninsula Borough School District
296.0
249030
...
NaN
NaN
Homer
AK
99603.0
995 Soundview Ave, Homer AK 99603
http://fireweedacademy.blogs.kpbsd.k12.ak.us/
0
http://fireweedacademy.blogs.kpbsd.k12.ak.us/
0
14
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200390.0
24
Kenai Peninsula Borough School District
448.0
249040
...
NaN
NaN
Soldotna
AK
99669.0
162 E Park Street, Soldotna AK 99669
http://soldotnaelementary.blogs.kpbsd.k12.ak.us/
0
http://soldotnamontessori.blogs.kpbsd.k12.ak.us/
0
15
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200390.0
24
Kenai Peninsula Borough School District
463.0
249050
...
NaN
NaN
Kenai
AK
99611.0
549 N Forest Dr, Kenai AK 99611
http://kaleidoscope.blogs.kpbsd.k12.ak.us/
0
http://www.kaleidoscope.school.8m.com/index.html
0
16
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200510.0
33
Matanuska-Susitna Borough School District
311.0
339010
...
NaN
NaN
Palmer
AK
99645.0
801 East Arctic, Palmer AK 99645
https://www.matsuk12.us/acc
0
http://www.matsuk12.us/acc
0
17
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200510.0
33
Matanuska-Susitna Borough School District
312.0
339020
...
NaN
NaN
Wasilla
AK
99623.0
7362 W Parks #714, Wasilla AK 99623
http://www.midnightsunschool.com/
0
http://www.mnc.matsuk12.us/
0
18
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200510.0
33
Matanuska-Susitna Borough School District
452.0
337050
...
NaN
NaN
Wasilla
AK
99623.0
7362 W Parks Hwy #723, Wasilla AK 99623
http://www.matsuk12.us/amc
0
http://www.matsuk12.us/amc
0
19
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200510.0
33
Matanuska-Susitna Borough School District
469.0
339030
...
NaN
NaN
Wasilla
AK
99654.0
141 E Seldon Road Suite C, Wasilla AK 99654
http://twindlybridge.us/
0
http://www.freewebs.com/twindlybridgechartersc...
0
20
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200510.0
33
Matanuska-Susitna Borough School District
740.0
339040
...
NaN
NaN
Wasilla
AK
99654.0
7010 E Bogard Road, Wasilla AK 99654
https://www.matsuk12.us/frc
0
http://www.matsuk12.us/frc
0
21
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200510.0
33
Matanuska-Susitna Borough School District
744.0
339050
...
NaN
NaN
Palmer
AK
99645.0
7101 E Palmer Wasilla Highway, Palmer AK 99645
http://www.birchtreecharterschool.org/
0
http://www.birchtreecharterschool.org/
0
22
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200570.0
35
Nome Public Schools
323.0
359010
...
NaN
NaN
Nome
AK
99762.0
Mile 3.5 Nome-Teller Highway, Nome AK 99762
http://nome.nosd.schoolaccess.net/~acsa/
0
http://nome.nosd.schoolaccess.net/~acsa/
0
23
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200600.0
16
Fairbanks North Star Borough School District
162.0
169010
...
NaN
NaN
Fairbanks
AK
99701.0
3002 International Street, Fairbanks AK 99701
https://www.k12northstar.org/chinook
0
http://www.k12northstar.org/chinook
0
24
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200600.0
16
Fairbanks North Star Borough School District
462.0
169030
...
NaN
NaN
North Pole
AK
99705.0
2945 Monk Court, North Pole AK 99705
https://www.k12northstar.org/starofthenorth
0
http://www.k12northstar.org/starofthenorth
0
25
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200600.0
16
Fairbanks North Star Borough School District
464.0
169040
...
NaN
NaN
Fairbanks
AK
99709.0
601 Loftus Road, Fairbanks AK 99709
http://ekc.k12northstar.org/
0
http://www.k12northstar.org/effiekokrine
0
26
2014-2015
2.0
AK
ALASKA
Alaska Department of Education and Early Devel...
200600.0
16
Fairbanks North Star Borough School District
742.0
169050
...
NaN
NaN
Fairbanks
AK
99709.0
4975 Decathlon Avenue, Fairbanks AK 99709
0
0
http://www.watershedhs.org/
0
27
2014-2015
4.0
AZ
ARIZONA
Arizona Department of Education
400001.0
4244
Cave Creek Unified District
616.0
5136
...
NaN
NaN
Scottsdale
AZ
85266.0
27880 N. 64th Street, Scottsdale AZ 85266
http://www.ccusd93.org/desertsunes
0
http://www.ccusd93.org/desertsunes
0
28
2014-2015
4.0
AZ
ARIZONA
Arizona Department of Education
400001.0
4244
Cave Creek Unified District
1872.0
78912
...
NaN
NaN
Cave Creek
AZ
85331.0
4322 E Desert Willow Parkway, Cave Creek AZ 8...
http://dwe.vail.k12.az.us/
0
http://dwe.vail.k12.az.us/
0
29
2014-2015
4.0
AZ
ARIZONA
Arizona Department of Education
400001.0
4244
Cave Creek Unified District
1872.0
78912
...
NaN
NaN
Cave Creek
AZ
85331.0
4322 E Desert Willow Parkway, Cave Creek AZ 8...
https://www.ccusd93.org/Page/19
0
http://www.ccusd93.org/desertwillowes
0
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
6819
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515330.0
5901
Verona Area School District
2849.0
150
...
NaN
NaN
Fitchburg
WI
53711.0
5830 Devoro Rd, Fitchburg WI 53711
http://vaisverona.org/
0
http://www.vaisverona.org/
0
6820
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515330.0
5901
Verona Area School District
2919.0
410
...
NaN
NaN
Verona
WI
53593.0
400 N Main St, Verona WI 53593
http://theexplorationacademy.org/
0
http://theexplorationacademy.org/contact-us/
0
6821
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515360.0
5985
Viroqua Area School District
1936.0
410
...
NaN
NaN
Viroqua
WI
54665.0
100 Blackhawk Dr, Viroqua WI 54665
https://laurelcharter.wordpress.com/
0
https://k12.niche.com/laurel-high-school-viroq...
0
6822
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515360.0
5985
Viroqua Area School District
2513.0
9407
...
NaN
NaN
Viroqua
WI
54665.0
100 Blackhawk Dr, Viroqua WI 54665
https://sites.google.com/viroquablackhawk.org/...
0
http://www.greatschools.org/wisconsin/viroqua/...
0
6823
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515360.0
5985
Viroqua Area School District
2972.0
140
...
NaN
NaN
Viroqua
WI
54665.0
115 N Education Ave, Viroqua WI 54665
http://www.viroqua.k12.wi.us/
0
www.viroqua.k12.wi.us
0
6824
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515750.0
6125
Watertown Unified School District
2981.0
430
...
NaN
NaN
Watertown
WI
53098.0
825 Endeavour Dr, Watertown WI 53098
http://endeavorhighschool.org/
0
www.endeavorcharterschool.com
0
6825
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515780.0
6174
Waukesha School District
2023.0
400
...
NaN
NaN
Waukesha
WI
53186.0
114 S Charles St, Waukesha WI 53186
https://sdw.waukesha.k12.wi.us/randalles
0
http://waukeshastemacademy.weebly.com/
0
6826
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515780.0
6174
Waukesha School District
2502.0
490
...
NaN
NaN
Waukesha
WI
53186.0
1150 Whiterock Ave, Waukesha WI 53186
https://sdw.waukesha.k12.wi.us/East
0
NaN
0
6827
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515780.0
6174
Waukesha School District
2688.0
430
...
NaN
NaN
Waukesha
WI
53186.0
401 E Roberta Ave, Waukesha WI 53186
http://www.edlinesites.net/pages/Waukesha_Engi...
0
https://www.waukesha.k12.wi.us/AboutUs.aspx
1
6828
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515780.0
6174
Waukesha School District
3003.0
150
...
NaN
NaN
Waukesha
WI
53186.0
222 Maple Ave, Waukesha WI 53186
http://www.eachieve.com/
0
www.eachieve.com
0
6829
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515780.0
6174
Waukesha School District
3334.0
450
...
NaN
NaN
Waukesha
WI
53186.0
401 E Roberta Ave, Waukesha WI 53186
http://www.edlinesites.net/pages/Waukesha_Engi...
0
http://www.waukeshasouth.com/
1
6830
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515780.0
6174
Waukesha School District
3380.0
470
...
NaN
NaN
Waukesha
WI
53186.0
222 Maple Ave, Waukesha WI 53186
http://www.eachieve.com/
0
http://www.eachieve.com/
0
6831
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515870.0
6216
Waupun School District
2903.0
0150
...
NaN
NaN
Fox Lake
WI
53933.0
200 S Depot St, Fox Lake WI 53933
http://www.waupun.k12.wi.us/sages
0
http://www.waupun.k12.wi.us/sages/
0
6832
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515900.0
6223
Wausau School District
2629.0
0150
...
NaN
NaN
Wausau
WI
54403.0
3101 N 13th St, Wausau WI 54403
http://montessori.wausauschools.org/
0
http://montessori.wausauschools.org/
0
6833
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515900.0
6223
Wausau School District
2747.0
0400
...
NaN
NaN
Wausau
WI
54403.0
2607 N 18th St, Wausau WI 54403
http://eea.wausauschools.org/
0
http://eea.wausauschools.org/
0
6834
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515900.0
6223
Wausau School District
2826.0
0410
...
NaN
NaN
Wausau
WI
54403.0
2607 N 18th St, Wausau WI 54403
http://www.wausauegl.org/
0
http://www.wausauegl.org/
0
6835
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515990.0
6244
Wauwatosa School District
2728.0
0150
...
NaN
NaN
Wauwatosa
WI
53213.0
1060 N Glenview Ave, Wauwatosa WI 53213
http://www.wstem.org/
0
http://www.wstem.org/
0
6836
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5515990.0
6244
Wauwatosa School District
2921.0
0430
...
NaN
NaN
Wauwatosa
WI
53226.0
12121 W North Ave, Wauwatosa WI 53226
http://wauwatosavirtualacademy.com/about-us/
0
http://wauwatosavirtualacademy.com/
0
6837
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5516260.0
6300
West Allis-West Milwaukee School District
2918.0
0410
...
NaN
NaN
West Allis
WI
53227.0
9004 W Lincoln Ave, West Allis WI 53227
http://sharedjourneys.wawm.k12.wi.us/
0
http://www.sharedjourneyswawm.com/
0
6838
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5516290.0
6307
West Bend School District
2953.0
0430
...
NaN
NaN
West Bend
WI
53095.0
1043 S Main St, West Bend WI 53095
http://www.west-bend.k12.wi.us/pcs/
0
http://www.pathwayscharter.org/
0
6839
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5516320.0
6328
West De Pere School District
2752.0
0400
...
Ste W
NaN
De Pere
WI
54115.0
400 Reid St Ste W, De Pere WI 54115
http://www.wdpsd.com/phantomknight
0
http://www.wdpsd.com/phantomknight/
0
6840
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5516500.0
6384
Weyauwega-Fremont School District
2523.0
9408
...
NaN
NaN
Weyauwega
WI
54983.0
310 E Main St, Weyauwega WI 54983
http://www.wegafremont.k12.wi.us/
0
http://www.greatschools.org/wisconsin/weyauweg...
0
6841
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5516680.0
6461
Whitewater Unified School District
2180.0
0080
...
NaN
NaN
Whitewater
WI
53190.0
242 S Prince St, Whitewater WI 5319
http://www.lincs.wwusd.org/
0
http://www.lincs.wwusd.org/
0
6842
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5516680.0
6461
Whitewater Unified School District
2901.0
9803
...
Ste 205
NaN
Whitewater
WI
53190.0
1221 Innovation Dr Ste 205, Whitewater WI 5319
http://www.jedivirtual.org/
0
http://www.jedivirtual.org/
0
6843
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5517070.0
6685
Wisconsin Rapids School District
2212.0
0220
...
NaN
NaN
Rudolph
WI
54475.0
6950 Knowledge Ave, Rudolph WI 54475
http://www.wrps.org/schools/think/
0
http://www.wrps.org/schools/think/
0
6844
2014-2015
55.0
WI
WISCONSIN
Wisconsin Dept of Public Instruction
5517070.0
6685
Wisconsin Rapids School District
2781.0
0170
...
NaN
NaN
Wisconsin Rapids
WI
54495.0
241 17th Ave S, Wisconsin Rapids WI 54495
http://www.wrps.org/schools/mead/
0
http://www.wrps.org/schools/mead/index.cfm
0
6845
2014-2015
56.0
WY
WYOMING
Wyoming Department of Education
5600730.0
0101000
Albany County School District #1
216.0
0101001
...
NaN
NaN
Laramie
WY
82070.0
4037 Grand Avenue, Laramie WY 8207
http://www.snowyrangeacademy.org/
0
http://www.snowyrangeacademy.org/
0
6846
2014-2015
56.0
WY
WYOMING
Wyoming Department of Education
5600730.0
0101000
Albany County School District #1
542.0
0101031
...
NaN
NaN
Laramie
WY
82070.0
365 West Grand Avenue, Laramie WY 8207
http://www.laramiemontessori.org/
0
http://www.laramiemontessori.org/
0
6847
2014-2015
56.0
WY
WYOMING
Wyoming Department of Education
5600960.0
0738000
Fremont County School District #38
367.0
0738055
...
NaN
NaN
Arapahoe
WY
82510.0
445 Little Wind River Bottom R, Arapahoe WY 8251
https://www.trulia.com/schools/WY-riverton-ara...
0
http://www.usnews.com/education/best-high-scho...
0
6848
2014-2015
56.0
WY
WYOMING
Wyoming Department of Education
5601980.0
1101000
Laramie County School District #1
547.0
1101040
...
NaN
NaN
Cheyenne
WY
82001.0
2201 Morrie Ave, Cheyenne WY 82001
http://poderacademy.com/
0
http://www.poderacademy.com/
0
6849 rows × 184 columns
In [7]:
result2 = result1[['TRUE_URL', 'CONFIRMED_CLOSED', 'SCH_NAME', 'OLD_URL', 'SHARED_URL', 'NCESSCH']]
In [21]:
print(len(result1['NCESSCH']) == len(result1['NCESSCH'].unique()), len(result1['NCESSCH']), len(result1['NCESSCH'].unique()), " unique for file 1")
False 6849 6691 unique for file 1
In [22]:
print(len(data14['NCESSCH']) == len(data14['NCESSCH'].unique()), len(data14['NCESSCH']), len(data14['NCESSCH'].unique()), " unique for file 1")
True 6972 6972 unique for file 1
In [10]:
print(len(data14), len(dataUrl))
6972 6725
In [23]:
print(len(dataUrl["SCH_NAME"]) == len(dataUrl["SCH_NAME"].unique()), len(dataUrl["SCH_NAME"]), len(dataUrl["SCH_NAME"].unique()), " unique for file 1")
False 6725 6658 unique for file 1
In [24]:
data14["NAME_ADDRESS"] = data14["SCH_NAME"] + data14["ADDRESS14"]
In [25]:
print(len(data14["NAME_ADDRESS"]) == len(data14["NAME_ADDRESS"].unique()), len(data14["NAME_ADDRESS"]), len(data14["NAME_ADDRESS"].unique()), " unique for file 1")
False 6972 6962 unique for file 1
In [26]:
print(len(data14["SCH_NAME"]) == len(data14["SCH_NAME"].unique()), len(data14["SCH_NAME"]), len(data14["SCH_NAME"].unique()), " unique for file 1")
False 6972 6896 unique for file 1
In [27]:
url_new = pd.read_csv("CMOs2014-15.csv", encoding = "latin1")
In [32]:
url_new = url_new.dropna(axis=1, how='all')
url_new.columns
Out[32]:
Index(['CMO NAME', 'NUM SCHOOLS MANAGED (NAPCS)',
'NUM SCHOOLS MANAGED (MANUAL)', 'LISTS SCHOOLS MANAGED',
'ALSO OPERATES NON-CHARTER SCHOOLS',
'TYPE (school-district, university, broad-services, narrow-services, NA)',
'STATE (EXCEL)', 'STATE (MANUAL)', 'ALL_STATES (MANUAL)',
'MULTI_STATE (MANUAL)', 'ADDRESS (MANUAL)', 'PHONE # (MANUAL)',
'MULTI_STATE (EXCEL)', 'CMO (NAPCS)', 'EMO (NAPCS)', 'SECTOR (CREDO17)',
'# STUDENTS (CREDO17)', 'URL', 'PERMANENTLY CLOSED (MANUAL)',
'NOTES: For-/ non-profit? Says CMO? No NCES match found?',
'SCH_NAME School 1', 'SCH_NAME School 2', 'SCH_NAME School 3',
'SCH_NAME School 4', 'SCH_NAME School 5', 'SCH_NAME School 6',
'SCH_NAME School 7', 'SCH_NAME School 8', 'SCH_NAME School 9',
'SCH_NAME School 10', 'SCH_NAME School 11', 'SCH_NAME School 12',
'SCH_NAME School 13', 'SCH_NAME School 14', 'SCH_NAME School 15',
'SCH_NAME School 16', 'SCH_NAME School 17', 'SCH_NAME School 18',
'SCH_NAME School 19'],
dtype='object')
In [28]:
url_new[['TRUE_URL', 'CONFIRMED_CLOSED', 'SCH_NAME', 'OLD_URL', 'SHARED_URL', 'NCESSCH', 'ADDRESS (MANUAL)']]
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
<ipython-input-28-7f70742099a7> in <module>()
----> 1 url_new = url_new[['TRUE_URL', 'CONFIRMED_CLOSED', 'SCH_NAME', 'OLD_URL', 'SHARED_URL', 'NCESSCH', 'ADDRESS (MANUAL)']]
/Users/shiji/anaconda/lib/python3.5/site-packages/pandas/core/frame.py in __getitem__(self, key)
1989 if isinstance(key, (Series, np.ndarray, Index, list)):
1990 # either boolean or fancy integer index
-> 1991 return self._getitem_array(key)
1992 elif isinstance(key, DataFrame):
1993 return self._getitem_frame(key)
/Users/shiji/anaconda/lib/python3.5/site-packages/pandas/core/frame.py in _getitem_array(self, key)
2033 return self.take(indexer, axis=0, convert=False)
2034 else:
-> 2035 indexer = self.ix._convert_to_indexer(key, axis=1)
2036 return self.take(indexer, axis=1, convert=True)
2037
/Users/shiji/anaconda/lib/python3.5/site-packages/pandas/core/indexing.py in _convert_to_indexer(self, obj, axis, is_setter)
1212 mask = check == -1
1213 if mask.any():
-> 1214 raise KeyError('%s not in index' % objarr[mask])
1215
1216 return _values_from_object(indexer)
KeyError: "['TRUE_URL' 'CONFIRMED_CLOSED' 'SCH_NAME' 'OLD_URL' 'SHARED_URL' 'NCESSCH'] not in index"
In [ ]:
Content source: jhaber-zz/Charter-school-identities
Similar notebooks: