If you've ever found yourself typing the same DataFrame inspection commands over and over just to get a quick sense of your data, you're not alone. The default Pandas output in VS Code notebooks is a static, truncated HTML table that often leaves you guessing about missing values, data types, uniqueness, and simple summaries. Data Wrangler's new interactive notebook results table changes all that. Here are the top 10 things you need to know about this powerful enhancement.
1. No More Repeated Cell Typing
Gone are the days of typing df.head() or df.describe() in every other cell just to peek at your data. The new interactive table replaces the static output with a live, sortable, and filterable view. You can instantly see the first and last rows, check for blank values, and verify uniqueness—all without writing a single line of code. This feature alone saves data scientists and analysts hours of repetitive effort, letting you stay in the flow of exploration.
2. Missing Values Revealed at a Glance
One of the most common questions during data exploration is: "Do I have rogue blank values?" With Data Wrangler, the column header automatically shows the count of missing (blank) values. A quick scan tells you if any columns have unexpected nulls, so you can address them before they break downstream analysis. No more scrolling through endless rows or writing df.isnull().sum()—the information is right there in your notebook cell.
3. Uniqueness Check Without Code
When you plan to use a column as a key, you need to know if all values are unique. The new results table shows a distinct value count directly in the column header. If the count matches the row count, you know the column is unique. If not, you can quickly see duplicates. This immediate feedback helps you validate primary keys and identify potential join issues on the fly.
4. Data Types at a Glance
Data type mismatches are a frequent source of bugs. Now, each column header displays the data type (e.g., int64, object, float64) alongside other stats. You can instantly spot if a column that should be numeric is being treated as a string, or if a date column is in the wrong format. This feature helps you catch issues early and avoid costly transformations later.
5. Value Frequency Counts in Seconds
Need to know how many times a specific value appears? Instead of writing df['col'].value_counts() and parsing the output, simply click on the column header and select “Frequency” from the menu. A histogram and value counts appear instantly, letting you see the distribution of your data. This is especially useful for categorical columns where you need to check for imbalance or rare categories.
6. Browse Large Datasets Effortlessly
Working with a 30,000-row DataFrame? The interactive table supports scrolling through all rows without truncation. You can quickly navigate to the last 10 items of a large dataset without writing custom slicing code. The virtualized scrolling ensures that even millions of rows remain responsive, so you can explore every corner of your data with ease.
7. Sort and Filter Without Code
Sorting and filtering are now point-and-click operations. Click any column header to sort ascending or descending. Use the filter icon to apply simple conditions (e.g., show only rows where a column is greater than a value). No more writing df.sort_values() or df[df['col'] > 0] repeatedly. This makes rapid iteration during data profiling much more intuitive.
8. Deep Insights Without Leaving Your Cell
Beyond basic stats, you can access comprehensive summaries, histograms, and distribution plots with a single click. The interactive panel shows mean, median, standard deviation, min, max, and quartiles for numeric columns. For categorical columns, you get mode, frequency, and unique counts. All this information is presented in a clean overlay, so you never lose your place in the notebook.
9. One Click to Full Data Wrangler + Copilot
Need more advanced cleaning? A single button takes you into the full Data Wrangler experience, where you can apply transformations like fill missing values, rename columns, split strings, and more. And with Copilot integration, you can describe your desired cleaning in plain language and let AI generate the steps. Returning to your notebook is just as easy—one click brings you back with the cleaned DataFrame ready to use.
10. Export to CSV or Parquet
Once you've explored and maybe transformed your data, you can export the results directly to CSV or Parquet files. This is ideal for feeding cleaned data into a machine learning pipeline or sharing with teammates. The export button is right in the interactive table, so you don't need to write df.to_csv(). It's a seamless way to transition from exploration to production.
Getting Started Today
To experience these features, install the free Data Wrangler extension for VS Code. Then run any Pandas DataFrame in a Jupyter notebook cell. The interactive results table will appear automatically. For example, just running a cell with df is enough to activate the new view. We’d love to hear your feedback—visit our GitHub repository to share your thoughts or report issues.
Conclusion
Data Wrangler's interactive notebook results table transforms the way you explore and prepare data in VS Code. It eliminates repetitive coding, surfaces critical insights instantly, and integrates seamlessly with advanced tools like Copilot. Whether you're a seasoned data scientist or a beginner, these 10 features will boost your productivity and make data exploration more intuitive. Try it today and see how much faster your workflow can become.