<SYSTEM_TASK:>
Given the following text description, write Python code to implement the functionality described below step by step
<END_TASK>
<USER_TASK:>
Description:
 <h3>Current School Panda</h3>
Working with directory school data
Creative Commons in all schools
This script uses a csv file from Creative Commons New Zealand and csv file from Ministry of Education. 
The ccnz csv file contains schools names that have cc licence, type of licence, 
The Ministry of Education csv file contains every public school in New Zealand and info about them. 
Standards for website addresses - if school name ends with school then cut it from name and add to . 
eg Horowhenua Collage
horowhenua.collage.nz
not 
horowhenuacollage.school.nz
Auckland Girls Grammar School
aucklandgirlsgrammar.school.nz
not
aucklandgirlsgrammarschool.school.nz
Everyschool has their own domain name and Linux server hosting the site. Private/Public keys. Static site, git repo. Nikola blog.
What made you choose that particular Creative Commons licence?
I like the CC
Step1:  Compare the schools on List of CC schools with list of all public/private schools. 
Why shouldn't it be default for all public schools licence to be under a Creative Commons BY license?
Step2:  Cycle through only first 89 values - stop when reaching 
Step3:  Create restfulapi of schools thaat have cc and those that don't
Merge two dicts together.
Both are 
{name of school 
<ASSISTANT_TASK:>
Python Code:
crcom = pd.read_csv('/home/wcmckee/Downloads/List of CC schools - Sheet1.csv', skiprows=5, index_col=0, usecols=[0,1,2])
Explanation: <h3>Current School Panda</h3>
Working with directory school data
Creative Commons in all schools
This script uses a csv file from Creative Commons New Zealand and csv file from Ministry of Education. 
The ccnz csv file contains schools names that have cc licence, type of licence, 
The Ministry of Education csv file contains every public school in New Zealand and info about them. 
Standards for website addresses - if school name ends with school then cut it from name and add to . 
eg Horowhenua Collage
horowhenua.collage.nz
not 
horowhenuacollage.school.nz
Auckland Girls Grammar School
aucklandgirlsgrammar.school.nz
not
aucklandgirlsgrammarschool.school.nz
Everyschool has their own domain name and Linux server hosting the site. Private/Public keys. Static site, git repo. Nikola blog.
What made you choose that particular Creative Commons licence?
I like the CC:BY licence because it offers the most freedom to people. 
I am not a fan of licenses that restrict commercial use. I believe everyone should be able to do what the like with my work with minimal interference. 
If I could I would remove non-commercial licenses. 
In the early days of my art blogging I would license under cc nc. This was wrong and I later changed this to a cc by licence. 
With my photography I once had a photo I taken in the newpaper. It made the front page. I was offered money and seeked permission. I was fine with it of course - the license allows this. At the bottom of the photo it read: PHOTO: William Mckee.
Perfect. 
The only thing I ask is they attribute.
I like the idea of sharealike but at the end of the I really don't care and would hate to chase down people to license it wrong. Sure, I don't like it that people could take my stuff and make it not open. I think everything should be open and free. 
My art site - artcontrol.me is currently down but when it was up I licenced the site under a cc:by. Elements of the site are still up - such as my YouTube channel. 
I attended art school in Wellington - The Learning Connexion. My focus was on drawing and painting. I taught myself programming on the bus to art school. Even when I was drawing on the easel I would be 'drawing' python code. During breaks I would often get my laptop out. 
I volunteered at Whaihanga Early Learning Centre. I spend the majority of my time there in the art area doing collabarth works with others. Oil Pastel, coloured pencil and pencil were my mediums of choice. Sometimes I would use paint, but it's quite messy. 
Copyright shouldn't be default. Apply and pay if you want copyright. CC license by default. That will sort the world.
End of explanation
#crcom
aqcom = pd.read_csv('/home/wcmckee/Downloads/List of CC schools - Sheet1.csv', skiprows=6, usecols=[0])
aqjsz = aqcom.to_json()
dicthol = json.loads(aqjsz)
dschoz = dicthol['School']
#dicthol
dscv = dschoz.values()
ccschool = list()
for ds in range(87):
    #print(dschoz[str(ds)])
    ccschool.append((dschoz[str(ds)]))
schccd = dict()
scda = dict({'cc' : True})
sanoc = dict({'cc' : False})
#schccd.update({ccs : scda})
for ccs in ccschool:
    #These schools have a cc license. Update the list of all schools with cc and value = true.
    #Focus on schools that don't have cc license.
    #Filter schools in area that don't have cc license.
    #print (ccs)
    schccd.update({ccs : scda})
ccschz = list()
for dsc in range(87):
    #print (dschoz[str(dsc)])
    ccschz.append((dschoz[str(dsc)]))
#Append in names of schools that are missing from this dict. 
#Something like
#schccd.update{school that doesnt have cc : {'cc' : False}}
#schccd
Explanation: Compare the schools on List of CC schools with list of all public/private schools. 
Why shouldn't it be default for all public schools licence to be under a Creative Commons BY license?
End of explanation
noclist = pd.read_csv('/home/wcmckee/Downloads/Directory-School-current.csv', skiprows=3, usecols=[1])
webskol = pd.read_csv('/home/wcmckee/Downloads/Directory-School-current.csv', skiprows=3, usecols=[6])
websjs = webskol.to_json()
dictscha = json.loads(websjs)
numsweb = dictscha['School website']
lenmuns = len(numsweb)
#for nuran in range(lenmuns):
#    print (numsweb[str(nuran)])
#noclist.values[0:10]
aqjaq = noclist.to_json()
jsaqq = json.loads(aqjaq)
najsa = jsaqq['Name']
alsl = len(najsa)
allschlis = list()
for alr in range(alsl):
    allschlis.append(najsa[str(alr)])
#allschlis
newlis = list(set(allschlis) - set(ccschool))
empd = dict()
Explanation: Cycle through only first 89 values - stop when reaching : These are schools that have expressed an interest in CC, and may have a policy in progress.
New spreadsheet for schools in progress of CC license. Where are they up to? What is the next steps?
Why are schools using a license that isn't CC:BY. They really should be using the same license. CC NC is unexceptable. SA would be OK but majority of schools already have CC BY so best to go with what is common so you don't have conflicts of licenses.
End of explanation
sstru = json.dumps(schccd)
for newl in newlis:
    #print (newl)
    empd.update({newl : sanoc})
empdum = json.dumps(empd)
trufal = empd.copy()
trufal.update(schccd)
trfaj = json.dumps(trufal)
savjfin = open('/home/wcmckee/ccschool/index.json', 'w')
savjfin.write(trfaj)
savjfin.close()
#savtru = open('/home/wcmckee/ccschool/cctru.json', 'w')
#savtru.write(sstru)
#savtru.close()
#for naj in najsa.values():
    #print (naj)
#    for schk in schccd.keys():
        #print(schk)
#        allschlis.append(schk)
#for i in ccschz[:]:
#    if i in allschlis:
#        ccschz.remove(i)
#        allschlis.remove(i)
#Cycle though some schools rather than everything. 
#Cycle though all schools and find schools that have cc 
#for naj in range(2543):
    #print(najsa[str(naj)])
#    for schk in schccd.keys():
#        if schk in (najsa[str(naj)]):
            #Remove these schools from the list
#            print (schk)
            
Explanation: Create restfulapi of schools thaat have cc and those that don't
Merge two dicts together.
Both are 
{name of school : 'cc' : 'True'/'False'}
End of explanation
<END_TASK>