用 SQL 查询 Jupyter Notebook 数据帧

DataSpell by JetBrains is an Integrated Development Environment (IDE) specifically designed for data analysts and engineers. It allows you to write Python scripts, run SQL queries, analyze data in Jupyter notebooks, manage dbt workflows, and connect to various databases, all within one seamless interface. DataSpell empowers you to stay focused on exploring insights and delivering high-quality results by combining rich data analysis tools with features like real-time error checking, code quality analysis, and built-in support for best practices like testing and documentation.

The DataSpell 2024.1 update brings the power of SQL directly to your Jupyter Notebook. This enhancement allows you to seamlessly analyze data frames and CSV files using intuitive SQL syntax. Simply create a dedicated SQL cell, select the target data frame, and craft your queries to filter, sort, or manipulate data with ease. DataSpell's powerful coding assistance ensures a smooth and efficient workflow throughout the process.

To see a full list of what's new in version 2024.1, see our release notes.

DataSpell is licensed per user as a commercial annual subscription. See our DataSpell licensing page for full details.

For more information, visit our DataSpell product page.