Geek Answers Handbook

How to search for Google Ngrams for "dated" words and phrases?

I would like to write an application that searches for Google Ngram data in order to return words and phrases that used to be more popular, arbitrary percentage, for some arbitrary range of years than now.

For example: https://books.google.com/ngrams/graph?content=cowabunga&year_start=1950&year_end=2000&corpus=15&smoothing=3

Ideally, I would like to find these words and phrases without indicating them in front. Can someone help me come up with a way to do this using a downloaded copy of Ngrams data?

+4
source share
1 answer

n- , SQLite3. , 1 , 't'

SQLite, sqlite3 1grams.db

sqlite> create table t1grams (ngram text, year integer, match_count integer, volume_count integer);
sqlite> .separator "\t"
sqlite> .import googlebooks-eng-all-1gram-20120701-t t1grams

- , YEAR_START YEAR_END, , PERCENT_THRESHOLD.

, ngram, match_count PERCENT_THRESHOLD%, YEAR_END, YEAR_START.

+1

More articles:


All Articles