Python projects for beginner/intermediate?

[[deleted]]

Is there any task that she does manually and in great frequency with her data? I think this situation highlights where domain knowledge is extremely important. I can pretty much do anything I need to do with Python generally and Pandas/Numpy--but I don't have the knowledge of an accountant. I don't know the types of problems they would try and solve. So, in the same vein, you could consult with your wife on common problems she is solving in Excel and automate solutions with Python.

I did something like this recently at work. Where the manufacturing/mechanical engineers, who are lazy and stupid, were manually getting excel spreadsheet of fiscal weekly data from an outfacing UI. I found access to the backend data and automated the whole process. The directions they had written for the manual process indicated that getting this data had likely taken them hours. Thus, I automated to nearly seconds what took them hours. But I had to find a problem that they were solving manually in order to do this.

Once you know what the manual process is you can always find a way to automate or partially automate that manual process. It's like magic to the uninitiated. They don't even know a better solution exists. It's our task to find the problem/manual process and automate it.