Syllabi is very important aspect of disciplinary workings. In this notebook we will work on a syllabi database that is provided by someone. We will also develop an algorithm that will look for syllabis.

Lets try "One million syllabi" and "Open syllabus project"

One million syllabus

One million syllabi is a project by Dan. It hold about one million of sillabi in an sql format that can be glimpsed into. In this workbook we will try to look into the dataset.

In [8]:
url = r'd:\Desktop\Desk 2014 09\week1\chnm_syllabus_finder_corpus_2011-03-30.sql'

In [9]:
import sqlite3
conn = sqlite3.connect(url)
c = conn.cursor()

In [10]:

In [11]:
c.execute('SELECT * FROM stocks WHERE symbol=?')

ProgrammingError                          Traceback (most recent call last)
<ipython-input-11-98db7bbc9be8> in <module>()
----> 1 c.execute('SELECT * FROM stocks WHERE symbol=?')

ProgrammingError: Cannot operate on a closed database.

In [5]:
f = open(url)

In [6]:

<repr(<str at 0x1eca0020>) failed: OverflowError: string is too large to make repr>

In [7]:

<open file 'd:\\Desktop\\Desk 2014 09\\week1\\chnm_syllabus_finder_corpus_2011-03-30.sql', mode 'r' at 0x03482288>

Open Syllabus Project

The project is available at Also, github repository is available at There is an irc chat at freenode. Twitter '@opensyllabusproject'