Use Python to Query a SQL Server Database & Export Results to a CSV File- A Real World Project

preview_player
Показать описание
In this tutorial, I demonstrate how to query your SQL Server database using Python, convert the results to a Pandas data frame and then export the results to a CSV file.

There's a lot of additional detail within the video, it's beginner friendly and is a great example for a Python automation project that also incorporates a common data task. You can automatically run this process and expand the script as you please.

Enjoy!

🤝 Connect with me on LinkedIn:

🤝 View my Website:

Рекомендации по теме
Комментарии
Автор

I keep getting an error message
UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.

AntonioNunnally
Автор

I can't find my Driver name, is still getting me errors

teddyfabriciocordovasaenz