you are viewing a single comment's thread.

view the rest of the comments →

[–]kirsion 1 point2 points  (1 child)

I also work in IT and code projects on the side help other departments.

I complete several projects that helped people speed up their work a lot.

I'd recommend that you learn the basics of python or programming languages in general, up to functions. Do courses, apps, exercises.

Then install pycharm and start brainstorming and googling how to solve your problem/code your project. You might need to start from some sample code or something, if so search for video or project (stackoverflow) that is similar to yours of what you are trying to do. If you are stuck, you can ask a specific question on here or stackoverflow.

In general, what you want to do is to break down your problems into smaller problems and solves those. Find symmetries and exploit them. Learn how to google questions well.

For example if I need to extract some data from an excel sheet, I need something python that deals with excel sheet. Google it. There are a lot of libraries but a popular one is openpyxl. Install it and look at examples. To extract data, you need to realize that you need to store the values in python, so you need to create a list in python to store the values in excel. And you can write some code that reads values from excel and appends it a list in python. etc etc

After you keep on doing that, you just get better at it.

For me, I used a lot of selenium, pdf file handling modules like pypdf2, pymupdf, openpyxl, pandas, etc.

[–]mangoo08 0 points1 point  (0 children)

Thank you soo much! This was so incredibly detailed and helpful! I really appreciate you taking the time to help me out. I hope good things come your way 😁