DataSpell 2023.3 EAP 2 Is Out! Introducing SQL Cells and Graphical Representation of Column Data
The second EAP release of DataSpell 2023.3 introduces several exciting features, including SQL cells in Jupyter notebooks and graphical representation of column data.
Below you’ll find the most noteworthy improvements available in DataSpell 2023.3 EAP 2. Please try them out and share your feedback in the comments below or in our issue tracker.
According to the 2022 State of Data Science survey by Anaconda, SQL is the second most used programming language by data scientists and data analysts after Python.
DataSpell already had great SQL support through the bundled Database Tools and SQL plugin powered by DataGrip. We’ve now gone a step further by introducing SQL cells.
Just like Python or Markdown cells, you can now use SQL cells in your Jupyter notebooks. You can get data from your database with an SQL cell, and it will be automatically put into a pandas DataFrame format to use immediately in your notebook.
To start using the cell, you need to:
- Create an SQL cell.
- Select the data source you want to use in the top-left corner of the cell.
- Set the Python variable name where the result of the SQL request will be stored as a pandas DataFrame.
- Start using your native SQL code and continue working in Python.
Graphical representation of column data
Visualizing data graphically is a common practice for data analysts, as it offers an easy way to understand distributions, identify potential data issues, and derive insights to guide further data exploration. To accomplish this, we’re introducing a significant simplification to your data analysis workflow – graphical representation of column data. With just a few clicks, you can build graphs based on your table data, greatly expediting the visualization process.
These are the most important updates for DataSpell 2023.3 EAP 2!
We’re excited to hear what you think!
Subscribe to Blog updates
Thanks, we've got you!
DataSpell 2023.3 EAP 4 Is Out! AI Assistant, SQL Cells, and Improvements for Interactive Tables
The fourth EAP build for DataSpell 2023.3 brings completion for database objects in SQL cells, the ability to get insights from your DataFrame using JetBrains AI Assistant, productivity boosters for interactive tables, and Full Line Code Completion. To catch up on all of the new features in DataS…
DataSpell 2023.3 EAP 3 is out! Introducing dbt® support!
The third EAP build for DataSpell 2023.3 brings dbt® support, JetBrains AI Assistant actions via the context menu in Jupyter, and easy access to column statistics and data distribution histograms in tables. To catch up on all of the new features in DataSpell 2023.3, check out our previous EAP blo…
DataSpell 2023.3 EAP 1 Is Out! Faster Table Data Exploration, New Project Templates, and the Ability to Sort DataFrames by Multiple Columns
The first EAP release of DataSpell 2023.3 introduces several exciting features: faster table data exploration in the Python console along with support for pandas Series, data analysis project templates, the ability to sort DataFrames by multiple columns, and code completion for Jupyter Magics. Th…
Polars vs. pandas: What’s the Difference?
If you’ve been keeping up with the advances in Python dataframes in the past year, you couldn’t help hearing about Polars, the powerful dataframe library designed for working with large datasets. Try Polars in DataSpell Unlike other libraries for working with larg…