How to Use SQL with Excel using Python

In this video you will learn how to use SQL with excel using python. Use sql with excel with python and learn to automate your excel tasks.

👉 Instagram: @theaiwarriors

What Does a Data Science Executive Carry Around in 2019?

Laptop - 2018 MacBook Pro with Touch Bar
Tablet - 2017 9.7” iPad or

Home Setup for more intense analysis and editing:

Other options to run Python on a budget

Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)

Favourite Mobile Apps to Run Python and Code

Music:

Creative Commons — Attribution 3.0 Unported — CC BY 3.0

[TJKing]

Thank you so much! This is exactly what I've been looking for for a long time. I've never found a good explanation of how to get a preexisting dataset into a database or SQL environment, but this skips that entirely so I can get started practicing SQL!

[roryderrick]

Thanks! This was very informative. I've worked with Excel and SQL Server for years and working with Python in the last few years. This beats VB hands down. As I saw one person post, Python is the glue that brings apps together.

[reynaldomorillo]

I am an MS Access/Oracle/SQL and .Net Developer learning python to improve and automate my processes; this tutorial is, the BEST, someone like myself can find on how to leverage and query excel by treating it as a SQL data source. OUTSTANDING tutorial!!!!

[andybecker]

This is a nice time saver instead of creating a table, importing, then manipulating with sql for one timers or not often used sheets

[supersql]

Please do more of these videos with SQL wildcards! Maybe finding only valid emails * food for thoughts

[tareqalhossaintomal]

Thanks for the great short really informative tutorial .... I request you to make a elaborate tutorial discussing the same topic with more information

[BrianThomas]

This is pretty awesome. What if the Excel workbooks lived on SharePoint? What would I do differently?

[vinaprannavem]

This is wonderful. Although all could be done with pandas. It's interesting for those who already master SQL. 😊

[kaneybubs]

Best use case video for Python/Excel/SQL I've seen and really well explained! Subscribed and now watching everything... Awesome Job!

[LouisDocquer]

wonderful job mate, very much appreciated. Hands down

[johnmosha]

Thank you so much this is very useful

[niftyoptionslivetradingand]

Great piece of work loved your video, thanks for posting 👍🙏

[trueintellect]

I had been using much more complex methods of querying data frames. I don't know why this never occurred to me until now, but I'm definitely going to do it this way from now on.

[gabrielrml]

WOW get out ODBC connectors and all that - this is great.

[DineshVaidyaOfficial]

Really Really Awesome. Thanks a lot...

[martincastillo]

Just what I was looking for. Thank you so much. Please keep on creating videos that benefit a lot of us!!!

[Riddingwithvivian]

If you want to advance your career then you have to learn these languages. Every person regardless of your discipline needs to learn SQL, Python and basic excel formulas and more importantly Excel navigation. Saying that though someone in a few years or if they haven't already will come up with a way to this in a drag and drop format avoiding some of the technicality ie Rows or Glide.

[rpsbr]

Thanks for this great content and straightforward explanation

[messeletchayele]

Thank you so much! Truly this is exceptional! 🙌

[harshitsaini]

Instead of creating a new Excel file for output, how may I add output to an existing sheet or to new sheet of same excel?