Alexander Loth aloth
aloth
/ postgres_string_split.sql
Created
January 14, 2016 15:08
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
| select | |
| guid | |
| , regexp_split_to_table(lower(post_content), '\s+') as word | |
| , count(1) as word_count | |
| from | |
| alexblog_posts | |
| group by | |
| guid, word |
aloth
/ twitter_word_attribute_tableau_calc.txt
Created
January 19, 2016 17:06
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
| CASE LEFT([Word], 1) | |
| WHEN "#" THEN "Hash Tag" | |
| WHEN "@" THEN "User Reference" | |
| ELSE "Regular Content" | |
| END |
aloth
/ get_emotion_sentiment_tableau.txt
Last active
January 31, 2016 10:25
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
| SCRIPT_STR(' | |
| library(sentiment) | |
| get_emotion(.arg1, algorithm = "bayes") | |
| ' | |
| , ATTR([Tweet Text])) |
aloth
/ get_polarity_sentiment_tableau.txt
Created
January 31, 2016 10:27
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
| SCRIPT_STR(' | |
| library(sentiment) | |
| get_polarity(.arg1, algorithm = "bayes") | |
| ' | |
| , ATTR([Tweet Text])) |
aloth
/ install_sentiment.R
Last active
August 7, 2016 19:28
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
| install.packages("devtools") | |
| library(devtools) | |
| install_github("aloth/sentiment/sentiment") |
aloth
/ install_sentiment_web.R
Last active
August 14, 2016 14:04
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
| install.packages("Rcpp") | |
| install.packages("http://alexloth.com/utils/sentiment/current/sentiment.zip",repos=NULL) |
aloth
/ corrcoef_python_tableau.txt
Created
November 7, 2016 12:17
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
| SCRIPT_REAL(' | |
| import numpy as np | |
| return np.corrcoef(_arg1,_arg2)[0,1] | |
| ', | |
| SUM([Sales]), SUM([Profit])) |
aloth
/ kmeans_r_tableau.txt
Created
December 22, 2016 09:03
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
| SCRIPT_INT(' | |
| kmeans(data.frame(.arg1,.arg2,.arg3),' + STR([Cluster Amount]) + ')$cluster; | |
| ', | |
| SUM([Sales]), SUM([Profit]), SUM([Quantity])) |
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
| library(twitteR) | |
| library(ROAuth) | |
| ## Twitter authentication | |
| ## Replace strings with your credentials | |
| setup_twitter_oauth("consumer_key", "consumer_secret", | |
| "access_token", "access_secret") | |
| # Fetch tweets from user timeline | |
| tweets <- userTimeline("xlth", n = 3200) |
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
| REGEXP_EXTRACT( | |
| [Post Message], | |
| '((?:http|https)://(?:[\w_-]+(?:(?:\.[\w_-]+)+))(?:[\w.,@?^=%&:/~+#-]*[\w@?^=%&/~+#-]))' | |
| ) |
OlderNewer