-
Polars vs. pandas : quelles sont les principales différences ?
Si vous avez suivi les avancées des dataframes en Python, vous avez sans doute entendu parler de Polars, la puissante bibliothèque de dataframes conçue pour travailler avec de grands jeux de données. Contrairement aux autres bibliothèques pour les grands jeux de données tels que Spark, Dask et Ray, Polars est conçue pour être utilisée sur une seule machine, ce qui peut amener à la comparer à pandas. Toutefois, Polars présente de nombreuses différences significatives avec pandas, notamment en ce qui concerne la façon dont elle gère les données et les cas dans lesquels son utilisation est o
-
DataSpell 2024.2: AI Cells, Enhanced Experience With Jupyter Notebooks, Geo Viewer for Tabular Data Files, and More
In DataSpell 2024.2, we've introduced AI cells, enabling AI-assisted code generation, code editing, and error fixing in Jupyter notebooks. The streamlined cell execution includes a Run Cell button next to each cell and a Go To button for the previously executed cell. The new version also includes new collapsible cells and cell tag features, and the new UI has been enabled by default for all users. Additionally, you can now explore geospatial data with the new Geo viewer, and you can use native math syntax in Markdown files. Download the new version of DataSpell from our website, update dir
-
DataSpell 2024.2 EAP Is Open!
This blog post marks the start of the Early Access Program for DataSpell 2024.2. The DataSpell 2024.2 EAP 1 build is now accessible for download, providing an early glimpse into the exciting updates on the horizon.You can download the new version from our website, update directly from inside the IDE or via the free Toolbox App, or use snap packs for Ubuntu. Download DataSpell 2024.2 EAP User experience The new UI made default for all users The new UI for JetBrains IDEs was introduced two years ago and has been continuously refined. We’ve diligently collected your feedback a
-
DataSpell 2024.1: Full Line Code Completion, the Ability to Query Data Frames via SQL Cells, Import Data Cells, dbt Сore Support Improvements
DataSpell 2024.1 introduces features designed to help you significantly boost your productivity. Our ML team has enhanced the local model that powers ML-assisted full line code completion for Python, resulting in longer suggestions with more context taken into account, all without sending data to the internet and completely free of charge. In DataSpell 2024.1, you can now write SQL to query data frames and CSV files directly in your Jupyter notebooks. We’ve introduced Import Data cells, which are a new cell type in DataSpell. You can easily start working with tabular data by dropp
-
DataSpell 2024.1 EAP 2 Is Out, Focusing on dbt Core
The second Early Access Program (EAP) release of DataSpell 2024.1 delivers a range of exciting updates focusing on enhanced dbt Core support. This EAP version enhances code completion, introduces the ability to incorporate environment variables into run configurations, and enables the execution of models directly from SQL files. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website.Below you’ll find the most noteworthy improvements available in DataSpell 2024.1 EAP 2. Pl
-
Join the Livestream: How to work with SQL and Databases in DataSpell
We invite you to join our livestream How to work with SQL and Databases in DataSpell. The event will take place on Monday, January 22, at 1:00 PM UTC. Date: January 22, 2024 Time: 1:00 pm UTC (2:00 pm CET / 8:00 am EST) Register In this livestream, we’ll show you how to write SQL queries and work with data in DataSpell, from writing simple queries faster to more advanced stuff with the help of embedded Database management functionality. What will be covered: Creating a simple query. Various types of code completion, code snippets, expanding wildcards, and workin
-
DataSpell 2023.3: AI Assistant, dbt Core Support, SQL Cells, Interactive Table Productivity Boosters
DataSpell 2023.3 introduces features designed to help you significantly boost your productivity. JetBrains AI Assistant is now generally available with a number of new and improved features. We've integrated support for dbt Core, the well-known data transformation framework, into DataSpell. Working simultaneously with Jupyter and SQL is now easier thanks to the new addition of SQL cells. Moreover, data comprehension has been made effortless; you can now view column data statistics directly in tables, accompanied by data distribution histograms. Lastly, we added the Chart view in tables, enab
-
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 DataSpell 2023.3, check out our previous EAP blog posts. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website. Below, you can find the most interesting features available in Da
-
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 blog posts. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website. Below, you can find the most interesting features available in DataSpell 2023.3 EAP 3. Please try them out a
-
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. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website. 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. Download DataSpell 2023.3 EAP SQL cells According to the
-
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. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website. Download DataSpell 2023.3 EAP Below you’ll find the most noteworthy improvements available in DataSpell 2023.3 EA
-
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 large datasets, such as Spark, Dask, and Ray, Polars is designed to be used on a single machine, prompting a lot of comparisons to pandas. However, Polars differs from pandas in a number of important ways, including how it works with data and what its optimal applications are. In the following article,
-
DataSpell 2023.2: Polars Support, Faster Table Data Exploration, New UI Improvements
DataSpell 2023.2 introduces Polars DataFrames library support, substantial enhancements in table data exploration, new UI improvements, and much more. We’re delighted to announce that we’ve started the integration of Polars as a first-class citizen within DataSpell. We understand how vital it is for data professionals to have access to the descriptive statistics of their data. This release makes data exploration easier than ever by displaying descriptive statistics for data. Users have expressed their love for the newly designed DataSpell UI, appreciating its ability to keep them focused o
-
DataSpell 2023.2 EAP 3 Is Out!
The third EAP build for DataSpell 2023.2 brings you faster table data exploration, the new AI Assistant, and the ability to configure managed Jupyter servers. To catch up on all of the new features DataSpell 2023.2 brings, check out our previous EAP blog posts. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website. Download DataSpell 2023.2 EAP Below you’ll find the most noteworthy improvements available in DataSpell 2023.2 EAP 3. Please try them out and s
-
DataSpell 2023.1.3 Is Out!
DataSpell 2023.1.3 brings you fixes for disappearing notebook cells, invisible DataFrame rows and cell focus bugs.
-
DataSpell 2023.2 EAP 2 Is Out!
In the second EAP build for DataSpell 2023.2 we improved Jupyter Notebooks synchronization with external applications. To catch up on all of the new features DataSpell 2023.2 will bring, check out our previous EAP blog posts. The Toolbox App is the easiest way to get the EAP builds and keep both your stable and EAP versions up to date. You can also manually download the EAP builds from our website. Download DataSpell 2023.2 EAP Improved Jupyter Notebooks Synchronization with External Applications In this release, we have made significant improvements to the synchronizatio
-
DataSpell 2023.2 EAP 1 Is Out!
The Early Access Program (EAP) for DataSpell 2023.2 is now open! The EAP gives you access to pre-release versions of DataSpell, allowing you to evaluate new features, test issues that have been resolved, and provide feedback. EAP builds are free and don’t require a license. All you need is a JetBrains Account. You can learn more about how the program works in this blog post. The first EAP build for DataSpell 2023.2 brings code completion and interactive data frames for Polars, easier access to columns type information and several bug fixes. Download DataSpell 2023.2 EAP Polar
-
DataSpell 2023.1.1 Is Out!
DataSpell 2023.1.1 provides more precise measurement of cell execution time, fixes for disappearing DataFrame tables, and more.
-
DataSpell 2023.1: Support for Multiple Projects, Notebook Productivity Boosters, and DataFrame Enhancements
DataSpell 2023.1 is out! Automatically convert a Jupyter Notebook into a Python script, drag and drop a CSV file to create a pandas DataFrame, and more
-
DataSpell 2023.1 EAP 2 is Out!
Many DataSpell users requested the ability to organize their work into multiple projects with completely separate environments and in DataSpell 2023.1 EAP 2 we have delivered! This second EAP build also contains new features to convert a Jupyter Notebook into a Python script and vice versa, to drag and drop a CSV to create a Pandas DataFrame, and to change the default number of rows displayed for a DataFrame. Finally, debugging and package management just got easier with an interactive debug console in the Jupyter Notebook Debugger and a fully functional Python Packages Tool Window.