{"id":40449,"date":"2023-08-25T14:23:09","date_gmt":"2023-08-25T18:23:09","guid":{"rendered":"https:\/\/mjtsai.com\/blog\/?p=40449"},"modified":"2023-08-25T14:23:09","modified_gmt":"2023-08-25T18:23:09","slug":"python-in-excel","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2023\/08\/25\/python-in-excel\/","title":{"rendered":"Python in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.theverge.com\/2023\/8\/22\/23841167\/microsoft-excel-python-integration-support\">Tom Warren<\/a> (via <a href=\"https:\/\/news.ycombinator.com\/item?id=37222191\">Hacker News<\/a>):<\/p>\n<blockquote cite=\"https:\/\/www.theverge.com\/2023\/8\/22\/23841167\/microsoft-excel-python-integration-support\">\n<p>A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python.<\/p>\n<p>&ldquo;You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel&rsquo;s formulas, charts and PivotTables to further refine your insights,&rdquo; <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/microsoft-365-blog\/introducing-python-in-excel-the-best-of-both-worlds-for-data\/ba-p\/3905482\">explains Stefan Kinnestrand<\/a>, general manager of modern work at Microsoft. &ldquo;Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon.&rdquo;<\/p>\n<p>You won&rsquo;t need to install any additional software or set up an add-on to access the functionality, as Python integration in Excel will be part of Excel&rsquo;s built-in connectors and Power Query. Microsoft is also adding a new PY function that allows Python data to be exposed within the grid of an Excel spreadsheet. Through a partnership with Anaconda, an enterprise Python repository, popular Python libraries like pandas, statsmodels, and Matplotlib will be available in Excel.<\/p>\n<\/blockquote>\n<p>This sounds really cool, though it&rsquo;s kind of a shame that it doesn&rsquo;t run on-device.<\/p>","protected":false},"excerpt":{"rendered":"<p>Tom Warren (via Hacker News): A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python. &ldquo;You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel&rsquo;s formulas, charts and PivotTables to further refine your insights,&rdquo; explains Stefan Kinnestrand, general manager [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"2023-08-25T18:23:11Z","apple_news_api_id":"64afbe37-7c79-4560-96a1-1c85e0d8aafb","apple_news_api_modified_at":"2023-08-25T18:23:11Z","apple_news_api_revision":"AAAAAAAAAAD\/\/\/\/\/\/\/\/\/\/w==","apple_news_api_share_url":"https:\/\/apple.news\/AZK--N3x5RWCWoRyF4Niq-w","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[35,30,32,2223,856,609,232],"class_list":["post-40449","post","type-post","status-publish","format-standard","hentry","category-technology","tag-cloud","tag-mac","tag-macapp","tag-macos-13-ventura","tag-microsoft-azure","tag-microsoft-excel","tag-python"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/40449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=40449"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/40449\/revisions"}],"predecessor-version":[{"id":40450,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/40449\/revisions\/40450"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=40449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=40449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=40449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}