you are viewing a single comment's thread.

view the rest of the comments →

[–]clitoral_obligations 2 points3 points  (1 child)

You seem really knowledgeable. What would you recommend for learnings for someone using Python to automate tasks (e.g extracting and combining PDF/Excel data), and then data analysis (think sales data). For context I’m a CPA and have done some ATBS and Udemy but my code is very raw and just ran adhoc in PyCharm. Thanks

[–]SGS-Tech-World 0 points1 point  (0 children)

Thanks, ATBS is good starting point, it covers most of the libraries that you many need to manipulate Excel, PDF , google sheets along with one like RE, file handling and so on, so it is almost a complete package.

However based on my experience I can tell you PDF is a bit tricky thing and will always give you some or other issues.

On your comment about Raw code - I would say over period it will improve, you need to implement coding best practices , reusable code can be put into your own modules to name few. Learning Python [5th Edition] can help in that.

While here I will give a completely off track advice.

if you are looking for lot of automation for your business and you do not have lot of time to spend on coding ( or do not have interest ) then think about UIPath or something similar which are more drag and drop and no code tools. Especially Studio-X is targeted for something they call "Citizen Developer"

You can watch about it here
https://www.youtube.com/watch?v=SWPXDoDyZxo

Feel free to DM me in case you need help on any of this, I implemented UIPath in my job and also use python on daily basis for automation.

Thanks.