{"id":10123,"date":"2025-08-19T11:08:23","date_gmt":"2025-08-19T19:08:23","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/python\/?p=10123"},"modified":"2025-08-19T11:08:23","modified_gmt":"2025-08-19T19:08:23","slug":"data-wrangler-results-table","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/python\/data-wrangler-results-table\/","title":{"rendered":"Announcing the Data Wrangler powered Notebook Results Table"},"content":{"rendered":"<p>If you have ever found yourself rewriting the last line of a notebook cell repeatedly just to get an overview of your data, you&#8217;re not alone. In VS Code the default output for Pandas DataFrames is a static, truncated HTML table and it often fails to answer essential questions, such as:<\/p>\n<ul>\n<li>Do we have rogue blank values somewhere we did not expect?<\/li>\n<li>Do the columns we plan on using as keys really contain unique values?<\/li>\n<li>Are the data types what I expect them to be?<\/li>\n<li>How many times does a specific value show up in the results?<\/li>\n<li>What are the last 10 items in this 30k items list?<\/li>\n<\/ul>\n<p>Check out how <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-toolsai.datawrangler\">Data Wrangler<\/a> integrates seamlessly with notebooks in VS Code to enable you to answer these questions quickly and easily, with just a few clicks.<\/p>\n<h2>Seamless integration with notebooks<\/h2>\n<p>The new experience seamlessly replaces the static HTML output for Pandas DataFrames, only where applicable, and without any additional actions. Just make sure the <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-toolsai.datawrangler\">Data Wrangler extension<\/a> is installed \ud83d\ude0a<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/notebook-integration-vid.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10131\" src=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/notebook-integration-vid.gif\" alt=\"GIF demonstrating viewing the contents of a Pandas DataFrame directly from within the Notebooks output cell using the embedded Data Wrangler UI.\" width=\"946\" height=\"642\" \/><\/a><\/p>\n<h2>Column sorting and filtering<\/h2>\n<p>There is no need to write code for sorting and filtering. You can just click around the interactive UI as you explore the data.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/column-sorting-filtering-vid.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10125\" src=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/column-sorting-filtering-vid.gif\" alt=\"GIF demonstrating sorting the host_name column and filtering the host_about column.\" width=\"1023\" height=\"601\" \/><\/a><\/p>\n<h2>Missing (blank) and distinct values are auto detected<\/h2>\n<p>You can instantly know if a column contains missing (blank) values or repeating values you did not expect just by glancing at the column header.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/missing-and-distinct-values.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10130\" src=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/missing-and-distinct-values.png\" alt=\"Static image demonstrating column statistics about the columns's values.\" width=\"1005\" height=\"151\" srcset=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/missing-and-distinct-values.png 1005w, https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/missing-and-distinct-values-300x45.png 300w, https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/missing-and-distinct-values-768x115.png 768w\" sizes=\"(max-width: 1005px) 100vw, 1005px\" \/><\/a><\/p>\n<h2>Deep data insights at your fingertips<\/h2>\n<p>Access summaries, statistics, histograms, frequency, and more, all instantly and without leaving the context of your notebook cell.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/data-summary.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10126\" src=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/data-summary.png\" alt=\"Static image demonstrating the Data Summary panel which contains statistics about the selected column 'reviews_per_month'.\" width=\"1191\" height=\"662\" srcset=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/data-summary.png 1191w, https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/data-summary-300x167.png 300w, https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/data-summary-1024x569.png 1024w, https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/data-summary-768x427.png 768w\" sizes=\"(max-width: 1191px) 100vw, 1191px\" \/><\/a><\/p>\n<h2>Full view mode + Copilot<\/h2>\n<p>With just one click you can jump into the full Data Wrangler experience for even more data cleaning operations and <a href=\"https:\/\/devblogs.microsoft.com\/python\/announcing-github-copilot-in-data-wrangler\/\">Copilot powered data cleaning<\/a>. Going back to the notebook view is just one click away.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/full-view-mode-copilot-vid.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10129\" src=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/full-view-mode-copilot-vid.gif\" alt=\"GIF demonstrating using Copilot within Data Wrangler to create a new column called 'price_clean' by removing currency signs and punctuation from the existing column 'price'.\" width=\"1113\" height=\"800\" \/><\/a><\/p>\n<h2>Export as csv or parquet<\/h2>\n<p>Export your data as CSV or Parquet files for further analysis or to feed it into a pipeline.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/export-as-csv-vid.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10128\" src=\"https:\/\/devblogs.microsoft.com\/python\/wp-content\/uploads\/sites\/12\/2025\/08\/export-as-csv-vid.gif\" alt=\"GIF demonstrating aggregating the data by price and number of bedrooms and then exporting as csv.\" width=\"1113\" height=\"800\" \/><\/a><\/p>\n<h2>Getting started today<\/h2>\n<p>To try out this experience today, make sure you have the free <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=ms-toolsai.datawrangler\">Data Wrangler extension for VS Code<\/a> installed. Then, run any Pandas DataFrame in your Jupyter notebook inside VS Code, and watch as Data Wrangler immediately enhances the output with powerful, interactive features (running a cell with just your DataFrame df is enough to get started).<\/p>\n<p>As we iterate to make Data Wrangler the best data exploration and preparation tool, we want to hear from you! If you have any feedback about this experience, please let us know in our <a href=\"https:\/\/github.com\/microsoft\/vscode-data-wrangler\/issues\">GitHub repository<\/a>.<\/p>\n<p>Elevate your data science workflow and enjoy a more intuitive way to work with your data today!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An introduction to the new Results Table integrated into the output cell of Notebooks, powered by the VS Code extension called Data Wrangler.<\/p>\n","protected":false},"author":127,"featured_media":10124,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1271,1272,1,6],"tags":[1276,1274,1266,1275,14,1267,1284,1286,1285],"class_list":["post-10123","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","category-data-wrangler","category-python","category-visual-studio-code","tag-ai","tag-copilot","tag-csv","tag-exploratory-data-analysis","tag-jupyter","tag-notebooks","tag-pandas","tag-parquet","tag-xls"],"acf":[],"blog_post_summary":"<p>An introduction to the new Results Table integrated into the output cell of Notebooks, powered by the VS Code extension called Data Wrangler.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/posts\/10123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/users\/127"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/comments?post=10123"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/posts\/10123\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/media\/10124"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/media?parent=10123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/categories?post=10123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/python\/wp-json\/wp\/v2\/tags?post=10123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}