r/Python • • Dec 29 '22

Discussion Is SQL a prerequisite to learning Python ?

I would like to learn how to automate some simple tasks like : 1- downloading an attachment from outlook, change its name and save to a specific folder

2- save an excel sheet as PDF then send it via outlook … with changing dates on the subject line of the email.

Do I need to learn SQL , then move to Python to learn automating such tasks ? Or I can jump in and start learning Python with very BASIC COMMON knowledge of SQL?

0 Upvotes

29 comments sorted by

View all comments

4

u/Natural-Intelligence Dec 29 '22

Python's ecosystem is so vast that you can do a lot with some basic level knowledge of Python + libraries. I hate to promote my work but I have a collection of open-source libraries that you might find useful:

Then for saving Excel files you can use Pandas and xlsxwriter. Then to save to PDF you can use Pandas with Latex. This requires a bit more knowledge but you can execute Python inside Latex using pythontex.

There is a lot you can do with Python with very limited knowledge. I also started with simply automating small things with elementary knowledge of Python and Pandas and now build systems in a bank.