Word frequency database - Githubissues

arwer13 / compsci

2 stars 1 forks source link

Word frequency database #7

Open arwer13 opened 8 years ago

arwer13 commented 8 years ago

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.

arwer13 commented 8 years ago

What other csv files did you mean? Only Sp5000.txt and Sp1000.txt are real csv. Here is an example of a program populating db with word frequencies from Excel table. I redesigned the table a little bit https://github.com/arwer13/compsci/commit/661b520c63784029ce70c3f7195a0c91bc118d58 Would you like to redesign it so that the database contains information about

language of every word,
other frequencies of this word (there are many in the xlsx file)?

Then we could load words from SP*.txt as well to the same database.