The JetBrains Blog
The latest updates on all JetBrains products and topics
How to Read From MySQL Database to pandas With Datalore
Reading data from a MySQL database to a pandas dataframe can be intimidating. Establishing a connection, keeping the credentials safe, creating an SQL query within a string variable, and saving the result to pandas is not a trivial task.
Can data science collaboration be secure? [New Datalore Case Study]
Working with financial data is not a trivial task, as you can’t just access a production database or a data lake, download the data, and work on it. You have to ensure secure access to the data and produce insights that are easy to share as well.
Using PyCharm to Read Data From a MySQL DataBase Into pandas
Sooner or later in your data science journey, you’ll hit a point where you need to get data from a database. However, making the leap from reading a locally-stored CSV file into pandas to connecting to and querying databases can be a daunting task. In the first of a series of blog posts, we’ll explo…
How to Prepare Your Dataset for Machine Learning and Analysis
Learn about data preparation for machine learning and analysis, and avoid some of the most common problems real-world data can throw at you.
What Is Ad Hoc Analysis? A Python Example in Datalore
Find out how to conduct ad hoc analysis using Python and Datalore.
Exploratory Data Analysis in Practice
How to use Exploratory Data Analysis to improve your data analytics? Definition, best practices, and more.
Entity Framework Core and Multiple Database Providers
While many software developers would prefer to sell software as a service (SaaS), there’s a market for offering your customers a self-hosted solution tailored to their infrastructure choices. Of course, one essential element of any modern software solution is the database, but in 2022 there are hund…
New in Datalore: BigQuery Support, SSH tunneling, and More
Learn how to connect your Jupyter Notebook to Google BigQuery in Datalore and try SSH tunneling to connect to remote databases!
Webinar Recording: “5 Tips for Combining Python and SQL in Datalore”
On Thursday, 28th July 2022, I gave a webinar about tips for combining Python and SQL in Datalore, our collaborative data science and data analytics platform. Here’s the recording for you to watch if you missed the live stream.
Webinar: I Can’t Believe It’s Not Real Data! An Introduction to Synthetic Data
Easy access to relevant, safe data is a major bottleneck hindering developers and data scientists. But what if you could generate your own accurate, privacy-protected, shareable data? Synthetic data can provide an inexpensive alternative to real sets of data that can’t be used due to its se…
Working with SQL and databases in Rider – Webinar Recording
The recording for our webinar, Working with SQL and databases in Rider with DataGrip team lead Maksim Sobolevskiy, is now available. Subscribe to our community newsletter to receive notifications about future webinars. https://www.youtube.com/embed/iNWWWj8dCfM Working with SQL and databases in R…
Datalore Enterprise 2022.2: Blazing Fast Docker-based Installation, Scheduled Runs, Collaboration on Attached Files, and More
Today we are happy to introduce the docker-based installation for Datalore Enterprise and a bunch of other ways to streamline your data science team work. Read on for the highlights of the release!