arwer13 / compsci Goto Github PK

This is Anki's spaced-repetition system (for flashcards): https://github.com/dae/anki/blob/master/anki/sched.py

With respect to the vocabulary program. Here is the starting specification as I see it.

Develop a schema of relational SQL database to store

• words (all unique)

• examples of word usage (whole sentences)

• frequencies of words

  Result: file with sql code to create the schema.
  Notes:

  • At this stage it would be impossible to differentiate word forms, but it's ok.
  • Consider to use SQLite3 as database, because it's the simplest one, but very popular
  • pure xml or json or something like this are not good choices at all for storing and further processing of our kind of data (for many reasons). Some document-oriented (for example json documents) might be considered, but it 's to be a good choice in our case.

Develop a Python program for parsing provided text and adding / updating database.

It should have a simple command line interface: one argument -- path to .txt file

Develop a Python program for querying information about word:

• all known examples of usage
• it's frequency
• it's percentage (among all known unique words)

This program should have a simple command line interface: one argument -- word to look up.

Example: Can I create a widget in which I insert a website name, URL, and description, then pushes it to our repo's links.md file.

Can you give me a simple example in code of populating a database using data from a csv file? I uploaded a simple word frequency database in SQLite and Access along with an Excel spreadsheet to Dropbox. These are words I complied from various lists of words that might appear on the SAT, a college-prep test that many Americans take.

Hi Artyom,

I created a wiki on my fork of this repo; can you walk me through how to merge it back into the master repo?

Thanks,
Ryan

Here are some small topics I've thought about

• filesystem hierarchy
• main configuration files (/etc)
• bash basics
• package manager
• mounting
• basic command line utilities
• Window Manager, Display Manager, Desktop Environments

Hi Artyom,

I tried to modify my text de-duplication program, which removes duplicate lines from a text file, to remove whitespace before considering whether a line is a duplicate. I used .strip() to do this. Before adding .strip(), the program was missing some duplicate lines. After adding .strip(), it deleted every line! What went wrong?

Thanks,
Ryan
textdeduplicator.txt