How to Use SQL and Pandas to Extract Data From a MySQL Database

preview_player
Показать описание
In this video, we'll look at two ways to answer the question: how many employees were hired each year by the company?

The first way is to simply write the SQL query.

The second way is to apply some data manipulation using Pandas.
Рекомендации по теме
Комментарии
Автор

Can we make df.to_csv()
To change the DB into excel file format ?

BlueSkyGoldSun
Автор

Very helpful. Now I was wondering (being new to sql) if you know how to manipulate data in pandas is it necessary to know how DML works ?

PlanetCherz
Автор

pulling data into pandas works, but I get this warning:
pandas only support SQLAlchemy connectable(engine/connection), please consider using SQLAlchemy

should I use Alchemy library?

MoVolto