{ "auto_complete": { "selected_items": [ [ "master_", "master_blacklist_id" ], [ "tmp_DT", "tmp_DT.curr" ], [ "tmpt", "tmp_DT.curr" ], [ "releas", "release_name_cleaned_nows" ], [ "vend", "vendor_id_old" ], [ "caught", "caught_hidden" ], [ "label_", "label_name" ], [ "latest", "latest_infrac_by_label" ], [ "late_", "latest_infrac_by_upc" ], [ "total", "total_infracs_by_label" ], [ "total_", "total_infracs_by_label" ], [ "DT.me", "DT.merge" ], [ "size", "size_only" ], [ "aid", "apple_id" ], [ "label", "labelid" ], [ "upc_has", "upc_has_at_least_one_infrac" ], [ "artist", "artist_name_cleaned" ], [ "artis", "artist_name_cleaned" ], [ "occu", "occurred_first_90_days" ], [ "true", "true_positives" ], [ "false_", "false_positive" ], [ "DT.merg", "DT.merge.rates" ], [ "caught.", "caught.by_release" ], [ "release_", "release_name" ], [ "DT.", "DT.merge.recent" ], [ "release", "release" ], [ "ll.p", "ll.precisions_90" ], [ "ll", "ll.precisions_90" ], [ "hist", "history" ], [ "DT.mer", "DT.merge.recent" ], [ "errors", "errors_caught" ], [ "empty", "emptylist" ], [ "DT.m", "DT.merge.recent" ], [ "relase", "releases" ], [ "Dt.sm", "DT.samp" ], [ "n_l", "n_length-1" ], [ "arti2", "artist_name_word_stems2" ], [ "DT.s", "DT.samp" ], [ "verb", "verbose" ], [ "stem", "stemDocument" ], [ "rele", "release_name_4parts" ], [ "prvo", "Provider" ], [ "first_", "occurred_first_90_days" ], [ "DT.r", "DT.tracks_per_upc" ], [ "upc", "upc_has_artistcleanup_error" ], [ "edit", "editorial_discretion" ], [ "ref", "refusal" ], [ "reasonc", "reasonCols" ], [ "clean_", "clean_wrapper_simple" ], [ "Rele", "release_name" ], [ "art_", "artist_name_words" ], [ "duplie", "duplicate_whitespace" ], [ "force", "force_space_around_all_punctuation" ], [ "duplic", "duplicate_whitespace" ], [ "art", "artist_name_cleaned_2" ], [ "substr", "substring" ], [ "joinCo", "joinCols.rec" ], [ "apple", "apple_id" ], [ "releve", "release_version" ], [ "count_", "count_of_discs" ], [ "Dt.m", "DT.merge" ], [ "log10", "log10Abs" ], [ "comp", "company" ], [ "relea", "release_name" ], [ "cols_no", "cols_not_needed_for_modelling" ], [ "latet", "latest_error_by_upc" ], [ "verbose", "verboseMsg" ], [ "get_dim", "get_dim_artist_cleaned" ], [ "count_o", "count_of_isrc" ], [ "count_of", "count_of_trackid" ], [ "track_", "track_unique_id" ], [ "upcs", "upcs_with_problem_in_source" ], [ "DTtrac", "DT.tracks_per_upc" ], [ "prble", "problematic_upcs" ], [ "probl", "problematic_upcs" ], [ "strange", "strange_upcs" ], [ "DT.tr", "DT.tracks_per_upc" ], [ "setkey", "setkeyIfNot" ], [ "strang", "strange_upcs" ], [ "cout_of", "count_of_discs" ], [ "countr", "count_of_track_id" ], [ "arti", "artist_name" ], [ "production.dim", "production.dim_label" ], [ "own", "ownerid" ], [ "distinct_ra", "distinct_reasons_upc" ], [ "appl", "apple_id" ], [ "DT.i", "DT.hidden2" ], [ "overw", "overwrite.bringme" ], [ "dis", "distinct_reasons_for_aid" ], [ "reason", "reason_occurrance" ], [ "event", "event_occurrance" ], [ "even", "event_occurrance" ], [ "ident", "identity" ], [ "diges", "digest_vec" ], [ "Syst", "Sys.time" ], [ "artst", "artist_name" ], [ "convert_", "convert_from" ], [ "punc", "punctuation" ], [ "newCol", "newCol" ], [ "artist_", "artist_name" ], [ "gros", "gross_revenue_usd" ], [ "artist_name_", "artist_name_cleaned_withws" ], [ "refre", "refresh_dim_artist" ], [ "DT.cl", "DT.artist_cleaned" ], [ "DT.art", "DT.artists_cleaned" ], [ "DT.ar", "DT.artists_cleaned" ], [ "artist_name_c", "artist_name_cleaned_with_ws" ], [ "intTo", "intToUtf8" ], [ "l", "lin Polygonal Line" ], [ "DT.a", "DT.artists" ], [ "vector", "vector_to_flat_string" ], [ "arit_", "artistid_list" ], [ "newC", "newCol" ], [ "newcol", "newCol1" ], [ "isDir", "is_dir" ], [ "bringme", "bringme" ], [ "shh", "ssh_host" ], [ "ssh_", "ssh_host" ], [ "remotefi", "remotefile" ], [ "accoun", "accounting_next" ], [ "file.mo", "file.model" ], [ "glob", "globalenv" ], [ "envi", "envir" ], [ "filensa", "filename.sample" ], [ "snowl", "snowflake_inuse" ], [ "getSnowfla", "getSnowflakeDB" ], [ "check_s", "check_exists_then_zArchive" ], [ "za", "zArchive_existing" ] ] }, "buffers": [ { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/IRIS UPCs Match.r", "settings": { "buffer_size": 2200, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/01 Hidden Content Modelling.r", "settings": { "buffer_size": 13188, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/00 Hidden files from DL to Ingest Dir.r", "settings": { "buffer_size": 3421, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/02 Hidden Content - Simple.r", "settings": { "buffer_size": 14023, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/for brad 2015-10-30.r", "settings": { "buffer_size": 2338, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/Offending Words.r", "settings": { "buffer_size": 511, "line_ending": "Unix" } }, { "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/Hidden Content 03 by String Parts.r", "settings": { "buffer_size": 24417, "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": 147.0, "last_filter": "push", "selected_items": [ [ "push", "Git: Push" ], [ "qui", "Git: Quick Commit Current File" ], [ "pull", "Git: Pull" ], [ "yaml", "Set Syntax: YAML" ], [ "name", "File: Copy Name" ], [ "quic", "Git: Quick Commit Current File" ], [ "path", "File: Copy Path" ], [ "word", "Word Wrap: Toggle" ], [ "wor", "Word Wrap: Toggle" ], [ "pat", "File: Copy Path" ], [ "pus", "Git: Push" ], [ "copy", "File: Copy Name" ], [ "re", "Set Syntax: R Extended" ], [ "reve", "File: Reveal" ], [ "ren", "File: Rename" ], [ "mini", "View: Toggle Minimap" ], [ "wro", "Word Wrap: Toggle" ], [ "rext", "Set Syntax: R Extended" ], [ "wo", "Word Wrap: Toggle" ], [ "Wro", "Word Wrap: Toggle" ], [ "sql", "Set Syntax: SQL" ], [ "git pu", "Git: Push" ], [ "rex", "Set Syntax: R Extended" ], [ "revea", "File: Reveal" ], [ "r", "R-Box: Choose Program" ], [ "ptah", "File: Copy Path" ], [ "rap", "R Application Switch" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "nam", "File: Copy Name" ], [ "rev", "File: Reveal" ], [ "move", "File: Move" ], [ "ra", "R Application Switch" ], [ "prett", "Pretty JSON: Format (Pretty Print) JSON" ], [ "js", "JSLint" ], [ "json", "Set Syntax: JSON" ], [ "qi", "Git: Quick Commit" ], [ "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" ], [ "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" ], [ "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" ], [ "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" ], [ "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" ], [ "ql", "Git: Quick Log" ] ], "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/ContentAnalysis", "/Users/rsaporta/git/orch/src/ContentAnalysis/supportFns", "/Users/rsaporta/git/orch/notes/ContentAnalysis" ], "file_history": [ "/Users/rsaporta/git/orch/src/ContentAnalysis/pull DT.releases_with_metadata.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/01 Hidden Content Modelling.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/00 Hidden files from DL to Ingest Dir.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/05 Ingest into Snowflake.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/2015-10-16 Quick Count for this week.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/current_blacklisted_words.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/spotify all content that is live.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/Hidden Content Modelling.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/Hidden Content 03 by String Parts.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/Hidden Content - Simple.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/hidden errors by column of DT.merge.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/for brad 2015-10-30.r", "/Users/rsaporta/git/orch/src/Looker/supportFns/create_lookml_from_tbl.r", "/Users/rsaporta/git/orch/src/Looker/supportFns/cleanLookerHeaders_after_download.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create -- MANUAL SOURCING.r", "/Users/rsaporta/git/misc/rscripts/utils/workspace.R", "/Users/rsaporta/git/orch/src/ContentAnalysis/Black Listed Artists.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/artist_name_cleaned.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/artist_id_from_fuzzy_name.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/Offending Words.r", "/Users/rsaporta/git/misc/rscripts/utils/clean_names_to_simple_alpha.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/count tracks per upc.r", "/Users/rsaporta/.bash_profile", "/Users/rsaporta/git/orch/ingest/ContentAnalysis/iTunes Hidden Music Trends (IODA) - editorials-refusals.tsv", "/Users/rsaporta/git/orch/ingest/ContentAnalysis/iTunes Hidden Music Trends 2015 (ORCH) - editorial-refusal-cleanup.tsv", "/Users/rsaporta/git/misc/rscripts/utils/addColsFrom and addMeta.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/01 Ingest Spotify Live File.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_with_metadata.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/Apple_ID_Mapping.r", "/Users/rsaporta/git/orch/src/Looker/birngAndCopyLookerFiles.r", "/Users/rsaporta/git/misc/rscripts/utils/hash and digest functions.r", "/Users/rsaporta/git/misc/rscripts/Benchmarks/vectorized hashing methods.R", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/store_view_snowflake.sql", "/Users/rsaporta/git/orch/src/chartio/GPU By Store.r", "/Users/rsaporta/git/orch/src/ContentAnalysis/supportFns/artist black list.txt", "/Users/rsaporta/git/misc/rscripts/utils/dict functions.r", "/Users/rsaporta/git/misc/rscripts/utilsRS.r", "/Users/rsaporta/git/orch/src/BunnyLee/BunnyLee Catalog Check.r", "/Users/rsaporta/git/misc/rscripts/utils/idcol.r", "/Users/rsaporta/git/orch/src/Looker/additional_lookml_pieces/filters.yaml", "/Users/rsaporta/git/orch/src/Looker/additional_lookml_pieces/bi.accounting.additional_lookml.ssv", "/Users/rsaporta/git/orch/src/Looker/additional_lookml_pieces/bi.analytics_track_level.additional_lookml.ssv", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/get_dim_x.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/region_group_to_factor.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create Accounting on Snowflake.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/create BI_Tables_Dump_From_Snowflake_noHeader file format.r", "/Users/rsaporta/git/misc/rscripts/utils/DB_Utils/SF_Utils.R", "/Users/rsaporta/git/orch/src/Looker/cleanLookerHeaders_after_download.r", "/Users/rsaporta/git/misc/rscripts/utils/xls/exportXLS.r", "/Users/rsaporta/git/misc/rscripts/utils/Orchard_Specific/market_group_to_factor.r", "/Users/rsaporta/git/orch/src/misc/AppleMusic vs SpotifyPremium - Lee - 2015-08-05.r", "/Users/rsaporta/Desktop/cleopatra - multiple labelids.r", "/Users/rsaporta/Desktop/Apple Music Issues.txt", "/Users/rsaporta/Downloads/GSA bak/GSA - Releases Q1 2014 and 2015.csv", "/Users/rsaporta/development/looks/client_team.model.lookml", "/Users/rsaporta/development/looks/country_view.view.lookml", "/Users/rsaporta/git/misc/rscripts/!!Setup New Install/SetupNewInstall.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/02_AN populate_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/03_AN update_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/02_AC populate_aggregated_accounting_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/DeNormalizing/BI_tables/Accounting/01_AC create_aggregated_accounting_snowflake.sql", "/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/orch/src/Spotify_Streams_Per_Top_Artist/11 Plotting.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/DB_Utils/DB_Utils.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", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting - missing transaction types 2015.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting_vs_Analytics_2015 (GL using) - old as of 20150114.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Accounting_vs_Analytics_2015 CTP - DT.iTunes_US_NR.r", "/Users/rsaporta/git/orch/src/Acc_vs_Anal_2015/Comparing OA_acc.acc vs OA_acc.activity.r", "/Users/rsaporta/git/orch/src/Accounting_Date/Months Apart.r", "/Users/rsaporta/git/orch/src/dbconcile/Spot 01 Ingest.r", "/Users/rsaporta/git/orch/src/EU_PricingTest_2015/01 Ingest Candidate Groups.r", "/Users/rsaporta/git/orch/src/EU_PricingTest_2015/01a DT.currency.r", "/Users/rsaporta/git/orch/src/EU_PricingTest_2015/01d DT.raw.r", "/Users/rsaporta/git/orch/src/EU_PricingTest_2015/01e DT.EU_aggd.r", "/Users/rsaporta/git/orch/src/EU_PricingTest_2015/Pretest Setup Splitting UPCs into Groups/01 Ingest UPC Candidates.r", "/Users/rsaporta/git/orch/src/misc/20150205 - missing data Spotify.r", "/Users/rsaporta/git/orch/src/misc/Ankit Spotify Marketshare.r", "/Users/rsaporta/git/orch/src/MissingData2015/iTunes Spotify Missing Data 2015.r", "/Users/rsaporta/git/orch/src/Spotify Playlist Webscrape/supportFns/get_CountryCodes.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/20150415 Spotify Biz Review - User Counts NEW.r" ], "find": { "height": 35.0 }, "find_in_files": { "height": 93.0, "where_history": [ "", "", "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "merge", "track", "files.hidden_content", "apple_id", "science", "clean", "artist_name", "artist_name_cleaned", "DT.merge", "upc", "Something went wrong with pulling the data", "view_label: |", "label: All", "_nows", "blacklist", "rwords", "setscience", "artist_name", "addcolsfrom_", "is_various_artistsrious_artists", "is_va", "Searching", "is_va", "isva", "not_id :=", "Some columns", "vendor_id", "Once in DT.merge,", "cols_not_using_from_DT.hidden", "cols_bringing_to_merge", "DT.casted <- ", "DT.releases_with_metadata", "dt.hidden <- ", "DT.hidden", "DT.hidden <-", "DT.hidden <- ", "DT.casted <- ", "HIDDEN_CONTENT_ITUNES_WIDE", "release_with_metadata", "total_infrac", "total_infractions", "total_infrac", "total_infracs_by", "total_infracs_by_upc", "total_infracs", "&&&", "first", "last_infraction", "latest_infraction_", "primary_key", "year_of_latest_infraction_upc", "year_of_latest_infraction", "year_of_latest_infraction_", "DT.lookml", "dt.lookml <-", "sfdesc", "label2", "decimals", "-- \"); DT.lookml[grepl(\"total\", field_name)]; catn()", "DT.lookml[grepl(\"total\", field_name)]", "label :=", "browser", "EXECUTE_MODEL", "converting from integer to factor", "rwords", "measure", " label: ", "#", "ingest", ",", "- ", "make_rsync_cmd", "verboseMsg", "any_event_in_first90days_", "total_infracs_", "distinct_reasons_", "_", "total_infracs_upc", "total_event", "at_least", "by.*country", "country", "\"prod\"", "prod", "\"bi\"", "artist_name", "clean_", "stopifnot", "ingestI", "has_in", "nfringe", "has_", "error", "Error", "has_err", "_err ", "_err", "error", "err", "\\b|_err_|\\b", "\\\\berr\\\\b", "\\berr\\b", "has_err", "error", "labelid", "f.out", "DT.merge.recent", "release", "\"release\"", "grpCol <- ", "head(", "ol", "col", "releas.", "N", "DT.samp <- ", "tm::", "clean_wrapper", "parens", "clean_wrapper_simple", "artist_name_words", "string_to_words", "clean_wrapper_simple", "kara", "string_to_words", "clean_wrapper_simple", "st ", "DT.rel_wourd_counts" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": false, "replace_history": [ "view_label: ' |'", "view_label: |", "", "is_various_artists", "lifetime_infrac", "total_infrac", "year_of_latest_infraction_by_upc", "-- \"); print(DT.lookml[grepl(\"total\", field_name)]); catn()", "-- \"); DT.lookml[grepl(\"total\", field_name)]; catn()", "any_event_in_first90days_by_", "any_event_in_first90days_", "total_infracs_by_", "total_infracs_", "distinct_reasons_by_", "Searching", "total_infrac", "dbname", "schema", "nfrac", "infringe", "Infringe", "has_infr", "DT.merge.rates", "artist", "ol.r", "release.", "releas.", "clean_wrapper_for_wordsplit", "clean_wrapper_simple", "artist_name_word_stems", "artist_name_words", "DT.rel.counts.word", "percTrue", "year_of_latest_infraction", "5", "99925344528", "99925996628", "source_has_problems", "is_source_has_problems", "DT.releases_with_metadata", "DT.releases_with_joins", "occurred_first_90_days", "first_90_days", "client_manager_at_the_time ", "_apid", "first_90_days", "x.samp", "x.char", "digest_sapply_explicit", "digest_sapply_std", "digest_vec2", "digest_vectorize", "aid_by_name", "csv.aid_name", "artistid_by_name", "Google Play (MUSIC)", "Google Play MUSIC", "496", "non_ascii_letters", "DT.ret", "_withws", "l", "s", "y", "c", "n", "u", "o", "i", "e", "|\",", "\\\"", ".create_looker_table_view_name", "create_looker_table_view_name", "create_lookml_model_from_schema", "create_model_from_schema", "create_lookml_model", "create_model_from_files", "pattern", "zArchive_if_flagged", "rsync=TRUE", "rsync=FALSE", "=tbl.apple", "call.", "transaction_type_id", "foreign_key: releaseid", "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" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "selected": 2, "sheets": [ { "buffer": 0, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/IRIS UPCs Match.r", "semi_transient": false, "settings": { "buffer_size": 2200, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_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", "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" ], "incomplete_sync": null, "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": 3, "type": "text" }, { "buffer": 1, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/01 Hidden Content Modelling.r", "semi_transient": false, "settings": { "buffer_size": 13188, "regions": { }, "selection": [ [ 13086, 13086 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_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", "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" ], "incomplete_sync": null, "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": 2228.0, "zoom_level": 1.0 }, "stack_index": 1, "type": "text" }, { "buffer": 2, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/00 Hidden files from DL to Ingest Dir.r", "semi_transient": false, "settings": { "buffer_size": 3421, "regions": { }, "selection": [ [ 1486, 1486 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "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_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content" ], "incomplete_sync": null, "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": 16.0, "zoom_level": 1.0 }, "stack_index": 0, "type": "text" }, { "buffer": 3, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/02 Hidden Content - Simple.r", "semi_transient": false, "settings": { "buffer_size": 14023, "regions": { }, "selection": [ [ 2811, 2816 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_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", "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" ], "incomplete_sync": null, "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": 374.0, "zoom_level": 1.0 }, "stack_index": 2, "type": "text" }, { "buffer": 4, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/for brad 2015-10-30.r", "semi_transient": false, "settings": { "buffer_size": 2338, "regions": { }, "selection": [ [ 636, 636 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_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", "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" ], "incomplete_sync": null, "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": 4, "type": "text" }, { "buffer": 5, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/Offending Words.r", "semi_transient": false, "settings": { "buffer_size": 511, "regions": { }, "selection": [ [ 0, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_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", "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" ], "incomplete_sync": null, "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": 6, "type": "text" }, { "buffer": 6, "file": "/Users/rsaporta/git/orch/src/ContentAnalysis/Hidden Content 03 by String Parts.r", "semi_transient": false, "settings": { "buffer_size": 24417, "regions": { }, "selection": [ [ 260, 0 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_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_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_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_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", "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" ], "incomplete_sync": null, "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": 5, "type": "text" } ] } ], "incremental_find": { "height": 25.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": 82.0 }, "output.git-pull": { "height": 88.0 }, "output.git-push": { "height": 82.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "hidden content.sublime-project", "replace": { "height": 46.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "mk", "supportFns/mkForecast.r" ], [ "push", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "ush", "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": 225.0, "status_bar_visible": true, "template_settings": { } }