{ "auto_complete": { "selected_items": [ [ "appen", "appendImgSave" ], [ "get_all", "get_all_playlists" ], [ "down", "download_date" ], [ "soure", "source_uri" ], [ "DT.top", "DT.top_playlists" ], [ "owner", "owner.name" ], [ "write", "writeLines" ], [ "join", "joinCols.rec" ], [ "DT.", "DT.ours" ], [ "pagin", "pagination" ], [ "DT.user", "DT.usermeta" ], [ "user", "user.id" ], [ "Value", "valueIfErrOrNull" ], [ "nume", "number_of_tracks" ], [ "inte", "intersect" ], [ "single", "single_col_elements" ], [ "extus", "external_urls" ], [ "start", "startCols" ], [ "inter", "intersect" ], [ "verbo", "verboseMsg" ], [ "wh.e", "wh.unexpected" ], [ "identi", "identical" ], [ "own", "owner_parts_using" ], [ "expecte", "expected_fields" ], [ "user_s", "user_access" ], [ "album", "album_name" ], [ "playlist", "playlist_id" ], [ "singl", "single_col_elements" ], [ "parse", "parsed_json" ], [ "follow", "followers.total" ], [ "sup", "suppressWarnings" ], [ "get_t", "get_featured_playlists" ], [ "get_js", "get_json_from_spotify_url_NEW" ], [ "play", "playlist.uri" ], [ "plau", "playlist.uri" ], [ "playlist.ur", "playlist.uri" ], [ "playlist.ow", "playlist.owner.id" ], [ "pal", "playlist" ], [ "pla", "playlist.id" ], [ "playist.alb", "playlist.track.album.type" ], [ "colClas", "colClasses" ], [ "files_", "files_all" ], [ "uri", "uris" ], [ "get_ap", "get_all_playlists_ids_downloaded_already" ], [ "file", "filenames" ], [ "user_", "user_ids" ], [ "json", "json_filename_to_playlists_uri" ], [ "sub", "subdir" ], [ "matc", "matched" ], [ "as.per", "as.perc" ], [ "max.", "max.width" ], [ "Filt", "filter_seq" ], [ "today", "todays_playlists" ], [ "L.a", "L.after" ], [ "L.be", "L.before-L.after" ], [ "initi", "initiate_file_for_process_tracking" ], [ "file.p", "file.process_tracking" ], [ "alread", "already_completed" ], [ "plua", "playlists.chunked" ], [ "glob", "globalenv" ], [ "nc", "nc.0" ], [ "clean", "cleanid" ], [ "need", "needs_cleaning" ], [ "nee", "needs_cleaning" ], [ "verbose", "verboseMsg" ], [ "err", "errd_uris" ], [ "Mont", "spotify.MonthlyCounts_by_source_by_day" ], [ "track_", "track_name" ], [ "time", "timestamp_utc" ], [ "stream", "stream_json" ], [ "track", "track_id" ], [ "return_", "return_query" ], [ "retu", "return_query" ], [ "last_", "last_ran" ], [ "FAIL", "fail.if.not" ], [ "getdeta", "sfGetWarehouseDetails" ], [ "sno", "snowflake_defaultwh" ], [ "is.cha", "is.char_of_length1" ], [ "next", "next_hour" ], [ "minutes", "minutes_left_in_hour" ], [ "sfGet", "sfGetWarehouseDetails" ], [ "setk", "setkey" ], [ "warehou", "warehouse_details" ], [ "suppress", "suppressWarnings" ], [ "auto_s", "AUTO_SUSPEND" ], [ "snowf", "snowflake_inuse" ], [ "sf_in", "snowflake_inuse" ], [ "time_", "time_started" ], [ "pieces", "pieces_to_preserve" ], [ "timeSt", "time_started" ], [ "DT", "DT_ids" ], [ "byCols", "byColsFull" ], [ "byCo", "byColsFull" ], [ "exp", "expanded" ], [ "subs", "substitute" ], [ "setnames", "setnamesIfBlank_" ], [ "sfWar", "sfSetWarehouseDetails" ], [ "sp", "sprintf" ], [ "SUSPEND", "SUSPENDED" ], [ "created", "created_on" ], [ "return", "return_error" ], [ "comp", "compilation" ], [ "star", "start_time" ], [ "value", "valueIfNull" ], [ "source", "source_uri" ], [ "sour", "source_uri" ], [ "ac", "activity_date" ], [ "geoco", "geocode_tamu" ], [ "Ret", "ret" ], [ "addre", "addresses" ], [ "iter_", "iter_size" ], [ "balan", "balance_threshold" ], [ "DT.g", "DT.geocode_with_tamu" ], [ "Count", "Counties" ], [ "verb", "verbose" ], [ "lt", "lt_or_gt" ], [ "Mu", "Municipality_Code" ], [ "TRE", "TRUE" ], [ "tmp_", "tmp_NAs.new" ], [ "url_", "url_results" ], [ "date_", "datetime_of_crash" ], [ "Po", "Police_Station" ], [ "date", "date_of_crash" ], [ "geocode_tamu_", "geocode_tamu_colnames" ], [ "cens", "censusYear" ], [ "geo_tam", "geocode_tamu_colnames" ], [ "req", "require" ], [ "geoc", "geocode_tamu" ] ] }, "buffers": [ ], "build_system": "", "build_system_choices": [ [ [ [ "Packages/R-Box/support/R-Box.sublime-build", "" ], [ "Packages/SublimeREPL/sublimerepl_build_system_hack.sublime-build", "" ] ], [ "Packages/R-Box/support/R-Box.sublime-build", "" ] ] ], "build_varint": "", "command_palette": { "height": 392.0, "last_filter": "", "selected_items": [ [ "pu", "Git: Push" ], [ "qui", "Git: Quick Commit Current File" ], [ "wor", "Word Wrap: Toggle" ], [ "push", "Git: Push" ], [ "re", "Set Syntax: R Extended" ], [ "pus", "Git: Push" ], [ "pull", "Git: Pull" ], [ "rena", "File: Rename" ], [ "ren", "File: Rename" ], [ "word", "Word Wrap: Toggle" ], [ "wo", "Word Wrap: Toggle" ], [ "git pull", "Git: Pull" ], [ "rex", "Set Syntax: R Extended" ], [ "dele", "File: Delete" ], [ "path", "File: Copy Path" ], [ "disa", "Package Control: Disable Package" ], [ "qcur", "Git: Quick Commit Current File" ], [ "enab", "Package Control: Enable Package" ], [ "name", "File: Copy Name" ], [ "reve", "File: Reveal" ], [ "rev", "File: Reveal" ], [ "ena", "Package Control: Enable Package" ], [ "dis", "Package Control: Disable Package" ], [ "disab", "Package Control: Disable Package" ], [ "enabl", "Package Control: Enable Package" ], [ "rbox", "R-Box: Choose Program" ], [ "move", "File: Move" ], [ "shel", "SublimeREPL: Shell" ], [ "pul", "Git: Pull" ], [ "renam", "File: Rename" ], [ "sql", "Set Syntax: SQL" ], [ "sq", "Set Syntax: SQL" ], [ "cop", "File: Copy Path" ], [ "rext", "Set Syntax: R Extended" ], [ "ord", "Word Wrap: Toggle" ], [ "qu", "Git: Quick Commit Current File" ], [ "quic", "Git: Quick Add" ], [ "qi", "Git: Quick Commit" ], [ "rb", "R-Box: Choose Program" ], [ "instal", "Package Control: Install Package" ], [ "rap", "Package Control: Remove Package" ], [ "wrod", "Word Wrap: Toggle" ], [ "revea", "File: Reveal" ], [ "html", "HTML: Encode Special Characters" ], [ "upgrad", "Package Control: Upgrade Package" ], [ "file name", "File: Copy Name" ], [ "bro", "SFTP: Browse Server…" ], [ "brow", "SFTP: Browse Server…" ], [ "edit", "SFTP: Edit Server…" ], [ "open file", "View: Toggle Open Files in Side Bar" ], [ "server", "SFTP: Setup Server…" ], [ "br", "SFTP: Browse Server…" ], [ "disabl", "Package Control: Disable Package" ], [ "edit serv", "SFTP: Edit Server…" ], [ "brow ser", "SFTP: Browse Server…" ], [ "install", "Package Control: Install Package" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "comm", "Git: Commit" ], [ "ra", "R Application Switch" ], [ "copy", "File: Copy Path" ], [ "q", "Git: Quick Commit" ], [ "en", "Set Syntax: Enhanced-R" ], [ "git pu", "Git: Pull" ], [ "update", "Package Control: Upgrade/Overwrite All Packages" ], [ "del", "File: Delete" ], [ "wro", "Word Wrap: Toggle" ], [ "upda", "Package Control: Upgrade Package" ], [ "text", "Set Syntax: Plain Text" ], [ "r", "R Application Switch" ], [ "d", "File: Delete" ], [ "comcur", "Git: Quick Commit Current File" ], [ "w", "Word Wrap: Toggle" ], [ "add cu", "Git: Add Current File" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "git chec", "Git: Checkout" ], [ "git check", "Git: Checkout" ], [ "syn shel", "Set Syntax: Shell Script (Bash)" ], [ "synt she", "Set Syntax: Shell Script (Bash)" ], [ "quick", "Git: Quick Commit Current File" ], [ "git ch", "Git: Checkout" ], [ "git stas", "Git: Pop Stash" ], [ "git sta", "Git: Stash" ], [ "add", "Git: Add Current File" ], [ "rapp", "R Application Switch" ], [ "git cur", "Git: Quick Commit Current File" ], [ "pat", "File: Copy Path" ], [ "quci", "Git: Quick Commit Current File" ], [ "ush", "SublimeREPL: Shell" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "disable pack", "Package Control: Disable Package" ], [ "check", "Git: Checkout New Branch" ], [ "git com cur", "Git: Quick Commit Current File" ], [ "curr", "Git: Add Current File" ], [ "git comcu", "Git: Quick Commit Current File" ], [ "qucur", "Git: Quick Commit Current File" ], [ "com cu", "Git: Quick Commit Current File" ], [ "addcu", "Git: Add Current File" ], [ "quicad", "Git: Quick Add" ], [ "PAT", "File: Copy Path" ], [ "git comm", "Git: Commit" ], [ "synshe", "Set Syntax: Shell Script (Bash)" ], [ "fil", "File: Copy Name" ], [ "nh", "Set Syntax: HTML" ], [ "nam", "File: Copy Name" ], [ "fin", "File: Copy Name" ], [ "checkou", "Git: Checkout New Branch" ], [ "filena", "File: Copy Name" ], [ "com file", "Git: Quick Commit Current File" ], [ "quc", "Git: Quick Commit Current File" ], [ "qucomf", "Git: Quick Commit Current File" ], [ "comf", "Git: Quick Commit Current File" ], [ "qucf", "Git: Quick Commit Current File" ], [ "commfil", "Git: Quick Commit Current File" ], [ "filen", "File: Copy Name" ], [ "branch", "Git: Checkout New Branch" ], [ "new br", "Git: Checkout New Branch" ], [ "branc", "Git: Checkout New Branch" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "WOR", "Word Wrap: Toggle" ], [ "delet", "File: Delete" ], [ "RA", "R Application Switch" ], [ "REV", "File: Reveal" ], [ "COPNA", "File: Copy Name" ] ], "width": 521.0 }, "console": { "height": 126.0, "history": [ "subprocess.Popen([Rscript, '-e', 'args(' + 'as.data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\" --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=\"data.table,ggplot2\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + '', stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + \"\", stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args = [Rscript, '-e', 'args(' + func + ')']", "args", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args =[Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2']", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.frame' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "import subprocess", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args", "args = [Rscript, '-e', 'args(' + func + ')']", "args <- [Rscript, '-e', 'args(' + func + ')']", "[Rscript, '-e', 'args(' + func + ')']", "output", "output = mycheck_output([Rscript, '-e', 'args(' + func + ')'])", "plat = sublime.platform()", "Rscript = \"Rscript\"", "Rscript = get(plat, \"Rscript\", \"Rscript\")", "plat", "help", "?", "{", "def get_Rscript():", "Rscript = get_Rscript()", "print(func in container)", "func", "func = m.group(1)", "print(func in container)", "m.group(1)", "m.group", "view.set_status(\"Enhanced-R\", \"\")", "not m", "if not m: return", "m", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "import re", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "point", "point = view.sel()[0].end() if view.sel() else 0", " point = view.sel()[0].end() if view.sel() else 0", "point", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "sel[0].begin() != sel[0].end()", "len(sel)", "if len(sel)!=1: return", "sel = view.sel()", "this_row = view.rowcol(point)[0]", "sel[0].end()", "sel[0].begin()", "sel[0]", "len(sel)", "sel", "sel'", "sel = view.sel()", "this_row", "this_row = view.rowcol(point)[0]", "not view.score_selector(point, \"source.r\")", "view.score_selector(point, \"source.r\")", "point", "point = view.sel()[0].end() if view.sel() else 0", "import urllib.request,os; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); open(os.path.join(ipp, pf), 'wb').write(urllib.request.urlopen( 'http://sublime.wbond.net/' + pf.replace(' ','%20')).read())" ] }, "distraction_free": { "menu_visible": true, "show_minimap": false, "show_open_files": false, "show_tabs": false, "side_bar_visible": false, "status_bar_visible": false }, "expanded_folders": [ "/Users/rsaporta/git/orch/src/z Test Project", "/Users/rsaporta/git/orch/notes/z Test Project" ], "file_history": [ "/Users/rsaporta/git/orch/sublws/z Test Project/Blank.sublime-workspace", "/Users/rsaporta/git/orch/sublws/z Test Project/Blank.sublime-project", "/Users/rsaporta/git/orch/sublws/z Test Project/z Test Project.sublime-project", "/Users/rsaporta/git/orch/sublws/z Test Project/z Test Project.sublime-workspace", "/Users/rsaporta/git/orch/sublws/z Test Project/Another.sublime-workspace", "/Users/rsaporta/git/!Projects/Acc_vs_Anal - iTunes.sublime-workspace", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Kick Off Files/Kick Off for ALL PLAYLISTS in our system.R", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.tracks.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_playlist_data.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_subjson.r", "/Users/rsaporta/Dropbox/The Orchard/EU Summit/Ricks Graphs/questions", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/misc_support_functions_for_parsing.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading II.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading III.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/streams_per_playlist.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/playlist_to_collection_conversion.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/Spotify_Stream_Count_by_label.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading I - create DT.playlist_metadata.r", "/Users/rsaporta/Dropbox/The Orchard/EU Summit/Ricks Graphs/tracks_on_playlist.csv", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After I Downloading and Processing - create DT.flat.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_user_data.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.playlists.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/After Downloading and Processing - create DT.flat.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/after download supportFns.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Bart Wirtz.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_url_for_spotify_API.r", "/Users/rsaporta/git/misc/rscripts/utils/dict functions.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_json_from_spotify_url_NEW.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_known_users.r", "/Users/rsaporta/git/misc/rscripts/utils/NA and NULL handlers.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.tracks_old.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_owner_subjson.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/expected_fields.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_url_type_from_url.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/url_conversions_for_spotify_API.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/processed/playlists_processed_rev.txt", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_items.users.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/download_featured_playlists.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/00 Featured Playlist Setup.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_featured_playlists.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_DT.orch_isrc_upc.r", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings", "/Users/rsaporta/git/orch/out/Spotify Playlist Webscrape/parsed_json/api.spotify.com/v1/users/thomasaunier/playlists/7jGXocavMLB45HGpeGAhlv/7jGXocavMLB45HGpeGAhlv_20150613_095322_Z.tsv", "/Users/rsaporta/git/orch/out/Spotify\\ Playlist\\ Webscrape/parsed_json/api.spotify.com/v1/users/thomasaunier/playlists/7jGXocavMLB45HGpeGAhlv/7jGXocavMLB45HGpeGAhlv_20150613_095322_Z.tsv", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_known_error_tsv_files.r", "/Users/rsaporta/git/misc/rscripts/utils/console_utils.R", "/Users/rsaporta/git/orch/out/Spotify Playlist Webscrape/parsed_json/api.spotify.com/v1/users/zukky/playlists/3pEEP3k71Jf7wi8eEQg0D6/RnB_Hip_Hop_Old_School_New_School_Grime_Garage_20150604_052809_Z.tsv", "/Users/rsaporta/git/orch/out/Spotify\\ Playlist\\ Webscrape/parsed_json/api.spotify.com/v1/users/zukky/playlists/3pEEP3k71Jf7wi8eEQg0D6/RnB_Hip_Hop_Old_School_New_School_Grime_Garage_20150604_052809_Z.tsv", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/2015-06-04 errors to check.R", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get jsonfiles from disk.r", "/Users/rsaporta/git/orch/out/Spotify Playlist Webscrape/parsed_json/api.spotify.com/v1/users/youngmoneyent/playlists/4ggOJNUeBhLcKcx6DhF1zF/4ggOJNUeBhLcKcx6DhF1zF_20150613_074613_Z formatted.tsv", "/Users/rsaporta/git/orch/out/Spotify Playlist Webscrape/parsed_json/api.spotify.com/v1/users/youngmoneyent/playlists/4ggOJNUeBhLcKcx6DhF1zF/4ggOJNUeBhLcKcx6DhF1zF_20150613_074613_Z.tsv", "/Users/rsaporta/git/data.table/fread bug/4ggOJNUeBhLcKcx6DhF1zF_20150613_074613_Z.tsv", "/Users/rsaporta/git/orch/out/Spotify\\ Playlist\\ Webscrape/parsed_json/api.spotify.com/v1/users/youngmoneyent/playlists/4ggOJNUeBhLcKcx6DhF1zF/4ggOJNUeBhLcKcx6DhF1zF_20150613_074613_Z.tsv", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/_latestBackups.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/download_playlist_data.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/web api tokens.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/parse_spotify_uri.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/developer API endpoints exploration.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_url_for_spotify_playlist_data.r", "/Users/rsaporta/git/misc/rscripts/utils/percent functions.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Example of given a list of playlists.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/Kick Off Files/Kick Off A - Front.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/write_which_playlists_were_processed_on_date.r", "/Users/rsaporta/git/.gitignore", "/Users/rsaporta/git/README.md", "/Users/rsaporta/git/open", "/Users/rsaporta/git/.Rhistory", "/Users/rsaporta/git/.Rapp.history", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/playlist analyis for marketing team.r", "/Users/rsaporta/git/misc/rscripts/utils/writeDT.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_json_from_spotify_url_OLD.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/SQL Error Incident 7199762.sql", "/Users/rsaporta/development/magrittr/man/exposition.Rd", "/Users/rsaporta/development/R-Box/syntax/R Extended.tmLanguage", "/Users/rsaporta/development/R-Box/syntax/R Functions.tmLanguage", "/Users/rsaporta/development/magrittr/exposition.Rd", "/Users/rsaporta/development/magrittr/vignettes/magrittr.Rmd", "/Users/rsaporta/development/rsnowflake/verboseQry.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/Check Spotify RAW tables.r", "/Users/rsaporta/development/rsnowflake/README.md", "/Users/rsaporta/development/rsnowflake/helper_functions.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/makeQry and runQry.r", "/Users/rsaporta/development/rsnowflake/snowflake_options.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R", "/Users/rsaporta/development/rsnowflake/sf_options.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/snowFlake_Wrappers.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/User Conversion Example.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/snowflake scratch II.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/snowflake scratch.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/snowflake_settings.r", "/Users/rsaporta/git/misc/rscripts/utils/addColsFrom and addMeta.r", "/Users/rsaporta/git/StackExchange/setting up Postgres.r", "/Users/rsaporta/git/misc/rscripts/utils/format functions.r", "/Users/rsaporta/git/StackExchange/meta data in separate data.frame.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/spotify json conversion.sql", "/Users/rsaporta/development/NJCrashData/src/supportFns/addCredits.r", "/Users/rsaporta/development/NJCrashData/data/geocode_tamu_results/UNION/tamu_results_20150423_013038.csv", "/Users/rsaporta/development/NJCrashData/data/geocode_tamu_results/UNION/tamu_results_20150423_012857.csv", "/Users/rsaporta/git/misc/rscripts/utils/rounding functions.r", "/Users/rsaporta/development/NJCrashData/data/geocode_tamu_results/UNION/tamu_results_20150423_003832.csv", "/Users/rsaporta/development/NJCrashData/src/SCRATCH.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/geocode_tamu.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/extractValidatorsFromHTML.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/geocode_read_files.r", "/Users/rsaporta/development/NJCrashData/html/NJ Crash Data", "/Users/rsaporta/development/NJCrashData/src/supportFns/parse_join_id.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/output_accidents_to_csv.r", "/Users/rsaporta/development/NJCrashData/src/03 Cleaning DTs.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/ingest_report_type.R", "/Users/rsaporta/development/NJCrashData/data/geocode_tamu_results/UNION/tamu_results_20150422_081933.csv", "/Users/rsaporta/development/NJCrashData/src/02 Ingest Files by Type and County.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/getCounties.R", "/Users/rsaporta/development/NJCrashData/src/04 Mapping.r", "/Users/rsaporta/git/misc/rscripts/utils/memoryFunctions.R", "/Users/rsaporta/git/misc/rscripts/utils/workspace.R", "/Users/rsaporta/development/NJCrashData/src/00 NJCrashData Setup.r", "/Users/rsaporta/development/NJCrashData/src/supportFns/clean_streetAddress.r", "/Users/rsaporta/development/NJCrashData/data/geocode_tamu_results/MONMOUTH/tamu_results_20150421_043110.csv", "/Users/rsaporta/development/NJCrashData/data/geocode_tamu_results/ESSEX/tamu_results_20150421_005417.csv", "/Users/rsaporta/git/misc/rscripts/utils/setScience.R", "/Users/rsaporta/development/NJCrashData/out/csvs_of_DTs/Accidents_MnmthEsx_2012_2013.csv", "/Users/rsaporta/development/NJCrashData/src/Texas A&M walkthrough.txt", "/Users/rsaporta/development/NJCrashData/src/Questions.txt", "/Users/rsaporta/development/NJCrashData/src/04 Geocode Accidents.r", "/Users/rsaporta/development/NJCrashData/src/NJ Traffic Accidents.r" ], "find": { "height": 22.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "ext", "if (FALSE", "getSubProj", "getProjName", "setPrompt", "if (FALSE", "getProjName", "if (FALSE)", "if( (FALSE)", "getSubProj", "opensubl", "subl", "ASSIGN", "setProjName", "getProjName(", "getProjName()", "subl", "dos.grp", "subdir", "dos.grp", "\"src\"", "sublws", ".workspace.p", "\"src\"", "dir", "2", "1", "openSublimeWorkspace", "subl", "if (length(wh.unexpected", "parse_owner_subjson", "\"artist\"", "parse_artist_subjson <- ", "do.call(parse_items.tracks", "filter_seq", "00 Fe", "source_uri", "DT.ours", "DT.track.album", "DT.track.artist", "parse_items.tracks", "DT.track.artist", "parse_owner_subjson", "expand_sub_group", "expand_sub_group(items$track$external_ids)", "data.table(expand_sub_group(items$track$external_ids)", "data.table(expand_sub_group(items$track$external_ids) %>% as.data.table", "DT.ours", "DT.count", "DT.counts", "processing", "explicit", "track.explicit", "is_explicit", "addColsFrom", "joinCols.r", "add_user_metadata_ <-", " add_user_metadata_", "name", "playlist.name", "playlist.track.album.markets", "\"TRUE\"", "\"FALSE\"", "FALSE", "DT.flat[", "upc", "artist", "DT.ours", "playist_belonging_to_user", "browser", "get_user_data", "url_type", "using=setdiff", "parse_followers_subjson", "DT.followers", "get_all_know", "error", "get_json_from_spotify_url_NEW <- ", "expected_fields", "nms", "DT.track", "setNamesDict", "valueIf", "value", "setdiff", "parsed_json", "/tracks", "ordering", "DT.owner <- ", "multi_col_elements", "single_c", "singleC", "single", ".spotify_extract_subgroup", "raw_json", "parsed_json", "raw_json", "DT.external_urls <- ", " DT.external_urls <- expand_sub_group(parsed_json[\"external_urls\"]) %>% as.data.table", " DT.external_urls <- expand_sub_group(parsed_json[\"external_urls\"]) %>% as.data.table\n", "followers", "DT.external_url", "external_url", "parse_items.list_of_playlists", "raw_json", "setdiff(parsed_json, not_using)", "artist != 'artist'", "items$track", "album", "condition_to_test", "artist_type", "DT.track.album", "parse_owner_subjson", "keep_uri", "album_dropping", "names(parsed_json)", "get_json_from_spotify_url_NEW", "images", "list_of_items", "parse_items.list_of_playlists", "DT.owner", "This is mostly just the following line", "function(playlists.uri, token=get_spotify_API_token(), file.process_tracking", "get_playlist_data", "dt.owner", "DT.owner", "owner$", "owner" ], "highlight": true, "in_selection": false, "preserve_case": true, "regex": false, "replace_history": [ "'B'", "'A'", "if (missing(using) && length(wh.unexpected", "if (length(wh.unexpected", "joinCols.rec", "TRUE ", "FALSE ", "playist_associatedto_user", "playist_belonging_to_user", "parsed_json", " ## OLD: DT.external_urls <- expand_sub_group(parsed_json[\"external_urls\"]) %>% as.data.table\n DT.external_urls <- parse_external_url_subjson(parsed_json, recursive=TRUE)", "external_url", "parse_items.playlists", "setdiff(names(parsed_json), not_using)", "setdiff(parsed_json, not_using)", "parsed_json", "artist", "not_using", "nms", "parse_items.list_of_playlists", "user", ".id", "## confirm all are exactly of length 1 and not a list, except for 'description'", "## confirm all are exactly of length 1 and not a list", "DT.pl", "DT.playlist_metadata", "\\", "files_chunked", "files", "files_all", "playlists.existing_in_outDir", "playlists.existing", "filenames", "initialize_file_for_process_tracking", "initiate_file_for_process_tracking", "playlists.marketing", "playlists.cat", "cleanid", "what.confirming", "FULLROW", "streams", "wh_opt", "wh_opts$", "DT_interactions", "byCols", "byColsFull", "attr", "NJ", "colsToBring", "82", "Args_for_url", "Args_pasting", "Args_pasted", "_", "splat", "NJCrashData", "20150413_STREAMS_per_users_per_release_country", "STREAMS_per_users_per_release_country", "label", "stream_customer_counts_by_label", "getSubProj", "subProj", "\\v", "AcctBIandProd_are_synced", "validate", "qry.rowcounts.fact", "unique_bucket", "activity_date", "accounting_month", "exportXLS.usingXLConnect", "store_name_short", "dict", "period_view", "dimCols", "dimensionCols", "fa.manual <- runQry(\"\nSELECT download_activity_date AS date, storeid, transactiontypeid AS transac_typeid, false AS from_errors_table\n , SUM(units) as units \nFROM production.fact_analytics \nWHERE storeid = 1 and download_activity_date >= '2014-10-01'\nGROUP By 1, 2, 3, 4\n \")\n", "schema", "period_view", "accounting_period_view", "skip.select.in_Denormalizing", "skip.select.indenormalizing", "out.right", "out.left", "gest_net_of_SC", "ancilla", "anal", "analytics", ".prod", "\\n ", "", " THEN", " THEN", "schema", "schema.tmp", "-------", "03_AC", "'", "DT.merged2", "calculated", "MgmtReport_", "MgmtReport", "----------", "Revenue", "file.in", "kCols.smry_supbuk", "thisRunIsAForecast", "notForecasting", "!notForecasting", "DT.GL_forecasted", "notForecasting", "DT.cleaned.aggd2", "DT.MgmtReport", "DT.cleaned.aggd", "GL_net_forDSOM", "DT.manual", "DT.cleaned.aggd", "DT.cleaned.OSC", "OA_percof_DS_forDSOM", "label_sc_group %in% OSC_values", "label_sc_group %ni% c(\"RED\", \"Orchard\")", "calc.tol", "DT.cleaned", "tmp_DT.monthly_sums_by_grp", "tmp_DT.monthly_sums", "is.na(ancillaryline)", "!is.na(ancillaryline)", "lastDateClosed", "zUncatego" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "sheets": [ ] } ], "incremental_find": { "height": 20.0 }, "input": { "height": 31.0 }, "layout": { "cells": [ [ 0, 0, 1, 1 ] ], "cols": [ 0.0, 1.0 ], "rows": [ 0.0, 1.0 ] }, "menu_visible": true, "output.exec": { "height": 166.0 }, "output.find_results": { "height": 256.0 }, "output.git-checkout": { "height": 100.0 }, "output.git-commit": { "height": 100.0 }, "output.git-pull": { "height": 82.0 }, "output.git-push": { "height": 94.0 }, "output.sftp": { "height": 178.0 }, "pinned_build_system": "", "project": "Blank.sublime-project", "replace": { "height": 40.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "ush", "All Queries To Refresh Spotify Flat Tables.r" ], [ "r", "Run For Rick Please.txt" ], [ "mk", "supportFns/mkForecast.r" ], [ "push", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "jesusfordata_forecasting", "supportFns/jesusForData_Forecasting.r" ], [ "permeat", "supportFns/permeate.r" ], [ "dict.", "supportFns/dict.rev_summary_colnames.r" ], [ "dict", "supportFns/dict.GL_colnames.r" ], [ "manl_cr", "GL_pt3_a Create DT.manl_crop.r" ], [ "mkforecast", "supportFns/mkForecast.r" ], [ "ull", "supportFns/calculateSplitPercentages.r" ], [ "us", "supportFns/calculateSplitPercentages.r" ] ], "width": 0.0 }, "select_project": { "height": 0.0, "last_filter": "", "selected_items": [ ], "width": 0.0 }, "select_symbol": { "height": 392.0, "last_filter": "", "selected_items": [ ], "width": 392.0 }, "selected_group": 0, "settings": { }, "show_minimap": false, "show_open_files": true, "show_tabs": true, "side_bar_visible": true, "side_bar_width": 346.0, "status_bar_visible": true, "template_settings": { } }