5 Tips for Combining Python and SQL in Datalore

SQL is extremely good for data retrieval and calculating basic statistics, whereas Python comes into its own when you need in-depth, flexible exploratory data analysis or data science. What if you could use both programming languages inside of one tool?

View at original site

In this webinar, Alena Guzharina will demonstrate how you can effectively combine SQL and Python in Datalore. Alena will show you how to:

  • Quickly understand and visualize SQL query results.
  • Seamlessly transition from SQL to Python in one notebook.
  • Parameterize SQL queries with Python variables.
  • Share your results and automate the whole workflow for the future.

Alena Guzharina is a Product Marketing Manager for JetBrains Datalore.

Related Resources

View Database Definitions
View the definitions of database entities quickly in the Database Tool Window
Working with Multiple Databases in a JetBrains IDE
Oh drat! In your latest project, you need to use data from multiple different databases - and worse still, they’re different database types!
Working with SQLite Databases in any JetBrains IDE
In this video, you’ll see how you can skip messing around with the command line and connect to your database just by dragging and dropping.