{"id":90169,"date":"2021-06-02T12:07:44","date_gmt":"2021-06-02T16:07:44","guid":{"rendered":"https:\/\/ibkrcampus.com\/?p=90169"},"modified":"2022-11-21T09:47:34","modified_gmt":"2022-11-21T14:47:34","slug":"financial-data-manipulation-in-dplyr-for-quant-traders-part-iv","status":"publish","type":"post","link":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/","title":{"rendered":"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><em>See&nbsp;<a href=\"\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders\/\">Part I<\/a>,&nbsp;<a href=\"\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-ii\/\">Part II<\/a>&nbsp;and <a href=\"\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iii\/\">Part III<\/a> to &nbsp;set up and load the data<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The&nbsp;<code>select()<\/code>&nbsp;dplyr verb<\/p>\n\n\n\n<figure class=\"wp-block-image img-twothird\"><img decoding=\"async\" width=\"419\" height=\"73\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-select-robot-wealth.png\" alt=\"Financial Data Manipulation in dplyr for Quant Traders\" class=\"wp-image-90184 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-select-robot-wealth.png 419w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-select-robot-wealth-300x52.png 300w\" data-sizes=\"(max-width: 419px) 100vw, 419px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 419px; aspect-ratio: 419\/73;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><code>select()<\/code>&nbsp;is used to pull out certain columns from your data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-selecting-columns-with-select\">Selecting columns with&nbsp;<code>select()<\/code><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Here we use&nbsp;<code>select()<\/code>to pull out the&nbsp;<code>ticker<\/code>,&nbsp;<code>date<\/code>&nbsp;and&nbsp;<code>close<\/code>&nbsp;columns.<\/p>\n\n\n\n<p style=\"background-color:#fcfcdb;font-size:12px\" class=\"has-background\">\nprices %&gt;%<br>\n  select(ticker, date, close)\n<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"850\" height=\"332\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-6-robot-wealth.png\" alt=\"\" class=\"wp-image-90205 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-6-robot-wealth.png 850w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-6-robot-wealth-700x273.png 700w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-6-robot-wealth-300x117.png 300w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-6-robot-wealth-768x300.png 768w\" data-sizes=\"(max-width: 850px) 100vw, 850px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 850px; aspect-ratio: 850\/332;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Chaining Transformations Together: Filtering, selecting and arranging<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"572\" height=\"130\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-pipes-robot-wealth-3.png\" alt=\"\" class=\"wp-image-90227 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-pipes-robot-wealth-3.png 572w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-pipes-robot-wealth-3-300x68.png 300w\" data-sizes=\"(max-width: 572px) 100vw, 572px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 572px; aspect-ratio: 572\/130;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We can chain transformations together using the pipe operator %&gt;%.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>If you\u2019re unsure how the pipe operator works, visit <a href=\"https:\/\/robotwealth.com\/financial-data-manipulation-in-dplyr-for-quant-traders\/\">Robot Wealth website<\/a> to watch a video on this topic<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019re going to chain together a transformation which:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>filters out a single stock<\/li><li>selects the date and close price<\/li><li>re-arranges by date descending.<\/li><\/ul>\n\n\n\n<p style=\"background-color:#fcfcdb;font-size:12px\" class=\"has-background\">\nprices %&gt;%<br>\n  filter(ticker == &#8216;XOM&#8217;) %&gt;%<br>\n  select(date, close) %&gt;%<br>\n  arrange(desc(date))\n<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"569\" height=\"328\" data-src=\"\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-7-robot-wealth.png\" alt=\"\" class=\"wp-image-90218 lazyload\" data-srcset=\"https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-7-robot-wealth.png 569w, https:\/\/ibkrcampus.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/dplyr-for-traders-7-robot-wealth-300x173.png 300w\" data-sizes=\"(max-width: 569px) 100vw, 569px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 569px; aspect-ratio: 569\/328;\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>When debugging a dplyr pipeline,&nbsp;it can be helpful to select each transformation one by one, and press CTRL-Enter in Rstudio to just run the selected transformation.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"h-stay-tuned-for-the-next-installment-in-which-the-author-will-demonstrate-the-arrange-dplyr-verb\"><em>Stay tuned for the next installment in which the author will demonstrate the&nbsp;<code><code>mutate()<\/code>&nbsp;dplyr verb<\/code><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Visit Robot Wealth website to read the full article and download code:&nbsp;<a href=\"https:\/\/robotwealth.com\/financial-data-manipulation-in-dplyr-for-quant-traders\/\">https:\/\/robotwealth.com\/financial-data-manipulation-in-dplyr-for-quant-traders\/<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.<\/p>\n","protected":false},"author":421,"featured_media":90176,"comment_status":"closed","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[339,343,338,350,341,344,342],"tags":[9390,2535,9188,6591,508,9815],"contributors-categories":[13676],"class_list":["post-90169","post","type-post","status-publish","format-standard","has-post-thumbnail","category-data-science","category-programing-languages","category-ibkr-quant-news","category-quant-asia-pacific","category-quant-development","category-quant-regions","category-r-development","tag-arrange-dplyr-verb","tag-dplyr","tag-filter-dplyr-verb","tag-rstats","tag-rstudio","tag-select-dplyr-verb","contributors-categories-robot-wealth"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v28.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV<\/title>\n<meta name=\"description\" content=\"Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/90169\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV | IBKR Quant Blog\" \/>\n<meta property=\"og:description\" content=\"Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/\" \/>\n<meta property=\"og:site_name\" content=\"IBKR Campus US\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-02T16:07:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-21T14:47:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Robot James\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Robot James\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\\\/\\\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"NewsArticle\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/#article\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/\"\n\t            },\n\t            \"author\": {\n\t                \"name\": \"Robot James\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/0fcf297a219d9485e2efa476d632b468\"\n\t            },\n\t            \"headline\": \"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV\",\n\t            \"datePublished\": \"2021-06-02T16:07:44+00:00\",\n\t            \"dateModified\": \"2022-11-21T14:47:34+00:00\",\n\t            \"mainEntityOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/\"\n\t            },\n\t            \"wordCount\": 206,\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/06\\\/quant-charts.jpg\",\n\t            \"keywords\": [\n\t                \"arrange() dplyr verb\",\n\t                \"dplyr\",\n\t                \"filter dplyr verb\",\n\t                \"rstats\",\n\t                \"RStudio\",\n\t                \"select() dplyr verb\"\n\t            ],\n\t            \"articleSection\": [\n\t                \"Data Science\",\n\t                \"Programming Languages\",\n\t                \"Quant\",\n\t                \"Quant Asia Pacific\",\n\t                \"Quant Development\",\n\t                \"Quant Regions\",\n\t                \"R Development\"\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/\",\n\t            \"name\": \"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV | IBKR Quant Blog\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/06\\\/quant-charts.jpg\",\n\t            \"datePublished\": \"2021-06-02T16:07:44+00:00\",\n\t            \"dateModified\": \"2022-11-21T14:47:34+00:00\",\n\t            \"description\": \"Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"@id\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/ibkr-quant-news\\\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\\\/#primaryimage\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/06\\\/quant-charts.jpg\",\n\t            \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2021\\\/06\\\/quant-charts.jpg\",\n\t            \"width\": 1000,\n\t            \"height\": 563,\n\t            \"caption\": \"Quant\"\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#website\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"name\": \"IBKR Campus US\",\n\t            \"description\": \"Financial Education from Interactive Brokers\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Organization\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#organization\",\n\t            \"name\": \"Interactive Brokers\",\n\t            \"alternateName\": \"IBKR\",\n\t            \"url\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/\",\n\t            \"logo\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\",\n\t                \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"contentUrl\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/05\\\/ibkr-campus-logo.jpg\",\n\t                \"width\": 669,\n\t                \"height\": 669,\n\t                \"caption\": \"Interactive Brokers\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/logo\\\/image\\\/\"\n\t            },\n\t            \"publishingPrinciples\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/about-ibkr-campus\\\/\",\n\t            \"ethicsPolicy\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/cyber-security-notice\\\/\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\\\/\\\/ibkrcampus.com\\\/campus\\\/#\\\/schema\\\/person\\\/0fcf297a219d9485e2efa476d632b468\",\n\t            \"name\": \"Robot James\",\n\t            \"url\": \"https:\\\/\\\/www.interactivebrokers.com\\\/campus\\\/author\\\/robotjames\\\/\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV","description":"Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.interactivebrokers.com\/campus\/wp-json\/wp\/v2\/posts\/90169\/","og_locale":"en_US","og_type":"article","og_title":"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV | IBKR Quant Blog","og_description":"Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.","og_url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/","og_site_name":"IBKR Campus US","article_published_time":"2021-06-02T16:07:44+00:00","article_modified_time":"2022-11-21T14:47:34+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg","type":"image\/jpeg"}],"author":"Robot James","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Robot James","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/#article","isPartOf":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/"},"author":{"name":"Robot James","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0fcf297a219d9485e2efa476d632b468"},"headline":"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV","datePublished":"2021-06-02T16:07:44+00:00","dateModified":"2022-11-21T14:47:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/"},"wordCount":206,"publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg","keywords":["arrange() dplyr verb","dplyr","filter dplyr verb","rstats","RStudio","select() dplyr verb"],"articleSection":["Data Science","Programming Languages","Quant","Quant Asia Pacific","Quant Development","Quant Regions","R Development"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/","url":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/","name":"Financial Data Manipulation in dplyr for Quant Traders \u2013 Part IV | IBKR Quant Blog","isPartOf":{"@id":"https:\/\/ibkrcampus.com\/campus\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/#primaryimage"},"image":{"@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/#primaryimage"},"thumbnailUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg","datePublished":"2021-06-02T16:07:44+00:00","dateModified":"2022-11-21T14:47:34+00:00","description":"Join Robot James for a tutorial on how to use select() to pull out certain columns from your data.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.interactivebrokers.com\/campus\/ibkr-quant-news\/financial-data-manipulation-in-dplyr-for-quant-traders-part-iv\/#primaryimage","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg","width":1000,"height":563,"caption":"Quant"},{"@type":"WebSite","@id":"https:\/\/ibkrcampus.com\/campus\/#website","url":"https:\/\/ibkrcampus.com\/campus\/","name":"IBKR Campus US","description":"Financial Education from Interactive Brokers","publisher":{"@id":"https:\/\/ibkrcampus.com\/campus\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ibkrcampus.com\/campus\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ibkrcampus.com\/campus\/#organization","name":"Interactive Brokers","alternateName":"IBKR","url":"https:\/\/ibkrcampus.com\/campus\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/","url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","contentUrl":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2024\/05\/ibkr-campus-logo.jpg","width":669,"height":669,"caption":"Interactive Brokers"},"image":{"@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/logo\/image\/"},"publishingPrinciples":"https:\/\/www.interactivebrokers.com\/campus\/about-ibkr-campus\/","ethicsPolicy":"https:\/\/www.interactivebrokers.com\/campus\/cyber-security-notice\/"},{"@type":"Person","@id":"https:\/\/ibkrcampus.com\/campus\/#\/schema\/person\/0fcf297a219d9485e2efa476d632b468","name":"Robot James","url":"https:\/\/www.interactivebrokers.com\/campus\/author\/robotjames\/"}]}},"jetpack_featured_media_url":"https:\/\/www.interactivebrokers.com\/campus\/wp-content\/uploads\/sites\/2\/2021\/06\/quant-charts.jpg","_links":{"self":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/90169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/users\/421"}],"replies":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/comments?post=90169"}],"version-history":[{"count":0,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/posts\/90169\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media\/90176"}],"wp:attachment":[{"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/media?parent=90169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/categories?post=90169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/tags?post=90169"},{"taxonomy":"contributors-categories","embeddable":true,"href":"https:\/\/ibkrcampus.com\/campus\/wp-json\/wp\/v2\/contributors-categories?post=90169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}