{"id":1396,"date":"2014-04-23T13:30:30","date_gmt":"2014-04-23T18:30:30","guid":{"rendered":"https:\/\/blogs.mathworks.com\/videos\/?p=1396"},"modified":"2014-04-23T13:30:30","modified_gmt":"2014-04-23T18:30:30","slug":"modifying-excel-column-names-to-legal-variables-in-matlab","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/videos\/2014\/04\/23\/modifying-excel-column-names-to-legal-variables-in-matlab\/","title":{"rendered":"Modifying Excel column names to legal variables in MATLAB"},"content":{"rendered":"I have been using <a href=\"https:\/\/www.mathworks.com\/help\/matlab\/ref\/table.html\">MATLAB tables<\/a> lately.  In doing that, MATLAB will store meta data with your numeric data.  I was bringing data in from Excel files.  Each column name will eventually become a variable name.  If these column names include characters like &#8216;(&#8216; then they can not be MATLAB variable names.  Rather than modify the Excel files, I just modified the column names before making the table in MATLAB.\r\n\r\n<div><div class=\"row\"><div class=\"col-xs-12 containing-block\"><div class=\"bc-outer-container add_margin_20\"><videoplayer><div class=\"video-js-container\"><video data-video-id=\"3877304422001\" data-video-category=\"blog\" data-autostart=\"false\" data-account=\"62009828001\" data-omniture-account=\"mathwgbl\" data-player=\"rJ9XCz2Sx\" data-embed=\"default\" id=\"mathworks-brightcove-player\" class=\"video-js\" controls><\/video><script src=\"\/\/players.brightcove.net\/62009828001\/rJ9XCz2Sx_default\/index.min.js\"><\/script><script>if (typeof(playerLoaded) === 'undefined') {var playerLoaded = false;}(function isVideojsDefined() {if (typeof(videojs) !== 'undefined') {videojs(\"mathworks-brightcove-player\").on('loadedmetadata', function() {playerLoaded = true;});} else {setTimeout(isVideojsDefined, 10);}})();<\/script><\/div><\/videoplayer><\/div><\/div><\/div>\r\n <\/div>\r\n","protected":false},"excerpt":{"rendered":"<div class=\"thumbnail thumbnail_asset asset_overlay video\"><a href=\"https:\/\/blogs.mathworks.com\/videos\/2014\/04\/23\/modifying-excel-column-names-to-legal-variables-in-matlab\/?dir=autoplay\"><img decoding=\"async\" src=\"https:\/\/cf-images.us-east-1.prod.boltdns.net\/v1\/static\/62009828001\/a2c98d66-eb6c-4954-96c8-c023e7eed0b0\/ab79b25c-7df1-4ea4-a73f-3a0fb5dd65b0\/1280x720\/match\/image.jpg\" onError=\"this.style.display ='none';\"\/>\n      <div class=\"overlay_container\">\n      <span class=\"icon-video icon_color_null\"><time class=\"video_length\">3:38<\/time><\/span>\n      <\/div>\n      <\/a><\/div><p>I have been using MATLAB tables lately.  In doing that, MATLAB will store meta data with your numeric data.  I was bringing data in from Excel files.  Each column name will eventually become a&#8230; <a class=\"read-more\" href=\"https:\/\/blogs.mathworks.com\/videos\/2014\/04\/23\/modifying-excel-column-names-to-legal-variables-in-matlab\/\">read more >><\/a><\/p>","protected":false},"author":68,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/1396"}],"collection":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/users\/68"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/comments?post=1396"}],"version-history":[{"count":9,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/1396\/revisions"}],"predecessor-version":[{"id":1411,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/posts\/1396\/revisions\/1411"}],"wp:attachment":[{"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/media?parent=1396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/categories?post=1396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/videos\/wp-json\/wp\/v2\/tags?post=1396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}