tomasonjo
/ gutenberg_blog_import
Created
August 30, 2019 17:20
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Get an array of words | |
| ws = c.split() | |
| l = len(ws) | |
| # Iterate through words | |
| for wi,w in enumerate(ws): | |
| # Skip if the word is not a person | |
| if not w[:2] == '$$': | |
| continue | |
| # Check next x words for any involved person |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236 | |
| Using May 2018 data | |
| # Schema | |
| CREATE CONSTRAINT ON (a:Airport) ASSERT a.code IS UNIQUE; | |
| # Import | |
| USING PERIODIC COMMIT 10000 |
tomasonjo
/ fuzzy_search.csv
Created
November 9, 2019 17:31
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| scream | 1.8314404488 | |
| a nightmare on elm street: the dream child | 1.3354252577 | |
| a nightmare on elm street 4: the dream master | 1.1446502209 | |
| bull durham | 1.1446502209 | |
| a nightmare on elm street 3: dream warriors | 1.1446502209 |
tomasonjo
/ multi-character-wildcard.csv
Created
November 9, 2019 17:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| a nightmare on elm street 4: the dream master | 1 | |
| a nightmare on elm street: the dream child | 1 | |
| my mother dreams the satan's disciples in new york | 1 | |
| a nightmare on elm street 3: dream warriors | 1 |
tomasonjo
/ single-character-wildcard.csv
Created
November 9, 2019 17:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| thx 1138 | 1 |
tomasonjo
/ logical-operator.csv
Created
November 9, 2019 17:38
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| american psycho | 0.4959547818 | |
| bamboozled | 0.4959547818 | |
| cast away | 0.4959547818 | |
| george washington | 0.4959547818 | |
| gladiator | 0.4959547818 |
tomasonjo
/ specific_attribute.csv
Created
November 9, 2019 17:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| a nightmare on elm street: the dream child | 2.641166687 | |
| a nightmare on elm street 4: the dream master | 2.2638571262 | |
| a nightmare on elm street 3: dream warriors | 2.2638571262 |
tomasonjo
/ range-query.csv
Created
November 9, 2019 17:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| 1492: conquest of paradise | 1.0 | |
| 15 minutes | 1.0 | |
| 2001: a space odyssey | 1.0 | |
| 48 hrs. | 1.0 | |
| the fifth element | 1.0 |
tomasonjo
/ boosting-score.csv
Created
November 9, 2019 17:44
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| a nightmare on elm street 4: the dream master | 2.463479518890381 | |
| a nightmare on elm street 3: dream warriors | 2.463479518890381 | |
| a nightmare on elm street: the dream child | 1.2535805702209473 | |
| 1492: conquest of paradise | 0.1572420448064804 | |
| 15 minutes | 0.1572420448064804 |
tomasonjo
/ final-fts-query.csv
Last active
November 9, 2019 17:45
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| title | score | |
|---|---|---|
| a nightmare on elm street 4: the dream master | 0.016532139852643013 | |
| a nightmare on elm street 3: dream warriors | 0.016532139852643013 | |
| a nightmare on elm street: the dream child | 0.00841264147311449 | |
| 15 minutes | 0.0010552341118454933 | |
| 48 hrs. | 0.0010552341118454933 |