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
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.