{ "auto_complete": { "selected_items": [ [ "fke", "f.keeping_by_bname" ], [ "f.ke", "f.keeping" ], [ "f.keep", "f.keeping_by_time" ], [ "is.char", "is.char_of_length1" ], [ "tmp_F", "tmp_files_dropping" ], [ "files.br", "files.brought2" ], [ "date", "dateFromSpotifyFile" ], [ "tmp_", "tmp_files_dropping" ], [ "tmp_File", "tmp_files_with_updates" ], [ "file2", "files.brought2" ], [ "Datecol", "dateCols" ], [ "DT.gro", "DT.gross_by_store" ], [ "DT.g", "DT.gross_by_store" ], [ "DT.s", "DT.gross_by_store" ], [ "gross", "gross_revenue_usd" ], [ "colsTo", "colsToPull" ], [ "contown", "stylizeContentOwner" ], [ "month.", "month.abb" ], [ "datefil", "date_file" ], [ "cohort", "cohortFiles" ], [ "evn", "envir" ], [ "accounting", "accountingyear" ], [ "activ", "activityyear" ], [ "country", "country_code" ], [ "country_", "country_code" ], [ "store", "storeCols" ], [ "DT.st", "DT.gross_by_store.aggd" ], [ "ve", "vendor_key" ], [ "head", "headDB" ], [ "model.f", "model.file" ], [ "nms.", "nms.quarter_and_year" ], [ "genre", "genre_ordering" ], [ "DT.ge", "DT.genre_s_vs_d" ], [ "nm", "nm_of_DT.sample" ], [ "preface", "preface_file_with" ], [ "is.ch", "is.char_of_length1" ], [ "numer_", "number_of_releases" ], [ "DTgen", "DT.genre_s_vs_d" ], [ "rank_", "rank_downloads" ], [ "DT.ger", "DT.genre_aggd" ], [ "dnma", "dbname" ], [ "produc", "product" ], [ "product_", "product_tag" ], [ "produ", "product_description" ], [ "qry_", "qry_whole" ], [ "sugges", "suggestable" ], [ "release", "releaseid" ], [ "day", "day_of_month" ], [ "day_", "day_of_week" ], [ "dime", "dimension_group" ], [ "integr", "integerFormat" ], [ "use", "use.names" ], [ "field", "field_name" ], [ "trans", "transac" ], [ "DT.", "DT.lookml" ], [ "dimen", "dimension" ], [ "meas", "measure" ], [ "dimn_", "dimension_group" ], [ "paste", "paste0" ], [ "View", "Views" ], [ "dstbl", "dstbl_clone" ], [ "db", "dbname" ], [ "artist", "artistid" ], [ "source", "source_uri" ], [ "spoti", "staging_raw_spotify_V2" ], [ "downl", "download_date" ], [ "count", "country_group" ], [ "coun", "country_group" ], [ "cuntry", "country_group" ], [ "alph", "alpha_string" ], [ "valu", "values.colDotgroup" ], [ "ratio", "ratio_of_revenue" ], [ "rev", "Revenue" ], [ "countr", "country_group" ], [ "labe", "labels_revenue" ], [ "Pra", "P.ratio_of_revenue" ], [ "pr", "product_description" ], [ "key", "key.new" ], [ "prod", "product" ], [ "tmp_DT", "tmp_DT_all_countries" ], [ "Re", "revenue_share" ], [ ".SD", ".SDcols" ], [ "cols", "colsToScale" ], [ "vari", "variable.name" ], [ "by", "byCols.scale" ], [ ".Sd", ".SDcols" ], [ "pro", "product" ], [ "payabl", "payable_eur" ], [ "mind", "minDate.global" ], [ "pay", "payable" ], [ "paya", "payable_usd" ], [ "Eu", "EUR_to_USD" ], [ "EUR", "EUR_to_USD" ], [ "pyab", "payable_usd" ], [ "payable_", "payable_usd" ], [ "payable", "payable_usd" ], [ "payab", "payable_usd" ], [ "co", "currency_code" ], [ "DT.ex", "DT.exchangerates" ], [ "ass", "assign.to" ], [ "color", "colors.sc" ], [ "time", "times_info" ], [ "resu", "result_string" ], [ "vlin", "vline.color" ], [ "vline.", "vline.alpha" ], [ "vline", "vline.value" ], [ "face", "facet_scales" ], [ "alp", "alpha_dot" ], [ "label_a", "label_act" ], [ "SE_", "SE_USERS" ], [ "curr", "currency" ], [ "curre", "currency_rate" ], [ "curren", "currency_code" ], [ "smo", "smooth" ], [ "smoot", "smooth_se" ], [ "DT.month.per", "DT.monthly_cast.perc_incr" ], [ "cols.", "cols.monthly_cast_perc" ], [ "total_", "total_streams" ], [ "lae", "labelcolor" ], [ "strea", "streams_scaled_MA3" ], [ "perce", "percent.y" ], [ "sre", "streams_as_perc_of_max" ], [ "top", "top50" ], [ "totl", "total_streams" ], [ "warning", "warningCols" ], [ "y", "ylab" ], [ "total", "total_streams" ], [ "DT.RED_", "DT.RED_Split_Spotify.an" ] ] }, "buffers": [ { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/TODO 2015-08-15.r", "settings": { "buffer_size": 1055, "line_ending": "Unix" } }, { "contents": "# screen -xRR SpotifyETL\n\n\nif (FALSE) {\n source(\"~/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker.r\")\n}\n\n## SETUP LOG\ntry({\n setScienceIfNot(proj=\"Spotify_Accounting_ETL\", subProj=\"ExportToLooker\")\n logname <- \"Spotify_Accounting_ETL_to_looker\"\n previousLogFile <- getLastSinkFileFromDisk(logname, dir=logDir)\n sinkFile <- newLogFile(name=logname)\n sinkOn(file=sinkFile)\n})\n\n\n\n## ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ##\n## ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ##\n## THIS SETUP HAS BEEN COPIED FROM 01 QUICK AUTO\n{\n fresh(notify.startup=FALSE)\n\n setScience(proj=\"Spotify_Accounting_ETL\", subProj=\"ExportToLooker\", create=FALSE, subl=FALSE, load=FALSE)\n setGitBranchToSystem(); .g()\n\n # productsUsing.forUserCounts <- c(\"A\", \"P\", \"PD\", \"U\")\n productsUsing.forUserCounts <- TRUE\n\n wh <- getWH_already_on(default=\"SCIENCE\")\n dbname <- \"prod\"\n setSnowflake(wh=wh, dbname=dbname)\n\n ## Step 1 - Download the files\n source(\"~/git/orch/src/Spotify_Accounting_ETL/01 Retrieve Files From FTP.r\")\n\n if (!getOption(\"snowflake_inuse\")) {\n warning(\"\\n\\nsnowflake_inuse has been reset during file 01\\n\\n\")\n setSnowflake(wh=wh, dbname=dbname)\n }\n\n ## Step 2 - Ingest the files\n source(\"~/git/orch/src/Spotify_Accounting_ETL/02 Ingest Spotify Files.r\")\n}\n## ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ##\n## ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ##\n\n\nsetScience(proj=\"Spotify_Accounting_ETL\", subProj=\"ExportToLooker\", load=FALSE, subl=FALSE, quiet=TRUE)\n\nRE_CREATE_LOOKML <- FALSE\n\nnot_ingesting <- c(\"DT.MISSING_DATA\", \"DT.country\", \"DT.country\", \"DT.super_total\", \"ll.SpotifyRates\", \"row1\", \"DT\", \"DT.lookml\")\n\n## Pull the list of names of DTs\nnms.DT <- lsosdt()$name %>% setdiff(not_ingesting) %>% selfname_\n\n# show the tbales\nshowDataTables(nms.DT, col=25, lines=100)\n\nwh <- getWH_already_on(default=\"CRON_JOBS_SMALL\")\nschema <- \"spotifymgmt\"\ndbname <- \"prod\"\n\nsetSnowflake(wh=wh, dbname=dbname, start=TRUE)\nsfShowTables(wh=wh, dbname=dbname, schema=schema, comments=FALSE)[]\n\n\n## CREATE SCHEMA IF NECESSARY\nif (!sfSchemaExists(dbname=dbname, schema=schema))\n sprintf(\"CREATE SCHEMA %s\", dbschematbl(dbname=dbname, schema=schema)) %>% sfQry()\n\n# for (nm in nms.DT) {\n# try(sprintf(\"DROP TABLE prod.%s.%s\", schema, gsub(\"DT\\\\.\", \"\", nm)) %>% sfQry(verbose=FALSE), silent=TRUE)\n# }\n\nfor (nm in nms.DT) {\n # setnames(get(nm), gsub(\"\\\\(%\\\\)\", \"percentage\", names(get(nm)), ignore.case=TRUE))\n # setnames(get(nm), gsub(\"\\\\(?ad-supported\\\\)?\", \"adsupported\", names(get(nm)), ignore.case=TRUE))\n # setnames(get(nm), gsub(\"No.\", \"Number\", names(get(nm)), ignore.case=TRUE))\n # setnames(get(nm), gsub(\"\\\\.\", \"_\", names(get(nm)), ignore.case=TRUE))\n # setnames(get(nm), gsub(\"\\\\(|\\\\)\", \"\", names(get(nm)), ignore.case=TRUE))\n try(ingestIntoSQL(nm, schema=schema, dbname=dbname, datetime_type=\"TIMESTAMP_NTZ\", confirm=TRUE, drop=TRUE, append=FALSE, wh=wh, snowflake_inuse=TRUE, verbose=TRUE))\n}\n\ndebug(ingestIntoSQL)\n\n## Confrim all tables are loaded\n{\n catheader(\"Checking that all tables are loaded\", prel=3, endl=1)\n is_loaded <- nms.DT %>% gsub(\"DT\\\\.\", \"\", .) %>% sapply(qTableExists, schema=schema, msg_sf=FALSE, snowflake=TRUE) %>% as.logical\n catn(\"Confirming that all tables have been loaded ...\")\n if (any(!is_loaded))\n warning(warningCols(\"Some tables were not properly loaded: \", nms.DT[!is_loaded]))\n else\n catn(\"All \", length(nms.DT), \" tables have been loaded!\")\n}\n\n\nif (RE_CREATE_LOOKML) \n{\n catn(\"Creating Lookml ...\")\n sourceSupportFns(proj=\"Looker\")\n create_lookml_model_from_schema(schema=schema, dbname=dbname, wh=wh)\n}\n\n\nsinkOff()\nshowSink()", "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker.r", "file_size": 3839, "file_write_time": 131074787730000000, "settings": { "buffer_size": 3839, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/load DTs/load and modify 03 DT.users.r", "settings": { "buffer_size": 4103, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02 Ingest Spotify Files.r", "settings": { "buffer_size": 9258, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/sample output.txt", "settings": { "buffer_size": 15462, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/simpleClean_of_spotify_DT.r", "settings": { "buffer_size": 8455, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/readSpotifyFiles.r", "settings": { "buffer_size": 2997, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/sample output II.txt", "settings": { "buffer_size": 30526, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/0-1 Quick Auto.r", "settings": { "buffer_size": 2220, "line_ending": "Unix" } } ], "build_system": "Packages/R-Box/support/R-Box.sublime-build", "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": "reve", "selected_items": [ [ "reve", "File: Reveal" ], [ "push", "Git: Push" ], [ "pull", "Git: Pull" ], [ "qui", "Git: Quick Commit Current File" ], [ "ren", "File: Rename" ], [ "rext", "Set Syntax: R Extended" ], [ "QUI", "Git: Quick Commit Current File" ], [ "rex", "Set Syntax: R Extended" ], [ "name", "File: Copy Name" ], [ "path", "File: Copy Path" ], [ "move", "File: Move" ], [ "revea", "File: Reveal" ], [ "wor", "Word Wrap: Toggle" ], [ "Rext", "Set Syntax: R Extended" ], [ "quico", "Git: Quick Commit" ], [ "quickad", "Git: Quick Add" ], [ "mini", "View: Toggle Minimap" ], [ "quic", "Git: Quick Commit Current File" ], [ "word", "Word Wrap: Toggle" ], [ "sql", "Set Syntax: SQL" ], [ "r", "R-Box: Choose Program" ], [ "ptah", "File: Copy Path" ], [ "rap", "R Application Switch" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "wro", "Word Wrap: Toggle" ], [ "nam", "File: Copy Name" ], [ "rev", "File: Reveal" ], [ "ra", "R Application Switch" ], [ "prett", "Pretty JSON: Format (Pretty Print) JSON" ], [ "js", "JSLint" ], [ "json", "Set Syntax: JSON" ], [ "qi", "Git: Quick Commit" ], [ "pus", "Git: Push Current Branch" ], [ "jslin", "JSLint" ], [ "insta", "Package Control: Install Package" ], [ "pretty", "Pretty JSON: Format (Pretty Print) JSON" ], [ "reinde", "JSON Reindent: reindent file or selection" ], [ "inden", "Indentation: Reindent Lines" ], [ "get package", "Package Control: Install Package" ], [ "package", "Preferences: Browse Packages" ], [ "enab", "Package Control: Enable Package" ], [ "ite", "Indentation: Convert to Spaces" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "pul", "Git: Pull" ], [ "d", "File: Delete" ], [ "comcur", "Git: Quick Commit Current File" ], [ "w", "Word Wrap: Toggle" ], [ "add cu", "Git: Add Current File" ], [ "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" ], [ "dele", "File: Delete" ], [ "del", "File: Delete" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "disable pack", "Package Control: Disable Package" ], [ "disa", "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" ], [ "qu", "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)" ], [ "shel", "SublimeREPL: Shell" ], [ "fil", "File: Copy Name" ], [ "nh", "Set Syntax: HTML" ], [ "fin", "File: Copy Name" ], [ "comm", "Git: Commit" ], [ "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" ], [ "wo", "Word Wrap: Toggle" ], [ "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" ], [ "copy", "File: Copy Name" ], [ "rena", "File: Rename" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "q", "Git: Quick Add" ], [ "renam", "File: Rename" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "en", "Set Syntax: Enhanced-R" ], [ "WOR", "Word Wrap: Toggle" ], [ "pu", "Git: Push" ], [ "cop", "File: Copy Name" ], [ "delet", "File: Delete" ], [ "RA", "R Application Switch" ], [ "REV", "File: Reveal" ], [ "COPNA", "File: Copy Name" ], [ "ENH", "Set Syntax: Enhanced-R" ], [ "QUIC", "Git: Quick Commit" ], [ "co", "File: Copy Name" ], [ "COP", "File: Copy Name" ], [ "oath", "File: Copy Path" ], [ "copy na", "File: Copy Name" ], [ "git pu", "Git: Pull" ], [ "diff", "Git: Diff Current File" ], [ "filenam", "File: Copy Name" ], [ "disab", "Package Control: Disable Package" ], [ "enable", "Package Control: Enable Package" ], [ "SQL", "Set Syntax: SQL" ], [ "sq", "Set Syntax: SQL" ] ], "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/Spotify_Accounting_ETL", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns", "/Users/rsaporta/git/orch/notes/Spotify_Accounting_ETL", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist" ], "file_history": [ "/Users/rsaporta/Downloads/2015_Fall/Accounting Simple.mdown", "/Users/rsaporta/Desktop/best_data scratch work to put back.md", "/Users/rsaporta/git/orch/data/VidServData/MONTHLY_AGGREGATE_WITH_CONTENT_TYPE_TEMPFILE_20160328_175219.tsv", "/Users/rsaporta/gitData/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20158.txt", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/print.datestamped.filenames.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/region_group_to_factor.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/user counts - scratch work.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/01 Retrieve Files From FTP.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/cleanRevshare.r", "/Users/rsaporta/git/misc/shell scripts/update slackbot.sh", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/dateFromSpotifyFile.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/addCurrencyNeutralCols_.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/03 Plot.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/readSpotifyDataFiles.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/05 Revenue per Territory.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/0-1 Quick Auto.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02 Ingest Spotify Files.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/simpleClean_of_spotify_DT.r", "/Users/rsaporta/git/misc/rscripts/utils/workspace.R", "/Users/rsaporta/git/orch/src/DeNormalizing/country rank by store.r", "/Users/rsaporta/git/misc/rscripts/utils/jesus/jesus.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R", "/Users/rsaporta/git/misc/rscripts/utils/makeSQLtable.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/readSpotifyFiles.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/extractReportInfo.r", "/Users/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/old_files/2013/spotify-revshare-for-iris-20133.txt", "/Users/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20159.txt", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/content_owner_stylize.r", "/Users/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-201510.txt", "/Users/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-201511.txt", "/Users/rsaporta/git/orch/out/Spotify_Accounting_ETL/July Files/spotify-data-for-theorchard-20157.txt", "/Users/rsaporta/git/orch/src/dbconcile/supportFns/quickCompareSnowflakeRedshift.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker part 2, spotify schema.r", "/Users/rsaporta/git/orch/src/Looker/supportFns/create_lookml_from_tbl.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/cleanRightsholderColumn_.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02b DT.data.Total_usage.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02b DT.data.Total_usage - absolute - EU.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02b DT.data.Total_usage - absolute.r", "/Users/rsaporta/git/misc/rscripts/utils/addQuarter.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/11 Plotting.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/03 Aggregate and Plot.r", "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/Spotify_Streams_Per_Top_Artist.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/_latestBackups.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/User Counts.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/! SCRATCH (spotify accounting) 2014-12-23.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/03 Plot - EU version.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/12 Formulate Monthly Payment.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150415 ! Spotify Biz Review - User & Stream Counts.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/Vodafone - Tom.R", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/print.revshare.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/Questions For Tom.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/Genre Analysis 2015-08-12.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/11 Ingest & Clean Rates.r", "/Users/rsaporta/git/misc/rscripts/utils/xls/xls_utils.r", "/Users/rsaporta/git/orch/sublws/Spotify_Accounting_ETL/Spotify_Accounting_ETL.sublime-project", "/Users/rsaporta/git/orch/src/Looker/create_lookml for bi accounting and analytics.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/02_AC populate_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/02_AC populate_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/02_AN populate_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/label_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/01_AN create_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/01_AN create_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/01_AC create_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/01_AC create_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting.sql", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_dim_x.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/Spain Playlist Analysis -- 01 Pull Data.r", "/Users/rsaporta/git/orch/src/Looker/aggregated_accounting.lookml.yaml", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_product_label_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_product_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_product_view.sql", "/Users/rsaporta/git/misc/rscripts/utils/AWS_Utils/s3_utils.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/clone_and_add_row_number.sql", "/Users/rsaporta/git/misc/rscripts/!!Setup New Install/SetupNewInstall.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create -- MANUAL SOURCING.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Accounting on Snowflake.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create All Views.r", "/Users/rsaporta/git/orch/src/Looker/Create LookML from DataTable.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Analytics on Snowflake.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/03_AN update_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/MgmtReport_bak 20140722/GL_pt1_e Ingest RED and OSC percentages.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/zArchived/AggregatedTables 140715/03_AN-update_aggregated_analytics (140715).sql", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO - Snowflake 20150716.r", "/Users/rsaporta/git/orch/src/DeNormalizing/2015-07-29 - Manual execution of table updates.R", "/Users/rsaporta/git/orch/src/Looker/Row Numbers for fact_analytics 20150721 -- straight serial.r", "/Users/rsaporta/git/orch/src/Looker/Row Numbers for fact_analytics 20150721.r", "/Users/rsaporta/git/orch/src/ConversionRate/CountConversions.sql", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/spotify json conversion.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting_no_RED.sql", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/SF - stages & file format for Apple Music and Spotify [2015-07-07].r", "/Users/rsaporta/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20150720_2247.logr", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils - Table Creations.r", "/Users/rsaporta/git/orch/src/misc/Lee Spotify Numbers Request.r", "/Users/rsaporta/git/orch/src/AppleMusic/2015-07-07 Apple Music Overview.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/makeQry and runQry.r", "/Users/rsaporta/git/orch/src/dbconcile/supportFns/compare_snowflake_to_redshift.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/DB_Utils_Setters_and_Getters.r", "/Users/rsaporta/git/misc/rscripts/utils/AWS_Utils/AWS_unload_load.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO.r", "/Users/rsaporta/git/orch/src/MgmtReport/DumpTables_to_S3.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/automate new.r", "/Users/rsaporta/git/orch/src/TableBasics/00 REFRESH_ALL TableBasics.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_view.sql", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/snowflake_settings.r", "/Users/rsaporta/git/misc/rscripts/utils/setPrompt.r", "/Users/rsaporta/git/orch/src/misc/bane anaysis.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_meta.r", "/Users/rsaporta/git/orch/src/Snowflake_Scratch/All Queries To Refresh Spotify Flat Tables.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/playlist_to_collection_conversion.r", "/Users/rsaporta/git/orch/notes/Spotify_Stream_Count/staging_raw_spotify_v2 example.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Acc_vs_Anal_for_Spotify RAW 20150413.r", "/Users/rsaporta/git/orch/src/Spotify_API_V2/streams per source - part 2.r", "/Users/rsaporta/git/orch/src/Spotify_Stream_Count/Spotify_Stream_Count_by_label.r", "/Users/rsaporta/git/misc/rscripts/utils/AWS_Utils/AWS_and_S3_options.r", "/Users/rsaporta/git/!Projects/_find and replace_.sublime-project", "/Users/rsaporta/git/misc/rscripts/utils/aggregateDT and changeAndAggregate.r", "/Users/rsaporta/git/misc/rscripts/utils/exploreDispersion.r", "/Users/rsaporta/git/misc/rscripts/utils/ggWrappers/ggHeatGrid.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/AcctBIandProd_are_synced.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/confirmSameValue.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/getReleaseInfo.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/mbworkbook.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Acc_vs_Anal_for_Spotify 20150413.r" ], "find": { "height": 35.0 }, "find_in_files": { "height": 93.0, "where_history": [ "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "113", "RED", "ownerid", "LOOKML", "subscriber_number", "users", "subscriber_number", "skip", "simpleClean_of_spotify_DT_", "get(startCol)", "basename(tmp_files.ftp_sync.the_orchard) %in% basename(files_on_disk)", "print", "namesOfFiles", "nms_orig", "files.brought2", "files_to_skip_one_line", "fullFilePaths.", "removeDuplicateFilesFromFileList <-", "removeDuplicateFilesFromFileList", "files1", "files2", "dateFromSpotifyFile <- ", "files.brought", "fx_neutralizing_factor", "addCurrencyNeutralCols_", "fx_neutralizing_factor", "DT.downloads", "lsosdt", "DT.downloads", "do.call", "Conversion", "startCol", "addQuarter", "\"region_group", "=region_group", "99", "snowflake", "setSnowflake", "colsToAgg", "gross", "nm.dt", "Add more product here", "setcolorderpt", "endcols", "extractContentOwnerFromSpotifyFile", "x", "DT.info", "append.file", "overlap", "readSpotifyDataFiles <- function(f, verbose=TRUE)", "dateFromSpotifyFile", "date_file", "simpleClean_of_spotify_DT_ <- ", "monthFloor", "readSpotifyFiles <- ", "get(startCol)", "(get(startCol)", "(get(startCol) =", "xlsFiles", "length(fullFilePaths)", "cohort", "cohorts", "Data point", "activity_month", "DT.Total_usage\\s* ", "DT.Total_usage\\s* \\<", "DT.Total_usage\\s* \\<\\- ", "DT.Total_usage <- ", "canBeInteger", "ountry", "DT.count_blanks.fact_sales", "percRowsThatAreBlankOrZero", "count_blanks", "group", "\"Rows\"", "DT.country_store_rankings_2015todate", "storeCos", "region_group\"", "DT.total_revshare", "JSON", "DT.sample", "tbls", "\n ", "underscore", "setnames", "yes_units", "\"date\"", "date", "month", "create_lookml_from_tbl", "wtf", "pro_rata_share", "rev", "country_name", "dt.country", "pro_rata_exact", "country", "showDatat", "validPercentage.quick_0_1", "setcolorderpt(DT, start", "setcolorderpt(DT, start=ordering)", "ret", "setnames(DT, new=.)", "setnames(DT, new = .)", ".Ratio", "Orchard.Ratio", "_above_", " %>%", ".above", "above", "above_15_sec", "DT.Streams_per_platform", "No.", "clean", "names(DT)", "DT.userCounts", "DT.LatestRegisteredUsers", "LatestActiveUsers", "DT.LatestActiveUsers", "LatestActiveUsers", ".nm", "DT.revshare", "DT.revenue_share", "DT.data.", "DT.data", "revshare", "numericFormat", "ret" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": false, "replace_history": [ "files_on_disk", "files.brought2", "files.ftp_sync.old_files", "files.ftp_sync", "\"broad_region_group", "=broad_region_group", "unclear", "DT.count_not_blanks.fact_sales", "DT.count_blanks.fact_sales", "percRowsThatAreNotBlankOrZero", "percRowsThatAreBlankOrZero", "DT.count_blanks.fact_sales.dcasted", "count_non_blanks", "count_blanks", "number_of_rows", "tmp_DT.aggd_gross_rank", "storeCols", "tbls.spotify", "DT", "setnames(DT, .)", "_Ratio", "_above", "DT.Latest_Registered_Users", "Latest_Active_Users", "DT.revenue_share", "DT.", "is_loaded", "DT.", "endCols", "endcols", "simpleClean_of_spotify_DT_", "DT.spotify_product_dict", "view_label", "view_name", "DT.formatted", "wh", "Analytics", "Accounting", "BI_Accounting_Creation", "Accounting", "0", "is_store_itunesUSA = 1", "is_store_itunesUSA = true", "getSnowflakeWH(connex=connex, refresh=TRUE, verbose=FALSE)", "getSnowflakeWH(connex=connex, refresh=TRUE)", "setSnowflakeWH", "setSnowflake(showWarnings=FALSE)", ".sf_showDB", ".sf_useDB", "getSnowflakeDB()", "BeNeLux", "gzip=TRUE", "Searching", "setnames_addPreface", "getGNUScreenName", "aggFunc", "makeQry", "addCountry.byCode_", "addCountry.byCode", "s3_sync", "s3_download", "s3_upload", "s3_ls", "s3_p", "s3_bucketExists", "country_group", "ylims", "xlims", "yscale", "xscale", "aggregate_out_product_DT.users", "dots_", "alpha.allOthers", "alpha", "alphs", "DT", "eur", "weekly_absolute_byCountry", "dot_alpha", "line_alpha", "active", "x_scale", "xlab", "DT.RED_Split_Spotify.an", "", "\\'", "spotify_streams", "total_streams", "orchard_streams", "DT.toptracks", "DT.top", "", "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" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "selected": 1, "sheets": [ { "buffer": 0, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/TODO 2015-08-15.r", "semi_transient": false, "settings": { "buffer_size": 1055, "regions": { }, "selection": [ [ 1055, 1055 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content" ], "bracket_highlighter.busy": false, "bracket_highlighter.locations": { "close": { }, "open": { }, "unmatched": { } }, "bracket_highlighter.regions": [ "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 1, "type": "text" }, { "buffer": 1, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/20150810 Export to Looker.r", "semi_transient": false, "settings": { "buffer_size": 3839, "regions": { }, "selection": [ [ 118, 118 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content" ], "bracket_highlighter.busy": false, "bracket_highlighter.locations": { "close": { "1": [ 118, 119 ] }, "open": { "1": [ 38, 39 ] }, "unmatched": { } }, "bracket_highlighter.regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 0, "type": "text" }, { "buffer": 2, "file": "/Users/rsaporta/git/orch/src/Spotify_Streams_Per_Top_Artist/load DTs/load and modify 03 DT.users.r", "semi_transient": false, "settings": { "buffer_size": 4103, "regions": { }, "selection": [ [ 1378, 1378 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 6, "type": "text" }, { "buffer": 3, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/02 Ingest Spotify Files.r", "semi_transient": false, "settings": { "buffer_size": 9258, "regions": { }, "selection": [ [ 7135, 7135 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 7, "type": "text" }, { "buffer": 4, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/sample output.txt", "semi_transient": false, "settings": { "buffer_size": 15462, "regions": { }, "selection": [ [ 1661, 1661 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/Text/Plain text.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 5, "type": "text" }, { "buffer": 5, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/simpleClean_of_spotify_DT.r", "semi_transient": false, "settings": { "buffer_size": 8455, "regions": { }, "selection": [ [ 261, 261 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 4, "type": "text" }, { "buffer": 6, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/readSpotifyFiles.r", "semi_transient": false, "settings": { "buffer_size": 2997, "regions": { }, "selection": [ [ 1759, 1759 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.sublime-syntax", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 2, "type": "text" }, { "buffer": 7, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/sample output II.txt", "semi_transient": false, "settings": { "buffer_size": 30526, "regions": { }, "selection": [ [ 763, 763 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/Text/Plain text.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 3, "type": "text" }, { "buffer": 8, "file": "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/0-1 Quick Auto.r", "semi_transient": false, "settings": { "buffer_size": 2220, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content" ], "bracket_highlighter.busy": false, "bracket_highlighter.locations": { "close": { }, "open": { }, "unmatched": { } }, "bracket_highlighter.regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content" ], "encoding_helper_encoding": "UTF-8", "encoding_thread_running": true, "incomplete_sync": null, "origin_encoding": "ASCII", "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true, "tab_size": 2, "translate_tabs_to_spaces": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 8, "type": "text" } ] } ], "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.find_results": { "height": 256.0 }, "output.git-commit": { "height": 94.0 }, "output.git-pull": { "height": 94.0 }, "output.git-push": { "height": 94.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "Spotify_Accounting_ETL.sublime-project", "replace": { "height": 64.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "ush", "Spotify_Accounting_ETL/user counts - scratch work.r" ], [ "addcurrencyneutralcols", "Spotify_Accounting_ETL/supportFns/addCurrencyNeutralCols_.r" ], [ "extractreportinfo", "Spotify_Accounting_ETL/supportFns/extractReportInfo.r" ], [ "datefrom", "Spotify_Accounting_ETL/supportFns/dateFromSpotifyFile.r" ], [ "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" ], [ "r", "03b DB_raw.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": 431.0 }, "selected_group": 0, "settings": { }, "show_minimap": false, "show_open_files": true, "show_tabs": true, "side_bar_visible": false, "side_bar_width": 344.0, "status_bar_visible": true, "template_settings": { } }